Passing Tablename
create procedure SAll (@tablename varchar(25))
as
EXEC (‘select * from ‘ + @tablename)
udhaya
PiSquare Soft Solns
Tags: c#, c# stored procedure, CSharp, EXEC ('select * from ' + @tablename), How to pass tablename as parameter, kps, MSSQL, mssql stored procedures, pisquare, procedure, select query on stored procedure, Stored Procedure, tablename, udhaya
This entry was posted on November 28, 2008 at 9:33 am and is filed under c# application, c# client server windows application, c#.net, c#.net stored procedures, client server c#, data binding using c#, data member, data source, database grid, dataset, easy way to pass a table name to stored procudure, EXEC ('select * from ' + @tablename), how to use select query on stored procedure, mssql stored procedures, passing table name, passing table name to stored procedure, table binding. You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or trackback from your own site.
Leave a comment