简单的表：

if exists (select * from sysobjects where id = OBJECT_ID('[Tb_admin]') and OBJECTPROPERTY(id, 'IsUserTable') = 1)
DROP TABLE [Tb_admin]

CREATE TABLE [Tb_admin] (
[id] [int]  IDENTITY (1, 1)  NOT NULL,
[name] [nvarchar]  (50) NULL,
[sex] [nvarchar]  (50) NULL,
[tel] [nvarchar]  (50) NULL)

以下是存储过程：

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tb_admin_ADD]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Tb_admin_ADD]
GO
------------------------------------
--用途：增加一条记录
--项目名称：
--说明：
--时间：2011-8-28 16:08:41
------------------------------------
CREATE PROCEDURE Tb_admin_ADD
@id int output,
@name nvarchar(50),
@sex nvarchar(50),
@tel nvarchar(50)

 AS
 INSERT INTO [Tb_admin](
 [name],[sex],[tel]
 )VALUES(
 @name,@sex,@tel
 )
 SET @id = @@IDENTITY
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tb_admin_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Tb_admin_Update]
GO
------------------------------------
--用途：修改一条记录
--项目名称：
--说明：
--时间：2011-8-28 16:08:41
------------------------------------
CREATE PROCEDURE Tb_admin_Update
@id int,
@name nvarchar(50),
@sex nvarchar(50),
@tel nvarchar(50)
 AS
 UPDATE [Tb_admin] SET
 [name] = @name,[sex] = @sex,[tel] = @tel
 WHERE id=@id
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tb_admin_Delete]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Tb_admin_Delete]
GO
------------------------------------
--用途：删除一条记录
--项目名称：
--说明：
--时间：2011-8-28 16:08:41
------------------------------------
CREATE PROCEDURE Tb_admin_Delete
@id int
 AS
 DELETE [Tb_admin]
  WHERE id=@id
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tb_admin_GetModel]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Tb_admin_GetModel]
GO
------------------------------------
--用途：得到实体对象的详细信息
--项目名称：
--说明：
--时间：2011-8-28 16:08:41
------------------------------------
CREATE PROCEDURE Tb_admin_GetModel
@id int
 AS
 SELECT
 id,name,sex,tel
  FROM [Tb_admin]
  WHERE id=@id
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Tb_admin_GetList]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[Tb_admin_GetList]
GO
------------------------------------
--用途：查询记录信息
--项目名称：
--说明：
--时间：2011-8-28 16:08:41
------------------------------------
CREATE PROCEDURE Tb_admin_GetList
 AS
 SELECT
 id,name,sex,tel
  FROM [Tb_admin]
GO
CREATE TABLE [Tb_admin] (
[id] [int]  IDENTITY (1, 1)  NOT NULL,
[name] [nvarchar]  (50) NULL,
[sex] [nvarchar]  (50) NULL,
[tel] [nvarchar]  (50) NULL)