Fundamentos de Bases de Datos: Referencias

Data Definition Language

https://msdn.microsoft.com/en-us/library/ff848799.aspx

https://technet.microsoft.com/en-us/library/ff848799(v=sql.110).aspx

Data Manipulation Language

https://msdn.microsoft.com/en-us/library/ff848766.aspx

https://technet.microsoft.com/en-us/library/ff848766(v=sql.110).aspx

Control of Flow Language

https://msdn.microsoft.com/en-us/library/ms174290.aspx

https://technet.microsoft.com/en-us/library/ms174290(v=sql.110).aspx

Data Types

https://msdn.microsoft.com/en-us/library/ms187752.aspx

https://technet.microsoft.com/en-us/library/ms187752(v=sql.110).aspx

Built-In Functions

https://msdn.microsoft.com/en-us/library/ms174318.aspx

Datediff
https://msdn.microsoft.com/en-us/library/ms189794.aspx

Transact-SQL

Transact-SQL Reference (Database Engine)
https://msdn.microsoft.com/en-us/library/bb510741.aspx

CREATE VIEW (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms187956.aspx

Views
https://msdn.microsoft.com/en-us/library/ms190174.aspx

SQL CREATE VIEW Statement
http://www.w3schools.com/sql/sql_view.asp

-- (Comment) (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms181627.aspx

SELECT @local_variable (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms187330.aspx

Create a Stored Procedure
https://msdn.microsoft.com/en-us/library/ms345415.aspx

How to: Create a Stored Procedure (SQL Server Management Studio)
https://msdn.microsoft.com/en-us/library/ms345415(v=sql.105).aspx


RAISERROR (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms178592.aspx