SQL Server

Question 1

What is a stored procedure and how do you make one?

Answer 1

A stored procedure is a saved SQL query that it can be reused. Can add parameters using @ symbol.

CREATE PROCEDURE procedure_name
AS sql_statement
GO

CREATE PROCEDURE procedure_name @param type
AS sql_statement
GO

Question 2

How do you execute a stored procedure?

Answer 2

EXEC procedure_name

EXEC procedure_name @parm = parameter

Question 3

How do you create a new database?

Answer 3

CREATE DATABASE databasename

Question 4

How to create a table?

Answer 4

CREATE TABLE tableName (
ID int IDENTITY(1,1) PRIMARY KEY
		Column1 datatype,
		Column2 datatype,
		Column3 datatype
		OtherID int FOREIGN KEY REFERENCES OtherTable(ID)
)

Question 5

What is a composite key?

Answer 5

A composite key is a key created by combining two columns

It can be used as a primary key if it is unique