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.
| Author |
Topic |
|
deepakshaw123
Starting Member
1 Post |
 Posted - 2011-07-12 : 08:46:44
|
| Dear All,I am new for this forum many many time i got solution of my problem from here. so expect one serious one..i am creating one use defined function in SQL SERVER 2008, which is similar to CONCAT in oracle. I have one application which has the option to both database SQL SERVER and ORACLE. so i have to keep the query same. For CONCAT in oracle no issue, but same is not available in SQL SERVER. I have created with the name CONCAT in SQL SERVER. But in SQL SERVER i have to access that function with the OWNER [.dbo] which is not possible to ORACLE. so any how i have to keep the same.Could you please find some solution for me.. Its very urgent.......Thanks |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-07-12 : 08:50:19
|
| You have to refer to user-defined functions in SQL as [schema name].[function name]. There's no way around that.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
remove dbo prefix from UDF