20100513.NETµ÷ÓÃSQL SERVER´æ´¢¹ý³Ì

¼¸¸ö´æ´¢¹ý³Ì£¬ºÜ¼òµ¥µÄ£¬µ«ÊÇÎÒ´ÓÀ´Ã»ÓÐѧϰ¹ý£¬ºÇºÇ£¬Õâ¸öÕýÊÇÎÒÒªÀ´ÅàѵµÄÄ¿µÄ
-- =============================================
-- Author:  
-- Create date: 2010Äê05ÔÂ12ÈÕ
-- Description: ´Ë¹ý³ÌÓÃÓÚ²éѯËùÓÐÓû§Ãû¼°ÃÜÂë
-- =============================================
CREATE PROCEDURE users_select_all
 
AS
BEGIN
 select * from users
END
GO
-- =============================================
-- Author:  
-- Create date: 2010Äê05ÔÂ12ÈÕ
-- Description: ´Ë¹ý³ÌÓÃÓÚ²éѯ·ûºÏÓû§ÃûºÍÃÜÂëµÄÓû§
-- =============================================
create PROCEDURE users_select_name @uname varchar(10)='%'
AS
BEGIN
 select * from users where username like @uname
END
GO
users_select_name 'СÃ÷6'
-- =============================================
-- Author:  
-- Create date: 2010Äê05ÔÂ12ÈÕ
-- Description: ´Ë¹ý³ÌÓÃÓÚÊä³ö·ûºÏÓû§ÃûºÍÃÜÂëµÄÓû§ÌõÊý
-- =============================================
create PROCEDURE users_select_name_output
@uname varchar(10),
@pwd varchar(10),
@count int output
AS
BEGIN
 select @count=count(*) from users where username=@uname and password=@pwd
END
GO
declare @count int
execute users_select_name_output 'СÃ÷6','xiaoming',@count output
select @count
-- =============================================
-- Author:  
-- Create date: 2010Äê05ÔÂ12ÈÕ
-- Description: ÍùÊý¾Ý¿âµÄ±íÖвåÈëÒ»ÌõмǼ
-- =============================================
create PROCEDURE users_insert
@uname varchar(10),
@pwd varchar(10),
@count int output
AS
set nocount on               --µ± SET NOCOUNT Ϊ ON ʱ£¬²»·µ»Ø¼ÆÊý£¨±íʾÊÜ Transact-SQL Óï¾äÓ°ÏìµÄÐÐÊý£©¡£
                                       --µ± SET NOC