TSQL

TSQL

What is a Stored Procedure

Here Jen explains what a stored procedure is, and how to create a basic one with no parameters. She...

Watch video

Insert Into vs. Select Into

Knowing how and when to use Insert Into or Select Into can quite often make or break your load...

Watch video

Best Habit for Coders

There’s a step you can make in your code to improve it many times over. It’s an easy step...

Watch video

Querying Dev Metadata

Sometimes you need to get info on objects you’ve created. Here you can see how you can query for...

Watch video

UNION and UNION ALL

Here I talk about UNION and UNION ALL, and the different rules about using ORDER BY, GROUP BY, SELECT...

Watch video

OR is bad, IF is good

Here I tell you about a common mistake – using OR instead of IF – and show you that...

Watch video

Designing Efficient Functions

Here I get on my cert soapbox again. I was going through a practice cert exam and came across...

Watch video

T-SQL Code Sins

SPEAKER: Jen McCown. Do you know how to set yourself for good coding practices? Well Jen does. Come see...

Watch video

Relational Division

Here we discuss relational division, the counterpart to relational multiplication (cross joins). We’ll hit a couple of examples, using...

Watch video

Insert Non-duplicate Rows

Here we work our way through a coding scenario—inserting rows—that should illustrate the process of solving a problem from...

Watch video