摘要: 例1: create proc proc_stu @sname varchar(20), @pwd varchar(20) as select * from ren where sname=@sname and pwd=@pwd go 查看结果:proc_stu 'admin','admin' 例2: 下面的存储过程实现用户验证的功能,如果不成功,返回0,成功则返回1. CREATE PROCEDURE VALIDATE @USERNAME CHAR(20),@PASSWORD CHAR(20),@LEGAL BIT OUTPUT AS IF EXISTS(SE 阅读全文
posted @ 2011-08-25 13:25 上海-天浩 阅读(222) 评论(0) 推荐(0) 编辑

Living in ShangHai

Copyright © 2008 天浩阁 Corporation, All Rights Reserved