Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag list Rss

   Items 1 to 6 of 6   

Find server in complex CMS hierarchy

List all the instances with their paths as stored on CMS.  Read more...
By Cheetah 2014/07/28 | Source: | Category: list
Rating: (not yet rated) |  Discuss |   Briefcase | 438 reads

Tables and rows listing

Simple script which create a list of all the tables and rows of the selected DB.  Read more...
By Claudio Tregambe 2013/02/11 | Source: | Category: tables
Rating: |  Discuss |   Briefcase | 1,032 reads

Script to get an ordered list of all stored procedures with parameters

Generate a per-schema, per-procedure ordered list of all stored procedures for the current database, together with their parameters, datatypes and nullability.  Read more...
By Derek Colley 2012/08/14 | Source: | Category: t-sql
Rating: |  Discuss |   Briefcase | 2,082 reads

Convert a string list to TABLE with single CTE query

Converts a string list into a table using a single query, no variables and no helper functions.  Read more...
By Dimitris Staikos 2012/05/11 | Source: | Category: cte
Rating: |  Discuss |   Briefcase | 2,231 reads

Using XML to pass lists as parameters in SQL Server

Every so often, the question comes up on forums of how to pass a list as a parameter to a SQL procedure or function. Phil Factor provides some examples using XML, and tests them against other popular methods.  Read more...
By Additional Articles 2012/01/26 | Source: SimpleTalk | Category: xml
Rating:  Rate this |   Briefcase | 3,704 reads

who can do what?

list each user has the right to do 
Rating: |  Discuss |   Briefcase | 2,225 reads
   Items 1 to 6 of 6   
t-sql (2)    
columns (1)    
cte (1)    
data dictionary (1)    
grantee (1)    
grantor (1)    
parameter (1)    
permission (1)    
recursive (1)    
security (1)    
sp_sproc_columns (1)    
stored procedure (1)    
tables (1)    
type (1)    
xml (1)