1
2 CREATE TABLE T (
3 int1 int ,
4 bit1 bit NOT NULL DEFAULT 0 ,
5 rvr1 timestamp ,
6 usr1 nvarchar ( 28 ) DEFAULT USER ,
7 createtime datetime DEFAULT CURRENT_TIMESTAMP
8 )
9 GO
2 CREATE TABLE T (
3 int1 int ,
4 bit1 bit NOT NULL DEFAULT 0 ,
5 rvr1 timestamp ,
6 usr1 nvarchar ( 28 ) DEFAULT USER ,
7 createtime datetime DEFAULT CURRENT_TIMESTAMP
8 )
9 GO
1
2 INSERT T (int1) VALUES ( 1 ) WAITFOR DELAY ' 00:00:01 '
3 GO
4 INSERT T (int1, bit1) VALUES ( 2 , 0 ) WAITFOR DELAY ' 00:00:01 '
5 GO
6 INSERT T (int1, bit1) VALUES ( 3 , 1 )
7 GO
2 INSERT T (int1) VALUES ( 1 ) WAITFOR DELAY ' 00:00:01 '
3 GO
4 INSERT T (int1, bit1) VALUES ( 2 , 0 ) WAITFOR DELAY ' 00:00:01 '
5 GO
6 INSERT T (int1, bit1) VALUES ( 3 , 1 )
7 GO
(1 rows affected)
1
SELECT
int1, bit1, usr1,
2 CONVERT ( int , rvr1) ' Timestamp as int ' ,
3 createtime
4 FROM T
5 GO
2 CONVERT ( int , rvr1) ' Timestamp as int ' ,
3 createtime
4 FROM T
5 GO
----------- ---- ---------------------------- ---------------- -----------------------
1 0 dbo 5007 2006-10-14 10:53:20.827
2 0 dbo 5008 2006-10-14 10:53:21.827
3 1 dbo 5009 2006-10-14 10:53:22.827
(3 rows affected)
1
2 UPDATE T
3 set bit1 = 1
4 WHERE int1 = 2
5 GO
2 UPDATE T
3 set bit1 = 1
4 WHERE int1 = 2
5 GO
1
SELECT
int1, bit1, usr1,
2 CONVERT ( int , rvr1) ' Timestamp as int ' ,
3 createtime
4 FROM T
5 GO
2 CONVERT ( int , rvr1) ' Timestamp as int ' ,
3 createtime
4 FROM T
5 GO
int1 bit1 usr1 Timestamp as int createtime
----------- ---- ---------------------------- ---------------- -----------------------
1 0 dbo 5007 2006-10-14 10:53:20.827
2 1 dbo 5010 2006-10-14 10:53:21.827
3 1 dbo 5009 2006-10-14 10:53:22.827
(3 rows affected)
1
2 drop table t
3 GO
2 drop table t
3 GO
from: 这里
欢迎加群互相学习，共同进步。QQ群：iOS: 58099570 | Android: 572064792 | Nodejs：329118122 做人要厚道，转载请注明出处！
本文转自张昺华-sky博客园博客，原文链接：http://www.cnblogs.com/sunshine-anycall/archive/2010/05/23/1742354.html
，如需转载请自行联系原作者
