SQL命令

简单查询：

select * from dbo.SmsLog  where mobile=‘186xxxxxxxx‘     *代表查询所有，可以替换为具体字段，查询具体字段值

select * from dbo.ClienterFinanceAccount where clienterID=3263

select top 100 * from OldCustomerCard where CustomerName=‘一米阳光‘   查询前100条数据

SELECT  count(distinct Id) FROM SupplierGroup(nolock)

删除命令 delete from tableName where 条件
delete from ClienterFinanceAccount where clienterID=3263   解绑提现账户

更新值      update tableName set  ... where 条件
UPDATE BusinessClienterRelation SET isbind=0 WHERE BusinessId=2092

UPDATE[dbo].[OrderChild] SET TotalPrice=0.01 where OrderId=‘151152‘;   支付金额修改

update CustomerExtOrderInfo set CustomerTypeId=0 where CustomerID =5833733 and SupplierId=269267

UPDATE dbo.Dine SET OrderStatusId=2,CreatTime=GETDATE() WHERE DineId=10500451

插入命令：insert into tableName values(‘ss‘,‘11‘....)

INSERT INTO OldCustomerCard VALUES (‘一米阳光‘,‘X0255452010‘,‘0.0‘,‘18618486814‘,‘2‘,‘会员类型1‘,‘0‘,‘269267‘,‘1990-05-08‘,
‘2016-09-18 15:23:20:000‘)

复杂查询

select * from dbo.clienter c where c.Id>(select min(Id) from dbo.clienter d where c.IDcard=d.IDcard
group by IDcard having count(IDcard)>1)

delete from dbo.clienter where Id !=(select min(Id) from dbo.clienter where dbo.clienter.IDcard=dbo.clienter.IDcard)

select count(1) from [order] o
join business b on o.businessid =b.id
where b.city=‘北京市‘   查询城市订单数

两张表关联查询，

select distinct b.cityid from order a join business b  on a.businessid=b.id   查询订单城市并去重

SELECT OrderCount,clienterId,*
FROM [order] (NOLOCK)
WHERE ActualDoneDate IS NOT NULL
AND ActualDoneDate >= ‘2015-07-30‘
AND ActualDoneDate < ‘2015-07-30 17:45:25‘

执行监控作业 :exec+监控事件

EXEC dbo.RedPackageActivityTimer

SQL命令

原文：http://www.cnblogs.com/chenchen-tester/p/6411155.html