Email Alerts
-
Stored procedures: Create and manage standard objects
This set of tools will quickly generate the necessary T-SQL code to create the objects needed for a proposed surrogate key architecture. Feature
-
Stored procedure: Examine children
Brian Walker offers a stored procedure for examining child rows. Feature
-
Stored procedures: Create and delete constraints and indexes
This collection of six stored procedures will help you create and delete constraints and indexes. Feature
-
Stored procedure: Investigate related data
Contributor Brian Walker offers this system stored procedure to return related data. Feature
-
Fast Guide: Stored procedures
Stored procedures can be executed quickly inside your database server, saving you the time it would take to do the same work on a client. In the second part of our stored procedure series of fast guides, we offer stored procedures to help you with SQ... Fast Guide
-
Replicate stored procedure execution
Find out why and how you must replicate stored procedure execution in this tip, one of 15 replication tips in 15 minutes. Tech Article
-
Freebies: Stored procedures and functions
Here are some of SQL Server performance tuning expert Jeremy Kadlec's favorite stored procedures and functions. Tech Article
-
Microsoft previews new SQL Server in-memory database features
Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server. News | 07 Nov 2012
-
Saying yes, no or maybe to stored procedures
The world of software somewhat resembles a pendulum. Styles of development swing in and out of favor. Take stored procedures, which work to some extent and may sometimes be the shortest way to a successful project. Article | 16 Aug 2006
-
SQL Server freebie: PromptSQL for word completion
This add-on application, available for a 30-day free trial, provides auto-complete functionality as you type for programs used to create SQL statements. News | 23 Nov 2005
-
Why use stored procedures?
Stored procedures offer several distinct advantages over embedding queries in your Graphical User Interface (GUI). Your first thought may be: "Why tolerate the added development overhead?" After seeing the advantages, you may change your mind. Article | 09 Feb 2005
-
SQL Server stored procedures vs. CLR stored procedures: Time to migrate?
Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you. Tip
-
Best practices for preventing a SQL injection attack
One of the sneakiest ways for a hacker to invade your system is via a SQL injection attack. Expert Robert Sheldon explains how to keep hackers out. Tip
-
SQL Server stored procedures supercharged in recent, upcoming versions
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release. Tip
-
Finding your way around SQL Server data preservation
Need to know what a table looked like before changes were changes were made? There are several tools for SQL Server data preservation -- SQL Server change tracking and SQL Server database mirroring among them -- each with its own uses and limitations... Tip
-
Top tips and tricks for SQL Server database development
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more. Tip
-
SQL Server errors, failures and other problems fixed from the trenches
SQL Server expert Matthew Schroeder gets down into the trenches to help resolve your SQL Server issues. Whether it's a failed cluster installation, a long-running stored procedure that causes a 3 a.m. phone call or a database in suspect mode, he's go... Tip
-
Check SQL Server database and log file size with this stored procedure
Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Space," but it can also be used to monitor database growt... Tip
-
SQL Server source code analysis and management adds database security
Manage and protect your SQL Server databases by implementing source code analysis. Source code is the foundation of any application, and integrating methods to test and debug this code adds a key layer of security. IT security specialist Kevin Beaver... Tip
-
Configure SQL Server Service Broker for sending stored procedure data
The Service Broker feature in SQL Server 2005 allows you to queue data of stored procedures and other application development components. Instead of processing the data, it's sent to a queue where it can be automatically read at a later date and proc... Tip
-
Find size of SQL Server tables and other objects with stored procedure
When determining SQL Server disk space used by an object, Microsoft's sp_spaceused has limits. Here's an original stored procedure, sp_SOS, that calculates specific object space in SQL Server. Use it to get an overview of user table sizes in a databa... Tip
- See more Tips on SQL Server Stored Procedures
-
Use SQL Profiler to find long running stored procedures and commands
Troubleshoot long running stored procedures with SQL Server Profiler by adding events to find the command with high run time. Ask the Expert
-
How can I export stored procedures in SQL Server 2005?
Export stored procedures in SQL Server 2005 with these step-by-step instructions in SQL Server Management Studio. Ask the Expert
-
Using BULK INSERT to insert rows from SQL Server dataset to table
Learn how to use BULK INSERT to import all SQL Server dataset rows to a table. Ask the Expert
-
SQL Server query to import database names
Discover a query that will import all database names into your SQL Server. Ask the Expert
-
Stored procedure for a BULK INSERT to SQL Server 2005 text file
Discover a stored procedure using the BULK INSERT command to import multiple tables to a SQL Server 2005 text file. Ask the Expert
-
Change collation to SQL Server 2005 after upgrading databases
Want to change the collation to SQL Server 2005 standards after upgrading databases from SQL Server 2000? Learn the best approach involving DTS and SSIS. Ask the Expert
-
Schedule stored procedure and save output to network drive
Find how to save stored procedure output to the network drive via SQL Server Management Studio. Ask the Expert
-
BULK INSERT to import data from file to SQL Server database
Looking for a stored procedure to import data from a file to a SQL Server database? Perhaps all you need is the BULK INSERT command. Ask the Expert
-
How to insert into SQL Server system tables
Get the stored procedure to enable SQL Server updates to the systems' catalog in SQL Server 2005. Ask the Expert
-
Get stored procedure results for unknown fields
Learn how to insert stored procedure results for result fields that are unknown by using the programming library. Ask the Expert
- See more Expert Advice on SQL Server Stored Procedures
-
library
In computing, a library is a collection of similar objects that are stored for occasional use - most frequently, programs in source code or object code form, data files, scripts, templates, fonts, and physical storage units such as tape cartridges. Definition
-
trigger
A trigger (from the Dutch trekken, meaning to pull) is a lever which, when pulled by the finger, releases the hammer on a firearm. Definition
-
Microsoft previews new SQL Server in-memory database features
Microsoft plans to offer new in-memory database capabilities with the next release of SQL Server. News
-
SQL Server stored procedures vs. CLR stored procedures: Time to migrate?
Should you use SQL Server stored procedures or CLR stored procedures? Expert Serdar Yegulalp helps you decide which is more appropriate for you. Tip
-
Best practices for preventing a SQL injection attack
One of the sneakiest ways for a hacker to invade your system is via a SQL injection attack. Expert Robert Sheldon explains how to keep hackers out. Tip
-
SQL Server stored procedures supercharged in recent, upcoming versions
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release. Tip
-
Finding your way around SQL Server data preservation
Need to know what a table looked like before changes were changes were made? There are several tools for SQL Server data preservation -- SQL Server change tracking and SQL Server database mirroring among them -- each with its own uses and limitations... Tip
-
Top tips and tricks for SQL Server database development
Check out these handy database development best practices, with tips on dealing with batch updates, stored procedures and more. Tip
-
SQL Server errors, failures and other problems fixed from the trenches
SQL Server expert Matthew Schroeder gets down into the trenches to help resolve your SQL Server issues. Whether it's a failed cluster installation, a long-running stored procedure that causes a 3 a.m. phone call or a database in suspect mode, he's go... Tip
-
Check SQL Server database and log file size with this stored procedure
Knowing the size of a SQL Server database is one of the many DBA responsibilities that you can accomplish easily with the stored procedure sp_SDS. Not only will sp_SDS determine "SQL Database Space," but it can also be used to monitor database growt... Tip
-
SQL Server source code analysis and management adds database security
Manage and protect your SQL Server databases by implementing source code analysis. Source code is the foundation of any application, and integrating methods to test and debug this code adds a key layer of security. IT security specialist Kevin Beaver... Tip
-
Configure SQL Server Service Broker for sending stored procedure data
The Service Broker feature in SQL Server 2005 allows you to queue data of stored procedures and other application development components. Instead of processing the data, it's sent to a queue where it can be automatically read at a later date and proc... Tip
- See more All on SQL Server Stored Procedures
About SQL Server Stored Procedures
Stored procedures are intended to make SQL Server development easier. Why write the same query over and over again, when you can just save it in the database. Writing stored procedures in T-SQL and CLR are covered in this topic's section, from querying and debugging to working with triggers. A stored procedure simplifies database development because it allows for more modular programming. You can create discrete pieces of functionality with stored procedures. Stored procedures have the parsing and execution plan built in when they are created so they execute faster than dynamic SQL.