|
|
-
Parth Patel Commented 6 Months 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 6 Months 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 6 Months ago through Puzzles
Only 2 years? Are you kidding me? You must be mathematician man!! Btw, thanks for providing Island example. :-)
|
-
Parth Patel Liked 6 Months 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 6 Months 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 6 Months ago through Puzzles
One last thing what would the output for ASDFKIJkLMNAXDBABCIJKPPSRNK? k is in small letter
|
-
Parth Patel Commented 6 Months ago through Puzzles
Hi Leszek,
Hands down to your Solution!!!
I must say every time I get a BIG surprise when I read your solution!!! I really like to improve my logic. Can you tell me which book or what criteria you follow or think when you start solving puzzle?
Btw
|
|
|
|
|