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为字符串的原因吗?
CREATE PROCEDURE Pr_GetDisAmuseUrlGroupCount
(
@groupTitle varchar
)
AS
SELECT count(*) as AmuseCount FROM Groups where Title=@groupTitle//这个地方
GO
应加上长度如 varchar(100)
returns @re table(count int)
as
begin
declare @count int
SELECT @count = count(*) FROM Groups where Title = @groupTitle
insert into @re values(@count)
return
end-- 调用
select * from f_getcount('title')