SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tag Stored Procedures Rss

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

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...
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...
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...
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...
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...
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...
Rating: |  Discuss |  Briefcase | 14,366 reads