|
|
|
|
|
|
-
Deepak kelath Posted 2 Months ago through Just Learned
hi friends
To get a list of all sql server collations we can execute following system function.
This will return name and description of various collations
**select * from fn_helpcollations()**
...
|
-
Deepak kelath Posted 4 Months ago through Just Learned
Today i studied an interesting thing related to GO statment
See in the following queries executed .***The batch preceding GO will execute the specified number of times***.
**create table test( id int not null identity (1, 1) primary key)
go
inser...
|
|
|
-
Deepak kelath Liked 1 Years ago through Pages
We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...
|
-
Deepak kelath Commented 1 Years ago through Just Learned
Stored procedures with a temporary table cannot be pre-compiled ?
It means will it compile on every time it runs? or compiled only first time its run?
This is little bit confusing me can you explain in detail...
|
-
Deepak kelath Commented 1 Years ago through Just Learned
Stored procedures with a temporary table cannot be pre-compiled ?
It means will it compile on every time it runs? or compiled only first time its run?
This is little bit confusing me can you explain in detail...
|
-
Deepak kelath Commented 1 Years ago through Just Learned
Good posting .. temp table are found faster when no of records are higher...
|
-
Deepak kelath Commented 1 Years ago through Just Learned
Good posting .. temp table are found faster when no of records are higher...
|