MSSQL

[tgparkk]

암호화 UPDATE T_MEMBER SET F_PHONE_TEMP = EncryptByPassPhrase('MD4',F_PHONE)

복호화 Select F_PHONE, F_PHONE_TEMP, Convert(varchar(Max),DecryptByPassPhrase('MD4',F_PHONE_TEMP)) from T_MEMBER

[tgparkk]

mssql openquery example

INSERT INTO OPENQUERY (mysql, 'SELECT seqno, value FROM mysql_test') VALUES ('5','openquery');

UPDATE OPENQUERY (mysql, 'SELECT seqno, value FROM mysql_test WHERE value = "database"') ​ SET seqno = '6';

DELETE OPENQUERY (mysql, 'SELECT seqno, value FROM mysql_test WHERE seqno > 4');

SELECT seqno, value FROM OPENQUERY (mysql, 'SELECT seqno, value FROM mysql_test');