Connect to a SQL Server database, obtain the list of stored procedures (USPs) in that db (process all schemas), get the code in these stored procs and save them as text files (.md) At the end, we'll ...

There are many benefits of using stored procedure, few of the reasons are to prevent SQL injection, minimize latency for batch operation, and also it improve performance by reusing compiled execution ...

Many times during SQL server development we need to search for a stored procedure containing a specific text. This helps in checking for dependencies for objects in stored procedures or sometimes we ...

In this blog we illustrate how to get the pagination data from SQL server stored procedure. To create a such type of a stored procedure, we need to send a minimum ...

We've got a strange problem here and I'm hoping someone has some kind of idea as to what could be causing it.<BR><BR>We've got a stored procedure in Sql Server 2005. It's not terribly complicated but ...

A Version 6 PROC SQL Pass-Through view does not need to be updated to be used in Version 7 or Version 8. The conversion of PROC SQL Pass-Through views is automatic and does not require you to use the ...

Looking to run SQL 2000 as a platform for an ERP app on a new box. Dual P4, 2GB RAM, up to 6 SCSI drives in any of a variety of RAID configurations.<BR><BR>The research I've done and the ERP vendor ...