--用trigger插入主键的值--通过时间变量来决定主键的值create trigger ss on testinstead of insert --在插入之前执行此triggerasbegindeclare @index varchar(30)--声明变量waitfor delay '00:00:00.010'--延时0.01秒执行下一条指令set @index = replace(replace(replace(replace(convert(varchar(23),getdate(),121),'-',''),' ',''),':',''),'.','') --将当前时间转化为字符串insert into test select @index,i.SNAME,i.STATUS,i.CITY from inserted iendinsert into test(SNAME,STATUS,CITY) values ('11',30,'ss');insert into test(SNAME,STATUS,CITY) values ('11',30,'ss');insert into test(SNAME,STATUS,CITY) values ('11',30,'ss');insert into test(SNAME,STATUS,CITY) values ('11',30,'ss');insert into test(SNAME,STATUS,CITY) values ('11',30,'ss');insert into test(SNAME,STATUS,CITY) values ('11',30,'ss');drop trigger ss;delete from testselect * from test--测试变量的用法declare @a numericset @a = cast(replace(replace(replace(replace(convert(varchar(23),getdate(),121),'-',''),' ',''),':',''),'.','') as numeric)print @aprint convert(varchar,(@a +1))--另一种方法使用变量declare @index varchar(30)--声明变量set @index = replace(replace(replace(replace(convert(varchar(23),getdate(),121),'-',''),' ',''),':',''),'.','') --将当前时间转化为字符串print @index
