using …

Pure C#

Archive for the ‘Sql Server Error’ Category

“Invalid value 0 for state. Valid range is from 1 to 127.”

Posted by esersahin on 07/04/2009


Nice sql server error messages šŸ™‚

UsingĀ deleteĀ joinĀ statement in stored procedures and sql server return error messages.

Why?

Because,

There are records in related tables.
Need to delete records in related tables andĀ  we should try to delete again.
Change the RaiseError ERROR_STATE() to 1

Posted in Sql Server, Sql Server Error, Sql Server Join, Transact-SQL | Leave a Comment »

SQL Server / T-SQL Tutorial

Posted by esersahin on 20/03/2009


http://www.java2s.com/Tutorial/SQLServer/CatalogSQLServer.htm

Posted in Cast, Common Table Expressions, Cross-Tabs, CTE, Functions, Instead Of, Pivot Tables, Raiserror, ROW_NUMBER, SQL, Sql Server, Sql Server Error, Sql Server Join, SQLCLR, Stored Procedure, Transact-SQL, Trigger, UNION, UNION ALL, Update with Join | Leave a Comment »

SQL Server / T-SQL

Posted by esersahin on 20/03/2009


http://www.java2s.com/Code/SQLServer/CatalogSQLServer.htm

Posted in Cast, Cross-Tabs, CTE, Functions, Pivot Tables, SQL, Sql Server, Sql Server Error, Sql Server Join, Stored Procedure, Transact-SQL, Trigger | Leave a Comment »

Detecting and Reporting Errors in Stored Procedures – Part 2: SQL Server 2005 TRY-CATCH Blocks

Posted by esersahin on 20/03/2009


http://www.sqljunkies.ddj.com/Article/E28ED88D-1780-4F6E-9810-2B88B382C934.scuk

Posted in Sql Server Error | Leave a Comment »

Detecting and Reporting Errors in Stored Procedures – Part 1: SQL Server 2000

Posted by esersahin on 20/03/2009


http://www.sqljunkies.com/Article/564F5D77-2F7E-41FB-91C7-353B6D84BF94.scuk

Posted in Sql Server Error | Leave a Comment »