Alexander Suprun (1/29/2016)

---

Because when you drop procedure you...

Curious on your resaoning, why do you say so?

When presenting at least I find the rule of 5/3 - 3/5 to be good guidance. There is typically that one manager/director in the room that wants more and I...

Hard to say without a copy of the data file and SSIS Package. Happy to repro on my side if you attach to this thread, or attach in a PM...

GilaMonster (1/28/2016)

---

You use it when you want to take a log backup and ensure that no more transactions can be made to the DB after the backup finishes, for example...

Please up-vote if you agree with the suggestion: CREATE OR ALTER statement

To the original question, redgate SQL Prompt is worth every penny IMO. I've been using it since the original beta version and rely on it heavily. So heavily in fact...

J Livingston SQL (1/29/2016)

---

Jeff Moden (1/29/2016)

---

Obfuscate ??

CReAte tABle mytable(TranID INTEGER nOt nUll primAry KEy,CustomerID INTEGER nOt

null,ProdID INTEGER NoT NulL,SalesAmount NUMERIC(5,2) not nUlL,TransDate

VARCHAR(23) not NULl); iNsErT inTO mytable(TranID,CustomerID,ProdID,SalesAmount,

TransDate) VALuES(142801,19246,7727,57.42,'2009-02-02 00:00:00.000');...

Luis Cazares (1/28/2016)

---

Orlando Colamatteo (1/28/2016)

---

Ugh, thanks for the correction Ed. I am confident my C# code is correct but I was going from memory on the post as to the...

Ugh, thanks for the correction Ed. I am confident my C# code is correct but I was going from memory on the post as to the boundaries (was juat trying...

Sorry, I neglected to speak to your larger question of getting away from dynamic SQL. it looks like you have SQL fragments or conditions sitting in tables, like this

SELECT...

Looks like a custom rules engine implemented in T-SQL. I inherited one such system and watched another one get commissioned. I was late to the party in both cases and...

As Steve mentioned, on SQL 2012 we would favor the TRY_* functions built...

Thanks for sharing Jeff. Method 1 is what I had in mind for a T-SQL+command-line solution. Method 2 sounds quite interesting.

I commonly see the same few barriers...