Writing SQL

Question 1

CREATE A TABLE

Answer 1

CREATE TABLE Customers (
CustomerID INT PRIMARY KEY,
FirstName VARCHAR(50),
LastName VARCHAR(50),
Email VARCHAR(100)
);

Question 2

CREATE A STORED PROCEDURE

Answer 2

CREATE PROCEDURE GetCustomerByID
@CustomerID INT
AS
BEGIN
SELECT * FROM Customers WHERE CustomerID = @CustomerID;
END;

Question 3

TRY / CATCH

Answer 3

BEGIN TRY
– Code block where errors might occur
– …
END TRY
BEGIN CATCH
– Error handling logic
– …
END CATCH;

Question 4

ROLLBACK

Answer 4

BEGIN TRANSACTION;

– SQL statements within the transaction
– …

IF <some>
ROLLBACK;</some>

COMMIT;