Pages about SQL

• 

  14 October 2021

  Find the SQL Server GUID table

  If you have a UNIQUEIDENTIFIER id of a row in a SQL Server database, here's how you can find out what table it belongs to.

• 

  2 March 2016

  Converting from Type to SqlDbType

  The .NET type system and SQL Server types are not very easy to map to each other. In SQL, variables don't just have a type, but can also have precision and maximum length, which is not possible to translate into simple .NET types. Here I show a naïve approach at translating from one type system to another.