sqlclrstoredproc.sql

来自「< SQL Server2005程序设计>」· SQL 代码 · 共 18 行

CREATE DATABASE Test
GO
USE Test
GO
CREATE TABLE TestTable (TestColumn INT)
GO
USE Master
GO
CREATE LOGIN [sahil] WITH PASSWORD=N'sahil', DEFAULT_DATABASE=[TEST], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE Test
GO
CREATE USER [sahil] FOR LOGIN [sahil]
GO
ALTER AUTHORIZATION ON SCHEMA::[db_owner] TO [sahil]
GO