In my last column (“What’s the Story About SQL Server on Linux?” on the DBTA website), I gave you a broad overview about some of the very cool things happening with SQL Server running on the Linux ...

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 ...

Modifies a column's values in existing rows of a table or view. Restriction: You cannot use UPDATE on a table accessed via an engine that does not support UPDATE processing. You can update one or more ...