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

MSSQLÈ«ÎļìË÷

MSSQLÈ«ÎļìË÷ --1.´ò¿ªÊý¾Ý¿â
use pubs
go
--2.´ò¿ªÈ«ÎÄË÷ÒýÖ§³Ö
--execute sp_fulltext_database 'enable'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 0 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--3.½¨Á¢È«ÎÄĿ¼ft_test
--execute sp_fulltext_catalog 'ft_test','create'
/*
ÃüÁîÒѳɹ¦Íê³É¡£
*/
--4.Ϊtitles±í½¨Á¢È«ÎÄË÷ÒýÊý¾ÝÔª£¬UPKCL_titleidindΪtitles±íÖÐÓÉÖ÷¼üËù½¨Á¢µÄΨһË÷Òý£¬´Ë²ÎÊý±ØÐë¡£
--execute sp_fulltext_table 'titles','create','ft_test','UPKCL_titleidind'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--5.ÉèÖÃÈ«ÎÄË÷ÒýÁÐÃû
--execute sp_fulltext_column 'titles','title','add'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--execute sp_fulltext_column 'titles','notes','add'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--6.½¨Á¢È«ÎÄË÷Òý
--execute sp_fulltext_table 'titles','activate'
/*
ÃüÁîÒѳɹ¦Íê³É¡£
*/
--7.Ìî³äÈ«ÎÄË÷ÒýĿ¼
--execute sp_fulltext_catalog 'ft_test','start_full'
/*
£¨ËùÓ°ÏìµÄÐÐÊýΪ 0 ÐУ©
£¨ËùÓ°ÏìµÄÐÐÊýΪ 1 ÐУ©
*/
--8.ÖÁ´Ë£¬È«ÎÄË÷Òý½¨Á¢Íê±Ï¡£
 
1-6.
´ò¿ªpubsÊý¾Ý¿â£¬ÓÒ¼ütitles±í£¬Ñ¡Ôñ¡°È«ÎÄË÷Òý±í¡±£¬¡°ÔÚ±íÉ϶¨ÒåÈ«ÎÄË÷Òý¡±£¬ÎªÆä´´½¨È«ÎÄĿ¼¡£ÔÚ¡°È«ÎÄË÷ÒýÏòµ¼¡±ÖУ¬
Ñ¡ÔñÄãÐèҪȫÎIJéѯÌõ¼þµÄÁУ¨¿ÉÒÔÊÇÎı¾»òͼÏñ£©£¬ÎÒÃÇÑ¡ÔñtitleºÍnotesÁС£È»ºóÏÂÒ»²½£¬ÊäÈëÒ»¸öеÄĿ¼ft_test£¬µã»÷ÏÂÒ»²½¡£ÔÚÌî³äµ÷¶ÈÒ»ÏîÀÎÒÃÇÔÝʱ²»½¨Á¢Ìî³äµ÷¶È¡£½Ó×Å¡°ÏÂÒ»²½¡±£¬È«³ÉÈ«ÎÄË÷ÒýÏòµ¼¡£Íê³Éºó£¬ÎÒÃÇ¿


Ïà¹ØÎĵµ£º

MSSQL varbinaryת»»³É×Ö·û´®

--> Title  : varbinaryת»»³É×Ö·û´®
--> Author : wufeng4552
--> Date   : 2009-12-15
declare @s varchar(20),@bin varbinary(1000)
select @s='www.CSDN.net',@bin=cast(@s as varbinary(1000))
declare @re varchar(1000),@i int
select @re='',@i=datalength(@bin)
while @i>0
&n ......

AspNetPagerÓëMSSQLº£Á¿·ÖÒ³´æ´¢¹ý³Ì½áºÏ

´æ´¢¹ý³ÌPagination£º
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[Pagination]
@tblName varchar(255), -- ±íÃû
@PKName varchar(255), -- ×Ö¶ÎÃû
@strGotFields varchar(1000) = '*' , --²éѯ×Ö¶ÎÃû
@PageSize int = 10, -- Ò³³ß´ç
@PageIndex int = 1, -- Ò³Âë
@OrderType bi ......

mssqlµÇ¼ÃûºÍÿ¸öÊý¾Ý¿âµÄÓû§µÄÇø±ðÁªÏµ


ÈçͼËùʾ£¬ÔÚ°²È«ÐÔ-µÇ½Àï¿ÉÒÔ¿´µ½ÓÒ±ßÁбíÀïµÄÓû§£¬Ñ¡ÖÐÓû§ÓÒ¼ü-ÊôÐÔ¿ÉÒÔ¸ü¸ÄÓû§ÃÜÂ룬¼°Êý¾Ý¿â½ÇÉ«µÈ¡£
²é¿´Óû§Ãû£¬¼°ÃÜÂëÊÇ·ñÕýÈ·£¬¿ÉÒÔµ¥¶ÀµÇ½ ²éѯ·ÖÎöÆ÷
Èç¹ûÄܵǽ˵Ã÷ÉèÖÃÕýÈ·£¬ÔÚmssql´î½¨µÄasp cmsÀï¾­³£ÒªÓõ½Óû§Ãû£¬ÃÜÂë¡£
ÏÖÔÚ¿´Ã¿¸öÊý¾ÝÏÂÃæµÄÓû§Ñ¡ÏÈçͼ
Ñ¡ÖÐÒ»¸öÒ»¸öÊý¾Ý¿â£¬»òÏÂÃæµÄÓû§Ñ ......

ASP.netÒ³ÃæʵÏÖMSSQLÊý¾Ý¿âµÄ´´½¨ºÍ²Ù×÷£¬ÊÇ¿â´´½¨£¡

///   <summary>  
        ///   ´´½¨Êý¾Ý¿â¡£  
        ///   </summary>
        ///   <param name="srvName">±íÊ ......

MSSQLд·¨¾«Á¶

1¡¢SQL2000ÖÐÒ»±íÓÐÒ»ÈÕÆÚÐÍ×Ö¶ÎBirthDay£¬¼Ç¼³öÉúÈÕÆÚ£¬ÏëÿÄêÔÚ±¾ÈÕÉúÈÕÇ°15Ì죬½«Æä¹ýÂ˳öÀ´£¬ÔõôдWhereÌõ¼þ£¿£º
select out_date from sales_out_head_tab where (DATEDIFF(day,DATEADD(year ,year(getdate())-year(out_date) ,out_date )
 ,getdate())  BETWEEN -15 and 0 ) order by out_date ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ