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
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬Ï뽫ÎÒÒÔÇ°×ö¹ýµÄÍøÕ¾·ÅÔÚÍøÉϸøÈË¿´£¬ÓÉÓÚÊÇms sqlµÄ£¬´ó¶àÊýÍøÂçÉ̵ÄÐéÄâÖ÷»úÊÇÒªÊշѵģ¬
Ïë´ò°üºó·ÅÔÚһЩÃâ·ÑµÄ¿Õ¼ä£¬ÈÃÈ˼Ò×Ô¼ºÏÂÔØÈ¥¿´£¬ËùÒÔÏ£Íû´ò¹ý°üºóµÄÊý¾Ý¿âµÄ±í²»Èÿͻ§¿´µ½£¬
»òÕßÊǼӹý ......
ÓÉÓÚ×î½üҪдһ¸ö·ÖÒ³µÄ³ÌÐò£¬ÔÚÍøÉÏÕÒÁ˸ö´æ´¢¹ý³Ì£»
create procedure add_pp_SqlPager
@sqlstr nvarchar(4000), --²éѯ×Ö· ......
ÎÒÁ¬½ÓÁËÁ½¸öÊý¾Ý¿â£¬mssql£¬access
ÈçºÎÔÚͬһ¸ö°´Å¥Ï²Ù×÷Á½¸öÊý¾Ý¿âµÄ±í
±ÈÈ磬ÎÒͨ¹ý¸´ÔÓµÄsqlÓï¾ä´ÓmssqlÊý¾Ý¿â¶à¸ö±íÈ¡µÃÁËÊý¾Ý
È»ºó²åÈëaccessÊý¾Ý¿âijһ¸ö±íÖÐ
SQL code:
SQL SER ......
°ì¹«ÊÒÀïÓÐ6̨µçÄÔ£¬ÆäÖÐһ̨װÓÐMSSQL 2005 ×÷Ϊ·þÎñÆ÷£¬ÁíÍâÎą̊µçÄÔ¸÷ÓÐÒ»¸öÓû§Ãû£¬¶¼ÉèÖóɿÉÒÔ·ÃÎʵÄÁË¡£µ«Ö»ÓÐÁ½Ì¨¿ÉÒÔÁ¬ÉÏÊý¾Ý¿â£¬ÆäËûµÄ±¨´í£º[DBNETLIB][ConnectionOpen (Connect()).]SQL Server ²»´æÔÚ»ò ......