SQL¼ÓÃÜÊý¾Ý
ÍõÑà½Ü
ÔÚÍøÂçÉÏ·¢ËÍÊý¾Ý¶¼»á·¢ÉúһЩÑÏÖØµÄ°²È«ÎÊÌâ£¬ÍøÂç×î´óµÄµ£ÓÇÔÚÓÚÓÐÈË¿ÉÒÔ²¶»ñÊý¾Ý£¬sqlserverÖ§³Ö²ÉÓÃÖ¤ÊéÀ´¼ÓÃÜ
1£®´´½¨Ö¤Êé
create master key encryption by
password = 'administrator123'
--ÓÃÃÜÂëadmini--
create certificate c1
encryption by password = 'administrator123'
with subject = 'c1 certificate',
start_date='03/08/2009',
expiry_date = '02/08/2020';
go
2£®´´½¨²âÊÔ±í£¬name×Ö¶ÎΪҪ¼ÓÃܵÄÁУ¬Êý¾ÝÀàÐÍΪvarbinary
×¢Ò⣺¼ÓÃܵÄÀàÐͱØÐëÊÇvarbinary£¬ÒòΪ¼ÓÃܵÄÊý¾ÝÊÇÀàÐÍvarbinary
create table testB(id int identity(1,1),name varbinary(5000))
3£®Ê¹ÓüÓÃܺ¯ÊýÏò²âÊÔ±íÖÐдÈëÒ»Ìõ²âÊÔÊý¾Ý
insert into testB(name)
select encryptbycert(cert_id('c1'),'test')
4£®ÀûÓÃÏÂÃæµÄÓï¾äÀ´ÌáÈ¡¼ÓÃÜÊý¾Ý
select * from testB
5.ÀûÓÃÒÔÏÂÓï¾äÀ´½âÃÜÊý¾Ý
select id ,cast(decryptbycert(cert_id('c1'),name ,
N'administrator123')as varchar(20)) from testB
Íê³ÉÁË
Ïà¹ØÎĵµ£º
Á·ÊÖ£¬Ã¿Ìì²é¿´±ðÈ˵Ķ«Î÷£¬²»Èç×Ô¼º×ܽáºÃ
1:replace º¯Êý
µÚÒ»¸ö²ÎÊýÄãµÄ×Ö·û´®£¬µÚ¶þ¸ö²ÎÊýÄãÏëÌæ»»µÄ²¿·Ö£¬µÚÈý¸ö²ÎÊýÄãÒªÌæ»»³Éʲô
select replace('lihan','a','b')
&nb ......
Ëø¶¨Êý¾Ý¿âµÄÒ»¸ö±í
SELECT * from table WITH (HOLDLOCK)
×¢Òâ: Ëø¶¨Êý¾Ý¿âµÄÒ»¸ö±íµÄÇø±ð
SELECT * from table WITH (HOLDLOCK)
ÆäËûÊÂÎñ¿ÉÒÔ¶ÁÈ¡±í£¬µ«²»ÄܸüÐÂɾ³ý
SELECT * from table WITH (TABLOCKX)
ÆäËûÊÂÎñ²»ÄܶÁÈ¡±í,¸üкÍɾ³ý
SELECT Óï¾äÖГ¼ÓËøÑ¡ÏŦÄÜ˵Ã÷
SQL ServerÌṩÁËÇ¿´ó¶øÍ ......
ÎÊÌâ: һ̨·þÎñÆ÷ÉÏÔËÐÐÁËSQL Server,SQL Server Agent,Distributed Transaction,CoordinatorÕâÈý¸ö·þÎñ£¬ÇëÎÊÕą̂·þÎñÆ÷ÊÇһ̨ʲôÑùµÄ·þÎñÆ÷£¿ÕâÈý¸ö·þÎñ¾ßÌåÓÐʲô×÷Óã¿
ÕâÊÇһ̨Êý¾Ý¿â·þÎñÆ÷.
SQL Server ÕâÊÇÖ÷Êý¾Ý¿â·þÎñ£¬¶øÇÒÐγÉÁËSQL ServerµÄÖ§Öù¡£ËüÓÃÓÚ´æ´¢ºÍÌáÈ¡Êý¾Ý¡£
SQL Server Agent Ò²½ÐSQL Server´ú ......
exec xp_cmdshell 'md E:\project'
--ÏÈÅжÏÊý¾Ý¿âÊÇ·ñ´æÔÚÈç¹û´æÔÚ¾Íɾ³ý
if exists(select * from sysdatabases where name='bbsDB')
drop database bbsDB
--´´½¨Êý¾Ý¿âÎļþ
create database bbsDB
--Ö÷Êý¾Ý¿âÎļþ
on primary
(
name='bbsDB_data',--ΪÖ÷ÒªÊý¾Ý¿âÎļþÃüÃû
filename='E:\proj ......
²Ù×÷Êý¾Ý¿â½á¹¹µÄ³£ÓÃSql
ÏÂÃæÊÇSql Server ºÍ Access ²Ù×÷Êý¾Ý¿â½á¹¹µÄ³£ÓÃSql£¬ÄÚÈÝÓɺ£ÍÞÕûÀí£¬²»ÕýÈ·Óë²»ÍêÕûÖ®´¦»¹ÇëÌá³ö£¬Ð»Ð»¡£
н¨±í£º
create table [±íÃû]
(
[×Ô¶¯±àºÅ×Ö¶Î] int IDENTITY (1,1) PRIMARY KEY ,
[×Ö¶Î1] nVarChar(50) default 'ĬÈÏÖµ' null ,
[×Ö¶Î2] ntext null ,
[×Ö¶Î3] dateti ......