-->i have store procedure of search with static tablename:
"select * from customer where @datafield=@valuefield"
in above i pass column name and values... but tablename is static
so in my database haveing 7 table for above query so i create 1 store procedure for each table...
-->but i thinks some different for store procedure of search with dynamically:
if i create single store procedure for all 7 table like this:
"select * from @tblname where @datafield=@valuefield"
where tablename,columnname,valuename all thing given dynamically
my question is "what is affect of above to store procedure of search on website ??
dynamically store procedure of search decrease performance then static table name"
it if on website or database performance ...when i host it