Are you writing a query that selects data from a table with lots of columns? Does the select list we need to have all or almost all of these columns? Remember, that it is possible to drag and drop objects from Object Explorer to the Query Window. By dragging and dropping the “Columns” node under the table from Object Explorer to the Query Window we can paste all of the column names from that table separated by a comma as shown below:
It is also possible to drag and drop columns separately and table name by dragging and dropping it to the “Query Window”. We can also do this for other objects (stored procedures, functions, users, etc.) to the query editor as well.
Related posts:
How to solve 'incorrect syntax near the keyword WITH' problem?
SQL Query to Find and Replace text in a stored procedures
Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql st...
How to solve "TableAdapter can't see stored procedure returned fields when using temp table" problem
"ORDER BY" with CASE and UNION in SQL Server