Locking is determined by the query engine. It always goes with a least cost lock. From the sounds of things, you don't have too much data in the table so...

Everyone has covered it so well up to this point, especially Phil Factor's bit. The one technical thing I would add is that a new DBA must learn the logical...

From the BOL:

You're locking a range when what you really want is to lock a row.

Even though GSquared eliminated the cursor, there are still other optimizations pointed out by others that can be done to the proc.

You're using the parameter twice, once to set & once to search. It can't be done like that. You have to refer to the column twice, but if you have...

anjan.ashok (6/19/2008)

---

hi grant see my sp pls and help me

CREATE PROCEDURE sp_replace_value (

@strcvalue varchar(100),

@strdesc nvarchar(100)

)

as

update testtbl set value=@strconfigvalue,desc=@strconfigdesc where value=@strconfigvalue

here assume we have...

You should be able to take the same structures that I supplied and modify it for a different column and/or data type. It all works the same way.

UPDATE table

SET col1...

This was a cross-post. Answers there too:

http://www.sqlservercentral.com/Forums/Topic520048-338-1.aspx

Please don't cross-post.

You mean something like this?

CREATE PROCEDURE UpdateEmail

(@OldEmail nvarchar(275)

,@NewEmail nvarchar(275)

AS

BEGIN TRY

UPDATE MyEmail

SET Email = @NewEmail

WHERE Email = @OldEmail

END

BEGIN CATCH

RETURN ERROR_NUMBER();

END

So much for contacting people.

I'm still baffled. I'm not sure why this is happening like it is. Odd stuff.

No, it's not the same at all. 2005 really is better.

Pull up the execution plan. That will help you find out where to look.

I suspect it's this:

(D.Did in (select max(Did) from D group by Aid) ...

I can't find the documentation. Here's a support article, but it's not what I meant:

http://support.microsoft.com/kb/281671

And Kalen

http://www.sqlmag.com/Article/ArticleID/16078/sql_server_16078.html

Actually, quite a few of us get paid to rewrite 500 line stored procedures. We'll help, but you...

First, I'd try posting in the SQL Server 2000 forums, not the 2005 forum.

Second, there isn't an immediate method to do this. There are some options. If you're running a...