Monthly Archives: October 2013

Unexpected results when querying a SQL View

The other day I was trying to run a select statement from a view in SQL Server and I got some unexpected errors with the data types in the result set from the view with respect to the base table. … Continue reading

Posted in Interesting Stuff | Leave a comment

Identity vs SCOPE_IDENTITY vs IDENT_CURRENT

It is a common practice to use IDENTITY value for columns which are simple integer increments. We can also specify what is the initial value and how we want to increment using seed values. In some cases the client applications … Continue reading

Posted in SQL Server | Leave a comment