скрипты бд второй лабы

Lab2 bd

-- EXEC sp_helpdb testdb;
-- CREATE DATABASE snapshot_db ON ( NAME = N'testdb',
--  FILENAME= N'/Users/roman/workspace/labdb/spashot_db.ss'
-- ),
-- (NAME = N'testdb1',
--  FILENAME= N'/Users/roman/workspace/labdb/spashot_db_2.ss')
--  AS SNAPSHOT OF testdb;


-- SELECT * FROM testdb.dbo.table1;
-- SELECT * FROM snapshot_db.dbo.table1;

-- UPDATE testdb.dbo.table1 SET fio='update' WHERE id = 1;

SELECT * FROM testdb.dbo.table1;
SELECT * FROM snapshot_db.dbo.table1;