SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Stored Procedure Rss

Search for any content tagged stored procedure

   Items 1 to 6 of 6   

Can comments hamper stored procedure performance?

After a recent conversation on Twitter, Aaron Bertrand shows where excessive comments in your stored procedures might have an impact on performance.  Read more...
By Additional Articles 2016/12/08 | Source: SQLPerformance.com | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 4,537 reads

How to Get the Output of a Stored Procedure into a Table

Putting the output of a stored procedure into a table provides you multiple options for parsing and using the output with other TSQL commands. Read on to learn more.  Read more...
By Additional Articles 2016/11/30 | Source: Database Journal | Category: stored procedure
Rating:  Rate this |   Briefcase | 9,692 reads

Stairway to U-SQL Level 11: Stored Procedures

To finish off our look at the core database objects, we inspect how the venerable stored procedure works in U-SQL.  Read more...
By Mike McQuillan 2016/11/16 | Source: SQLServerCentral.com | Category: u-sql
Rating: |  Discuss |   Briefcase | 1,524 reads

How to Categorize Uncategorized Data

Using SQL to perform cluster analysis to gain insight into data with unknown groups  Read more...
By Stephan Calderon 2015/04/16 | Source: SQLServerCentral.com | Category: cluster analysis
Rating: |  Discuss |   Briefcase | 4,388 reads

Using the SQL Server APP_NAME function to control stored procedure execution

In this tip we will look at one way to achieve control of stored procedures to ensure that reuse is for the intended purpose and changes do not break other applications that may be using this same code.  Read more...
By Additional Articles 2013/03/29 | Source: MSSQLTips.com | Category: stored procedure
Rating: (not yet rated)  Rate this |   Briefcase | 4,190 reads

How to save results of a procedure with more than one result set

Sometimes a procedure returns more than 1 result set. The article describes how to save all result sets into new database tables  Read more...
By Pavel Sinkevich 2012/09/06 | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 10,183 reads
   Items 1 to 6 of 6