Hi all,
In Oracle while selecting a date we can query in this way for example trunc(col name,dd/mm/yyyy) = trun(sysdate)
how do I do that in SQL Server I am using 2000.
Thanks in advance,
krishnaa.
Thanks mikeyb
I agree with you I am able to query the db table using sql analyzer, actually my problem is the link was made by some other person through attunity connecting driver using a profile we can querry as well as look into the db which is in vax vms system. I want to reverse engineer the...
Hi All,
I have a linked server, for which I need to do the schema reverse engineering into ms-visio to know the relationships
How do I do that, any help on this is highly appreciated.
Thanks in advance
krishna.
Hi All,
I have to reverse engineer a schema for which I do not have a direct access and it is linked to sql server as a linked server. I appreciate if any body help's me out in this.
thanks in advance,
krishna.
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.