22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE table1 (NAME varchar(20) ,MobilePhont varchar(20))
INSERT INTO table1 VALUES('jace','132224')
CREATE PROC my_proc
@NAME varchar(20),@MobilePhont varchar(20)
AS
BEGIN
SELECT '之前',@NAME,0,@MobilePhont,0
UNION all
SELECT '之后',NAME,(CASE WHEN NAME=@NAME THEN 1 ELSE 0 END)AS valid1 ,MobilePhont, (CASE WHEN MobilePhont=@MobilePhont
THEN 1 ELSE 0 END )AS valid2 FROM TABLE1
END
EXEC my_proc 'jace','132224'
这样[/quote]
非常感谢大神耐心的指导
刚试着根据您给的自己写了下,运行出来了,
再次感谢!--测试数据
if not object_id(N'T') is null
drop table T
Go
Create table T([name] nvarchar(22),[mobilephone] BIGINT)
Insert T
select N'张三',13311111111 union all
select N'李四',13311111111
Go
--测试数据结束
SELECT * FROM T
CREATE PROC dbo.proA
@name NVARCHAR(100) ,
@mobilephone BIGINT
AS
BEGIN
SELECT @name AS name,
NULL AS IsValid ,
@mobilephone AS mobilephone ,
NULL AS IsValid
UNION ALL
SELECT name ,
CASE WHEN name = @name THEN 1
ELSE 0
END ,
mobilephone ,
CASE WHEN mobilephone = @mobilephone THEN 1
ELSE 0
END
FROM T
END
GO
EXEC dbo.proA @name = N'张三', -- nvarchar(100)
@mobilephone = 13311111111 -- bigint
CREATE TABLE table1 (NAME varchar(20) ,MobilePhont varchar(20))
INSERT INTO table1 VALUES('jace','132224')
CREATE PROC my_proc
@NAME varchar(20),@MobilePhont varchar(20)
AS
BEGIN
SELECT '之前',@NAME,0,@MobilePhont,0
UNION all
SELECT '之后',NAME,(CASE WHEN NAME=@NAME THEN 1 ELSE 0 END)AS valid1 ,MobilePhont, (CASE WHEN MobilePhont=@MobilePhont
THEN 1 ELSE 0 END )AS valid2 FROM TABLE1
END
EXEC my_proc 'jace','132224'
这样