`
javababy1
  • 浏览: 1174126 次
  • 性别: Icon_minigender_1
  • 来自: 北京
文章分类
社区版块
存档分类
最新评论

测试 not between

 
阅读更多

试试 not between

  1. ------------------------------------
  2. --Author:Flystone
  3. --Version:V1.001
  4. --Date:2008-08-0223:26:50
  5. ------------------------------------
  6. --TestData:@t
  7. declare@ttable(idint)
  8. insertinto@t
  9. selecttop20idfromsysobjects
  10. --Start
  11. Select*from@t
  12. --Result:
  13. /*
  14. id
  15. -----------
  16. 1
  17. 2
  18. 3
  19. 4
  20. 6
  21. 8
  22. 9
  23. 10
  24. 11
  25. 12
  26. 14
  27. 19
  28. 20
  29. 21
  30. 22
  31. 23
  32. 24
  33. 95
  34. 96
  35. 979330
  36. (所影响的行数为20行)
  37. */
  38. select*
  39. from@t
  40. whereidnotbetween5and20
  41. --Result:
  42. /*
  43. id
  44. -----------
  45. 1
  46. 2
  47. 3
  48. 4
  49. 21
  50. 22
  51. 23
  52. 24
  53. 95
  54. 96
  55. 979330
  56. (所影响的行数为11行)
  57. */
  58. --End
分享到:
评论

相关推荐

    Upnp TEST 测试器

    If you are experiencing problems with the Universal Plug and Play service, your computer might not be able to automatically detect the presence of other networked devices, such as PCs, printers, ...

    数位板压力测试

    Are any commonly available fea¬tures not supported? • Does the interface provide what users need? Is anything missing? • Are future extensions possible and fairly easy? • Are vendor-specific ...

    oracle中通配符和运算符的使用方法介绍

     范围:between…and、not between….and  匹配测试:like、not like  Null测试:is null、is not null  布尔链接:and、or、not  通配符:  在where子句中,通配符可与like条件一起使用。在Oracle中: ...

    specd:用于将单元测试编写为 D 中的规范的库

    规格 将单元测试写为规范,而不是断言。 describe("a specifications DSL").as((it) { ... "user".must.not.be.between("rock", "hard place")) ; 入门 在单元测试块中编写规范: unittest { describe("a

    数据库基准和压力测试 2018版本 [Database Benchmarking and Stress Testing - 2018.pdf]

    数据库基准和压力测试 2018版本 [Database Benchmarking and Stress Testing - 2018.pdf](https://itbooks.pipipan.com/fs/18113597-314044807) Database Benchmarking and Stress Testing pdf Provide evidence...

    基恩士条码枪

    在结果文档中A 列显示测试发生的时间,你可以根据不同测试时间来找到相应的结 果。 A column is test time 30 | Confidential © 2013 Cognex Corporation 注意事项-- Notice  DM-V3 按装需与支架平台垂直,倾斜...

    mysql常用查询测试及答案

    mysql常用查询测试及答案: 参考链接: http://blog.sina.com.cn/s/blog_767d65530101861c.html -------------------创建如下表---------------------- 1.创建表 CREATE TABLE student ( id INT(10) NOT NULL ...

    一款比较好的网络性能测试工具

    -i, --interval # seconds between periodic bandwidth reports -l, --len #[KM] length of buffer to read or write (default 8 KB) -m, --print_mss print TCP maximum segment size (MTU - TCP/IP header) -o...

    TS.rar 禁忌搜索算法对TSP旅行商问题的应用

    .tsp文件读入,模拟退火算法函数接口,测试文件,运行结果全在里面了 Tabu Search (TS) is a local search-based metaheuristic, which is proposed by Fred W. Glover, in 1986. Tabu Search is completely ...

    great_expectations:始终知道对数据有什么期望

    它们是《大期望》中的主力抽象,涵盖了各种常见数据问题,包括: expect_column_values_to_not_be_null expect_column_values_to_match_regex expect_column_values_to_be_unique expect_column_values_to_match_...

    OPC Client.rar

    wonderware 软件服务端通讯是否成功测试程序。 In the wonderful world of Device Integration, Microsoft OPC connectivity Standards are becoming more popular. Under the guideline of OPC Foundation ...

    MirrorDiffKit:从凌乱的XCTAssertEqual消息中毕业

    提供两种功能以进行有效测试的工具: 2种任何类型之间的输出差异 任何类型的Equatable的默认实现 平台 状态 苹果系统 Linux 用法 diff(between: T, and: T) import MirrorDiffKit // Input 2 structs or classes...

    EMC技术汇总

    No terminal voltage limits apply for leads, which are not easily extensible by the user (permanently connected, or provided with a specific connector), which are shorter than 2 m, and which connect ...

    BURNINTEST--硬件检测工具

    Windows 98 and ME are not supported in BurnInTest version 5.3 and above. Use a version of BurnInTest prior to 5.2 for compatibility with W98 and ME. Windows 95 and Windows NT =======================...

    自动鼠标点击工具,完全免费版

    - random intervals (between 2 values) - loop mouse events (highly-requested!) - save loop value together with the mouse events to XML - turn on XP Visual Styles (which "normal" applications doesn't ...

    dx修复工具

    此次发布的程序虽经多次测试,但仍难免存在不足以及BUG,希望大家见谅并指正。 如果您对本程序有任何疑问或建议,欢迎发送电子邮件到: zhangyue667#263.net (把#换成@) 本人期待与您的交流。 最后,再次感谢...

    Oracle8i_9i数据库基础

    §10.1.8 Not in和Not Exists 218 §10.1.9 关于 COPY命令 218 §10.1.10 列值为NULL情形的处理 219 §10.1.11 使用 product_user_file来限制用户使用产品 220 §10.2 常用技巧 221 §10.2.1 long 类型的查询 222 §...

    PegasusWindowsTools

    测试pegasus的一款工具! Windows Platform common utilities for Pegasus build Karl Schopmyer 12 August 2003 This zip file is a collection of the most useful utilities for working with Pegasus on ...

    pymore:莫python,问题较少。 python的助手

    这包括EqualsTester:一个用于测试Python中的平等契约的帮助程序(最初是为开发的) import pymoretester = pymore . EqualsTester ()# This tests that the added elements all satisfy the equals contract# ...

    经典全面的SQL语句大全

     8、说明:between的用法,between限制查询数据范围时包括了边界值,not between不包括 select * from table1 where time between time1 and time2 select a,b,c, from table1 where a not between 数值1 and 数值2 ...

Global site tag (gtag.js) - Google Analytics