Category: SQL Server

First, the table. Each number shows how many rows fit into a table where every row always contained 1 int value and 6 string values, all with the same string length (the available field length could be larger). First, the lengths were stored using the non-Var data type. Then the same was done with the …

The following steps apply to the built-in SQL Server administrator account(sa), but with minor adjustments they should work for any account. Successfully tested on MS SQL Server 2008 R2. The same steps should apply both to SQL Server Express instances (SQLEXPRESS) and to instances of the “full” MS SQL (MSSQLSERVER) Steps: Log in to SQL …

Over the course of my roughly 6 projects that used an SQLite DB, I wrote a number of classes that helped me and, in a sense, even automated my work with the database. So once I had learned the simple SQLite, I moved on to the more complex SQL Server. Another reason is that at …