Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
blund
Starting Member
23 Posts |
 Posted - 2011-12-23 : 16:23:36
|
| I am creating a query in sql management studio (2008 r2), and want to copy the sql code to the clipboard and paste elsewhere. While in the query designer, the code states simply the column and table names (e.g. SELECT name FROM customer). Is there a "toggle" so that query shows the text in the "database.table.column" format? (e.g. SELECT db.customer.name FROM db.customer), so that I do not have to fill in the info?Thank you |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-23 : 23:13:47
|
| Nope thats not possible using standard editor. only way is to do a find and replace it yourself.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
show (db).(table) path in query