DB2 COALESCE 测试
来源:互联网 发布:ansys是什么软件 编辑:程序博客网 时间:2024/05/06 14:42
DB2 COALESCE 测试
--2006-1-12 16:31
--彭建军
--建立测试环境
drop table t1;
create table t1(c1 int,c2 varchar(10),c3 date,c4 timestamp);
--插入测试值
insert into t1(c1,c2,c3,c4)values(1,'1',current date,current timestamp)
insert into t1(c1)values(1)
insert into t1(c2)values('1')
insert into t1(c3)values('2005-01-01')
insert into t1(c4)values('2005-01-01 00:00:00.000000')
--查询原表数据
select * from t1
--调用函数示例
select coalesce(c1,0),coalesce(c2,'fuck'),coalesce(c3,'2000-01-01'),coalesce(c4,'2000-01-01 00:00:00.000000') from t1
- DB2 COALESCE 测试
- DB2 COALESCE 测试
- DB2 COALESCE
- DB2 COALESCE
- DB2 COALESCE
- 关于DB2 COALESCE函数
- DB2的COALESCE函数
- db2 COALESCE 函数的用法
- DB2里面的coalesce函数
- COALESCE
- COALESCE
- COALESCE
- COALESCE .
- coalesce
- DB2 IF 测试
- DB2 数据库恢复测试
- DB2 sequence 测试
- DB2前滚测试
- Embedded Firebird: Full-Featured Embedded Database with 2 MB Runtime
- Using ROW_NUMBER() to paginate your data with SQL Server 2005 and ASP.NET
- 逝去的2005
- Finding SQL Servers on the Network
- TransactionScope in .NET 1.1
- DB2 COALESCE 测试
- Integrating Microsoft Access DB, SQL Reporting Services and Visual Studio .NET
- Oracle Advance Queue or Advanced Queuing from .NET (C#/VB/MC++)
- Programmatically using ADO.NET and XML
- Fulltext Search for Firebird SQL
- SQL Server DO's and DONT's
- C# Code Generator for Stored Procedures
- Data Access Layer (DAL) with SqlWrapper library
- SQL Injection Attacks and Some Tips on How to Prevent Them