Develop DECLARE @column_name column_type from Table
For a Table or View or UDF, either in Explorer or with the object selected in a script, right-click to develop to the clipboard or new query window a list of DECLARE statements reflecting the object's column names in the simple form:
For SS2005, separate
DECLARE @column1<<TAB>><column1_data_type>
DECLARE @column2<<TAB>><column2_data_type>
For SS2008:
DECLARE @column1<<TAB>><column1_data_type>
, @column2<<TAB>><column2_data_type>
Stephen
shared this idea
Thank you for your suggestion.
Ideally, we’d love to respond individually to every request, but currently we can’t due to the volume of unanswered tickets. We’re clearing up our UserVoice backlog to make it easier for us as a small team to prioritize the most valuable features moving forward. Therefore, due to a lack of recent interest in this ticket, we have decided to close it.
If you feel strongly about it, we encourage you to create a new request.
Thanks,
The Prompt Team