记录生活
存档 Archives : October, 2009

SQL:获取不同版本中差异参数值

<Category: SQL Server> 发表评论

帮朋友写的一个sql,比较数据里面不同版本的参数数值

阅读这篇文章的其余部分 »

本文来自: SQL:获取不同版本中差异参数值

C++&OTL调用SQLServer成功

<Category: C++> 1 条评论
#include 
using namespace std;
#include 

#define _ODBC_MSSQL_2005 // Compile  3.1/OCI7
#include "otlv4.h" // include the  4 header file

//Table--Create--Script-----begin---------------------------------------------------
//USE [Matrix]
//GO
///****** Object:  Table [dbo].[tb1]    Script Date: 10/10/2009 16:40:55 ******/
//SET ANSI_NULLS ON
//GO
//SET QUOTED_IDENTIFIER ON
//GO
//SET ANSI_PADDING ON
//GO
//CREATE TABLE [dbo].[tb1](
//	[cl1] [varchar](50) COLLATE _Latin1_General_CP1_CS_AS NULL,
//	[cl2] [varchar](50) COLLATE _Latin1_General_CP1_CS_AS NULL
//) ON [PRIMARY]
//
//GO
//SET ANSI_PADDING ON
//Table--Create--Script-----end-----------------------------------------------------

otl_connect db; // connect object

void insert()
// insert rows into table
{
    //删除测试数据
   otl_stream d;
    d.open(50, // buffer size
   "truncate  Table tb1; ",db);

 otl_stream o(50, // buffer size
              "insert into tb1 values(:cl1,:cl2)",
                 // SQL statement
              db // connect object
             );
 char tmp[32];

 for(int i=1;i<=100;++i){
  sprintf(tmp,"Name%d",i);
  o<<(float)i<) ",
   db);

    //输入显示大于数字的记录数
    int var1;
    cin>>var1;
    i<>f1>>f2;
  cout<<"f1="<

本文来自: C++&OTL调用SQLServer成功

VMware Server 序列号

<Category: 小道消息> 发表评论

 

http://register.vmware.com/content/registration.html 免费获得key
linux:
9ADDW-Y8ZAY-2CM3N-4K41M
9096D-Y0ZAU-2CH9J-4RJ2M
9296R-Y0Z2Y-23N14-4U01D
90D48-YAU8F-2CM10-4H4KH
90XFX-YAF0Z-23410-4R18E
windows:
90H2T-Y6E40-1D1CK-4APTN
9ANAT-Y4840-1DJ1K-407H8
98M0W-Y4D6N-1D03K-43HA5
90N28-Y6T6H-1F11P-48LVR
924AD-YDX45-14J33-402U1

http://www.vmware.com/download/player/download.html

本文来自: VMware Server 序列号