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

DBF±íÓëSQL Server±íµÄµ¼Èë¡¢µ¼³ö

 ----------Dbf µ¼Èë Sql Server±í----------
ÒÔϾùÒÔSQL2000¡¢VFP6¼°ÒÔÉϵıíΪÀý
´úÂëµ¼È룺²éѯ·ÖÎöÆ÷ÖÐÖ´ÐÐÈçÏÂÓï¾ä(ÏÈÑ¡Ôñ¶ÔÓ¦µÄÊý¾Ý¿â)
-------------Èç¹û½ÓÊܵ¼ÈëÊý¾ÝµÄSQL±íÒÑ´æÔÚ
--Èç¹û½ÓÊܵ¼ÈëÊý¾ÝµÄSQL±íÒѾ­´æÔÚ
Insert Into ÒѾ­´æÔÚµÄSQL±íÃû Select * from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:','select * from aa.DBF')
--Ò²¿ÉÒÔ¶ÔÓ¦ÁÐÃû½øÐе¼È룬È磺
Insert Into ÒѾ­´æÔÚµÄSQL±íÃû (ÁÐÃû1,ÁÐÃû2...) Select (¶ÔÓ¦ÁÐÃû1,¶ÔÓ¦ÁÐÃû2...) from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:','select * from aa.DBF')
-------------Èç¹û½ÓÊܵ¼ÈëÊý¾ÝµÄSQL±í²»´æÔÚ£¬µ¼Èëʱ´´½¨
--·½·¨Ò»£ºÓÐÒ»¸öȱµã£º°ÑDBF±íµ¼ÈëSQL ServerÖкó£¬ÂíÉÏÓÃVISUAL FOXPRO´ò¿ªDBF±í£¬»áÌáʾ“²»ÄÜ´æÈ¡Îļþ”£¬¼´Õâ¸ö±í»¹±»SQL´ò¿ª×ÅÄØ¡£¿ÉÊǹýÁË1·ÖÖÓ×óÓÒ£¬ÔÙ´ò¿ªDBF±í¾Í¿ÉÒÔÁË£¬ËµÃ÷¾­¹ýÒ»¶Îʱ¼äºó²éѯ·ÖÎöÆ÷²Å°ÑÕâ¸ö±í¹Ø±Õ¡£
Select * Into ÒªÉú³ÉµÄSQL±íÃû from openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=c:','select * from dbf±íÃû.DBF')
--·½·¨¶þ£ºÓÐÒ»¸öȱµã£º°ÑDBF±íµ¼ÈëSQL ServerÖкó£¬ÂíÉÏÓÃVISUAL FOXPRO´ò¿ªDBF±í£¬»áÌáʾ“²»ÄÜ´æÈ¡Îļþ”£¬¼´Õâ¸ö±í»¹±»SQL´ò¿ª×ÅÄØ¡£¿ÉÊǹýÁË1·ÖÖÓ×óÓÒ£¬ÔÙ´ò¿ªDBF±í¾Í¿ÉÒÔÁË£¬ËµÃ÷¾­¹ýÒ»¶Îʱ¼äºó²éѯ·ÖÎöÆ÷²Å°ÑÕâ¸ö±í¹Ø±Õ¡£
Select * Into TEMP1 from openrowset('VFPOLEDB.1','C:';'admin';'' ,'select * from dbf±íÃû.DBF')
--Èç¹ûûÓа²×°VFP£¬ÐèÒª°Ñvfpoledb.dll¿½±´µ½SYSTEMĿ¼Ï£¬²¢×¢²á¡£
--·½·¨Èý£ºµ¼ÈëSQL SERVERºó£¬Ô´±íÔÙÓÃVFP´ò¿ª¾Í²»Ìáʾ“²»ÄÜ´æÈ¡Îļþ”£¬ËµÃ÷Óï¾äÖ´Ðкó¾Í°ÑÔ´±í¹Ø±ÕÁË¡£²»¹ýÒ²Óв»¾¡ÈËÒâµÄµØ·½£¬¾ÍÊÇÓÃǰÁ½ÖÖ·½Ê½µ¼Èëºó£¬Ô´±íÖеÄ×Ö·ûÐÍ×ֶε¼ÈëºóSQL±í×ֶζÔÓ¦±ä³ÉNVARCHARÁË¡£
Select * Into ÒªÉú³ÉµÄSQL±íÃû from OPENROWSET('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;DATABASE=c:','select * from dbf±íÃû.dbf')
--·½·¨ËÄ£ºµ¼ÈëSQL SERVERºó£¬Ô´±íÔÙÓÃVFP´ò¿ª¾Í²»Ìáʾ“²»ÄÜ´æÈ¡Îļþ”£¬ËµÃ÷Óï¾äÖ´Ðкó¾Í°ÑÔ´±í¹Ø±ÕÁË¡£²»¹ýÒ²Óв»¾¡ÈËÒâµÄµØ·½£¬¾ÍÊÇÓÃǰÁ½ÖÖ·½Ê½µ¼Èëºó£¬Ô´±íÖеÄ×Ö·ûÐÍ×ֶε¼ÈëºóSQL±í×ֶζÔÓ¦±ä³ÉNVARCHARÁË¡£
Select * I


Ïà¹ØÎĵµ£º

SQL server 2005°²×°ÎÊÌâ»ã×Ü

 SQL2005 ·ÖÎå¸ö°æ±¾£¬ÈçÏÂËùÁУ¬
¡¡¡¡1.Enterprise(ÆóÒµ°æ),
      2.Development(¿ª·¢°æ),
¡¡¡¡3.Workgroup,(¹¤×÷Ⱥ°æ)
¡¡¡¡4.Standard,(±ê×¼°æ)
¡¡¡¡5.Express.(àÅ£¬¹ÀÇҾͽÐËü¼òÒ×°æ°É)
¡¡¡¡Õ⼸¸ö°æ±¾£¬ÎÒÃǾ¿¾¹Ó¦¸ÃʹÓÃÄÄÒ»°æÄØ﹖
¡¡¡¡ÕâÊÇÐí¶à³õѧSQL2005µÄÈË×î³£ÎʵÄÎ ......

SQLÖеÄREPLACEÌæ»»×Ö·ûº¯Êý


SQLÖеÄREPLACEÌæ»»×Ö·ûº¯ÊýµÄÓ÷¨£¨Ê¹Ö®Ö§³Ötext/ntext£©
Óï·¨
REPLACE ( original-string, search-string, replace-string )
²ÎÊý
Èç¹ûÓÐij¸ö²ÎÊýΪ NULL£¬´Ëº¯Êý·µ»Ø NULL¡£
original-string     ±»ËÑË÷µÄ×Ö·û´®¡£¿ÉΪÈÎÒⳤ¶È¡£
search-string     ÒªËÑË÷²¢±» repl ......

SQL Server 2005ÖеÄÎļþºÍÎļþ×é

 Author : wufeng4552                           Date   : 2009-10-23
1¡¢ÎļþºÍÎļþ×éµÄº¬ÒåÓë¹ØÏµ
    ÿ¸öÊý¾Ý¿âÓÐÒ»¸öÖ÷Êý¾ÝÎļþ.ºÍÈô¸É¸ö´ÓÎÄ ......

sql server2000ÖÐÔõô¶Ô´æ´¢¹ý³Ì½øÐмÓÃܺͽâÃÜ

 1. >>¼ÓÃÜ
from the Books Online:
Use the WITH ENCRYPTION option:
IF EXISTS (SELECT name from sysobjects
WHERE name = 'encrypt_this' AND type = 'P')
DROP PROCEDURE encrypt_this
GO
USE pubs
GO
CREATE PROCEDURE encrypt_this
WITH ENCRYPTION
AS
SELECT *
from authors
GO
EXEC sp ......

SQL Server CLRÈ«¹¦ÂÔÖ®Èý

±¾½ÚÖ÷Òª½éÉÜʹÓÃCLR´´½¨±êÁ¿º¯Êý£¬±íÖµº¯ÊýºÍ¾ÛºÏº¯Êý¡£
Ëùν±êÁ¿º¯ÊýÖ¸µÄ¾ÍÊǴ˺¯ÊýÖ»·µ»ØÒ»¸öÖµ¡£±íÖµº¯Êý·µ»ØÖµÊÇÒ»¸ö±í¡£¾ÛºÏº¯ÊýÊÇÔÚselectÓï¾äÖÐʹÓõģ¬ÓÃÀ´¾ÛºÏÒ»¸ö½á¹û¼¯£¬ÀàËÆÓÚSum()»òÊÇCount()µÈÄÚÖõĺ¯Êý£¬¶øÇÒÕæÕýµÄ×Ô¶¨Òå¾ÛºÏº¯ÊýĿǰֻÄÜÓÃCLRÀ´ÊµÏÖ¡£
ÏÂÃæµÄÀý×ÓʹÓÃÁËSQLServer×Ô´øµÄpubsÊý¾Ý¿â¡£
1 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ