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

mssql ¸ß¼¶²éѯ

ÉÌÆ·±í
ProductManager_Name                  ProductManager_Type_Id
-------------------------------------------------------------
Öйú¾­¼ÃÈȵãÑо¿±¨¸æ1           203,182
ÖйúÈËÎÄÉç»á¿ÆѧǰÑر¨¸æ1999 182,203


Àà±ð±í
ProductManager_Type_Id              ProductManager_Type_Name
-------------------------------------------------------------
203                                  ƤÊéϵÁÐ
182                                  ¾­¼ÃѧϵÁÐ


ÎÒÏë²éѯ³öµÄ½á¹ûÊÇ
ProductManager_Name                  ProductManager_Type_Id            ProductManager_Type_Name
-----------------------------------------------------------------------------------------------------
Öйú¾­¼ÃÈȵãÑо¿±¨¸æ1           203,182                            ƤÊéϵÁÐ,¾­¼ÃѧϵÁÐ
ÖйúÈËÎÄÉç»á¿ÆѧǰÑر¨¸æ1999 182,203                            ¾­¼ÃѧϵÁÐ,ƤÊéϵÁÐ

SQL code




Ïà¹ØÎÊ´ð£º

ÍøÕ¾´ò°ü£¬ÄÜ´ò³ÉmssqlµÄ±í²»Èÿͻ§¿´µ½ÄÚÈÝÂð

ÈçÌ⣬Ï뽫ÎÒÒÔÇ°×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹý ......

»ñµÃmssqlÊý¾Ý¼¯µÄÎÊÌâ

ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
  create  procedure add_pp_SqlPager
  @sqlstr nvarchar(4000),                --²éѯ×Ö· ......

ÈçºÎ°Ñ´Ómssql²éѯµ½µÄÊý¾Ý²åÈëµ½accessÖÐ

ÎÒÁ¬½ÓÁËÁ½¸öÊý¾Ý¿â£¬mssql£¬access

ÈçºÎÔÚͬһ¸ö°´Å¥Ï²Ù×÷Á½¸öÊý¾Ý¿âµÄ±í

±ÈÈ磬ÎÒͨ¹ý¸´ÔÓµÄsqlÓï¾ä´ÓmssqlÊý¾Ý¿â¶à¸ö±íÈ¡µÃÁËÊý¾Ý

È»ºó²åÈëaccessÊý¾Ý¿âijһ¸ö±íÖÐ

SQL code:
SQL SER ......

Ò»¸öMSSQLµÄÁ¬½ÓÎÊÌâ

°ì¹«ÊÒÀïÓÐ6̨µçÄÔ£¬ÆäÖÐһ̨װÓÐMSSQL 2005 ×÷Ϊ·þÎñÆ÷£¬ÁíÍâÎą̊µçÄÔ¸÷ÓÐÒ»¸öÓû§Ãû£¬¶¼ÉèÖóɿÉÒÔ·ÃÎʵÄÁË¡£µ«Ö»ÓÐÁ½Ì¨¿ÉÒÔÁ¬ÉÏÊý¾Ý¿â£¬ÆäËûµÄ±¨´í£º[DBNETLIB][ConnectionOpen (Connect()).]SQL Server ²»´æÔÚ»ò ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ