易截截图软件、单文件、免安装、纯绿色、仅160KB

sql语句问题

能否将下面两个语句合并在一起，得到结果要求：
AutoID为奇、偶数时，在同一记录分别以不同的字段（Newchar，Newchar1）来显示？
select Months as Newchar from vw_ReportMonthBankAccountAmount where AutoID % 2 <> 0
select Months as Newchar1 from vw_ReportMonthBankAccountAmount where AutoID % 2 = 0
SQL code:
select case AutoID % 2 when 1 then Months end as Newchar,
case AutoID % 2 when 0 then Months end as Newchar1,
from vw_ReportMonthBankAccountAmount

SQL code:
select
(select Months as Newchar from vw_ReportMonthBankAccountAmount where AutoID % 2 <> 0)
Newchar
,
(
select Months as Newchar1 from vw_ReportMonthBankAccountAmount where AutoID % 2 = 0
) 'Newchar1 '
from vw_ReportMonthBankAccountAmount

case when  来判断
引用
SQL codeselectcase AutoID%2when1then Monthsendas Newchar,case AutoID%2when0then Monthsendas Newchar1,from vw_ReportMonthBankAccountAmount



这样会当AutoID为奇数时，Newchar值为Null，为偶数时，Newchar1为Null,如果不让它们不显示Null？？
引用这样会当AutoID为奇数时，Newchar值为Null，为偶数时，Newchar1为Null,如果不让它们不显示Null？？
你想�


相关问答：

求一条SQL - MS-SQL Server / 疑难问题

--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......

求SQL语句！！！ - MS-SQL Server / 应用实例

clientserial devseral chunnelnum devdata5
CZ0001 308001 5000 11.1
CZ0001 308001 5001 11.2
CZ0001 308001 5002 11.3
CZ0001 3080 ......

ASP链接SQL的简单登陆界面 - .NET技术 / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......
© 2009 ej38.com All Rights Reserved. 关于E健网 | 联系我们 | 站点地图 | 赣ICP备09004571号