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

Content with tags T-SQL, Stored Procedures Rss

<< Newer    Items 21 to 40 of 102    Older >>
 

Stored procedure parameters

By gary.rumble 2009/08/10 | Category: stored procedures
Rating: (not yet rated) |  Discuss |   Briefcase | 4,685 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,829 reads

Lightweight source control

Versioning for Stored Procs and view   Read more...
By Jamie Ingram 2009/04/22 | Source: SQLServerCentral.com | Category: source control
Rating: |  Discuss |   Briefcase | 1,024 reads

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2013/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,344 reads

Find a Table's Metadata

Stored Procedure that returns table information  Read more...
By Crosbie Christopher 2008/10/23 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 1,326 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 | 13,259 reads

Passing a Table to A Stored Procedure

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...
By Jacob Sebastian 2007/12/07 (first published: 2007/05/30) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 65,459 reads

Giving Permissions through Stored Procedures

QL 2005 adds two new methods – signing with certificates and impersonation with EXECUTE AS – that can manage cases where the classic method of ownership chaining fails. I explain the two new methods, as well as the old one, and warns you about the pitfalls.  Read more...
By Additional Articles 2008/04/15 | Source: Erland Sommarskog's SQL Page | Category: t-sql
Rating:  Rate this |   Briefcase | 3,097 reads

How to Share Data Between Stored Procedures

Different ways of passing sets of data between stored procedures.  Read more...
Rating:  Rate this |   Briefcase | 7,489 reads

Designing High Performance Stored Procedures

Stored procedures can be an effective way to handle conflicting needs, but it's not always so obvious how to write them so they both perform well and scale.  Read more...
By Additional Articles 2007/02/05 | Source: DevX | Category: performance tuning
Rating:  Rate this |   Briefcase | 10,233 reads

Passing a Table to A Stored Procedure

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...
By Jacob Sebastian 2007/12/07 (first published: 2007/05/30) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 65,459 reads

Insert Update Stored Procedure for a table

Generic Script for Insert Update Stored Procedures  Read more...
By Prasad Bhogadi 2013/10/22 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 29,344 reads

Output Parameters

Regular columnist Robert Marda writes about the basics of using output parameters. If you're not using output params we hope this article will get you started - they are a great way to return less data to the client, perfect if you need only a few values and not a recordset/resultset.   Read more...
By Robert Marda 2007/10/26 (first published: 2003/11/25) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 31,802 reads

Passing a Table to A Stored Procedure

In the first article of a new series on T-SQL tips, Jacob Sebastian brings us a very useful technique. How to pass a table to a stored procedure so some set of rows can be operated on using some business logic.   Read more...
By Jacob Sebastian 2007/12/07 (first published: 2007/05/30) | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 65,459 reads

Nesting Stored Procedures

We're pleased to announce that Robert will be writing for us each month - generally on stored procedures, but occasionally on a different topic. This article discusses how nesting stored procedures works and how to use @@NextLevel. Good reading! If there is a stored procedure topic you'd like to see covered, add a comment to the article or email us at articles@sqlservercentral.com   Read more...
By Robert Marda 2007/05/18 (first published: 2003/05/23) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 35,045 reads

Sales Order Workshop Part IV

In the fourth installment of this series, Jacob Sebastian moves on to SQL Server 2005 and the new XML capabilities that make working with XML data easier than ever.   Read more...
By Jacob Sebastian 2007/04/05 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |   Briefcase | 12,216 reads

Sales Order Workshop Part III

In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes.   Read more...
By Jacob Sebastian 2007/04/03 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,670 reads

Sales Order Workshop Part II

In part 2 of this series, Jacob Sebastion continues looking at XML in SQL Server 2000 with some advanced XML processing.  Read more...
By Jacob Sebastian 2007/03/29 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 7,248 reads

Saving a Sales Order Part 1

How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000.   Read more...
By Jacob Sebastian 2007/03/27 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,012 reads

SQL Server Error Handling Workbench

Grant Fritchey steps into the workbench arena, with an example-fuelled examination of catching and gracefully handling errors in SQL 2000 and 2005, including worked examples of the new TRY..CATCH capabilities.  Read more...
By Additional Articles 2007/03/06 | Source: SimpleTalk | Category: stored procedures
Rating:  Rate this |   Briefcase | 3,110 reads
<< Newer    Items 21 to 40 of 102    Older >>
 
Tags
miscellaneous (20)    
programming (18)    
sql server 7 (16)    
administration (13)    
advanced querying (9)    
performance tuning (9)    
xml (8)    
ado (7)    
security (5)    
strategies (5)    
configuring (4)    
sql server 2005 (4)    
sql-dmo (4)    
triggers (4)    
visual basic 6 (4)    
dts (3)    
installation (3)    
linked server (3)    
backup / restore (2)    
database design (2)    
development (2)    
dynamic sql (2)    
indexing (2)    
maintenance and management (2)    
monitoring (2)    
sql server 2008 (2)    
user defined function (udf) (2)    
xsl (2)    
::fn_listextendedproperty (1)    
asp (1)    
basics (1)    
best and worst practices (1)    
coalesce (1)    
columns (1)    
dba (1)    
distributed queries (1)    
english query (1)    
execute (1)    
find foreign key using sql (1)    
indexed views (1)    
insert update stored procedure generation (1)    
naming standards (1)    
openxml (1)    
palalelism (1)    
parameters (1)    
replication (1)    
schemas/dtds (1)    
search (1)    
semaphore (1)    
source control (1)    
sp_rename (1)    
sql puzzles (1)    
sql server 6.5 (1)    
sqlclr (1)    
stress test (1)    
syscolumns (1)    
sysobjects (1)    
system development life cycle (1)    
system tables (1)    
table field information (1)    
table metadata (1)    
tables (1)    
updategrams (1)    
user-defined data types (1)    
utility (1)    
worst practices (1)