작성일 : 11-11-04 14:00
|
[MsSQL] openquery 오픈쿼리 기본 조작방법 [mssql - oracle]
|
 |
|
글쓴이 :
Mr가망생
 조회 : 5,418
|
select * from
openquery(CREDU, 'select * from aaa')
where bbb = '391170'
update openquery(CREDU, 'select * from aaa')
set bbb = 387624
where ccc = 393852
DELETE openquery(CREDU, 'select * from aaa')
WHERE aaa = '111'
select @credu_seq_max3 = max(convert(int,bbb)) from
openquery(CREDU, 'select bbb from aaa')
/*
다음과같이 하면 맥스값이 잡히지 않음, 헐.. (컨버전 해줘야함)
select max(bbb) from
openquery(CREDU, 'select bbb from aaa')
*/
|
|
1354
