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?
Programmatically remove schemabinding
the replace function with nvarchar(max) strings
SQLSetting up nightly script
Disabling a SQL Job
Monitoring identity columns
SQl Database in 2005
End of support for Sql Server 2005
SQL Server Agent 2005 and SSIS