Database ‘Adventureworks’ does not exist (Msg 911)

Posted on August 14, 2018

If you get this sort of error as shown below:

Msg 911, Level 16, State 1, Line 1
Database 'Advantureworks ' does not exist. Make sure that the name is entered correctly.

And you already have this database, make sure you are typing the Database name correctly such as:

USE Adventureworks

Computed Columns – SQL Server

Posted on August 1, 2018

Computed columns it self does not contain any data, but shows value based on expression (given formula). Its very simple to add a computed columns in SQL Server you can either add them through DDL query or through SSMS Read the rest of this entry »