Groups表结构:
GroupID int 4
Title varchar 50
我想进行按名字查找的方法.CREATE PROCEDURE Pr_GetDisAmuseUrlGroupCount
(
@groupTitle varchar
)
AS
SELECT
count(*) as AmuseCount
FROM
Groups
where
@groupTitle=Title
GO总是找不到结果,是什么原因呢? 是Title为字符串的原因吗?
GroupID int 4
Title varchar 50
我想进行按名字查找的方法.CREATE PROCEDURE Pr_GetDisAmuseUrlGroupCount
(
@groupTitle varchar
)
AS
SELECT
count(*) as AmuseCount
FROM
Groups
where
@groupTitle=Title
GO总是找不到结果,是什么原因呢? 是Title为字符串的原因吗?
where
Title= @groupTitle
(
@groupTitle varchar(100)
)
AS
declare @str varchar(500)select @str ='SELECT count(*) as AmuseCount FROM Groups where Title like ''%'+@groupTitle +'%''' exec (@str)
GO
我没加(100)