|
|
-
Parth Patel Commented 2 Years ago through Just Learned
> SELECT
> STUFF(
> (
> SELECT ',' + COLUMN_NAME
> FROM INFORMATION_SCHEMA.COLUMNS
> WHERE TABLE_NAME = 'YourTableName'
> ORDER BY ORDINAL_POSITION
> FOR XML PATH('')
> ), 1, 1, '')...
|
-
Parth Patel Commented 2 Years ago through Just Learned
> SELECT
> STUFF(
> (
> SELECT ',' + COLUMN_NAME
> FROM INFORMATION_SCHEMA.COLUMNS
> WHERE TABLE_NAME = 'YourTableName'
> ORDER BY ORDINAL_POSITION
> FOR XML PATH('')
> ), 1, 1, '')...
|
-
Parth Patel Commented 2 Years ago through Just Learned
> SELECT
> STUFF(
> (
> SELECT ',' + COLUMN_NAME
> FROM INFORMATION_SCHEMA.COLUMNS
> WHERE TABLE_NAME = 'YourTableName'
> ORDER BY ORDINAL_POSITION
> FOR XML PATH('')
> ), 1, 1, '')...
|
-
Parth Patel Commented 2 Years ago through Puzzles
Only 2 years? Are you kidding me? You must be mathematician man!! Btw, thanks for providing Island example. :-)
|
-
Parth Patel Learned 2 Years ago through Just Learned
When we use select count(*), the query processor will use scan on the index with the smallest number of pages to find the result of select(*).......
|
-
Parth Patel Liked 2 Years ago through Just Learned
When we use select count(*), the query processor will use scan on the index with the smallest number of pages to find the result of select(*).......
|
-
Parth Patel Learned 2 Years ago through Just Learned
When we use select count(*), the query processor will use scan on the index with the smallest number of pages to find the result of select(*).......
|
-
Parth Patel Liked 2 Years ago through Just Learned
When we use select count(*), the query processor will use scan on the index with the smallest number of pages to find the result of select(*).......
|
|
|
-
Parth Patel Commented 2 Years ago through Puzzles
One last thing what would the output for ASDFKIJkLMNAXDBABCIJKPPSRNK? k is in small letter
|