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
(69)
Monitoring
(2)
Editorial
(1)
RSExecutionLog
(1)
Miscellaneous
(21)
Reporting Services (SSRS)
(2)
Editorial - iPod
(1)
Schemas/DTDs
(1)
Programming
(18)
Search
(2)
Editorial - MP3
(1)
script
(1)
SQL Server 7, 2000
(17)
select
(2)
Editorial - WMV
(1)
Semaphore
(1)
Administration
(16)
update
(2)
Encryption
(1)
source control
(1)
Performance Tuning
(10)
User Defined Function (UDF)
(2)
English Query
(1)
split
(1)
Basic Querying
(9)
XSL
(2)
Error Description
(1)
splog
(1)
Advanced Querying
(8)
::fn_listextendedproperty
(1)
Error Messages
(1)
SQL Puzzles
(1)
ADO
(7)
Arrays
(1)
Error Number
(1)
SQL Server 2008
(1)
SQL Server 2005
(6)
ASP
(1)
Excel
(1)
SQL Server 6.5
(1)
Security
(5)
AutoGenerate parameters
(1)
Execute
(1)
SS2K5 - XML
(1)
Strategies
(5)
automatic
(1)
extended procedures
(1)
syscolumns
(1)
XML
(5)
Basics
(1)
find foreign key using SQL
(1)
Sysobjects
(1)
Configuring
(4)
Best and Worst Practices
(1)
function
(1)
System Development Life Cycle
(1)
Metadata
(4)
Blogs
(1)
Indexed Views
(1)
System Tables
(1)
SQL-DMO
(4)
charindex
(1)
INFORMATION_SCHEMA.ROUTINES
(1)
table field information
(1)
Triggers
(4)
CLR functions
(1)
Integration Services (SSIS)
(1)
table metadata
(1)
Visual Basic 6
(4)
CLR Stored Procedures
(1)
Maintenance and Management
(1)
tables
(1)
DTS
(3)
CLR UDT
(1)
Matrix
(1)
Temp tables
(1)
Installation
(3)
Coalesce
(1)
Naming Standards
(1)
Temporary Tables
(1)
parameters
(3)
column description wi SQL
(1)
nested loop
(1)
temporary tables
(1)
AutoGenerate
(2)
Crosstab
(1)
Object_ID
(1)
T-SQL Aids
(1)
Backup and Recovery
(2)
Data Quality
(1)
OpenXML
(1)
UpdateGrams
(1)
chris morton
(2)
DBA Code
(1)
Performance Monitoring
(1)
Utility
(1)
codrakon
(2)
Development
(1)
pivot
(1)
Video
(1)
Database Design
(2)
Distributed Queries
(1)
Profiler
(1)
Views
(1)
Dynamic SQL
(2)
DROP FUNCTION
(1)
Replication
(1)
WITH ENCRYPTION
(1)
Indexing
(2)
DROP PROCEDURE
(1)
report
(1)
Worst Practices
(1)
insert
(2)
dynamic
(1)
Reporting Services Execution Log
(1)
Items 1 to 20 of 118
Next 20 >>
Generate stored procedure parameter list based on table
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with lots of columns.
Read more...
By
Thomas Cournane
2009/12/04
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
17 reads
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
|
22,296 reads
Auto-Execute Procs
Read more...
By
Taposh Dutta Roy
2009/11/16
|
Category:
Stored Procedures
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,318 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
|
13,361 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,564 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
|
631 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,677 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,028 reads
Stored procedure parameters
Read more...
By
gary.rumble
2009/08/10
|
Category:
Stored Procedures
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
4,032 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,441 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,346 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
|
439 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,764 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
|
706 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,037 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,557 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
|
544 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
|
242 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
|
156 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
|
158 reads
Items 1 to 20 of 118
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
|
13,361 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,441 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,564 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use