dd
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROC [dbo].[P_LoginLyh]@UserName varchar(500)='', @Pwd varchar(500)=''asselect isnull(姓名,'') as 姓名 ,isnull(角色,'') as 角色,[id] from T_User where 用户名=@UserName and 密码=@Pwd
sql存储过程代码段2010
set ANSI_NULLS ONset QUOTED_IDENTIFIER ONgoALTER PROC [dbo].[P_Loginydp]@UserName varchar(500),@Psd varchar(500),@PersonName varchar(50) OUTPUT,@PersonRole varchar(50) OUTPUT ,@ID int OUTPUTasselect @PersonName=姓名,@PersonRole=角色,@ID=id from T_User where 用户名=@UserName and 密码=@Psd
小小代码
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"><HTML><HEAD><TITLE>河北登陆管理</TITLE><META content="text/html; charset=gb2312" http-equiv=Content-Type><LINK rel=stylesheet href="河北_files/site.css"><SCRIPT language=JavaScript><!--if (self != top) top.location.href = window.location.href/...
最新评论
- 爱孔孟：set ANSI_NULLS ON<br /> set QUOTED_IDENTIFIER ...