kumar4ashwani (4/23/2014)
how can i restrict the query on query window that contain *(astric)EXP:-
select * from emp
want to stop this king of query,only for the selected column should be allow.
Short answer...you can't.
You could jump through a lot of hoops and setup database triggers and all sorts of crazy stuff to try to prevent it but it is only going to slow down the whole system.
Honestly there is nothing wrong select * when used appropriately (like inside an exists). It is however terrible when used to shortcut building the list of columns which is what you are trying to prevent.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/