Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

CÓïÑÔÓëSQL SERVERÊý¾Ý¿â

1.ʹÓÃCÓïÑÔÀ´²Ù×÷SQL SERVERÊý¾Ý¿â,²ÉÓÃODBC¿ª·ÅʽÊý¾Ý¿âÁ¬½Ó½øÐÐÊý¾ÝµÄÌí¼Ó,ÐÞ¸Ä,ɾ³ý,²éѯµÈ²Ù×÷¡£
step1:Æô¶¯SQLSERVER·þÎñ,ÀýÈç:HNHJ,¿ªÊ¼²Ëµ¥ ->ÔËÐÐ ->net start mssqlserver
step2:´ò¿ªÆóÒµ¹ÜÀíÆ÷,½¨Á¢Êý¾Ý¿âtest,ÔÚtest¿âÖн¨Á¢test±í(a varchar(200),b varchar(200))
step3:½¨Á¢ÏµÍ³DSN,¿ªÊ¼²Ëµ¥ ->ÔËÐÐ ->odbcad32,
  Ìí¼Ó->SQL SERVER
Ãû³Æ£ºcsql,·þÎñÆ÷£ºHNHJ
ʹÓÃÓû§Ê¹ÓõǼIDºÍÃÜÂëµÄSQLSERVERÑéÖ¤,µÇ¼ID:sa,ÃÜÂë:
  ¸ü¸ÄĬÈϵÄÊý¾Ý¿âΪ:test
...
²âÊÔÊý¾ÝÔ´£¬²âÊԳɹ¦£¬¼´DNSÌí¼Ó³É¹¦¡£ 2.cppÎļþÍêÕû´úÂë #include
#include
#include
#include
#include
#include
#include
SQLHENV henv = SQL_NULL_HENV;
SQLHDBC hdbc1 = SQL_NULL_HDBC;
SQLHSTMT hstmt1 = SQL_NULL_HSTMT;
/*
cppÎļþ¹¦ÄÜ˵Ã÷£º
1.Êý¾Ý¿â²Ù×÷ÖеÄÌí¼Ó£¬Ð޸ģ¬É¾³ý£¬Ö÷ÒªÌåÏÖÔÚSQLÓï¾äÉÏ
2.²ÉÓÃÖ±½ÓÖ´Ðз½Ê½ºÍ²ÎÊýÔ¤±àÒëÖ´Ðз½Ê½Á½ÖÖ
*/
int main(){
RETCODE retcode;
UCHAR szDSN[SQL_MAX_DSN_LENGTH+1] = "csql",
szUID[MAXNAME] = "sa",
szAuthStr[MAXNAME] = "";
//SQLÓï¾ä
//Ö±½ÓSQLÓï¾ä
UCHAR sql[37] = "insert into test values('aaa','100')";
//Ô¤±àÒëSQLÓï¾ä
UCHAR pre_sql[29] = "insert into test values(?,?)";
//1.Á¬½ÓÊý¾ÝÔ´
//1.»·¾³¾ä±ú
retcode = SQLAllocHandle (SQL_HANDLE_ENV, NULL, &henv);
retcode = SQLSetEnvAttr(henv, SQL_ATTR_ODBC_VERSION,
(SQLPOINTER)SQL_OV_ODBC3,
SQL_IS_INTEGER);
//2.Á¬½Ó¾ä±ú
retcode = SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc1);
retcode = SQLConnect(hdbc1, szDSN, 4, szUID, 2, szAuthStr, 0);
//ÅжÏÁ¬½ÓÊÇ·ñ³É¹¦
if ( (retcode != SQL_SUCCESS) && (retcode != SQL_SUCCESS_WITH_INFO) ) {
printf("Á¬½Óʧ°Ü!\n");
} else {
//2.´´½¨²¢Ö´ÐÐÒ»Ìõ»ò¶àÌõSQLÓï¾ä
/*
1.·ÖÅäÒ»¸öÓï¾ä¾ä±ú(statement handle)
2.´´½¨SQLÓï¾ä
3.Ö´ÐÐÓï¾ä
4.Ïú»ÙÓï¾ä
*/
retcode = SQLAllocHandle(SQL_HANDLE_STMT, hdbc1, &hstmt1);


Ïà¹ØÎĵµ£º

C³ÌÐò£º¿´ËƼòµ¥


pFn¡¡t1(void);
pFn¡¡t2(void);
int main()
{
¡¡¡¡pFn fn = t1 ;
¡¡¡¡while(1){
¡¡¡¡¡¡¡¡fn = fn();¡¡¡¡//Õâ¸ö£¬´ó¼Ò¿´Çå³þÁË
¡¡¡¡}
}
pFn¡¡t1()
{
¡¡¡¡printf("t1\n");
¡¡¡¡return t2 ;
}
pFn¡¡t2()
{
¡¡¡¡printf("t2\n");
¡¡¡¡return t1 ;
}
ÇëÎÊ£¬Ïëͨ¹ý±àÒ룬pFnº¯ÊýÖ¸ÕëÀàÐÍ ......

¸ÅÄî£ºÎ±Ëæ»úÊý¡¢ÖÖ×ÓÒÔ¼°CÖеÄËæ»úº¯Êý


¸ÅÄî£ºÎ±Ëæ»úÊý¡¢ÖÖ×ÓÒÔ¼°CÖеÄËæ»úº¯Êý
2007Äê12ÔÂ03ÈÕ ÏÂÎç 02:28
Ê×ÏÈÐèÒªÉùÃ÷µÄÊÇ£¬¼ÆËã»ú²»»á²úÉú¾ø¶ÔËæ»úµÄËæ»úÊý£¬¼ÆËã»úÖ»ÄܲúÉú“Î±Ëæ»úÊý”¡£Æäʵ¾ø¶ÔËæ»úµÄËæ»úÊýÖ»ÊÇÒ»ÖÖÀíÏëµÄËæ»úÊý£¬¼´Ê¹¼ÆËã»úÔõÑù·¢Õ¹£¬ËüÒ²²»»á²úÉúÒ»´®¾ø¶ÔËæ»úµÄËæ»úÊý¡£¼ÆËã»úÖ»ÄÜÉú³ÉÏà¶ÔµÄËæ»úÊý£¬¼´Î±Ëæ»úÊý¡£ 
......

SQL 2005 ASP.NETÊý¾Ý¿âÁ¬½Ó×ܽá

 
VS2005+SQL2005 ASP.NET2.0Êý¾Ý¿âÁ¬½Ó×ܽá
    Í¨¹ýÉÏÆªÎÄÕ£¨http://www.cnblogs.com/user34j/archive/2007/01/23/628426.html£©µÄÉèÖÃÆäʵÒѾ­²î²»¶àÍê³ÉÁË£¬Ö»ÊÇ»¹ÓÐһЩϸ½ÚµÄµØ·½Ã»ÓÐ×öºÃ£¬¾­¹ýÒ»·¬Ñо¿ÏÖÔÚÖÕÓڸ㶨ÁË¡£¶ÔÓÚÏñÎÒÕâÑùµÄÐÂÊÖÀ´Ëµ£¬Õû¸öÊý¾Ý¿âÁ¬½ÓÕæÊDz»ÈÝÒס£ÏÖ×ܽáÈçÏ£ ......

SQL ServerÊý¾Ý²Ö¿âÏà¹Ø¸ÅÄî ά¶È±íºÍÊÂʵ±í¸ÅÊö

SQL ServerÊý¾Ý²Ö¿âÏà¹Ø¸ÅÄî-ά¶È±íºÍÊÂʵ±í¸ÅÊö ÊÕ²Ø
¿ªÊ¼Ñо¿BI£¬³õѧ¡£»á¼Ç¼һЩ¸ÅÄîÐÔµÄÎÄÕ¡£
»ù±¾¸ÅÄ
1.¶àάÊý¾Ý¼¯£º¶àάÊý¾Ý¼¯ÊÇÁª»ú·ÖÎö´¦Àí (OLAP) ÖеÄÖ÷Òª¶ÔÏó£¬ÊÇÒ»Ïî¿É¶ÔÊý¾Ý²Ö¿âÖеÄÊý¾Ý½øÐпìËÙ·ÃÎʵļ¼Êõ¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸öÊý¾Ý¼¯ºÏ£¬Í¨³£´ÓÊý¾Ý²Ö¿âµÄ×Ó¼¯¹¹Ô죬²¢×éÖ¯ºÍ»ã×ܳÉÒ»¸öÓÉÒ»×éά¶ÈºÍ¶ÈÁ ......

Ò»¸öSQLÎÞÏÞ¼¶Ê÷ÐÍ´æ´¢¹ý³ÌʵÏÖÊ÷ÐͽṹÊý¾ÝÅÅÐò

ÎÒÃÇÔÚÆ½³£µÄϵͳ¿ª·¢Öг£³£»áÓöµ½ÏñÎÞÏÞ¼¶·ÖÀàÕâÑùµÄÊ÷ÐͽṹÊý¾Ý£¬ÏÖÌṩһ¸ö¿ÉÓõÄÊý¾Ý¿â´æ´¢¹ý³Ì£¬¿ÉÒÔÍê³ÉÊ÷ÐͽṹÊý¾ÝµÄÅÅÐò¡£
»·¾³£ºwindows7+Sql Server 2008
˵Ã÷£ºÏÂÃæ´úÂëÒѾ­×ª»»³ÉSql server2000µÄ½Å±¾£¬´¦ÀíЧ¹ûÈçÏ£¬¿´sortname×ֶνá¹û,´úÂë¾­¹ý²âÊÔ¡£
´´½¨Ê÷Ðͱí
CREATE TABLE [dbo].[categories](
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ