Arthur Fuller explores the value of identity columns and the usefulness of their arbitrary values and discusses ways to use SQL Server 2000's IDENTITY_INSERT setting. Despite your numerous ...

Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...

The table I'm using is currently in a schema, set through either TableName() or schema.NamingStrategy.TablePrefix. But if I were to try to create a row in SQL Server with it, while using a preset ...

Hopefully an easy question. -- View image here: http://episteme.arstechnica.com/groupee_common/emoticons/icon_smile.gif --<br><br>I have two tables:<br><br>Table1<br ...

Recently, my good friend and co-worker Aaron Bertrand and I were producing a video for the upcoming PASS Summit 2015 event. (Learn more about the international SQL ...

Launch timing aside, SQL Server 2012 has released with a solid set of new features and improved technologies. You can download SQL Server 2012 at www.microsoft.com ...

I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view?