using …

Pure C#

Archive for the ‘Stored Procedure’ Category

Dynamic creation of Insert, Update, Delete Stored procedures

Posted by esersahin on 09/07/2010


http://www.sqlservercentral.com/articles/Stored+Procedures/67055/

Posted in SQL, Sql Server, Stored Procedure | 1 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 »

Find the TOP n Longest Running Procedures (or Queries), Ordered by Total Impact on Server

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=LongRunningProcs&referringTitle=Home

Posted in Stored Procedure, Transact-SQL | Leave a Comment »

Lock a Stored Procedure for Single Use Only

Posted by esersahin on 18/01/2009


http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=GetAppLock&referringTitle=Home

Posted in Lock, Stored Procedure, Transact-SQL | Leave a Comment »

Using TRY…CATCH in Transact-SQL

Posted by esersahin on 18/01/2009


http://msdn.microsoft.com/en-us/library/ms179296(SQL.90).aspx

Posted in Raiserror, Sql Server, Stored Procedure, Transact-SQL, Try Catch | Leave a Comment »

Exploring ‘ON DELETE SET NULL’ in SQL Server 2005

Posted by esersahin on 18/01/2009


http://www.sqljunkies.ddj.com/Article/D839595A-0BC3-4F7E-97EA-DE4911EE2217.scuk

Posted in Raiserror, Sql Server, Stored Procedure, Transact-SQL | Leave a Comment »

Stored Procedures in AdventureWorks

Posted by esersahin on 18/01/2009


http://technet.microsoft.com/en-us/library/ms124456.aspx

Posted in Sql Server, Stored Procedure | Leave a Comment »

WITH common_table_expression (Transact-SQL)

Posted by esersahin on 26/11/2008


http://msdn.microsoft.com/en-us/library/ms175972(SQL.90).aspx

Posted in SQL, Sql Server, Stored Procedure, Transact-SQL, WITH | Leave a Comment »

Creating a Stored Procedure for Custom Paging with the ASP.NET DataGrid Control

Posted by esersahin on 26/11/2008


http://www.dotnetjunkies.com/Article/975BE770-E5DC-4610-870B-A82BDB9B8845.dcik

Posted in Custom Paging, Stored Procedure | Leave a Comment »