gumpgit
11/23/2017 - 6:31 AM

sql 奇技淫巧

获取返回的标识列

IDENT_CURRENT ,@@identity,SCOPE_IDENTITY() 之间对比

string sql_addM = @"Insert Into [dbo].[RB_AchievementM] ([Depart], [TargetClassID], [BeginTime],[EndTime], [ModifyTime])
                      Values ('总部', @classID, @BT,@ET, GetDate());Select Scope_Identity();";
 int _Mid = (int)cmd_add.ExecuteScalar();

执行时间戳

declare @sdt datetime=getdate()

Print '1--------------------------------------------------' + Convert(Varchar, DateDiff(Second,@sdt, GetDate()));