The IF ELSE statements are one of the most frequently used statement within SQL and control of flow statements are one of the core statements within any programing language. Once you have understood the concept you can easily make powerful scripts. An IF statement is a check to see whether a condition is TRUE and […]
How to attach AdventureWorks 2012 to SQL Server
Have you ever wanted to install the sample database (AdventureWorks )provided by Microsoft which a lot of the tutorials and books refer to? Well one of my colleagues has started to learn SQL Server so I thought I would knock up a quick guide for him. The correct classical way is to use T-SQL would […]
Change a database state in SQL
Have you ever wanted to change a databases state from read only to read write or vice versa? Well I am going to show you how using some easy to remember T-SQL which you will be using repeatedly over time. We received a database from a client the other day and noticed one of […]
- « Previous Page
- 1
- 2
- 3
- 4
- 5
- 6
- …
- 12
- Next Page »