SQLServer: How to Read only the First x Characters from a nText Field using SQL
Often you need to display a grid with a list of text items stored as…
Database
Microsoft SQLServer: Testing If Table/Column Exists
Sometimes I have existing customers who need their database upgrading to a newer version – new…
SQLServer Transactions in .NET
Les Kendall discusses why we need Database Transactions and gives simple examples for Microsoft SQLServer…
MySQL: Finding the ID of the Last Inserted Record
Many times you insert a new record into a database and you need to know…