Identity fields give each new customer or invoice a unique number, even with many users entering data. Here is when and how to go about Overriding Identity Fields.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Many to Many Relationships – Day 8 of 35
Many to many relationships explained with an online shopping cart: one order holds many products, and one product is bought by many customers.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Dirty Records and Table Hints – Day 7 of 35
A Joes 2 Pros tip on dirty records and table hints: what an intermediate record is during a transaction, and how table hints change what you read.
SQL SERVER – Row Constructors – Day 6 of 35
Before SQL Server 2008, 20 rows meant 20 INSERT INTO statements. Row Constructors let you insert them all in one statement. A simple example to try.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding un-matching Records – Day 5 of 35
How to find un-matching records, like products that never sold, first with a basic subquery and then with an unmatched records query. A Joes 2 Pros tip.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35
An efficient query writing strategy from Joes 2 Pros: get the easy parts of a complex query working first, so you write it faster with fewer errors.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 of 35
A Joes 2 Pros tip on finding apostrophes in string and text: how to search for a single quote with LIKE when a quote also ends the string.