loaddata.sql

来自「Time Tracker Starter Kit 使您能轻松创建这样一个应用程序」· SQL 代码 · 共 22 行

-- Vertigo Software Data Script File
-- This file was auto-generated by Utilities.DataScripter Version 1.0.1152.18116 on 3/4/2003 at 2:26 PM.

-- point to proper DB 
use [~~##CMRCStarterKitDB##~~]
GO

DELETE FROM [dbo].[TT_Roles]

GO

INSERT INTO [dbo].[TT_Roles]
([RoleID],[Name])
SELECT 1, 'Administrator'
UNION ALL
SELECT 2, 'Project Manager'
UNION ALL
SELECT 3, 'Consultant'

GO