SQL±êʶֵ £¨×ª£©
@@IDENTITY£º·µ»Ø×îºó²åÈëµÄ±êʶֵµÄϵͳº¯Êý¡£
SCOPE_IDENTITY£º·µ»Ø²åÈ뵽ͬһ×÷ÓÃÓòÖеıêʶÁÐÄÚµÄ×îºóÒ»¸ö±êʶֵ¡£Ò»¸ö·¶Î§ÊÇÒ»¸öÄ£¿é£º´æ´¢¹ý³Ì¡¢´¥·¢Æ÷¡¢º¯Êý»òÅú´¦Àí¡£Òò´Ë£¬Èç¹ûÁ½¸öÓï¾ä´¦ÓÚͬһ¸ö´æ´¢¹ý³Ì¡¢º¯Êý»òÅú´¦ÀíÖУ¬ÔòËüÃÇλÓÚÏàͬµÄ×÷ÓÃÓòÖС£
IDENT_CURRENT:·µ»ØΪָ¶¨µÄ±í»òÊÓͼÉú³ÉµÄ×îºóÒ»¸ö±êʶֵ¡£ËùÉú³ÉµÄ×îºóÒ»¸ö±êʶֵ¿ÉÒÔÕë¶ÔÈκλỰºÍÈκÎ×÷ÓÃÓò¡£
Óï·¨£ºIDENT_CURRENT( 'table_name' )
SCOPE_IDENTITY¡¢IDENT_CURRENT ºÍ @@IDENTITY ÊÇÏàËƵĺ¯Êý£¬ÒòΪËüÃǶ¼·µ»Ø²åÈëµ½±êʶÁÐÖеÄÖµ¡£µ«ÊÇ£¬ÉÏÊöÿ¸öº¯ÊýÖж¨ÒåµÄ“×îºó”µÄ×÷ÓÃÓòºÍ»á»°ÓÐËù²»Í¬¡£
IDENT_CURRENT ²»ÊÜ×÷ÓÃÓòºÍ»á»°µÄÏÞÖÆ£¬¶øÊÜÏÞÓÚÖ¸¶¨µÄ±í¡£IDENT_CURRENT ·µ»ØΪÈκλỰºÍ×÷ÓÃÓòÖеÄÌض¨±íËùÉú³ÉµÄÖµ¡£
SCOPE_IDENTITY ºÍ @@IDENTITY ·µ»ØÔÚµ±Ç°»á»°ÖеÄÈκαíÄÚËùÉú³ÉµÄ×îºóÒ»¸ö±êʶֵ¡£µ«ÊÇ£¬SCOPE_IDENTITY Ö»·µ»Ø²åÈëµ½µ±Ç°×÷ÓÃÓòÖеÄÖµ£»@@IDENTITY ²»ÊÜÏÞÓÚÌض¨µÄ×÷ÓÃÓò¡£
ÀýÈ磬ÓÐÁ½¸ö±í T1 ºÍ T2£¬²¢ÇÒÔÚ T1 É϶¨ÒåÁË INSERT ´¥·¢Æ÷¡£µ±½«Ä³ÐвåÈë T1 ʱ£¬´¥·¢Æ÷±»¼¤·¢£¬²¢ÔÚ T2 ÖвåÈëÒ»ÐС£¸Ã·½°¸ÑÝʾÁËÁ½¸ö×÷ÓÃÓò£ºÔÚ T1 ÉϵIJåÈ룬ÒÔ¼°ÔÚ T2 ͨ¹ý´¥·¢Æ÷µÄ²åÈë¡£
¼ÙÉè T1 ºÍ T2 ¶¼ÓбêʶÁУ¬@@IDENTITY ºÍ SCOPE_IDENTITY ½«ÔÚ T1 É쵀 INSERT Óï¾äµÄ×îºó·µ»Ø²»Í¬µÄÖµ¡£@@IDENTITY ½«·µ»ØÔÚµ±Ç°»á»°ÖеÄÈκÎ×÷ÓÃÓòÄÚ²åÈëµÄ×îºóÒ»¸ö±êʶÁеÄÖµ¡£ÕâÊÇÔÚ T2 ÖвåÈëµÄÖµ¡£SCOPE_IDENTITY() ½«·µ»ØÔÚ T1 ÖвåÈëµÄ IDENTITY Öµ¡£ÕâÊÇÔÚͬһ¸ö×÷ÓÃÓòÄÚ·¢ÉúµÄ×îºóµÄ²åÈë¡£Èç¹ûÔÚÈκΠINSERT Óï¾ä×÷ÓÃÓÚ×÷ÓÃÓòÖеıêʶÁÐ֮ǰµ÷Óà SCOPE_IDENTITY() º¯Êý£¬Ôò¸Ãº¯Êý½«·µ»Ø¿ÕÖµ¡£
Èç¹ûÓï¾äºÍÊÂÎñʧ°Ü£¬ËüÃÇ»á¸ü¸Ä±íµÄµ±Ç°±êʶ£¬´Ó¶øʹ±êʶÁÐÖеÄÖµ³öÏÖ²»Á¬¹áÏÖÏó¡£¼´Ê¹Î´Ìá½»ÊÔͼÏò±íÖвåÈëÖµµÄÊÂÎñ£¬Ò²ÓÀÔ¶ÎÞ·¨»Ø¹ö±êʶֵ¡£ÀýÈ磬Èç¹ûÒò IGNORE_DUP_KEY ³åÍ»¶øµ¼Ö INSERT Óï¾äʧ°Ü£¬±íµÄµ±Ç°±êʶֵÈÔÈ»»áÔö¼Ó¡£
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
ϵͳ»·¾³£ºWindows 7
Èí¼þ»·¾³£ºVisual C++ 2008 SP1 +SQL Server 2005
±¾´ÎÄ¿µÄ£º±àдһ¸öº½¿Õ¹ÜÀíϵͳ
ÕâÊÇÊý¾Ý¿â¿Î³ÌÉè¼ÆµÄ³É¹û£¬ËäÈ»³É¼¨²»¼Ñ£¬µ«ÊÇ×÷ΪÎÒÓÃVC++ ÒÔÀ´±àдµÄ×î´ó³ÌÐò»¹ÊÇ´«µ½ÍøÉÏ£¬ÒÔ¹©²Î¿¼¡£ÓÃVC++ ×öÊý¾Ý¿âÉè¼Æ²¢²»ÈÝÒ×£¬µ«Ò²²»ÊDz»¿ÉÄÜ¡£ÒÔÏÂÊÇÎҵijÌÐò½çÃ棬ºóÃæ ......
import java.sql.*;
public class JdbcUtil
{
public static void close(Statement st, Connection con)
{
try
{
&nb ......
´ÓÍøÂçÉÏ¿´µ½²»ÉÙ¹ØÓÚÊý¾Ý¿âÔ¶³Ì·ÃÎÊÅäÖõÄÎÄÕ£¬¸øÎҵĴóÌåÓ¡Ïó¾ÍÊÇÅäÖùý³Ì¸´ÔÓÈßÓ࣬Óв»ÉÙ»¹ÊÇ´íÎóµÄÅäÖÆ·½·¨£¬´ó¶àÊý¶¼ÈÃÈ˸оõ·Ñ½â£¬¼øÓÚ´Ë£¬ÎÒ×Ô¼º¸ù¾Ýʵ¼Ê²Ù×÷£¬Ð´ÁËÒ»¸öÊý¾Ý¿âÔ¶³Ì·ÃÎʵÄÅäÖ÷½·¨£¬Á¦Çó¼òµ¥ÓÐЧ¡£ÓжÔÏÂÃæÅäÖÃÓÐÒÉÎʵĿÉÒÔÁôÑÔ£¬ÎÒ½«×÷³ö»Ø´ð¡£
1. &nb ......
Èç¹ûÄãÕýÔÚ¸ºÔðÒ»¸ö»ùÓÚSQL ServerµÄÏîÄ¿£¬»òÕßÄã¸Õ¸Õ½Ó´¥SQL Server£¬Ä㶼ÓпÉÄÜÒªÃæÁÙһЩÊý¾Ý¿âÐÔÄܵÄÎÊÌ⣬ÕâƪÎÄÕ»áΪÄãÌṩһЩÓÐÓõÄÖ¸µ¼£¨ÆäÖдó¶àÊýÒ²¿ÉÒÔÓÃÓÚÆäËüµÄDBMS£©¡£
ÔÚÕâÀÎÒ²»´òËã½éÉÜʹÓÃSQL ServerµÄÇÏÃÅ£¬Ò²²»ÄÜÌṩһ¸ö°üÖΰٲ¡µÄ·½°¸£¬ÎÒËù×öµÄÊÇ×ܽáһЩ¾Ñé----¹ØÓÚÈçºÎÐγÉÒ»¸öºÃµÄÉè¼Æ¡£Õ ......