Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 SAS Guide

Author  Topic 

deathrone
Starting Member

15 Posts

Posted - 2012-08-20 : 04:07:45
Hello little girls and wise boys.

Do ya know is there any possibility to make the sequence simplier in proc SQL? I mean how to connect our database instead of writin the same statements (in every query )like
"CONNECT to oracle as db (path='x' user='x' password='x');
select *
from connection to db ( "...

trololoolo

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-08-20 : 05:18:39
In Microsoft SQL Server you can use

EXECUTE AS ...




N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
   

- Advertisement -