Asp深度揭密(6)

ts (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_info_3]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
   drop procedure [dbo].[user_info_3]
   GO
  
   if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[user_info]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
   drop table [dbo].[user_info]
   GO
  
   CREATE TABLE [dbo].[user_info] (
   [id] [int] IDENTITY (1, 1) NOT NULL ,
   [user_name] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
   [password] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
   ) ON [PRIMARY]
   GO
  
   ALTER TABLE [dbo].[user_info] WITH NOCHECK ADD
   CONSTRAINT [PK_user_info] PRIMARY KEY CLUSTERED
   (
   [user_name]
   ) ON [PRIMARY]
   GO
  
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS OFF
   GO
  
   CREATE PROCEDURE [output_1]
   @sid int output
   AS
   set @sid=2
   GO
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS ON
   GO
  
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS OFF
   GO
  
   CREATE PROCEDURE [return_1]
   (@user_name varchar(40),@password varchar(20))
   AS
   if exists(select id from user_info where user_name=@user_name and password=@password)
   return 1
   else
   return 0
   GO
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS ON
   GO
  
   SET QUOTED_IDENTIFIER ON
   GO
   SET ANSI_NULLS OFF
   GO
  
   CREATE PROCEDURE [user_info_1]
   (@user_name varchar(40),@password varchar(20))
   AS
   select id from user_info where user_name=@user_name and password=@password
   GO
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS ON
   GO
  
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS OFF
   GO
  
   CREATE PROCEDURE [user_info_2]
   (@user_name varchar(40),@password varchar(20))
   AS
   SET XACT_ABORT ON
   BEGIN TRANSACTION
   delete from user_info where user_name=@user_name and password=@password
   COMMIT TRANSACTION
   SET XACT_ABORT OFF
   GO
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS ON
   GO
  
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS OFF
   GO
  
   CREATE PROCEDURE [user_info_3] AS
   select * from user_info
   GO
   SET QUOTED_IDENTIFIER OFF
   GO
   SET ANSI_NULLS ON
   GO  做人要厚道，请注明转自chinazhan中国站长(www.ChinaZhan.com)。