Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by Smorton
-
Does SQL Server 2000 support hierarchial queries?
Oracle has the connect by and start with commands. Does SQL Server 2000 have the ability to query tables with a hierarchial relationship like Oracle does? Thanks- Smorton
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
Is there an Equivalent of Oracle's SQLERRM in SQL Server 7?
Hi all, here is my dilema. I am converting an Oracle database into SQL Server 7. In Oracle, when I receive an error message I capture it by sticking it into a variable. Example: v_ErrorText := substr(sqlerrm, 1, 200); I stick that error text into a separate table called TERRORLOG which has the...- Smorton
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
