OK so you tried to post some code but you missed the mark. The code you posted is full of syntax errors and variables not declared. There are columns referenced...

Nice straight forward question. Keep them coming Pradeep.

You are welcome. Glad you were able to figure out a solution.

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

---

Sean Lange (7/24/2012)

---

Neat idea, but unfortunately it...

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...