SQLServerCentral: Content tagged list

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: SQLServerCentral.com | Category: tables

Rating:

|

Discuss |

Briefcase | 816 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: SQLServerCentral.com | Category: sql

Rating:

|

Discuss |

Briefcase | 1,873 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: SQLServerCentral.com | Category: cte

Rating:

|

Discuss |

Briefcase | 1,928 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,494 reads

who can do what?

list each user has the right to do Read more...

By Ricardo Leka 2011/10/31 | Source: SQLServerCentral.com | Category: security |

SQL Scripts Manager Compatible

Rating:

|

Discuss |

Briefcase | 2,023 reads

Content with tag list

Tables and rows listing

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

Convert a string list to TABLE with single CTE query

Using XML to pass lists as parameters in SQL Server

who can do what?