寂零幽谷的博客set @recount=count(id) from school -- 错误这里只能用select不能用set 如果school为一个@chart参数的话,上面方法就不适用了 应该为: declare @getRecordSql nvarchar(100) set @getRecordSql='select @...
那些花儿.的博客SELECT uf.fans_id as fansId,u.`nickname` as nickname,u.`head` as head, uf.`create_time` as createTime,1 as type FROM `user_fans` uf LEFT JOIN `user` u ON uf.fans_id=u.id WHERE uf.`u...