Stored Procedure

stored-procedure

Great Reads

Advanced SQL Server Monitor with Performance Graph, Analysis and Version Control

by Huisheng Chen

monitor sql server processes and jobs, analyse performance, object version control, view executing sql query, kill process / job, object explorer, database shrink/log truncate/backup/detach/attach etc

Better View State Management in ASP.NET 4.0

by ASP.NET Community

ASP.NET is a great platform to develop any web applications. From ASP.NET 1.1 we are having one feature called View State which store the data in

CLR Stored Procedure in SQL Server

by Jignesh G Trivedi

This tip will help you to understand CLR procedure.

Connecting to MySQL from Visual C#

by Lizandro Campbell

Using Visual C# 2008 to establish connection to a MySQL 5.1 database with MySQL Connector/NET 5.1.7

Latest Articles

Advanced SQL Server Monitor with Performance Graph, Analysis and Version Control

by Huisheng Chen

Better View State Management in ASP.NET 4.0

by ASP.NET Community

ASP.NET is a great platform to develop any web applications. From ASP.NET 1.1 we are having one feature called View State which store the data in

CLR Stored Procedure in SQL Server

by Jignesh G Trivedi

This tip will help you to understand CLR procedure.

Connecting to MySQL from Visual C#

by Lizandro Campbell

Using Visual C# 2008 to establish connection to a MySQL 5.1 database with MySQL Connector/NET 5.1.7

All Articles

top

stored-procedure

CLR Stored Procedure in SQL Server

by Jignesh G Trivedi

This tip will help you to understand CLR procedure.

Cool Insert Generator

by Ashkan.hosseini

Stored procedure that generates insert stored procedure for tables

How to Modify Views, Triggers and Procedures from Code

by NightWizzard

Read and/or modify database objects like views, triggers, stored procedures and functions from .NET code.

LTRIM RTRIM doesn’t always work

by Israel Cris Valenzuela

LTRIM and RTRIM don't always remove all the whitespace characters in a field such as carriage return or linefeed

LTRIM RTRIM doesn’t always work

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...

sp_extendedproperty

by Paw Jershauge

An easy to use extendedproperty procedure (alternative to sp_dropextendedproperty, sp_addextendedproperty, sp_updateextendedproperty)