Sql Intermediate

Question 1

Create a user defined table type BasicUTD

Answer 1

Create Type Dbo.BasicUDT as Table
( 
FirstName Varchar(50),
LastName Varchar(50)
);

Question 2

Add procedure using BasicUDT to add people in Person table.

Answer 2

Create Procedure dbo.InsertPeople @MyPeople BasicUDT readonly
AS
Begin
Insert into person (firstname, lastname)
Select firstname,lastname from @MyPeople
End

Question 3

Restore a database backup

Answer 3

Put the backup .bak in MSSQL\backup folder, in ms sql server management studio, right click on database->restore database-> from device and choose the path of the backup

Question 4

Get the database version

Answer 4

Select @@version