Table name as parameter

[User 1804931]

Hi, Can I pass table name as a parameter to an stored procedure. Please is there any round the way to do this. Regards, Chakravarthy.V

[padvit]

If you are passing table_name as a parameter to stored procedure and using there is a specific syntax which should be followed and used. I dont remeber exaclt how I had done this. As well there are some limitations with the same. Padvit

[Plunging_Falcon]

You can use dynamic sql to do that. For instance, if you have a procedure that gets column_in as column parameter and table_in as table parameter, then you can write something like this: (Oracle SQL, haven't tested elsewhere) OPEN ref_cur1 FOR 'SELECT ' || column_in || ' FROM ' || table_in; I think if you are using SQL SERVER then you should just omit the OPEN...FOR part.

[utsav_verma]

Hope it'll help CREATE PROCEDURE [DBO].[GetFieldByID] (@FieldName varchar(50), @TableName varchar(50), @IDVal int) AS declare @IDField varchar(50) set @IDField = @TableName + 'ID' exec('select ' + @FieldName + ' from ' + @TableName + ' where ' + @IDField + ' = ' + @IDVal) GO UTSAV

[User 1804931]

Hi, It is working fine, thank you very much. Regards, Chakravarthy.v

[User 1804931]

Hi, I tested it but it is causing some problems, can you please verify this because this query is imp for me. Initially I tested this code only by passing the code then it worked fine. Regards KLAYAN

[utsav_verma]

wELL THIS CODE IS DAMN TESTED, I GUESS U R MISSING WRONG DATATYPE VALUE ooops, sorry 4 caps lock on, hope u'd not mind ;) UTSAV