SQL 语句动态写法 ？在线等

[兔子侠客]

SQL 语句能这样写吗 我要查询的是动态的 可变的

SqlConnection con = new SqlConnection("server=localhost;database=7daydian;uid=sa;pwd=1234");


        string dia = "dianliang";

        string sql = "select '"+dia+"' from tongji order by shijian";

        SqlCommand com = new SqlCommand(sql, con);

我执行了下 没有结果

应该怎样写啊
在线等 急！

[兔子侠客]

我这个 dianliang 字段在数据库里是有的

[EnForGrass]

dia是字段名？
string sql = "select " + dia + " from tongji order by shijian";
这样写

[tan598121925]

 string sql = 'select "+dia+" from tongji order by shijian';

[兔子侠客]

[Quote=引用 2 楼 的回复:]
dia是字段名？
string sql = "select " + dia + " from tongji order by shijian";
这样写
[/Quote]

dianliang 是字段名

[mr_goodboy]

2楼正解

[兔子侠客]

[Quote=引用 3 楼 的回复:]
C# code

string sql = 'select "+dia+" from tongji order by shijian';
[/Quote]

3 楼的 可以 谢谢！！

自己想的还是不够多 只要“dia” 就可以啦 还得学习啊

[guoruixing]

字段名不需要加单引号。。。。

[efreer6]

[Quote=引用楼主 的回复:]
SQL 语句能这样写吗 我要查询的是动态的 可变的


C# code


SqlConnection con = new SqlConnection("server=localhost;database=7daydian;uid=sa;pwd=1234");


string dia = "dianliang";

string sql = ……
[/Quote]
string sql = "select " + dia + " from tongji order by shijian";
这样写



泰安二手房

[mr_goodboy]

[Quote=引用 3 楼 的回复:]
C# code

string sql = 'select "+dia+" from tongji order by shijian';
[/Quote]

三楼有点懒，单引号不对吧

[EnForGrass]

[Quote=引用 6 楼 的回复:]

引用 3 楼 的回复:
C# code

string sql = 'select "+dia+" from tongji order by shijian';


3 楼的 可以 谢谢！！

自己想的还是不够多 只要“dia” 就可以啦 还得学习啊
[/Quote]
不会吧？他那是单引号啊

[EnForGrass]

[Quote=引用 10 楼 的回复:]

引用 6 楼 的回复:

引用 3 楼 的回复:
C# code

string sql = 'select "+dia+" from tongji order by shijian';


3 楼的 可以 谢谢！！

自己想的还是不够多 只要“dia” 就可以啦 还得学习啊

不会吧？他那是单引号啊
[/Quote]
字符串额，编译都过不去，单引号的话

[qianwan3]

直接 sql=" select dianliang from tongji order by shijian"

[兔子侠客]

[Quote=引用 2 楼 的回复:]
dia是字段名？
string sql = "select " + dia + " from tongji order by shijian";
这样写
[/Quote]

string sql = "select distinct  [name] as 板块名称 ,[" + mon + "]as [周一]
,[" + thur + "]as [周2]
,[合计] from (select [name],[zhuzhai2],riqi,[合计]=sum([zhuzhai2])over(partition by [name]) from vw_rp_plan_houseitem where riqi>=''and  dep_master_Nod='1' and BossNod='1' ) a pivot (max([zhuzhai2]) for [riqi] in( [" +mon+ "]as [周一],[" + thur + "]as [周2]))b ";

这个怎么改啊 也是动态的

[EnForGrass]

[Quote=引用 13 楼 的回复:]

引用 2 楼 的回复:
dia是字段名？
string sql = "select " + dia + " from tongji order by shijian";
这样写

C# code

string sql = "select distinct [name] as 板块名称 ,[" + mon + "]as [周一]
,[" + thur + "]as [周2]
,[……
[/Quote]
你这个又有中文字段名又有英文，很烦

   string sql = "select distinct [name] as 板块名称,[" + mon + "] as [周一]" +
",[" + thur + "] as [周2],[合计] from (select [name],[zhuzhai2],riqi,[合计]=sum([zhuzhai2])over(partition by [name]) from vw_rp_plan_houseitem where riqi>='' and dep_master_Nod='1' and BossNod='1') a pivot (max([zhuzhai2]) for [riqi] in( [" + mon + "] as [周一],[" + thur + "] as [周2])) b ";

[EnForGrass]

对应的输出，难看，尤其是那个合计

select distinct  [name] as 板块名称 ,[num1] as [周一],[num2]  as [周2],[合计] from (select [name],[zhuzhai2],riqi,[合计]=sum([zhuzhai2])over(partition by [name]) from vw_rp_plan_houseitem where riqi>=''and  dep_master_Nod='1' and BossNod='1' ) a pivot (max([zhuzhai2]) for [riqi] in( [num1] as [周一],[num2]as [周2]))b 

[我爱小土豆]

[Quote=引用 2 楼 的回复:]

dia是字段名？
string sql = "select " + dia + " from tongji order by shijian";
这样写
[/Quote]
++