SQL SERVER 插入、取回

注释比较清楚，直接贴代码

#include "stdafx.h"
#include <sqlext.h>
#include <stdio.h>
#include <windows.h>

int main(){
	SQLHENV henv;
	SQLHDBC hdbc;
	SQLHSTMT hstmt;
	SQLRETURN retCode;

	retCode = SQLAllocHandle(SQL_HANDLE_ENV, SQL_NULL_HANDLE, &henv);
	if(retCode != SQL_SUCCESS){
		printf("Can not allocate env handle\n");
	}
	//设置版本信息
	retCode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION, 
							(void*)SQL_OV_ODBC3, 0);
	if(retCode != SQL_SUCCESS){
		printf("Cannot set ODBC version\n");
	}

	retCode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc);
	if(retCode != SQL_SUCCESS){
		printf("Cannot allocate connect handle\n");
	}

	//设置连接属性
	retCode = SQLSetConnectAttr(hdbc, SQL_LOGIN_TIMEOUT, (SQLPOINTER)5, 0);
	//连接
	retCode = SQLConnect(hdbc, (SQLCHAR*)"test", SQL_NTS,
						(SQLCHAR*)"sa", SQL_NTS, (SQLCHAR*)"holyshit", SQL_NTS );