Is there any differnce between open view and select * from view ?
Oct 02, 2012 at 01:49 PM
Oct 02, 2012 at 02:49 PM
There is no T-SQL syntax support for OPEN VIEW. You can use the SQL Server Management Studio to issue a command that is running "SELECT * FROM view" in the background.
Oct 02, 2012 at 04:31 PM
Grant Fritchey ♦♦
Thanks a lot Grant.The reason I asked this question is I am trying to copy information from a column and paste it in a tool called 7edit(tool for reading hl7 messages). If I copy date from a physical table or a view the 7edit tool wont parse the string.But If I copy information from open view command then 7edit dosent give any problem. So, I was a bit curious.
Sounds like the difference in output. You can try varying the results from a query too. There's a button at the top that will change the output to text instead of a grid. Experiment a little.
Differnce in output may be the issue. I tried output to text to but only if i copy from an open view then it works..sql server is sometimes funny..
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Oct 02, 2012 at 01:49 PM
Seen: 715 times
Last Updated: Oct 10, 2012 at 10:58 AM
Restore database losing views
how to get the value used in SP or Views or Functions or SQL Jobs?
Backing up data between SQL Express 2005 and SQL Server 2008 Standard Edition
Page Granularity Locking
How to import bulk .log files and add a column to the table
how to write subquery in the insert sql server 2005
Full Text Search FreeTextTable Predicate Search Problem
creating a cumulative counter with a cursor
Is this query invalid?
Adding entry to autonumber field thats been deleted