FreeTDS连接Sqlserver数据库批量提交数据

FreeTDS作为Sqlserver和Sybase数据库的c/c++连接库

 int main()  
{  
    char szUsername[32] = "sa";  
    char szPassword[32] = "123456";  
    char szServer[32] = "172.16.3.127:1433";  
    char szDBName[32] = "blue";  
    char sql[256];  
   
  
    //初始化db-library  
    dbinit();  
  
    //连接数据库  
    LOGINREC *loginrec = dblogin();  
    DBSETLUSER(loginrec, szUsername);  
    DBSETLPWD(loginrec, szPassword);  
    DBSETLCHARSET(loginrec, "UTF-8");  
    DBPROCESS *dbprocess = dbopen(loginrec, szServer);//连接数据库  
    if(dbprocess == FAIL)  
    {  
        printf("Conect to MS SQL SERVER fail, exit!\n");  
        return -1;  
    }  
    printf("Connect to MS SQL SERVER success!\n");  
  
    //绑定数据库  
    if(dbuse(dbprocess,szDBName) == FAIL)  
        printf("Open database failed!\n");  
    else  
        printf("Open databas