Advertisement
Guest User

Untitled

a guest
Jan 26th, 2020
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.49 KB | None | 0 0
  1. USE master;
  2. DECLARE @dbname nvarchar(128)
  3. SET @dbname = N'School';
  4.  
  5. IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname))
  6. BEGIN
  7.     DROP DATABASE School;
  8. END
  9.  
  10. CREATE DATABASE School;
  11. GO
  12. USE School;
  13. GO
  14.  
  15. CREATE TABLE Student (
  16.     studentID INT NOT NULL PRIMARY KEY,
  17.     studentName nvarchar(150) NOT NULL
  18.  
  19. );
  20.  
  21. INSERT INTO dbo.Student
  22. VALUES
  23. (1, 'A'),
  24. (2, 'B'),
  25. (3, 'C'),
  26. (4, 'D'),
  27. (5, 'E'),
  28. (6, 'F')
  29.  
  30. ---SELECT * from dbo.Student
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement