Posted by Erland Sommarskog on 06/12/07 21:10

Omar Abid (omar.abid2006@gmail.com) writes:
> Thank you the problem was solved, and I used mid to get the table
> name, because the output was "[DBO].[table]"

You could modify the query if you don't want the schema.

Then again, in SQL 2005, it may be dangerous to ignore the schema, since
SQL 2005 makes schemas useful, and it can be deceivable to work with.
The AdventureWorks database is a good example of this.




--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Remove the last carriage return and line feed from sql text field
• Prev in forum: Re: UPDATETEXT, WRITETEXT
• Thread view: Re: SQL Server 2005 with VB.net 2005

[Reply to this message]