Topic: SQL Server如何列值为空的数据 |
 Print this page
|
| 1.SQL Server如何列值为空的数据 | Copy to clipboard |
|
Posted by: lixaohan Posted on: 2005-07-01 20:10 SQL Server如何列值为nuLL的数据啊。 表结构如下: T1 T2 1 NULL 2 2004-10 3 NULL 我想要T1为1、3的那二条记录。 我用select t1 from............ where t2=null 查不出来啊。 谁能告诉我啊。谢谢了! | |
| 2.Re:SQL Server如何列值为空的数据 [Re: lixaohan] | Copy to clipboard |
|
Posted by: 沙漠小鸟 Posted on: 2005-07-13 10:28 where t2=null 查不出来啊! 你用where t2=null 当然查不出了.你查的是NULL 不是空.空要用where t2='' | |
| 3.Re:SQL Server如何列值为空的数据 [Re: 沙漠小鸟] | Copy to clipboard |
|
Posted by: why Posted on: 2005-07-13 12:16 沙漠小鸟 wrote:  Please provide accurate information! If you aren't sure, test it before you post. Be responsible! It should be WHERE T2 IS NULL | |
| 4.Re:SQL Server如何列值为空的数据 [Re: lixaohan] | Copy to clipboard |
|
Posted by: 沙漠小鸟 Posted on: 2005-07-13 12:55 はい！わかりました！ わたしが見るてくる、(ついでに答えるちょっと )、次回を経た後試験します、また発送します！ | |
| 5.Re:SQL Server如何列值为空的数据 [Re: lixaohan] | Copy to clipboard |
|
Posted by: 沙漠小鸟 Posted on: 2005-07-13 14:33 在Oracle中通过 select t1 from where t2=' ' 注: t2=' ' 引号中间加空格 | |
| 6.Re:SQL Server如何列值为空的数据 [Re: 沙漠小鸟] | Copy to clipboard |
|
Posted by: why Posted on: 2005-07-13 20:31 沙漠小鸟 wrote: 1. In Oracle, ' ' is an empty string, not NULL. 2. The post is about SQL Server, not Oracle. | |
| 7.Re:SQL Server如何列值为空的数据 [Re: lixaohan] | Copy to clipboard |
|
Posted by: q_yuan Posted on: 2005-09-27 09:19 <color=black>￥いいぃォ</color> | |
| 8.Re:SQL Server如何列值为空的数据 [Re: lixaohan] | Copy to clipboard |
|
Posted by: q_yuan Posted on: 2005-09-27 09:22 [color = black]select t1 from .. where t2 is null [/color] | |
| 9.Re:SQL Server如何列值为空的数据 [Re: lixaohan] | Copy to clipboard |
|
Posted by: mwsxh Posted on: 2005-10-07 23:21 呵呵～ | |
 |
Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1 客服电话 18559299278 客服信箱 714923@qq.com 客服QQ 714923 |