Category Archives: SQL

T-SQL: INSERT for Table w/ Only IDENTITY Column

In the event that you wish to insert a record into a SQL Server table that contains only a single column, and that column is an IDENTITY column, here is the statement: INSERT INTO dbo.TableName DEFAULT VALUES; I am primarily … Continue reading

Posted in SQL | Tagged , , , | Comments Off

SQL Server 2008 Database Diagram Crash

I am able to get the SQL Server 2008 Design Diagram to crash reliably. I prefer to use “Custom View” with some useful column such as “Identity” and “Default Value” to make it easier to quickly get new table structures … Continue reading

Posted in SQL | Tagged , , , , , , | 2 Comments