SQL Server 2005 ÎÊÌ⣺TCP/IPÎÞ·¨Á¬½Ó
¸ÕÅöµ½Õâ¸öÎÊÌâʱ£¬ÒÔΪÊÇÓ¦Ó÷þÎñÆ÷ºÍÊý¾Ý¿â·þÎñÆ÷ûÁ¬Í¨£¬²éÁ˰ëÌìµÄÍøÂç½á¹ûÍøÉÏÒ»²é£¬¸úSQL Server 2005Óйأ¬ÄãÌ«ÑôµÄ£¡
¿ªÊ¼²Ëµ¥-SQLServer2005-ÅäÖù¤¾ß-SQL Server Configuration Manager-SQLserver2005ÍøÂçÅäÖÃ-MSSQLSERVERµÄÐÒé-Ë«»÷TCP/IPÐÒé
°ÑIP¸Ä³Éµ±Ç°Ê¹Óõ쬵±È»£¬¶Ë¿ÚҲҪȷ±£ÕýÈ·¡£ÔÙÖØÆôÊý¾Ý¿â£¬¾ÍOKÁË¡£¸ÄÁËIPµØÖ·£¬SQLServer¾ÓÈ»²»»á×Ô¶¯Ð޸ģ¬Õæ´À£¬ÔÙÌ«ÑôÒ»´ÎMS
Ïà¹ØÎĵµ£º
create function [dbo].[DeptTree](@initDeptCode varchar(10))/*¶¨Ò庯Êýc_tree£¬ÊäÈë²ÎÊýΪ³õʼ½ÚµãDeptCode*/
returns @t table(DeptCode varchar(10),UpDeptCode varchar(10),lev int)/*¶¨Òå±ítÓÃÀ´´æ·ÅÈ¡³öµÄÊý¾Ý*/
begin
declare @i int/*±êÖ¾µÝ¹é¼¶±ð*/
set @i=1
insert @t ......
SQLʱ¼ä¶Î²éѯ
ACCESSµÄ»°
select * from table where date1<#2008-1-20# and date2>#2007-8-30#
MYSQLµÄ»°
select * from table where date1<'2008-1-20' and date2>'2007-3-30'
Ò²¿ÉÒÔ
select * from table where date1 between '2008-1-20' and '2007-3-30'
ÆäÖÐdate1,date2¶¼ÊÇÈÕÆÚÀàÐ͵Ä× ......
/*
¸ù¾Ýºº×Ö»ñȡȫƴ
1.Éú³ÉËùÓжÁÒôÁÙʱ±í
2.¸ù¾ÝChinese_PRC_CS_AS_KS_WS ÅÅÐò»ñÈ¡¶ÁÒô
*/
Create function ChineseSpell(@str varchar(100))
returns varchar(8000)
as
begin
declare @re varchar(8000)
--Éú³ÉÁÙʱ±í
declare @t table(chr nchar(1) collate Chinese_PRC_CS_AS_KS_WS,py nvarchar(20))
ins ......
Ò»¡¢¼òµ¥ÊµÓõı¸·Ý·½·¨£º
ÆóÒµ¹ÜÀíÆ÷ÖеÄTools£¬Database Maintenance Planner£¬¿ÉÒÔÉèÖÃÊý¾Ý¿âµÄ¶¨ÆÚ×Ô¶¯±¸·Ý¼Æ»®¡£²¢Í¨¹ýÆô¶¯Sql server AgentÀ´×Ô¶¯ÔËÐб¸·Ý¼Æ»®¡£¾ßÌå²½ÖèÈçÏÂ:
1¡¢´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÔÚ¿ØÖÆÌ¨¸ùĿ¼ÖÐÒÀ´Îµã¿ªMicrosoft SQL Server-->SQL Server×é-->Ë«»÷´ò¿ªÄãµÄ·þÎñÆ÷
2¡¢È»ºóµãÉÏÃæ²Ëµ¥ÖÐ ......
--×÷ÓãºÊý¾Ý¿âÖÐµÄ±í±¸·Ý³ÉÎı¾
Declare @tabname varchar(200),@ip varchar(50),@user varchar(50),@password varchar(50),@sql varchar(1000),@filetxt varchar(200),@file varchar(50)
set @tabname='database.dbo.tb' --±íÃû
set @ip='127.0.0.1' --IPµØÖ·£¬±¾»úµÄ»°¾Íд127.0.0.1
set @user='sa' ......