Home > SQL Server Learning Center
EMAIL THIS
 Learning Center:  Stored procedures
Last Updated: Jan 18, 2006 
Stored procedures are an essential component of an efficient and well-constructed database, providing a means to streamline development by grouping T-SQL statements into smaller blocks. Try out the stored procedures in this ...
>> Ask Andrew Novick your stored procedure questions here.
>> Check out our complete collection of stored procedures.
Why use stored procedures?

(26 Jul 2005)

Contributor Parthasarathy Mandayam discusses the four advantages of stored procedures over embedded queries.

Read Full Story
ADVICE:
>> Undocumented stored procedures: Registry manipulation in SQL Server 7.0 and 2000
TIP :Among the many undocumented functions you'll find in SQL Server 7.0 and 2000 is a set of extended stored procedures to ...
>> Stored procedures: Find columns and tables
TIP :Continuing our stored procedure series, this simple routine is handy for finding columns by name and listing the table(s) in ...
>> Undocumented stored procedure: Return string type for a column with sp_gettypestring
TIP :One useful (albeit unsupported) stored procedure in SQL Server 2000 is the sp_gettypestring, which can be used to return the ...
>> Stored procedure: List SQL Server database objects by selected type(s)
TIP :Brian Walker presents a simple stored procedure to return a list of all the objects of selected types in the current ...
>> How to use results from one stored procedure in another
ASK THE EXPERTS :I've written a stored procedure for use in a Crystal Report. It works great. I would also like to use the results from this ...
>> Writing stored procedures in SQL Server to import data
ASK THE EXPERTS :Can a stored procedure be used to import data from other types of database's and text files to SQL Server?
>> Stored procedures and remote procedure calls
ASK THE EXPERTS :Is a stored procedure a remote procedure call?

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


RELATED CONTENT
SQL Server Stored Procedures
SQL Server Mailbag: CALs, witnesses and unwanted changes
SQL Server Mailbag: Stored procedures, triggers and SSRS reports
Top tips and tricks for SQL Server database development
Top 10 SQL Server development tips of 2008
SQL Server trigger vs. stored procedure to receive data notification
SQL Server errors, failures and other problems fixed from the trenches
SQL Server and data manipulation in T-SQL
How to use SQL Server 2008 hierarchyid data type
SQL Server stored procedures tutorial: Write, tune and get examples
Check SQL Server database and log file size with this stored procedure

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
library  (SearchSQLServer.com)
trigger  (SearchSQLServer.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

> SQL Server restore how-tos
> Learning Center: Top 10 SQL Server security tips
> SQL Server 2005 data mining
> SQL Server 2005 security
> Database design decisions
View All Topics

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts