Click here to Skip to main content
15,885,537 members
Everything / Stored procedure

Stored procedure

stored-procedure

Great Reads

by Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.
by ASP.NET Community
ASP.NET offers a number of places to store state, both on the client and server. However, sometimes it's difficult to decide where you should put
by ASP.NET Community
ASP.NET Session state provides a place to store values that will persist across page requests.  Values stored in Session are stored on the server
by Paw Jershauge
An easy to use extendedproperty procedure (alternative to sp_dropextendedproperty, sp_addextendedproperty, sp_updateextendedproperty)

Latest Articles

by NightWizzard
Read and/or modify database objects like views, triggers, stored procedures and functions from .NET code.
by Paw Jershauge
An easy to use extendedproperty procedure (alternative to sp_dropextendedproperty, sp_addextendedproperty, sp_updateextendedproperty)
by koolprasad2003
This article will help you to know how to Debug your stored procedure
by Kuv Patel
Debug stored procedures in Visual Studio and SQL Server Management Studio.

All Articles

Sort by Score

Stored procedure 

29 Dec 2016 by Paw Jershauge
An easy to use extendedproperty procedure (alternative to sp_dropextendedproperty, sp_addextendedproperty, sp_updateextendedproperty)
26 Sep 2013 by Ashkan.hosseini
Stored procedure that generates insert stored procedure for tables
18 Feb 2012 by Israel Cris Valenzuela
LTRIM and RTRIM don't always remove all the whitespace characters in a field such as carriage return or linefeed
10 Mar 2015 by Jignesh G Trivedi
This tip will help you to understand CLR procedure.
30 Sep 2019 by NightWizzard
Read and/or modify database objects like views, triggers, stored procedures and functions from .NET code.
16 Feb 2012 by PIEBALDconsult
In SQL Server 2008, I do that with a CLR User Defined Function:namespace PIEBALD.Lib{ public static partial class LibSql { public static string Trim ( string Victim ) { return ( Victim.Trim() ) ; } }}Needs to be built into a...