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: 716 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?
Query does not give exact results
Sql server redundancy
login failure alert in sqlserver log
Is there any locked file is created internally while rebuild index running?
How is user variable added to Oracle sql expression used in SSIS variable
Not able to shrink the logfile?
Word count in a column
How to Exporting to a text file from Reporting Services 2005?