Viewing 15 posts - 121 through 135 (of 206 total)
Excellent question - thanks!
September 7, 2017 at 1:58 am
September 1, 2017 at 1:57 am
Except that it's known almost everywhere as a Table Value Constructor, not Valued.
September 1, 2017 at 1:45 am
The question is a very good example of what happens when your requirements are poorly expressed.
August 22, 2017 at 1:08 am
July 20, 2017 at 2:18 am
Thank you everyone. The problem is compounded because a) there are missing WHERE clauses that I omitted for clarity, and b) this SQL is composed within a webservice written in...
May 3, 2017 at 1:59 am
twin.devil - Wednesday, April 26, 2017 12:36 AMnice and easy. Thanks Steve.
Just curious, why 42 🙂?
Because it's the answer to...
April 26, 2017 at 2:53 am
BWFC (12/21/2016)
edwardwill (12/21/2016)
The article you cite in support of the answer is silent on the limits to the size of the input string.Technically it's not.
Then please point me to the...
December 21, 2016 at 7:16 am
The article you cite in support of the answer is silent on the limits to the size of the input string.
December 21, 2016 at 2:38 am
TimCarrett (12/8/2016)
"I want to set...
December 8, 2016 at 4:06 am
Both 1 and 2 were invalid, but 2 was more seriously invalid than 1, so I guessed right. For once! 😀
November 2, 2016 at 5:20 am
Koen Verbeeck (10/25/2016)
edwardwill (10/25/2016)
I executed the DDL statements against my test database, and the DML statements against master.
Then you get the index information of the master database.
Cool. I learnt...
October 25, 2016 at 3:13 am
Koen Verbeeck (10/25/2016)
edwardwill (10/25/2016)
select * from sys.indexes -- returned 159 rows
I then executed the first...
October 25, 2016 at 3:08 am
Weird. I'm not a DBA so I likely didn't really understand, but I executed this:
select * from sys.indexes -- returned 159 rows
I then executed the first statement (CREATE TABLE)...
October 25, 2016 at 2:22 am
Viewing 15 posts - 121 through 135 (of 206 total)