
CREATE DATABASE test
GO

USE test
GO

CREATE TABLE test (
  id INTEGER IDENTITY PRIMARY KEY,
  testcol VARCHAR(50)
)
GO

-- SQLCLR procedure
EXECUTE InsertRowOfTestData
GO

SELECT * FROM test
GO

-- SQLCLR procedure
EXECUTE InsertRowOfTestData2
GO

-- change to the pubs database
USE pubs
GO
 
-- SQLCLR procedure that uses parameters internally
EXECUTE InsertWithParameters 
GO
 
select * from authors