SELECT [GroupID] FROM [sys_Group] where G_Delete=0 and G_ParentID=1 查询结果:
6
7
8先要通过sql语句查询列出这样的结果:
dundiandanwei =6 or dundiandanwei =7 or dundiandanwei =8 请问该怎么写,谢谢:)
6
7
8先要通过sql语句查询列出这样的结果:
dundiandanwei =6 or dundiandanwei =7 or dundiandanwei =8 请问该怎么写,谢谢:)
declare @s varchar(100)
SELECT
@s=isnull(@s+' or ','')+' dundiandanwei = '+ltrim([GroupID]) FROM [sys_Group] where G_Delete=0 and G_ParentID=1
select @s
declare @s varchar(100)
SELECT
@s=isnull(@s+' or ','')+' dundiandanwei = '+ltrim([GroupID]) FROM [sys_Group] where G_Delete=0 and G_ParentID=1
select @s
set QUOTED_IDENTIFIER ON
goALTER function [dbo].[f_str](@ParentID int) returns varchar(100)
as
begin
declare @str varchar(100)
SELECT
@str=isnull(@str+' or ','')+' dundiandanwei = '+ltrim([GroupID]) FROM [sys_Group] where G_Delete=0 and G_ParentID=@ParentID return @str
end
然后带代码中调用:SELECT [dbo].[f_str] (1)即可搞定:)