zhukui66的专栏

select IDENT_CURRENT('表名')+1 id

SELECTa.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_nameFROMxzll

SELECT         *FROM         xzllgj_user_free_60mWHERE         user_id IN (                   SELECT                            user_id                   FROM                        

Select CONVERT(varchar(100), GETDATE(), 0): 05 16 2006 10:57AMSelect CONVERT(varchar(100), GETDATE(), 1): 05/16/06Select CONVERT(varchar(100), GETDATE(), 2): 06.05.16Select 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