Recent content by HamletDRC

I was able to get an answer to this from a different source. It is not possible to do what I am trying to do. The MS-SQL function calling interface always requires you to call a function using the owner.function format. So there is no way to make a function that can be called as nvl(), it...

The function works, except I still have to prefix my call with dbo. Since my goal is to not have to do search and replace, do you know if it is even possibly to create a function that doesn't need to be called with the owner specified?

Sorry, I hit send too soon. There is a SQL DBA specific course. You might parley that into the full cert. by taking the next 3 tests too. And I'm not dissuading you from an MCP. I have one. But I can say, as someone that does make hiring decisions, that I would rather see experience.

You can read about all the tests at the MCP website http://www.microsoft.com/learning/mcp/default.asp I would suggest the test about how to be an MS-SQL DBA. Remember, the MCP just proves that you memorized enough to pass the exam. Employers would rather see some relevant school/volunteer...

I routinely have to take Oracle SQL statements and run them against a SQL server database, and I find myself always doing search and replace to convert nvl() fuctions to isnull() functions. I want to write a MS-SQL function that will translate and nvl() occurances in a SQL statement into...