Query Status Code

[Guest_imported]

How do i get the status code of the query fired i.e. whether the query was successful or not.(insert, update and delete)

 

[DBCustard]

Well, if the insert /update fails because of a constraint, you'll get notified at runtime - this notification will depend on the environment you are using, alternatively, if you want to see how many rows an update /insert /select affects, you could use the @@rowcount variable eg:

select * from sysobjects
select @@rowcount

 

[Andel]

or you can insert @@error at the end of your query:

IF @@ERROR > 0
PRINT 'There is an Error!'
ELSE
PRINT 'No Error'

Andel
andel@barroga.net

http://andyb.8m.com