asutorius | SQLServerCentral

asutorius

Forum Replies Created

Viewing 5 posts - 1 through 5 (of 5 total)

RE: Lots of inserts? Part I

You have to infer the schema for tbl from the script and create it before running the script.
Thank you

July 27, 2016 at 6:04 am

#1892239
RE: Lots of inserts? Part I

I received the following reply when running that script against AdventureWorks database.
Beginning execution loop
Msg 208, Level 16, State 1, Line 2
Invalid object name 'tbl'.
** An error was encountered during execution...

July 27, 2016 at 5:53 am

#1892235
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

Eric M Russell (7/18/2016)
Any difference in exeution time would be the result of T-SQL syntax pre-processing; one is probably just a macro of the other. All other things being equal,...

July 20, 2016 at 11:19 am

#1891117
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

Eric, thank you for answering my question.

July 20, 2016 at 11:18 am

#1891116
RE: Stairway to T-SQL: Beyond The Basics Level 8: Coding Shortcuts using += and -= Operators

I was curious how these two concatenate examples compared in speed, I placed the examples in their own tabs in my local Sql Server 2014 and turned on Include Client...

July 15, 2016 at 7:09 am

#1890294

Viewing 5 posts - 1 through 5 (of 5 total)