CREATE PROCEDURE p1
@type varchar(11)
AS
SELECT au_id,address,pub_id,pub_name
FROM publishers,authors
WHERE publishers.city=authors.city
AND au_id LIKE @type
GO
declare @m id
set @m= '2% '
exec p1 @m
这个id是什么意思,他是数据类型吗啊
------解决方案--------------------
用select * from systypes where name= 'id ' 或者sp_help 'id ' 看一下