It can be anything.. y should i be concered with it.. I just need to be sure my code does return the values..

CREATE PROCEDURE dbo.Insert_Sp ( @param ,@param1 output)

AS

SET NOCOUNT ON

BEGIN TRY

Insert Statement..............

END TRY

BEGIN CATCH

Select @param1= @@error

RETURN 1 --...

What i understand is.

1. If i want to return error as an error i can either use RAISEERROR with my custom error message or just do nothing and shown by...

OPTION #5 (Try ... Catch)

Use Db_name

Go

CREATE PROCEDURE Insert_Sp

( @param1

...

Below are the options I have.. We have try catch tracactions also but i dont want to use itsince that should be for multiple updates.

So I need to know...

please provide sample code for a simple single insert statements that just returns status to the caller saying the insert ws successfull or not.. Sounds so simple but there are...

But there is only a single insert statement.. Do i need to put tat also in Withing Try catch transactuions.. I thought it should only by for multiple inserts... what...

Thanks everyone .. I had never though SSMS to be different from Sql Server.. So when I was given this new tool, i got pretty confused. I get the point...

Anyways the question still remains.. is SSMS the best option or other clients tools should work just fine.. and y?? I need proper reason here to justify myself..

yes, Print gives an error stating unknown keyword or something..

And may be SSMS is not free and Teradata is.. tat is y its use is limited.. ??

the fact that "print" and "go" do not work proves that SQL Teradata is not compatible with SQL Server. Am I right??

Guys, I need an answer in general. What can be the disadvantages of using any 3rd party tool other than sql server mgnt studio.. I dont answer specific to sql...

Use Output parameter:

DECLARE @SQL NVARCHAR(4000);

DECLARE @ParameterDefinition NVARCHAR(4000);

-- Set value for Parameter variable

SELECT @ParameterDefinition = '

@top INT,

@acctnum INT,

@ErrorOutput INT OUTPUT,

@ROWCOUNTOutput INT OUTPUT'

-- Set value for the Sql String

SELECT @SQL = 'Select top...