Use SQL Server DMVs to find a table’s IDENTITY Column
Use SQL Server DMVs to find a table’s IDENTITY Column. The SQL Server DMVs sys.objects and sys.columns contain valuable information that can identify IDENTITY Columns.
SQL Blogs
SQL Blogs
SQL and SQL Server database topics. Includes design, issue resolution and tips.
Incorrect syntax near ‘GO’ when creating Dynamic SQL
Learn about line breaks when creating dynamic SQL.
Programming, SQL Blogs
Querying an Oracle linked server fails
The other day, I needed to pull some data from an Oracle server on our network. The oracle server was
SQL Blogs
Great Circles in SQL Server 2005 and SQL Server 2000
Recently, I had a request to calculate the distance between 2 GPS coordinates. Now, the system I am working with