Składnia SQL

Question 1

Tworzenie widoku

Answer 1

CREATE VIEW … AS SELECT …

Question 2

Tworzenie procedury

Answer 2

CREATE PROCEDURE … (argumenty) AS BEGIN … END

Question 3

Tworzenie funkcji

Answer 3

CREATE FUNCTION … (argumenty) RETURNS … AS BEGIN … END

Question 4

INSERT EXEC

Answer 4

INSERT INTO …(…) EXEC …

Question 5

SELECT INTO

Answer 5

SELECT … INTO … FROM …

Question 6

BULK INSERT

Answer 6

BULK INSERT … FROM … WITH ( datafiletype, fieldterminator, rowterminator)

Question 7

Tworzenie indexów

Answer 7

CREATE CLUSTRED INDEX … ON table (column) INCLUDE (column)

Question 8

Tworzenie triggerów

Answer 8

CREATE TRIGGER … ON table AFTER INSERT/UPDATE/DELETE AS …

Question 9

Tworzenie synonimów

Answer 9

CREATE SYNONIM … FOR …

Question 10

Warunek na usunięcie obiektu z bazy

Answer 10

If EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N’…’) AND type = N’UQ’)