¹ØÓÚsql serverµÄ1433ºÍ1434¶Ë¿Ú
ת×Ô£º°Ù¶È°Ù¿Æ
Ëùν¶Ë¿Ú£¬¾ÍÊÇÏ൱ÓÚ»úÆ÷ÓëÍâ½ç½Ó´¥µÄ´°¿Ú¡£¶Ë¿ÚÆäʵÊÇÈí¼þµÄ´°¿Ú£¬¾ÍÊÇ˵һ¸öÈí¼þÈç¹ûÒªºÍÍâ½çÁªÏµ£¬¾Í±ØÐë´ò¿ªÒ»¸ö¶Ë¿Ú£»1434¶Ë¿ÚÊÇ΢ÈíSQL Serverδ¹«¿ªµÄ¼àÌý¶Ë¿Ú¡£ÄãҪʹÓÃSQL£¬¾Í±ØÈ»´ò¿ª1433ºÍ1434¶Ë¿Ú¡£
ĬÈÏÇé¿öÏ£¬SQL ServerʹÓÃ1433¶Ë¿Ú¼àÌý£¬ºÜ¶àÈ˶¼ËµSQL ServerÅäÖõÄʱºòÒª°ÑÕâ¸ö¶Ë¿Ú¸Ä±ä£¬ÕâÑù±ðÈ˾Ͳ»ÄܺÜÈÝÒ×µØÖªµÀʹÓõÄʲô¶Ë¿ÚÁË¡£¿Éϧ£¬Í¨¹ý΢Èíδ¹«¿ªµÄ1434¶Ë¿ÚµÄUDP̽²â¿ÉÒÔºÜÈÝÒ×ÖªµÀ SQL ServerʹÓõÄʲôTCP/IP¶Ë¿ÚÁË¡£ ÀýÈ磺“2003Èä³æÍõ”ÀûÓÃSQL SERVER 2000µÄ½âÎö¶Ë¿Ú1434µÄ»º³åÇøÒç³ö©¶´£¬¶ÔÍøÂç½øÐй¥»÷¡£
²»¹ý΢Èí»¹ÊÇ¿¼Âǵ½ÁËÕâ¸öÎÊÌ⣬±Ï¾¹¹«¿ª¶øÇÒ¿ª·ÅµÄ¶Ë¿Ú»áÒýÆð²»±ØÒªµÄÂé·³¡£ÔÚʵÀýÊôÐÔÖÐÑ¡ÔñTCP/IPÐÒéµÄÊôÐÔ¡£Ñ¡ÔñÒþ²Ø SQL Server ʵÀý¡£Èç¹ûÒþ²ØÁË SQL Server ʵÀý£¬Ôò½«½ûÖ¹¶ÔÊÔͼö¾ÙÍøÂçÉÏÏÖÓÐµÄ SQL Server ʵÀýµÄ¿Í»§¶ËËù·¢³öµÄ¹ã²¥×÷³öÏìÓ¦¡£ÕâÑù£¬±ðÈ˾Ͳ»ÄÜÓÃ1434À´Ì½²âÄãµÄTCP/IP¶Ë¿ÚÁË£¨³ý·ÇÓÃPort Scan£©
SQL Server 2005²»ÔÙÔÚ1434¶Ë¿ÚÉϽøÐÐ×Ô¶¯ÕìÌýÁË¡£Êµ¼ÊÉÏ£¬ÊÇÍêÈ«²»ÕìÌýÁË¡£ÄãÐèÒª´ò¿ªSQL ä¯ÀÀÆ÷·þÎñ£¬°ÑËü×÷Ϊ½â¾ö¿Í»§¶ËÏò·þÎñÆ÷¶Ë·¢ËÍÇëÇóµÄÖмäý½é¡£SQL ä¯ÀÀÆ÷·þÎñÖ»ÄÜÌṩÃû×Ö/¶Ë¿Ú¾öÒé¡£
Ïà¹ØÎĵµ£º
ÔÚSQLÓï¾äÖУ¬³£³£Óûá¶Ôʱ¼ä£¨»òÈÕÆÚ£©½øÐÐһЩ´¦Àí£¬ÏÂÃæÊDZȽÏͨÓõÄһЩÓï¾ä£º
ÑÓ³Ù£º
sysdate+(5/24/60/60) ÔÚϵͳʱ¼ä»ù´¡ÉÏÑÓ³Ù5Ãë
sysdate+5/24/60 ÔÚϵͳʱ¼ä»ù´ ......
Õâ¸öº¯ÊýDateAdd(month,2,WriteTime)£º
ÈÕÆÚ²¿·ÖËõд Year yy, yyyy quarter qq, q Month mm, m dayofyear dy, y Day dd, d Week wk, ww Hour hh minute mi, n second ss, s millisecond ms
¡¡¡¡Õâ¸ö±í×㹻˵Ã÷ÎÊÌâÁË°É,´Óyearµ½millisecond¶¼¿ÉÒÔ´¦Àí£¬¹»·½±ãÁË°É.
DATEDIFF º¯Êý [ÈÕÆÚºÍʱ¼ä]
-------------- ......
1.bzscs(ɳ³æ ÎÒ°®Ð¡ÃÀ)Óú¯數µÄºÃ辦·¨:
CREATE function [dbo].[calc_date](@time smalldatetime,@now smalldatetime)
returns nvarchar(10)
as
begin
declare @year int,@month int,@day int
select @year = datediff(yy,@time,@now)
if (month(@now)=month(@time)) and (day ......
--sql structured query language
--DML--Data Manipulation Language--Êý¾Ý²Ù×÷ÓïÑÔ
query information (SELECT),
add new rows (INSERT),
modify existing rows (UPDATE),
delete existing rows (DELETE),
perform a conditional update or insert operation (MERGE),
see an execution plan of SQL (EXPLA ......
×¢'svw'Ϊ³öÎÊÌâµÄÊý¾Ý¿â,´Ë·½Ê½¶Ôsql7.0ÒÔÉÏ°æ±¾ÓÐЧ,ÆäËüµÍ°æ±¾Îª²âÊÔ
sp_configure 'allow',1
go
reconfigure with override
go
update sysdatabases set status=32768 where name='svw'
go
dbcc rebuild_log('svw','D:\mssql7\data ......