12-02-02, 17:40 #1Registered User
- Join Date
- Nov 2002
Unanswered: convert some Oracle scripts to SQL server
While trying to convert some Oracle scripts to SQL server,i got some problems:
In sql server, when using outer join, both terms must contain columns. But in my script, some of them have constant in it
Like in my oracle script ACTL_1.M_ACTL_N_ACTORTYPE(+)=1
can anyone tell me how to do this please.