You can use cursors in SQL Server stored procedures to process data already in the database and take action accordingly. These can be used just like recordsets within standard code - for example: [Read More]

For example, to change the owner of table MyTable to user MyUser, just run the predefined stored procedure sp_changeobjectowner: [Read More]

Catching unknown / dynamic variables [Read More]

Conditional Debugging Attribute [Read More]

Threads are very easy to use with C#. In this example I use a thread to ensure that a connection to a database is closed correctly (merely closing a connection in a method was not always successful as that connection was sometimes still busy when the Close() method line was... [Read More]