¡¾ÇóÖú¡¿sqlserver¿ÉÒÔ´´½¨Ö»ÓеǼȨÏÞµÄÓû§Âð
SqlServer´´½¨Óû§Ê±Ä¬ÈϾ͸³ÓèÁËÒ»¸öpublic½ÇÉ«¡£ ÎÒÊÇ·ñ¿ÉÒÔ´´½¨Ò»¸öÓû§£¬ÈÃÕâ¸öÓû§Ö»ÓеǼµÄȨÏÞ£¬Ã»ÓÐÆäËûµÄȨÏÞ£¡
ÎÒµÄÊý¾Ý¿âÊÇSqlServer2000 SQL code: --Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾Ý¿â EXEC sp_addlogin 'wh1','123' ÕâÑù´´½¨ÒÔºó¾ÍÖ»ÓеǼµÄȨÏÞÒýÓà public½ÇÉ«²»¿ÉÒÔÈ¥µôµÄ ²»¹ýÄã¿ÉÒÔÈ¡ÏûËû¶ÔËùÓÐÊý¾Ý¿âµÄ·ÃÎÊ ......ÒýÓà SQL code--Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾Ý¿âEXEC sp_addlogin'wh1','123' ³¢ÊÔÁË£¬Ê¼ÖÕ¿ÉÒÔ·ÃÎÊϵͳÊý¾Ý¿âµÄ£¬ÄǸöpublicÈ¡Ïû²»µôµÄ ûÓÐÈκÎȨÏÞµÄÕË»§£¬²»ÖªµÀÓÐʲôÓÃ
Ïà¹ØÎÊ´ð£º
ÏÈÓÉÈçÏÂsqlÓï¾ä select A,B,C from table1 union select A,B,C from table2 order by A, C asc µÃµ½½á¹ûÈçÏ£º A B &nbs ......
ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð» ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡ ¹Ø×¢¡«¡« Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿ ......
ÎÒ´Ó΢Èí¹ÙÍøÏÂÔØµÄdriverÔõôÊǸöhtmlÎļþ˸øÖ¸Õýһϣ¬ÔÚÄÄÀïÏ£¬¾ßÌå·¾¶¼°²Ù×÷²½Öè Ò»°ã¹ÜÍøÏÂÔØ¶¼ÒªÒ»²½Ò»²½×ßÏÂÈ¥£¬Èç¹ûÄã¹ýÔçÁí´æÎªµÄ»°£¬µÃµ½µÄÍùÍùÊÇlicenseÄÇÒ»Ò³¡£ ÎҼǵĺÃÏëÔÚ£ºÄãϵÄÄǸöHTMLÎļ ......
Ê×ÏÈ£º¼ÒÀïµçÄÔ×°×ÅSQLServer ÊÇ×Ô¼ºµ½¼ÒÀïÒ²ÄÜ·½±ã¹¤×÷£¬Ç°¼¸Ì컹ºÃºÃµÄ£¬×òÌìÎÒÉÏSQL È´´ò²»¿ªÁË£¬µÇ¼²»ÉÏÈ¥£¬ÎÒÊÔ×Å»»saµÇ¼Ҳ²»ÐС£ÓÃwindowsµÇ¼»¹ÊÇÁ¬½Óʧ°Ü ±¨´íÊÇÕâÑùµÄ£º ÔÚ½¨Á¢ ......
--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ CREATE OR REPLACE TRIGGER TG_BU_TSTK_IMPORTITEM BEFORE UPDATE ON TSTK_IMPORTITEM FOR EACH ROW DECLARE VAR_LIBGOODCOUNT NUMERIC(12,2); BEGIN
......