Wednesday, March 28, 2012

Is there a method to convert "Select * From Table" to "Select field1,field2,...fieldn From

Is there a method to convert "Select * From Table" to "Select field1,field2,...fieldn From Table" ?

Thanks

No method that I know of, but if you right-click on your Table and select "Script Table as", you'll have an option to "SELECT To" which will automatically generate the SELECT statement for you for all fields of the table.

No comments:

Post a Comment