zhukui66的专栏

select IDENT_CURRENT('表名')+1 id

SELECT a.user_id, a.package_id, a.addtime, a.result, b.package_name + '' + b.package_price + '' + b.package_traffic+ '' + case b.type when 1 then '（后付费）' else '（预付费）' END package_name FROM xzll

SELECT          * FROM          xzllgj_user_free_60m WHERE          user_id IN (                    SELECT                             user_id                    FROM                         

Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AM Select CONVERT(varchar(100), GETDATE(), 1): 05/16/06 Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16 Select CONVERT(varchar(100),

update  t_sms_send set msg_flag = -1  where id in (select top 100 id from t_sms_send with (nolock) where msg_flag=-2)

SELECT TOP 1 dateadd(month,1,getdate()) time FROM table