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
Ïà¹ØÎĵµ£º
ʹÓà LIKE µÄģʽƥÅä
µ±ËÑË÷ datetime ֵʱ£¬ÍƼöʹÓà LIKE£¬ÒòΪ datetime Ïî¿ÉÄܰüº¬¸÷ÖÖÈÕÆÚ²¿·Ö¡£ÀýÈ磬Èç¹û½«Öµ 19981231 9:20 ²åÈëµ½ÃûΪ arrival_time µÄÁÐÖУ¬Ôò×Ó¾ä WHERE arrival_time = 9:20 ½«ÎÞ·¨ÕÒµ½ 9:20 ×Ö·û´®µÄ¾«È·Æ¥Å䣬ÒòΪ SQL Server ½«Æäת»»Îª 1900 Äê 1 Ô 1 ÈÕÉÏÎ ......
--²éѯµ±Ç°Á¬½ÓµÄʵÀýÃû
select @@servername
--²ì¿´ÈκÎÊý¾Ý¿âÊôÐÔ
sp_helpdb master
--ÉèÖõ¥Óû§Ä£Ê½£¬Í¬Ê±Á¢¼´¶Ï¿ªËùÓÐÓû§
alter database Northwind set single_user with rollback immediate
--»Ö¸´Õý³£
alter database Northwind set multi_user
--²ì¿´Êý¾Ý¿âÊôÐÔ
sp_helpdb
--²ì¿´Êý¾Ý¿â»Ö¸´Ä£Ê½
sel ......
ǰ¶Îʱ¼ä °Ñ֮ǰµÄÎÞÏÞ·Ö¼¶±íÉÔ΢×öÁËһЩ¸Ä½ø ¸Ä½øºóµÄ±í½á¹¹ÈçÏÂ
ID Name ParentID ParentIDList level
1 A 0 0-1 &nbs ......
[¿ÉÓÃ]Èç¹û³öÏÖ°²×°sql server 2000ÒªÇóCD-KEYµÄÇé¿ö,ÇëʹÓÃregedt32ÕÒ¿ª×¢²á±í,ÔÚÒÔÏÂÖ÷¼ü[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager]Öн¨Á¢Ò»¸öDWORD¼ü
SafeDLLSearchMode²¢ÉèֵΪ0
Õâ¸öÊÔ¹ý£¬ÊÇ¿ÉÒÔÓõÄ
H6TWQ-TQQM8-HXJYG-D69F7-R84VM - ......
ansi_warningºÍansi_nulls Á½¸öÑ¡Ïî±ØÐë´ò¿ª£¬ºÃÏñ¶ÔϵͳҲûɶӰÏì¡£
Â¥Ö÷ÔÙ¼ì²éÒ»ÏÂÁ½¸öµØ·½£¬¾²âÊÔ£¬ÔÚҪʹÓ÷ֲ¼Ê½ÊÂÎñʱ£¬ÕâÊDZØÐëÒªÉèÖõġ£
1¡¢Á´½Ó·þÎñÆ÷ºÍÃû³Æ½âÎöÎÊÌâ
-- ´´½¨Á´½Ó·þÎñÆ÷
EXEC sp_addlinkedserver 'srv_lnk', 'ms', 'SQLOLEDB', '192.168.1. ......