What have I done?
- use AdventureWorks; // this connect my query window the database I wish to use.
- Type select * from + [Ctrl+ space bar]. My table that resides in the AdventureWorks db doesn't exist in the drop-down list (as shown below, the list doesn't show tblApplication).
What are the work-arounds?
1. Use full schema in select definition:
Type select * from AdventureWorks.dbo.tblApplication
2.Work-around I found by accident.
Leave the use

No comments:
Post a Comment