SQL Server 2005 with VB.net 2005

[Erland Sommarskog]

Re: SQL Server 2005 with VB.net 2005

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@sommarsk og.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

[Omar Abid]

Re: SQL Server 2005 with VB.net 2005

On 12 juin, 23:10, Erland Sommarskog <esq...@sommars kog.sewrote:

Omar Abid (omar.abid2...@ 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, esq...@sommarsk og.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.c om/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.c om/sql/prodinfo/previousversion s/books.mspx

Thank you for your advice, it was really helpful to me
Omar Abid