Pages about SQL

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.

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.