没发生lz的问题。 CREATE TABLE 厂站归属表 (tag_name VARCHAR(20) ,tag_id INT ) GO INSERT INTO 厂站归属表(tag_name,tag_id) SELECT '册亨牵引变电所',1 UNION SELECT '变电所123',2 UNION SELECT '变电所456',3 if (object_id('proc_find_stu', 'P') is not null) drop proc proc_find_stu go create PROCEDURE proc_find_stu(@name varchar(20)) as begin select * from dbo.厂站归属表 where tag_name = @name end GOexec proc_find_stu @name = N'册亨牵引变电所'/* tag_name tag_id 册亨牵引变电所 1*/select * from dbo.厂站归属表 where tag_name = N'册亨牵引变电所'/*tag_name tag_id 册亨牵引变电所 1*/
CREATE TABLE 厂站归属表 (tag_name VARCHAR(20) ,tag_id INT )
GO
INSERT INTO 厂站归属表(tag_name,tag_id)
SELECT '册亨牵引变电所',1
UNION
SELECT '变电所123',2
UNION
SELECT '变电所456',3
if (object_id('proc_find_stu', 'P') is not null)
drop proc proc_find_stu
go
create PROCEDURE proc_find_stu(@name varchar(20))
as
begin
select * from dbo.厂站归属表 where tag_name = @name
end
GOexec proc_find_stu @name = N'册亨牵引变电所'/*
tag_name tag_id
册亨牵引变电所 1*/select * from dbo.厂站归属表 where tag_name = N'册亨牵引变电所'/*tag_name tag_id
册亨牵引变电所 1*/