| How to
avoid using INSERT without a column list? |
|
It is undesirable
to include insert TableX values(...) in your code or stored
procedure because if a column is added or deleted, you can expect
a sure bug.
With sp_help
TableX
you can easily get a column list. Just cut and paste it, add commas
and you have the insert with the explicit column list.
You can also do
this from the Object Browser in Query Analyzer.
|
| The World Leader
in SQL Server Training |
|
|
|