--
----------------------------------
-- 用途:增加一条记录
-- 项目名称:CodematicDemo
-- 说明:
-- 时间:2008-4-28 19:32:10
-- ----------------------------------
CREATE PROCEDURE UP_EntryLog_ADD
@ID int output,
@Name varchar ( 50 ),
@LandingDate datetime
AS
INSERT INTO EntryLog(
[ ID ] , [ Name ] , [ LandingDate ]
) VALUES (
@ID , @Name , @LandingDate
)
SET @ID = @@IDENTITY
GO
-- 用途:增加一条记录
-- 项目名称:CodematicDemo
-- 说明:
-- 时间:2008-4-28 19:32:10
-- ----------------------------------
CREATE PROCEDURE UP_EntryLog_ADD
@ID int output,
@Name varchar ( 50 ),
@LandingDate datetime
AS
INSERT INTO EntryLog(
[ ID ] , [ Name ] , [ LandingDate ]
) VALUES (
@ID , @Name , @LandingDate
)
SET @ID = @@IDENTITY
GO
--
----------------------------------
-- 用途:删除一条记录
-- 项目名称:CodematicDemo
-- 说明:
-- 时间:2008-4-28 19:32:10
-- ----------------------------------
CREATE PROCEDURE UP_EntryLog_Delete
@ID int
AS
DELETE EntryLog
WHERE ID = @ID
GO
-- 用途:删除一条记录
-- 项目名称:CodematicDemo
-- 说明:
-- 时间:2008-4-28 19:32:10
-- ----------------------------------
CREATE PROCEDURE UP_EntryLog_Delete
@ID int
AS
DELETE EntryLog
WHERE ID = @ID
GO
--
----------------------------------
-- 用途:查询记录信息
-- 项目名称:CodematicDemo
-- 说明:
-- 时间:2008-4-28 19:32:11
-- ----------------------------------
CREATE PROCEDURE UP_EntryLog_GetList
AS
SELECT
ID,Name,LandingDate
FROM EntryLog
WHERE ID = @ID
GO
-- 用途:查询记录信息
-- 项目名称:CodematicDemo
-- 说明:
-- 时间:2008-4-28 19:32:11
-- ----------------------------------
CREATE PROCEDURE UP_EntryLog_GetList
AS
SELECT
ID,Name,LandingDate
FROM EntryLog
WHERE ID = @ID
GO