Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Stored Procedures Rss

<< Newer    Items 41 to 60 of 180    Older >>
 

Dynamic creation of Insert, Update, Delete Stored procedures

Automates the creation of INSERT, UPDATE & DELETE stored procedure of a table  Read more...
By Deepthi Viswanathan Nair 2010/07/09 (first published: 2009/07/23) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 32,170 reads

Get default values of parameters in stored procedures

Helps to get the default value of parameters from stored procedures and functions.   Read more...
By Atif-ullah Sheikh 2010/06/22 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 2,005 reads

Using Certificates to Sign Stored Procedures

How to sign stored procedures with certificates, this is useful if the procedures use dynamic SQL.  Read more...
By Jonathan Roberts 2010/06/21 | Source: SQLServerCentral.com | Category: certificates
Rating: |  Discuss |   Briefcase | 7,628 reads

Stored Procedure Execution

By Jason Shadonix 2010/06/09 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,032 reads

Access variables values from Trigger

Pass variables values from Stored Procedures to Trigger  Read more...
By Tejas Shah 2010/06/09 | Source: SQLServerCentral.com | Category: triggers
Rating: |  Discuss |   Briefcase | 7,871 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 2010/05/21 | Source: SQLServerCentral.com | Category: rsexecutionlog
Rating: |  Discuss |   Briefcase | 1,774 reads

Slow SP with date parameters solved.

when you use datetime parameters in SPs in the where clause the SP becomes very slow  Read more...
Rating: |  Discuss |   Briefcase | 2,790 reads

How to find unused Stored Procedures in SQL Server 2005/2008

Use dynamic PivotTables to identify unused Stored Procedures in a SQL Server 2005/2008 database  Read more...
By Ronny Dahl 2010/04/15 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 26,076 reads

EXECute SQL Commands over entire sets of parameters!

A super-powered EXEC on steroids, the Power Tool every DBA wants for Christmas.  Read more...
By RBarry Young 2010/03/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,731 reads

Optimization

By Paul Randal 2010/03/01 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,044 reads

Implement a stack in SQL Server using stored procedures

In this article I will show you how to implement a stack.  In programming, stacks are a great way to...  Read more...
By Josef Richberg 2010/01/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 3,964 reads

Run SSIS packages from remote client with stored procedure

By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.  Read more...
By Jason Rowland 2010/01/12 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 8,018 reads

Generate stored procedure parameter list based on table order by table

this script does the same as the one publish on 04-12-2009 plus add the number of table you need and it will be sort by table name and ordinal position.  Read more...
Rating: |  Discuss |   Briefcase | 763 reads

Synchronize several stored procedure between two servers

Synchronize source code between two servers for multiple stored procedures  Read more...
By Th Tr 2009/12/21 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 1,143 reads

Synchronize all stored procedures between two servers

This script will synchronize all stored procedures between two servers, using spSynchStoredProcedure.  Read more...
By Th Tr 2009/12/15 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,049 reads

Synchronize a stored procedure between two servers

Use this stored procedure to synchronize source code of a stored procedure between two servers.  Read more...
By Th Tr 2009/12/11 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,560 reads

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: |  Discuss |   Briefcase | 1,636 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 | 30,200 reads

Auto-Execute Procs

By Taposh Dutta Roy 2009/11/16 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 3,763 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 2011/04/08 (first published: 2009/10/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,783 reads
<< Newer    Items 41 to 60 of 180    Older >>
 
Tags
t-sql (80)    
miscellaneous (21)    
programming (19)    
administration (17)    
sql server 7 (17)    
performance tuning (13)    
advanced querying (9)    
xml (9)    
ado (7)    
sql server 2005 (7)    
parameters (6)    
security (6)    
strategies (5)    
triggers (5)    
configuring (4)    
metadata (4)    
sql-dmo (4)    
visual basic 6 (4)    
backup / restore (3)    
development (3)    
dts (3)    
dynamic sql (3)    
insert (3)    
installation (3)    
integration services (ssis) (3)    
linked server (3)    
reporting services (ssrs) (3)    
select (3)    
temporary tables (3)    
update (3)    
3-tier design (2)    
autogenerate (2)    
blogs (2)    
chris morton (2)    
codrakon (2)    
database design (2)    
encryption (2)    
error handling (2)    
excel (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
search (2)    
sql server (2)    
sql server 2008 (2)    
user defined function (udf) (2)    
views (2)    
xsl (2)    
.net (1)    
::fn_listextendedproperty (1)    
arrays (1)    
asp (1)    
autogenerate parameters (1)    
automatic (1)    
automation (1)    
backup / recovery (1)    
basics (1)    
best and worst practices (1)    
call stack (1)    
certificates (1)    
charindex (1)    
coalesce (1)    
columns (1)    
context_info() (1)    
crosstab (1)    
data quality (1)    
date manipulation (1)    
dba (1)    
dba code (1)    
dependency (1)    
distributed queries (1)    
drop function (1)    
drop procedure (1)    
dynamic (1)    
ebook (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
english query (1)    
execute (1)    
execution plans (1)    
extended procedures (1)    
find foreign key using sql (1)    
function (1)    
functions (1)    
indexed views (1)    
information_schema.routines (1)    
input (1)    
insert update stored procedure generation (1)    
matrix (1)    
mkproc_createupdate (1)    
mkproc_get (1)    
multiple server (1)    
naming standards (1)    
nested loop (1)    
object_id (1)    
openxml (1)    
palalelism (1)    
parsing (1)    
passwords (1)    
performance monitoring (1)    
permissions (1)    
pivot (1)    
pivottable (1)    
profiler (1)    
query tuning (1)    
replication (1)    
report (1)    
resultset (1)    
rsexecutionlog (1)    
schemas/dtds (1)    
script (1)    
semaphore (1)    
service broker (1)    
set options (1)    
source control (1)    
split (1)    
splog (1)    
sql puzzles (1)    
sql server 6.5 (1)    
sqlclr (1)    
stack (1)    
statistics (1)    
stress test (1)    
sys.dm_exec_cached_plans (1)    
sys.dm_exec_sql_text (1)    
syscolumns (1)    
sysobjects (1)    
system development life cycle (1)    
system health (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
temp tables (1)    
try..catch (1)    
unused (1)    
updategrams (1)    
user-defined data types (1)    
utility (1)    
video (1)    
with encryption (1)    
worst practices (1)