SQL server questions (3) - 77394

Request Posted by
alexpeoples

alexpeoples

Rating : No Rating
Earned: $0
Request Detail
Price: $10
  • From: Mathematics,
  • Due on: Wed 24 Jun, 2015 (01:00am)
  • Asked on: Wed 24 Jun, 2015
  • Due date has passed, but you can still Post Solution.
Description

I need some help on a few SQL server questions:

 

Give me the T-SQL code to backup a database named  Sample to disk in a file name c:\temp\Sample.BAK with a description of "Full Sample Backup"

 

Part 1 =

Give me the T-SQL code to create a table named  Stuff with the following columns

1_col  Integer and primary key

2_col  varcharacter

Part 2 =

Give me T-SQL code to create a view on this table named SView where 1_col is greater than 100

 

 

Give me the T-SQL command to allow a user named Bob to access SQL Server.

the account Bob has already been created on SQL Server.

 

 

 

Please Login or Register to Submit the Solution for the Request