Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE master;
- DECLARE @dbname nvarchar(128)
- SET @dbname = N'School';
- IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname))
- BEGIN
- DROP DATABASE School;
- END
- CREATE DATABASE School;
- GO
- USE School;
- GO
- CREATE TABLE Student (
- studentID INT NOT NULL PRIMARY KEY,
- studentName nvarchar(150) NOT NULL
- );
- INSERT INTO dbo.Student
- VALUES
- (1, 'A'),
- (2, 'B'),
- (3, 'C'),
- (4, 'D'),
- (5, 'E'),
- (6, 'F')
- ---SELECT * from dbo.Student
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement