SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Other Forums
 Other Topics
 SAS Guide
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

deathrone
Starting Member

Poland
9 Posts

Posted - 08/20/2012 :  04:07:45  Show Profile  Reply with Quote
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

Edited by - deathrone on 08/20/2012 04:09:04

SwePeso
Patron Saint of Lost Yaks

Sweden
29138 Posts

Posted - 08/20/2012 :  05:18:39  Show Profile  Visit SwePeso's Homepage  Reply with Quote
In Microsoft SQL Server you can use

EXECUTE AS ...




N 56°04'39.26"
E 12°55'05.63"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000