sql-server Archives - Page 39 of 39

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005? 4 ...

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) ...