|
|
-
pinakee Liked 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
pinakee Learned 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
pinakee Liked 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
pinakee Learned 1 Years ago through Just Learned | 1 Point
I have been working on creating my demo scripts for "Tech-ED India 2012" and while trying different options, realized that the FORMAT function can be (mis)used to embed external strings into the format specification.
PRINT FORMAT( GETDATE(), ...
|
-
pinakee Liked 1 Years ago through Just Learned | 1 Point
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
pinakee Learned 1 Years ago through Just Learned | 1 Point
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
pinakee Liked 1 Years ago through Just Learned | 1 Point
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
pinakee Learned 1 Years ago through Just Learned | 1 Point
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement
[code]DROP table test1,test2,test3[/code]......
|
-
pinakee Liked 1 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|
-
pinakee knew 1 Years ago through Just Learned | 1 Point
Suppose you have a huge table which has say 30-40 columns and you want to select all of them or most of them say around 30 columns. It is a tedious job to type each of the column names. Here is a quick way to get a comma separated list of all the column...
|