性能测试脚本之SQLServer执行语句

Action()
{
      int NumRows=0;
       int i=1;
       int NumRows1=0;

    //建立数据库连接
    lr_db_connect("StepName=DatabaseConnection",
      "ConnectionString=Password=XX0817xx@@@;Persist Security Info=True;User ID=sa;Initial Catalog=student;Data Source=ESFVMVI-2528\SQLEXPRESS",
      "ConnectionName=InvDatabaseConnection",
      "ConnectionType=SQL",
      LAST);

    //执行SQL语句
    NumRows=lr_db_executeSQLStatement("StepName=PerformQuery",
         "ConnectionName=InvDatabaseConnection",
         "SQLStatement=SELECT * FROM score",
         "DatasetName=MyDataset",
         LAST);
    lr_output_message("The query returned %d rows.", NumRows);

  
    //打印出结果
     lr_db_dataset_action("StepName=PrintDataset","DatasetName=MyDataset","Action=PRINT",LAST);
 
     NumRows1=lr_db_executeSQLStatement("StepName=procQuery",
         "ConnectionName=InvDatabaseConnection",
         "SQLStatement=exec StuProc1",
         "DatasetName=MyDataset1",
         LAST);
     lr_output_message("The query returned %d rows.", NumRows1);
     
     lr_db_dataset_action("StepName=PrintDataset","DatasetName=MyDataset1","Action=PRINT",LAST);
     
     lr_db_disconnect("StepName=Disconnect",
        "ConnectionName=InvDatabaseConnection", 
        LAST );
}