ACCESSÊý¾Ý¿âµ½SQLÊý¾Ý¿â
´ÓAccessÊý¾Ý¿âµ¼Èëµ½SQL
·½·¨Ò»:
ÔÚMSsqlÖÐÒª¼òÀúODBC..·½·¨±È½Ï±¿µã..
·½·¨¶þ:
Ö±½Ó´ÓAccessÉýǨµ½MSsql..
ÒòΪAccessÊý¾Ý¿âÓÐÉèÖÃÃÜÂë..»¹Õæ²»ºÃ¸ã..¸ãÁ˺ü¸´Î¶¼Ê§°ÜÁË..
ÀûÓ÷½·¨¶þ..Ò»´Î³É¹¦..
ÓÃÊý¾Ý¿âÉýǨ...¼òµ¥...
½¨ÒéʹÓõڶþÖÖ·½·¨µ¼ÈëACCESSÊý¾Ý¿âµ½MSSQLÊý¾Ý¿âÖÐ..Ê¡ÊÂ!!!
Ïà¹ØÎĵµ£º
'´´½¨Êý¾Ý¿â
Private Sub Create(ByVal mdbPath As String)
If File.Exists(mdbPath) Then
Throw New Exception("Ä¿±êÊý¾Ý¿âÒѾ´æÔÚ£¬ÎÞ·¨´´½¨")
......
SQLÖеÄREPLACEÌæ»»×Ö·ûº¯ÊýµÄÓ÷¨£¨Ê¹Ö®Ö§³Ötext/ntext£©
Óï·¨
REPLACE ( original-string, search-string, replace-string )
²ÎÊý
Èç¹ûÓÐij¸ö²ÎÊýΪ NULL£¬´Ëº¯Êý·µ»Ø NULL¡£
original-string ±»ËÑË÷µÄ×Ö·û´®¡£¿ÉΪÈÎÒⳤ¶È¡£
search-string ÒªËÑË÷²¢±» repl ......
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 ......
UNION ÔËËã·û½«¶à¸ö SELECT Óï¾äµÄ½á¹û×éºÏ³ÉÒ»¸ö½á¹û¼¯¡£ £¨£±£©Ê¹Óà UNION ÐëÂú×ãÒÔÏÂÌõ¼þ£º £Á£ºËùÓвéѯÖбØÐë¾ßÓÐÏàͬµÄ½á¹¹£¨¼´²éѯÖеĵÄÁÐÊýºÍÁеÄ˳Ðò±ØÐëÏàͬ£©¡£ £Â£º¶ÔÓ¦ÁеÄÊý¾ÝÀàÐÍ¿ÉÒÔ²»Í¬µ«ÊDZØÐë¼æÈÝ£¨ËùνµÄ¼æÈÝÊÇÖ¸Á½ÖÖÀàÐÍÖ®¼ä¿ÉÒÔ½øÐÐÒþʽת»»£¬²»ÄܽøÐÐÒþʽת»»Ôò±¨´í£©¡£Ò²¿ÉÒÔÓÃÏÔʽת»»ÎªÏàͬµ ......