I am not sure actually 2 "set" commands in one update work... but see my reply posted here.. one SET is sufficient..

I could be wrong but I do recall...

select '['+column_name+']' ColumnName from INFORMATION_SCHEMA.columns where IS_NULLABLE = 'yes' and table_name ='Person'

-- copy and paste the results for this column in below

ColumnName

[Title]

[MiddleName]

[Suffix]

[AdditionalContactInfo]

[Demographics]

--...

I had the same issue and restarting MSSMS fixed it..

Thank you for the comment and yes, you are right, it depends on the individual scenario / special cases / etc. and that traffic and the IO is not too...

This is just a sample piece to demonstrate how to "denormalize" data.

Really a fun thing to play with and not taken seriously as a practical script for production.

As...

You are absolutely right.

What I should have added as a comment or a warning is that .. "... this is for training purposes and should not be considered as a...

I did not continue to read the rest of the script after seeing the 2 "," back to back..

therefore, I have answered the last 2 .. since both will...

..with possibilities of truncation?

Of course the language notion is a very good point. however, this example was of course set for English ..

but your point is well taken

Yes, of course, it is only a 30 day month. Albeit, it is not because it knows the "END" of the month.. but the requested day is the 31st of...

"MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION... MUST READ THE WHOLE QUESTION...

"

Of course I answered all...

this explains it why mine did not work also.. I had bigint and table data types..

I also have posted 3 options and I thought I was right!! Is there an ambiguity to this question and the answers or I really need to go back...

Perhaps a single search on a single column with non-clustered index would be fast and as a matter of fact there are some recommendations on building a non-clustered index on...

Ashish has a very good point. Also, clustered one is a "physical" order and sorted data and by far is faster than a non-clustered.. of course you know you...