|
|
-
|
|
One of the basic restrictions around IDENTITY columns is that they must not allow for NULL values and they cannot have a DEFAULT constraint defined on them. This is often taken as IDENTITY cannot have any constraints defined on them, which is a myth....
|
|
-
|
|
Java is not good at data computing, especially massive structured data computing. The appearance of esProc Dev could help Java to solve this problem....
|
|
-
|
|
There are many questions on making/replacing the capital letter the first character of each word in a sentence in every forums. Find the below function for such cases without a loop. Hope this would help you...
Create Function dbo.CapitalizeEachword ...
|
|
-
|
|
what are Difference between DATALENGTH and LEN?...
|
|
-
|
|
When IDENTITY columns are added to existing tables, how is a particular record assigned an IDENTITY value?...
|
|
-
|
|
As I wrote about replication latency from publisher to distributor and distributor to subscriber for replication and an alert for replication latency, same as we need to have an alert in case of replication failure. I would like to review some of my ear...
|
|
-
|
|
Impressed by awesome sessions at SQLBangalore user group meeting today (15th of June, 2013), I decided to write a blog post about it. It’s a monthly event that takes place at Microsoft campus in Bangalore. Today’s UG meeting named “Relive TechEd 2013 a...
|
|
-
|
|
Different type of containers and uses in SSIS...
|
|
-
|
|
Export to XML File using SSIS...
|
|
-
|
|
IDENTITY values work great when inserting records into a table. But, can IDENTITY columns be added to existing tables where records already exist in the table? If yes, in what order will the IDENTITY values be assigned?...
|
|