xuweilmy的专栏

开启数据库： bool DBBase::startUp(){bool flag = true;try{env = Environment::createEnvironment(Environment::OBJECT);conn = env->createConnection(username, userpwd, connstr);//创建环境变量}catch (SQLExcep

stadfx.h中添加：#import "c:\program files\common files\system\ado\msado15.dll" no_namespace rename("EOF","adoEOF")示例代码：// sqlTest.cpp : 定义控制台应用程序的入口点。//#include "stdafx.h"#include using n

-- 创建历史数据库if object_id('[dbo].[spr_create_his_db]') is not null drop procedure [dbo].[spr_create_his_db]gocreate proc [dbo].[spr_create_his_db]( @hisdbname varchar(30) -- 要创建的历史数据库名称)as

SQLserver中用convert函数转换日期格式2008-01-15 15:51SQLserver中用convert函数转换日期格式SQL Server中文版的默认的日期字段datetime格式是yyyy-mm-dd Thh:mm:ss.mmm例如: select getdate() 2004-09-12 11:06:08.177 整理了一下SQL Server里面可能经常

declare @tmSuffix datetimedeclare @curYear varchar(2)declare @curMonth varchar(2)-- 当前数据库名declare @strCurDBName varchar(30)select @strCurDBName = name from master..sysDataBases where dbid = (s

IF OBJECT_ID('[dbo].[get_service_status]') IS NOT NULL DROP FUNCTION [dbo].[get_service_status]GOCREATE FUNCTION [dbo].[get_service_status]( @arrear_time datetime, @reminder_time in

my.inidefault-character-set=utf8character-set-server=utf8重启mysql服务SHOW VARIABLES LIKE 'character%';+--------------------------+---------------------------------+   | Variab