Nothing. But in all of your cases the error will still be returned as error,...

I wouldn't use any one of your's posted.

It is really depends on what you want your caller to get- Error or Status?

1. If error, then simpler analogue of your...

Lowell (3/22/2012)

---

here's a pretty full fleshed model:

CREATE PROCEDURE EXAMPLEINSERT(

@Value VARCHAR(30))

AS

BEGIN

BEGIN TRY

BEGIN TRANSACTION

...

itskanchanhere (3/22/2012)

---

Need to write a simple Insert stored procedure (Single insert)with proper error handling.. The sp should make the insert and return somthing to client application indicating the insert was...

If you would only post stored procedure code...

Without seeing the code it's impossible to advise anything concrete.

It may be due to:

1. Parameter sniffing

2. Tables require update statistics

3. Bad code

and many...

...

It's actually what scalar UDF's were invented for and one of the few places where RBAR actually has the advantage. Of course, I threw in a couple...

What about posting the code?

The owner of the file is account under which your SQL Server service is running.

It's pretty bad idea of creating files on remote PC's from SQL Server.

You can either create...

tom.mcginty (3/20/2012)

---

All,

Over the years, I've had fits trying to update large tables via join to another table. I currently have a 46 million-record table I need to update via joining...

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

2. http://www.sqlservercentral.com/articles/Best+Practices/61537/

Try to post on MYSQL forum, it should be the one somewhere;-)

...

Since your table is a heap, you can either use the drop method or you'll need to add a clustered index.

...

You could also use TRUNCATE to clear the...

Create a DEFAULT for your column. You can do it via T-SQL or Table Design in SSMS

I guess you have this step failing due to SQLServer 2008 cannot find your ZIP providing DLL.

Does your table have a clustered index?