Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Articles with tag
Stored Procedures
Refine your search with one of the following additional tags (with number of items):
T-SQL
(62)
Installation
(3)
Development
(1)
Naming Standards
(1)
Miscellaneous
(20)
SQL Server 2005
(3)
Distributed Queries
(1)
OpenXML
(1)
Programming
(18)
Backup and Recovery
(2)
Dynamic SQL
(1)
Performance Monitoring
(1)
SQL Server 7, 2000
(17)
Database Design
(2)
Editorial
(1)
Profiler
(1)
Administration
(15)
Indexing
(2)
Editorial - iPod
(1)
Replication
(1)
Performance Tuning
(10)
Monitoring
(2)
Editorial - MP3
(1)
Schemas/DTDs
(1)
Basic Querying
(9)
Reporting Services (SSRS)
(2)
Editorial - WMV
(1)
Semaphore
(1)
Advanced Querying
(8)
User Defined Function (UDF)
(2)
English Query
(1)
SQL Puzzles
(1)
ADO
(7)
XSL
(2)
Error Description
(1)
SQL Server 6.5
(1)
Security
(5)
Arrays
(1)
Error Messages
(1)
SS2K5 - XML
(1)
Strategies
(5)
ASP
(1)
Error Number
(1)
System Development Life Cycle
(1)
XML
(5)
Basics
(1)
Excel
(1)
Temp tables
(1)
Configuring
(4)
Best and Worst Practices
(1)
extended procedures
(1)
Temporary Tables
(1)
SQL-DMO
(4)
Blogs
(1)
Integration Services (SSIS)
(1)
UpdateGrams
(1)
Triggers
(4)
Crosstab
(1)
Matrix
(1)
Video
(1)
Visual Basic 6
(4)
Data Quality
(1)
Metadata
(1)
Worst Practices
(1)
DTS
(3)
Search for
any
content tagged
Stored Procedures
Items 1 to 20 of 97
Next 20 >>
Undocumented Extended and Stored Procedures
Some useful undocumented extended and stored procedures in SQL Server 2005
Read more...
By
Timothy A Wiseman
2009/11/20 (first published: 2008/05/09)
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
14,530 reads
Methods For Converting a Stored Procedure
An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.
Read more...
By
Eli Leiba
2009/10/29
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
12,608 reads
Excel with Stored Procedures
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
Read more...
By
David Poole
2009/10/09 (first published: 2008/08/13)
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
37,218 reads
Dynamic creation of Insert, Update, Delete Stored procedure
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
Read more...
By
Deepthi Viswanathan Nair
2009/07/23
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
14,366 reads
The Pros and Cons of Stored Procedures
I saw this mentioned on Twitter, and watched it while doing some light editing and scheduling. It’s from TechEd 2009 in LA, and includes a number of MVPs and consultants and even a Microsoft SQL Server program manager. It’s a video, running about 55 minutes...
Read more...
By
Steve Jones
2009/05/22
|
Source:
SQLServerCentral.com
|
Category:
Blogs
Rating:
(not yet rated)
Rate this
|
Briefcase
|
3,753 reads
The Multi-valued Parameters problem in Reporting Services
Longtime SQLServerCentral author, Alex Grinberg, brings us a short piece on how to deal with multi-valued parameters in Reporting Services when you have a stored procedure call.
Read more...
By
Alex Grinberg
2009/04/21
|
Source:
SQLServerCentral.com
|
Category:
Reporting Services (SSRS)
Rating:
|
Discuss
|
Briefcase
|
9,000 reads
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
Read more...
By
Steve Jones
2009/02/27
|
Source:
SQLServerCentral.com
|
Category:
Editorial
Rating:
|
Discuss
|
Briefcase
|
239 reads
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
Read more...
By
Steve Jones
|
Source:
SQLServerCentral.com
|
Category:
Editorial - MP3
Rating:
(not yet rated)
Rate this
|
Briefcase
|
147 reads
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
Read more...
By
Steve Jones
|
Source:
SQLServerCentral.com
|
Category:
Editorial - WMV
Rating:
(not yet rated)
Rate this
|
Briefcase
|
150 reads
Pruning
DBAs tend to be very organized, and most of them don't want unnecessary objects on their systems. Is it worth cleaning up? Steve Jones asks the question this Friday.
Read more...
By
Steve Jones
|
Source:
SQLServerCentral.com
|
Category:
Editorial - iPod
Rating:
(not yet rated)
Rate this
|
Briefcase
|
145 reads
Get Error Description in SQL Server 2000
How to Extract Error Description in SQL Server 2000 based on Error Number
Read more...
By
Mudassar Ahmed Khan
2009/01/13
|
Source:
SQLServerCentral.com
|
Category:
Error Description
Rating:
|
Discuss
|
Briefcase
|
5,561 reads
Getting A Clue About Your Databases
Got a new database you know nothing about? Here's my basic proposal on how to find interesting tables in it.
Read more...
By
Gregor Borosa
2009/01/09
|
Source:
SQLServerCentral.com
|
Category:
Data Quality
Rating:
|
Discuss
|
Briefcase
|
9,873 reads
SSIS and Stored procedures using temp tables
SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.
Read more...
By
Michael Cape
2008/12/26
|
Source:
SQLServerCentral.com
|
Category:
Integration Services (SSIS)
Rating:
|
Discuss
|
Briefcase
|
7,371 reads
Performance testing and tuning for a beginner
How to test and tune a stored procedure?
Read more...
By
Arup Chakraborty
2008/11/17
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
17,063 reads
Creating Functions for Stored Procedures
With the advent of so many new technologies in the Microsoft space, a DBA needs to learn more and more about many of them that aren't a part of SQL Server. Alex Grinberg brings us a technique he has used to create ADO functions for your stored procedures.
Read more...
By
Alex Grinberg
2008/10/10
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
12,516 reads
Excel with Stored Procedures
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
Read more...
By
David Poole
2009/10/09 (first published: 2008/08/13)
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
37,218 reads
Creating Stored Procedures - SQL School Video
MVP Brian Knight covers the basics of creating stored procedures in SQL Server. Stored Procedures are ways of encapsulating a section of code inside of a function, and this video shows how you to convert your queries to stored procedures.
Read more...
By
Brian Knight
2008/07/29
|
Source:
SQLServerCentral.com
|
Category:
Video
Rating:
|
Discuss
|
Briefcase
|
6,697 reads
Reporting Services: Adding extra columns / rows to a matrix
The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described.
Read more...
By
Martin Cremer
2008/07/24
|
Source:
SQLServerCentral.com
|
Category:
Reporting Services (SSRS)
Rating:
|
Discuss
|
Briefcase
|
12,249 reads
Searching Objects for Text
When searching meta-data to find an occurance of a particular string or pattern it is difficult to look everywhere. This procedure helps you find what you are looking for.
Read more...
By
Solomon Rutzky
2008/05/28
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
6,281 reads
Measuring Performance of Stored Procedures
Database developers need to write stored procedures which are not only fully functional, but also which perform acceptably. This article concentrates on some of the counters used to measure performance and analyses methods of capturing these counters.
Read more...
By
Additional Articles
2008/05/21
|
Source:
SQL Server Universe
|
Category:
Performance Monitoring
Rating:
Rate this
|
Briefcase
|
6,173 reads
Items 1 to 20 of 97
Next 20 >>
Most popular
Methods For Converting a Stored Procedure
An interesting use of T-SQL to run a stored procedure as part of a SELECT statement to get a result set to be used and combined with other tables. From Eli Leiba, learn how you can build a stored procedure into your queries.
Read more...
By
Eli Leiba
2009/10/29
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
12,608 reads
Excel with Stored Procedures
Longtime DBA David Poole brings us an interesting situation in involving setting up a user to allow Excel to query data from SQL Server.
Read more...
By
David Poole
2009/10/09 (first published: 2008/08/13)
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
37,218 reads
Dynamic creation of Insert, Update, Delete Stored procedure
Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table
Read more...
By
Deepthi Viswanathan Nair
2009/07/23
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
14,366 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use