<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
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
Content with tag
Stored Procedures
Refine your search with one of the following additional tags (with number of items):
T-SQL
(67)
Monitoring
(2)
DROP PROCEDURE
(1)
Replication
(1)
Miscellaneous
(21)
parameters
(2)
dynamic
(1)
report
(1)
Programming
(18)
Reporting Services (SSRS)
(2)
Editorial
(1)
Reporting Services Execution Log
(1)
SQL Server 7, 2000
(17)
Search
(2)
Editorial - iPod
(1)
RSExecutionLog
(1)
Administration
(16)
select
(2)
Editorial - MP3
(1)
Schemas/DTDs
(1)
Performance Tuning
(10)
update
(2)
Editorial - WMV
(1)
script
(1)
Basic Querying
(9)
User Defined Function (UDF)
(2)
Encryption
(1)
Semaphore
(1)
Advanced Querying
(8)
XSL
(2)
English Query
(1)
source control
(1)
ADO
(7)
::fn_listextendedproperty
(1)
Error Description
(1)
split
(1)
Security
(5)
Arrays
(1)
Error Messages
(1)
splog
(1)
SQL Server 2005
(5)
ASP
(1)
Error Number
(1)
SQL Puzzles
(1)
Strategies
(5)
AutoGenerate parameters
(1)
Excel
(1)
SQL Server 6.5
(1)
XML
(5)
automatic
(1)
Execute
(1)
SS2K5 - XML
(1)
Configuring
(4)
Basics
(1)
extended procedures
(1)
System Development Life Cycle
(1)
Metadata
(4)
Best and Worst Practices
(1)
find foreign key using SQL
(1)
System Tables
(1)
SQL-DMO
(4)
Blogs
(1)
function
(1)
table field information
(1)
Triggers
(4)
charindex
(1)
Indexed Views
(1)
table metadata
(1)
Visual Basic 6
(4)
CLR functions
(1)
INFORMATION_SCHEMA.ROUTINES
(1)
tables
(1)
DTS
(3)
CLR Stored Procedures
(1)
Integration Services (SSIS)
(1)
Temp tables
(1)
Installation
(3)
CLR UDT
(1)
Maintenance and Management
(1)
Temporary Tables
(1)
AutoGenerate
(2)
Coalesce
(1)
Matrix
(1)
temporary tables
(1)
Backup and Recovery
(2)
column description wi SQL
(1)
Naming Standards
(1)
T-SQL Aids
(1)
chris morton
(2)
Crosstab
(1)
nested loop
(1)
UpdateGrams
(1)
codrakon
(2)
Data Quality
(1)
Object_ID
(1)
Utility
(1)
Database Design
(2)
DBA Code
(1)
OpenXML
(1)
Video
(1)
Dynamic SQL
(2)
Development
(1)
Performance Monitoring
(1)
Views
(1)
Indexing
(2)
Distributed Queries
(1)
pivot
(1)
WITH ENCRYPTION
(1)
insert
(2)
DROP FUNCTION
(1)
Profiler
(1)
Worst Practices
(1)
Items 1 to 20 of 116
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,604 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,216 reads
The Ultimate Object Searcher
Searches for objects (including CLR) who's names contain the search string. outputs IDs, names, and types of the object and its parent.
Read more...
By
Jesse Roberge
2009/10/06
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
600 reads
Encrypt All Stored procedures at once
this code encrypts all stored procedures that meet a certain format. this code is easy to change to suit your particular needs, but be sure to back up your stored procs first.
Read more...
By
Chris Morton
0001/01/01
|
Source:
SQLServerCentral.com
|
Category:
WITH ENCRYPTION
Rating:
|
Discuss
|
Briefcase
|
1,653 reads
Automatic Generation of Insert, Update and Delete stored procedures
This script automatically generates stored procedures for insert, update and delete operations on the given table
Read more...
By
Samardeep Khera
2009/08/12
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
1,007 reads
Stored procedure parameters
Read more...
By
gary.rumble
2009/08/10
|
Category:
Stored Procedures
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,979 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
Using Coalesce in a stored Procedure
A quick way to take a column of data and place it into a variable in a Stored Procedure in a comma, separated format.
Read more...
By
Richard Spalding
2009/06/26
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
1,329 reads
Stored Procedure to maintain RSExecutionLog
An alternative to the SSIS approach to maintaining an RSExecutionLog database for Reporting Services supplied by Microsoft
Read more...
By
Perry Dyball
2009/06/03
|
Source:
SQLServerCentral.com
|
Category:
RSExecutionLog
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
422 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
Lightweight source control
Versioning for Stored Procs and view
Read more...
By
Jamie Ingram-729524
2009/04/22
|
Source:
SQLServerCentral.com
|
Category:
source control
Rating:
|
Discuss
|
Briefcase
|
700 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
List of Stored procedures in your database
This query returns the list of stored procedures in the database it's run on, and other details like schema, date..
Read more...
By
VM-723206
2009/03/20
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
1,544 reads
DROP all stored procedures
This code will drop all stored procedures made with splog. With minor modification it will also drop all functions and sp not made with splog.
Read more...
By
Chris Morton
2009/03/13
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
535 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
Search All SQL Script Objects in All Databases for Text
Edit the @SearchText and you can enter any text you would like to search for in SQL Objects.
Read more...
By
Joshua A. Walker
2009/02/19
|
Source:
SQLServerCentral.com
|
Category:
Stored Procedures
Rating:
|
Discuss
|
Briefcase
|
1,019 reads
Items 1 to 20 of 116
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,604 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,216 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
