How should this stored procedure be implemented?

lesterlin

Data tables A and B are now available:

Form A Form B
--------------------------- ----------------------- ---
uid name topic uid
1 David xxxxx 1
2 Jack xxx 3
3 Mike xxxxxx 0

After processing the stored procedure, we get such a table C:
Form C
-------------------------
topic name
xxxxx David
xxx Mike
xxxxxx anonymous

Excuse me, how to write such a stored procedure?

lisongfox

select b.topic, (case a.name when null then 'a.name' else a.name end) as NAME

FROM B table b
LEFT JOIN
Table A
on a.uid = b.uid

lisongfox

SQL:
select b.topic, (case a.name when null then 'anonymous' else a.name end) as NAME
FROM B table b
LEFT JOIN
Table A
on a.uid = b.uid

lisongfox

Stored procedure:

CREATE PROCEDURE Getname
AS

begin
select b.topic, (case a.name when null then 'anonymous' else a.name end) as NAME
FROM B table b
LEFT JOIN
Table A
on a.uid = b.uid
end
GO

5954979

Ha ha, a statement upstairs is completed, also use stored procedures?
But to ask, can the outer of the LEFT outer JOIN be omitted? Never dared to save.

capalex

select b.topic, ISNULL (a.name, 'Anonymous') from B table b LEFT JOIN A table a ON a.uid = b.uid

zhouyin1981

create procedure P_test
as
begin
    select topic, uname = case when (select [NAME] from table A where table A.uid = table B.uid) is null then 'anonymous' else (select [NAME] from table A where table A.uid = table B. uid) end from Table B

end

lesterlin

Thank you all upstairs, thezhouyin1981(Bobo) statement is feasible. Thelisongfoxstatement "anonymous" cannot be written into the new field, and the new field still displays null.
But thank you all for your help.