Timeline for Can view adapt to implicitly reference user's default schema?
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 25, 2013 at 15:03 | comment | added | Aaron Bertrand |
Yes, there are syntax errors and also why on earth would you ever specify varchar/nvarchar without a length? Do you know how many characters those strings will be truncated to?
|
|
| Apr 25, 2013 at 10:10 | history | edited | András Váczi | CC BY-SA 3.0 |
added 2 characters in body
|
| Apr 25, 2013 at 10:10 | comment | added | András Váczi | Paddy, please explain why would this work. Thanks! | |
| Apr 25, 2013 at 8:48 | comment | added | Ryan Edgar | I don't think even that hack would work. I don't want to have to specify the user - I want the user's default schema to be automatically used for whichever objects are contained in the view. If I don't specify the schema, this works perfectly in a bog-standard query. Put that query into a view however and it no longer functions with that behaviour. | |
| Apr 25, 2013 at 7:28 | review | Low quality posts | |||
| Apr 25, 2013 at 10:10 | |||||
| Apr 25, 2013 at 7:09 | history | answered | Paddy Carroll | CC BY-SA 3.0 |