How create Dynamic Stored Procedure?

[bharanikrishna]

i want one stored procedure

specs: i give three parameters to the stored procedure , using these three parameters the stored procedure will insert data into database

parameters


param1: tablename
param2: column name
param3: column data(some value to that column)

so write a sql stored procedure it genates dynamic
sql query. after genarating sql query we have to execute that query in the same stored procedure..

Thanking you
Bharani krishna

 

[tlbroadbent]

Only one column to update in the table? No data types in the spec? Not much to go on! Oh well, here goes...

------------------------------
Create Procedure DynamicProc
@tblname varchar(128),
@colname varchar(128),
@data varchar(128) As

Declare @sql varchar(1024)

Set @sql="Insert " + @tblname + "(" + @colname + &quot Values('" + @data + "')"

exec sp_executesql @sql

Go
------------------------------

Task accomplished! Terry
------------------------------------
Blessed is the man who, having nothing to say, abstains from giving us worthy evidence of the fact. -George Eliot