Passing Tablename
create procedure SAll (@tablename varchar(25))
as
EXEC (‘select * from ‘ + @tablename)
Passing Tablename
create procedure SAll (@tablename varchar(25))
as
EXEC (‘select * from ‘ + @tablename)
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
Posted in 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 | Leave a Comment »