Question

请问实现下面代码的SQL SERVER的存储过程怎么写？

select distinct word from 表1
select * from 表2 where word like '''' || word1 || '%'''
其中word1代表的是第一个sql的选择结果

Answer 1

if exists(select 1 from sysobject where name = '存储过程名称') is not null
drop procedure 存储过程名称
go

create procedure 存储过程名称
as
if exists (select distinct word from 表1)
begin
select * from 表2 where word like '''' || word1 || '%''';
end
go