What is your objective?
Are you trying to compare these databases because you want to make a decision on selecting the right database for a application?
or
Are you trying to compare these databases because you have experience with one database and you want to know how things are done in other...
Yes, of course there are tools like that in Sybase
1. Auditing
2. Monitor Server / Historical Server
you have to separately install either of these utilities.
If you just want to get sqltext for a single process, then you can even use dbcc sqltext()
Stephlal,
I don't think what you are trying to do can be done with a single query, create this following stored procedure after changing real table name, column names, column types , variable name and variable types:
drop procedure test1
go
create procedure test1
as
create table #temp1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.