T-SQL Notes

SELECT list_of_columns_required
FROM list_of_tables_or_views_that_act_as_source_of_data
WHERE list_of_conditions_or_filter
ORDER BY sort_order_columns;

http://msftdbprodsamples.codeplex.com/ --- sample database download for SQL Server products

To connect to specific database in an SQL Server Instance:

USE [AdventureWorks2012]

GO

One SQL Server Instance, can have many databases used by one or more different applications.

select * from [AdventureWorks2012].[HumanResources].[Employee]
select * from AdventureWorks2012.HumanResources.Employee

We can do:

USE [AdventureWorks2012]
GO
SELECT * from HumanResources.Employee




The advantage with high-lighted approach: The code can be run against a different database, as long as the schema exists.


Say we can have [MYSTARTUP] database which has HumanResources schema and the schema contains Employee table.


SELECT
 BusinessEntityID
 ,NationalIDNumber
 ,LoginID
FROM
[HumanResources].[Employee]




In the above HumanResources is Schema. A schema contains the object, and that schema is then owned by a user. Because users own a schema, and the schema contains the object, you can change the owner of the schema without having to modify object ownership.