Programming Embedded SQL for C
Microsoft Embedded SQL for C (ESQL/C) offers programmers an alternative to writing Microsoft® SQL Server™ 2000 client applications with the DB-Library for C or Open Database Connectivity (ODBC) application programming interfaces (APIs). ESQL/C enables you to incorporate Transact-SQL statements into your C-language programs.ESQL/C is mainly used for porting your existing applications from other databases to SQL Server.帮助上看到的,虽然我还不懂:D
Microsoft Embedded SQL for C (ESQL/C) offers programmers an alternative to writing Microsoft® SQL Server™ 2000 client applications with the DB-Library for C or Open Database Connectivity (ODBC) application programming interfaces (APIs). ESQL/C enables you to incorporate Transact-SQL statements into your C-language programs.ESQL/C is mainly used for porting your existing applications from other databases to SQL Server.帮助上看到的,虽然我还不懂:D
For example, the following Embedded SQL code does the same task as the DB-Library example in Call-level Method:main()
{
EXEC SQL BEGIN DECLARE SECTION;
char first_name[50];
char last_name[] = "White";
EXEC SQL END DECLARE SECTION; EXEC SQL CONNECT TO my_server.pubs
USER my_login.my_password;
EXEC SQL SELECT au_fname INTO :first_name
from authors where au_lname = :last_name;
return (0);
}