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

SQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.

 ±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
±¾ÎÄÊÇÒ»¸ö¼¼ÇÉÎÄÕÂ,½éÉÜSQL¸ù¾ÝÒÑÖªµÄÄêÔÂ,¼ÆËã¸ÃÔµÄÌìÊý.
declare   @iDays   int 
declare   @dt   varchar(50) 
set   @dt=@Year+'-'+@Month+'-01'
select @iDays=day(dateadd(d,-Day(dateadd(m,1,convert(datetime,@dt))),dateadd(m,1,convert(datetime,@dt))))
print @idays


Ïà¹ØÎĵµ£º

SQL ServerÃæÊÔÌâÕûºÏ

3¡£±íÄÚÈÝÈçÏÂ
-----------------------------
ID            LogTime
1            2008/10/10 10:00:00
1            2008/10/10 10:03:00
1            2008/10/10 10:09:00
2 ¡ ......

SQLÒªÇóCDKEYµÄ½â¾ö°ì·¨

 
[¿ÉÓÃ]Èç¹û³öÏÖ°²×°sql server 2000ÒªÇóCD-KEYµÄÇé¿ö,ÇëʹÓÃregedt32ÕÒ¿ª×¢²á±í,ÔÚÒÔÏÂÖ÷¼ü[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager]Öн¨Á¢Ò»¸öDWORD¼ü
SafeDLLSearchMode²¢ÉèֵΪ0
Õâ¸öÊÔ¹ý£¬ÊÇ¿ÉÒÔÓõÄ
 
H6TWQ-TQQM8-HXJYG-D69F7-R84VM      - ......

OracleÓëSQL ServerÊý¾Ý»¥ÓÃÐÔ£¨3£©

 ×÷Õß Haidong Ji  ·­Òë GoodKid
ÔÚÎҵĹØÓÚOracleºÍSQL Server »¥ÓÃÐÔµÄϵÁÐÎÄÕ part 1 ºÍ part 2 µ±ÖУ¬ÎÒÌÖÂÛÁËOracleºÍSQL Server µÄһЩ²»Í¬µãµÄ»°ÌâÒÔ¼°OracleÇý¶¯µÄ¿ÉÑ¡ÐÔ¡£ÔÚ±¾Ö÷ÌâÖУ¬ÎÒ½«ÌÖÂÛÒ»¸öÀ´×ÔOracle 10gµÄй¤¾ß£¬Oracle¼´Ê±¿Í»§¶Ë¡£
¶ÔÓÚOracle 10gÒÔǰµÄ°æ±¾£¬Èç¹ûÏ뽨Á¢ºÍOracleµÄÁ¬½Ó£¬ ......

轉SQL Server Ô¶³ÌÁ´½Ó·þÎñÆ÷ÏêϸÅäÖÃ

 Ô¶³ÌÁ´½Ó·þÎñÆ÷ÏêϸÅäÖÃ
--
½¨Á¢Á¬½Ó·þÎñÆ÷
EXEC
sp_addlinkedserver
'
Ô¶³Ì·þÎñÆ÷IP
'
,
'
SQL Server
'
--
±ê×¢´æ´¢
EXEC
sp_addlinkedserver
@server

=

'
server
'
,
--
Á´½Ó·þÎñÆ÷µÄ±¾µØÃû³Æ¡£Ò²ÔÊÐíʹÓÃʵÀýÃû³Æ£¬ÀýÈçMYSERVER\SQL1
@srvproduct

=

'
product_name ......

ʹÓÃSQL SERVERµÄLink ServerʵÏÖ·Ö²¼Ê½ÊÂÎñ

ansi_warningºÍansi_nulls Á½¸öÑ¡Ïî±ØÐë´ò¿ª£¬ºÃÏñ¶ÔϵͳҲûɶӰÏì¡£
 
Â¥Ö÷ÔÙ¼ì²éÒ»ÏÂÁ½¸öµØ·½£¬¾­²âÊÔ£¬ÔÚҪʹÓ÷ֲ¼Ê½ÊÂÎñʱ£¬ÕâÊDZØÐëÒªÉèÖõġ£
1¡¢Á´½Ó·þÎñÆ÷ºÍÃû³Æ½âÎöÎÊÌâ
-- ´´½¨Á´½Ó·þÎñÆ÷
EXEC sp_addlinkedserver 'srv_lnk', 'ms', 'SQLOLEDB', '192.168.1. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ