May 5, 2008
Disabling the SQL Server row-count feature can help optimize T-SQL stored procedures and batches.
April 21, 2008
Michael Otey responds to reader questions about how transactions work, when and where the data is written, and whether the data is put into the database before the transaction is committed.
April 7, 2008
Transactions are essential for complex systems that update multiple related tables. Rolling back a transaction rolls back the entire group of updates, and that just might save your bacon if you encounter an error.
March 17, 2008
Need to load a lot of data into a SQL Server database? Then using T-SQL's BULK INSERT statement is the way to go. Here's how to get started.
March 3, 2008
Do you want to change the value of a column in a particular row of a table? The T-SQL UPDATE statement is the answer. Here's what you need to know.
February 25, 2008
If you aren't careful with the T-SQL DELETE statement, you can easily end up deleting all the rows in a table. Here's how DELETE works.
February 4, 2008
Get a jump start on using the T-SQL INSERT statement, the primary T-SQL command for adding data to tables in a SQL Server Express database.
January 28, 2008
Table variables can provide better performance than temporary tables and are especially useful when you need to group together related information or your script needs to access the same information multiple times.
January 14, 2008
Michael Otey explains how to code T-SQL's addition, subtraction, multiplication, division, and modulus math operators.
December 17, 2007
If you write T-SQL scripts that need to be portable between servers, you'll want to learn how to assign values that come from a SQL Server Express database to T-SQL variables.
December 3, 2007
Learn the fundamentals of working with T-SQL variables: how to declare and name variables and how to assign single and multiple values to them.
November 19, 2007
Using T-SQL variables in dynamic SQL statements is a powerful way to make your applications more flexible.
November 5, 2007
Michael Otey continues his tutorial on stored procedures by discussing how to use variables in them.
October 15, 2007
Learn how to provide default values for parameters in stored procedures.
October 1, 2007
Let's take a step back and look at the big picture of SQL Server Express stored procedures. Just like a table or view, a stored procedure is a database object, and there are two types.
September 24, 2007
Michael Otey takes you inside the code of a stored-procedure template.
September 10, 2007
Here's a way for those who aren't very familiar with T-SQL and stored procedures to easily create stored procedures.
August 20, 2007
Learning the basics of stored procedures starts with learning how to create and run them.
August 6, 2007
The SQL SELECT statement's COUNT function can tell you the number of rows in a table, how many unique values are in a column, and the number of unique values for an expression. Here's how to use it.
July 16, 2007
Using the HAVING clause with SELECT is similar to using the WHERE clause, with one important difference.
Add these Headlines to your Website
