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

¡¾ÇóÖú¡¿sqlserver¿ÉÒÔ´´½¨Ö»ÓеǼȨÏÞµÄÓû§Âð

SqlServer´´½¨Óû§Ê±Ä¬ÈϾ͸³ÓèÁËÒ»¸öpublic½ÇÉ«¡£
ÎÒÊÇ·ñ¿ÉÒÔ´´½¨Ò»¸öÓû§£¬ÈÃÕâ¸öÓû§Ö»ÓеǼµÄȨÏÞ£¬Ã»ÓÐÆäËûµÄȨÏÞ£¡

ÎÒµÄÊý¾Ý¿âÊÇSqlServer2000

SQL code:
--Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾Ý¿â
EXEC sp_addlogin 'wh1','123'



ÕâÑù´´½¨ÒÔºó¾ÍÖ»ÓеǼµÄȨÏÞ

ÒýÓÃ
public½ÇÉ«²»¿ÉÒÔÈ¥µôµÄ
²»¹ýÄã¿ÉÒÔÈ¡ÏûËû¶ÔËùÓÐÊý¾Ý¿âµÄ·ÃÎÊ

......

ÒýÓÃ
SQL code--Ìí¼ÓµÇ¼ wh1,ÉèÖÃÃÜÂëΪ123,ĬÈÏÊý¾Ý¿âEXEC sp_addlogin'wh1','123'


³¢ÊÔÁË£¬Ê¼ÖÕ¿ÉÒÔ·ÃÎÊϵͳÊý¾Ý¿âµÄ£¬ÄǸöpublicÈ¡Ïû²»µôµÄ

ûÓÐÈκÎȨÏÞµÄÕË»§£¬²»ÖªµÀÓÐʲôÓÃ


Ïà¹ØÎÊ´ð£º

sqlserver Êý¾ÝºÏ²¢ÎÊÌâ

ÏÈÓÉÈçÏÂsqlÓï¾ä
select  A,B,C from table1
union
select  A,B,C from table2
order by A, C asc
µÃµ½½á¹ûÈçÏ£º
  A        B      &nbs ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

sqlserver jdbc driverÇý¶¯ÄÄÀïÕÒ

ÎÒ´Ó΢Èí¹ÙÍøÏÂÔØµÄdriverÔõôÊǸöhtmlÎļþË­¸øÖ¸Õýһϣ¬ÔÚÄÄÀïÏ£¬¾ßÌå·¾¶¼°²Ù×÷²½Öè
Ò»°ã¹ÜÍøÏÂÔØ¶¼ÒªÒ»²½Ò»²½×ßÏÂÈ¥£¬Èç¹ûÄã¹ýÔçÁí´æÎªµÄ»°£¬µÃµ½µÄÍùÍùÊÇlicenseÄÇÒ»Ò³¡£

ÎҼǵĺÃÏëÔÚ£ºÄãϵÄÄǸöHTMLÎļ ......

SQLServer ÎÞ·¨½¨Á¢Á¬½Ó£¬·þÎñÈ«²¿¹Ø±Õ£¬Æô¶¯²»ÁË

Ê×ÏÈ£º¼ÒÀïµçÄÔ×°×ÅSQLServer ÊÇ×Ô¼ºµ½¼ÒÀïÒ²ÄÜ·½±ã¹¤×÷£¬Ç°¼¸Ì컹ºÃºÃµÄ£¬×òÌìÎÒÉÏSQL È´´ò²»¿ªÁË£¬µÇ¼²»ÉÏÈ¥£¬ÎÒÊÔ×Å»»saµÇ¼Ҳ²»ÐС£ÓÃwindowsµÇ¼»¹ÊÇÁ¬½Óʧ°Ü ±¨´íÊÇÕâÑùµÄ£º
      ÔÚ½¨Á¢ ......

--oracle ´¥·¢Æ÷£¬×ª sqlserver ÎÊÌâ

--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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ