set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
/*****************************************************
** PROCEDURE : pro_is_so_cust_nam_show_repeat
** DECRIPTION: 判断客户用户和或显示名称是否重复
** DATE : 2012-07-04
** VERSION AUTH DATE DESC
** -------- ------------ ------------ -----------------
** V000.0.1 PuKuimin 2012-07-04 新建程序
** -------- ------------ ------------ -----------------
*******************************************************/
ALTER procedure [dbo].[pro_is_so_cust_nam_show_repeat]( @cust_nam varchar(20),-- 登录名
@show_nam varchar(20),--显示名称
@ret varchar(20) output-- 0:不重复,否则返回ID
)as
begin
declare @id varchar(20)
--set @id = -1
select @id = isnull(id, 'null')
FROM T_SO_CUST_INFO
where (cust_nam= @cust_nam OR SHOW_NAM=@show_nam) AND STAT='1'
if @id is null set @ret = 0
else set @ret = @id
END
/*
declare @ret varchar(20)
exec [dbo].[pro_is_so_cust_nam_show_repeat]
'000',-- 登录密码
'000',
@ret output-- 0:成功, 其他:失败
print @ret
*/
分享到:
相关推荐
https://www.bilibili.com/video/BV12b411K7Zu?p=134 mysql李玉婷
mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-...
开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin...
mysql-connector-net-0.1.0.msi mysql-connector-net-6.3.6.msi mysql-connector-net-6.3.7.msi mysql-connector-net-6.3.8.msi mysql-connector-net-6.3.9.msi mysql-connector-net-6.4.0.msi mysql-connector-...
mysql存储过程编程教程: MySQL 存储过程编程基础 -- 指南,基本语句,存储过程中的 SQL 和错误处理 创建 MySQL 存储过程程序 -- 事务处理,内建函数,存储过程函数和触发器 在应用程序中使用 MySQL 存储...
mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community...
centos 下hive连接mysql驱动 ,mysql-connector-java-8.0.26-1.el7.noarch. 使用方法: 1.下载本rpm文件后,上传至你的服务器(虚拟机) 2. rpm -ivh mysql-connector-java-8.0.26-1.el7.noarch进行安装 3.安装完成...
JavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector...
赠送jar包:mysql-binlog-connector-java-0.21.0.jar; 赠送原API文档:mysql-binlog-connector-java-0.21.0-javadoc.jar; 赠送源代码:mysql-binlog-connector-java-0.21.0-sources.jar; 赠送Maven依赖信息文件:...
mysql驱动包 mysql-connector-java-5.1.13-bin.jar 方便快捷获取。。。
mysql-connector-java-5.1.27.jar mysql-connector-java-5.1.27.jar
mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 ...
mysql-connector-java-5.1.7-bin.jar
包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-...
Mysql数据库驱动mysql-connector-java-5.1.41-bin.jar
java连接mysql数据库的驱动,里边包含两个版本:5.1.47、8.0.28 也可从以下两个地址免费下载: 1. https://repo1.maven.org/maven2/mysql/mysql-connector-java/ 2. ...
mysql数据库连接 mysql-connector-java-5.1.26-bin.jar
包括以下文件 mysql-connector-java-3.0.16-ga-bin.jar mysql-connector-java-3.1.8-bin.jar mysql-connector-java-3.1.13-bin.jar mysql-connector-java-5.0.5-bin.jar
mysql-connector-java mysql-connector-java-5.1.5 mysql-connector-java-5.1.40
MySQL SQL高级特性-存储过程-触发器-事务,非常不错,感谢