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

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Data Dictionary

By Timothy Harms,

Set the variable values, entering server name, database name, table name open query and debug, shown below..

@Server NVARCHAR(1000) = ''/*can be blank for non openquery*/
@Database NVARCHAR(1000) = ''/*cannot be blank*/
@TableName NVARCHAR(1000) = ''/*cannot be blank*/
@OpenQuery BIT= 0/*1 will use open query, 0 will not*/
@Debug BIT = 0 /*1 with Print @sql, 0 will execute @sql*/
and execute.

Total article views: 388 | Views in the last 30 days: 382
 
Related Articles
FORUM

Blank page

Blank page inserted in SSRS 2008

FORUM

datetime - 1/1/1900 treated as blank??

(not, blank treated as 1/1/1900)

FORUM

datetime - 1/1/1900 treated as blank??

(not, blank treated as 1/1/1900)

FORUM

subreport pass a blank parameter

subreport parameter id blank - error

 
Contribute