|
Is there any differnce between open view and select * from view ?
(comments are locked)
|
|
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. 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.
Oct 05 '12 at 03:34 PM
neeehar
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.
Oct 06 '12 at 01:15 PM
Grant Fritchey ♦♦
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..
Oct 09 '12 at 04:02 PM
neeehar
(comments are locked)
|
