|
|
-
Nirav Gandhi Liked 1 Days ago through Blogs | 1 Point
what are Difference between DATALENGTH and LEN?...
|
-
Nirav Gandhi Posted 1 Days ago through Blogs | 10 Points
what is Difference between DATALENGTH and LEN?...
|
-
Nirav Gandhi Liked 20 Days ago through Blogs | 1 Point
A myth around IDENTITY columns is that values cannot be inserted explicitly into IDENTITY columns. Not only can IDENTITY columns accept explicit inserts via the IDENTITY_INSERT option, this is one of the most used methods when working with replication a...
|
-
Nirav Gandhi refreshed 20 Days ago through Blogs | 1 Point
A myth around IDENTITY columns is that values cannot be inserted explicitly into IDENTITY columns. Not only can IDENTITY columns accept explicit inserts via the IDENTITY_INSERT option, this is one of the most used methods when working with replication a...
|
|
|
|
|
|
|
|
|
-
Nirav Gandhi Liked 4 Months ago through Blogs | 1 Point
Sometime we are using triggers to get old and new values or new values for the historical data to save in another table. So we can get inserted, updated and deleted data using triggers.
But one amazing feature "Output" clause. ...
|
-
Nirav Gandhi refreshed 4 Months ago through Blogs | 1 Point
Sometime we are using triggers to get old and new values or new values for the historical data to save in another table. So we can get inserted, updated and deleted data using triggers.
But one amazing feature "Output" clause. ...
|