Run Code  | API  | Code Wall  | Users  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

OUTPUT CLUASE

Language: Layout:
View schema
Absolute service time: 0.16 sec 
edit mode |  history  | discussion
Error(s), warning(s):
An explicit value for the identity column in table 'TGT' can only be specified when a column list is used and IDENTITY_INSERT is ON.
   orderid custid orderdate
1 1 1 6/12/2012 12:00:00 AM
2 2 2 6/12/2012 12:00:00 AM
3 3 3 6/12/2012 12:00:00 AM
   orderid custid empid orderdate
1 1 1 3 6/12/2012 12:00:00 AM
2 2 2 2 6/12/2012 12:00:00 AM
   orderid custid empid orderdate
1 1 1 3 6/12/2012 12:00:00 AM
2 2 2 2 6/12/2012 12:00:00 AM
3 3 3 5 6/12/2012 12:00:00 AM
4 4 1 3 6/12/2012 12:00:00 AM
5 5 2 2 6/12/2012 12:00:00 AM
   orderid
1 2
2 5
   orderid old_orderdate neworderdate
1 1 6/12/2012 12:00:00 AM 6/13/2012 12:00:00 AM
2 4 6/12/2012 12:00:00 AM 6/13/2012 12:00:00 AM