SQL Server Danar124 Cheat Sheet

**Stored Procedure**
CREATE PROCEDURE <name> AS <sql_statement>

**Views**
CREATE VIEW<name>[(<Column>,...)]
AS <SELECT_statement>

**Triggers**
CREATE TRIGGER <name> ON <table>
FOR INSERT, UPDATE, DELETE AS <sql_statement>

**Functions**
CREATE FUNCTION <name>
RETURNS <data_type>
AS BEGIN <sql_statement>
RETURN <sql_expression> END

CREATE PROCEDURE name
@variable AS datatype = value
AS
-- Comments
SELECT * FROM table
GO

ALTER TABLE <table1> WITH CHECK
ADD CONSTRAINT <constraintName>
FOREIGN KEY (<table1col1>)
REFERENCES <table2> (<table2col2>)

ALTER TABLE <tablename> DROP
CONSTRAINT <constraintName>

ALTER TABLE <tablename> ADDCONSTRAINT <constraintName>
PRIMARY KEY CLUSTERED (column_List)

CREATE UNIQUE INDEX name
ON
table (columns)

**UPDATE Statement**
UPDATE table_name
SET column_name=(expression | DEFAULT | NULL [,...n]
[WHERE <search_condition>]

**DELETE Statement**
DELETE [FROM] table_name
[WHERE <search_condition>]

**INSERT Statement**
INSERT [INTO] table_name [(column_list)]
VALUES ((DEFAULT | NULL | expression 1[,...n])

SELECT [DISTINCT] [(TOP int | TOP int PERCENT)]
Column list
[INTO new_table]
FROM table_source
[[[INNER | {{ LEFT | RIGHT | FULL}[OUTER]}] JOIN | CROSS APPLY]
table_source2
ON table_source.primary_key =
table_source2.foreign_key][,...n]
[WHERE search_condition]
[GROUP BY group_by_expression]
[HAVING search_condition]
[ORDER BY order_expression [ASC | DESC]]