【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,458.sql,希望对大家有所帮助!
/*定义SQL
通信区*/
EXEC SQL INCLUDE sqlca;
/*说明主变量*/
EXEC SQL BEGIN DECLARE SECTION;
char teacher_name [50];
int age;
EXEC SQL END DECLARE SECTION;
main()
{
/*建立与SQL Server数据库连接*/
EXEC SQL CONNECT TO db_
sql USER sa;
if (sqlca->sqlcode !=0)
{
printf("连接失败\n");
}
else
{
printf("连接成功! \n");
}
/*定义嵌入式SQL语句*/
EXEC SQL SELECT TNAME,AGE
INTO :teacher_name,:age
FROM tb_MyTeacher23
WHERE TNO=1;
/*输出
查询结果*/
printf("教师: %s\n 工龄: %d\n",
teacher_name,age);
}