Create Procedure GenericTableSelect
	@TableName VarChar(100)
AS

Declare @SQL VarChar(1000)

SELECT @SQL = 'SELECT * FROM ' 
SELECT @SQL = @SQL + @TableName

Exec ( @SQL)

GO

SELECT @SQL = 'SELECT * FROM ' 
SELECT @SQL = @SQL + @TableName

create Procedure GenericTableSelect
	@TableName VarChar(100),
@columnname varchar(max)
AS

Declare @SQL VarChar(1000)

SELECT @SQL = 'SELECT + @columnname + FROM + @TABLENAME'

Exec ( @SQL)

GO

create Procedure GenericTableSelect
	@TableName VarChar(100),
@columnname varchar(max)
AS

Declare @SQL NVarChar(1000)

SELECT @SQL = 'SELECT '+ @columnname + ' FROM ' + QUOTENAME(@TableName)
-- print @SQL

Exec ( @SQL)

GO

quote:

---

Originally posted by learning_grsql

Thanks to all of you
@James..
print @SQL doesn't work in my case. Maybe because mine is sql server 2003?
Even after I uncomment it, I don't see the strings I'm constructing. However, it works with "select @sql" given by nigelrivett

---

quote:

---

Originally posted by learning_grsql

Thanks.

@James..I got it now. It was under message tab.

@visakh16..sorry ..it is sql server 2005

---

Declare @SQL VarChar(max)
DECLARE @DEBUG BIT
set @DEBUG = 0

SELECT @SQL = 'SELECT ' + @columnname + ' from ' + @tablename

IF @debug = 1
print @SQL


Exec ( @SQL)

quote:

---

Originally posted by nigelrivett



Declare @SQL VarChar(max)
DECLARE @DEBUG BIT
set @DEBUG = 1

SELECT @SQL = 'SELECT ' + @columnname + ' from ' + @tablename

IF @debug = 1
print @SQL


Exec ( @SQL)


As it is an SP make the debug flag an optional parameter

create Procedure GenericTableSelect
@TableName VarChar(100),
@columnname varchar(max) ,
@debug int = 0
AS

Declare @SQL NVarChar(1000)

SELECT @SQL = 'SELECT '+ @columnname + ' FROM ' + QUOTENAME(@TableName)
if @debug = 1
begin
PRINT @SQL
end
else
begin
Exec ( @SQL)
end
go

Then you can set the flag = 1 on a call if you wish to just view the string that will be executed without executing it.
You can use another value if you want to display and execute.

I create a table called trace to log info from everything that is not run too often.
I this situation I would log the string before the call and the completion to record what had happened and how long it took.
As in
http://www.nigelrivett.net/Products/DWBuilder/TraceTable.html


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---