Matt Miller (#4) (7/24/2012)

---

Sean Lange (7/24/2012)

---

This thread has a good example of using OUTPUT with MERGE.

http://www.sqlservercentral.com/Forums/Topic1325508-391-1.aspx

There is nothing magical about try/catch blocks in t-sql. They work just like the same...

Welsh Corgi (7/24/2012)

---

Sean Lange (7/24/2012)

---

This thread has a good example of using OUTPUT with MERGE.

http://www.sqlservercentral.com/Forums/Topic1325508-391-1.aspx

There is nothing magical about try/catch blocks in t-sql. They work just like the same constructs...

I tossed together a quick flowchart to demonstrate what this is doing. Maybe it will help. Look down below for the attachment.

Smash125 (7/24/2012)

---

Wanted to know where i am going wrong in this query

DECLARE @Table TABLE

(

FirstName NVARCHAR(255),

MiddleName NVARCHAR(255),

LastName NVARCHAR(255),

ContactID INT

)

INSERT INTO @Table

SELECT FirstName,MiddleName,LastName,ContactID FROM Person.Contact

DECLARE @FirstName NVARCHAR(255)

SET @FirstName='kim'

IF EXISTS(SELECT * FROM...

AND your update statement has no where clause. I guess this is OK if you want everyone to be named 'Sam'. 😛

This thread has a good example of using OUTPUT with MERGE.

http://www.sqlservercentral.com/Forums/Topic1325508-391-1.aspx

There is nothing magical about try/catch blocks in t-sql. They work just like the same constructs in every programming language.

http://msdn.microsoft.com/en-us/library/ms175976.aspx

I understand you there and I am trying to help you protect yourself. Have...

D-SQL (7/24/2012)

---

I have been asked to create a script to manipulate the database and set any nullable columns to null in the entire DB.

Is there an easy way to...

I absolutely agree with you...I just misread...

Lynn Pettis (7/24/2012)

---

Sean Lange (7/24/2012)

---

lokeshvij (7/24/2012)

---

My Friend, point here is that SQL Optimizer will not be able to use an index if the query is sargable. It will literally try...

jeezontorst (7/24/2012)

---

Thanks for the comments on Nolock.

Well basically i use it because I've been learning sql for 6 months only, and this is what i have been shown by other...

lokeshvij (7/24/2012)

---

My Friend, point here is that SQL Optimizer will not be able to use an index if the query is sargable. It will literally try to evaluate and match...

Hi and welcome to SSC. It seems you have gotten some good suggestions at finding a solution. You may be wondering why nobody responded with some sql for you. That...

http://msdn.microsoft.com/en-us/library/ms189292.aspx

Don't forget what I said in your other thread about SARGability of your query....

Just because it was written that way originally does not mean it...