On many occasions rows may be inserted utilizing an identity column as the primary key, in many of these cases it may be necessary to capture the newly auto-generated value. The following article will describe three such approaches: @@IDENTITY, SCOPE_IDENTITY(), and IDENT_CURRENT().

[Read more...]

Two examples of how to import CSV files into SQL Server

[Read more...]

The concept of building configurable applications and utilizing application configuration files has been around for years. In general the idea behind the use of application configuration files stems from the ability to dictate program behavior without the need to change code and recompile.

[Read more...]

In many cases you may need to be able to call a function and return multiple values.  Many times this functionality is implemented by utilizing an array or similar object as the return value and simply reading the contents back into variables.

[Read more...]

Both out and ref parameters are used to return values in the same variables that you would pass as an argument of a method. Both types of parameters can be useful in an event where you would like to return more than one value from your method.

[Read more...]