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.
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.