Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hockeyman9474
Starting Member
11 Posts |
 Posted - 2014-06-09 : 09:45:08
|
| I am writing code that includes a concatenation. SQL keeps changing concat( into fn{concat(. This limits my arguments to two and I have more tan two arguments. How can I add this to my view and not have it chnage to fn{ |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2014-06-09 : 10:22:51
|
quote:
Originally posted by hockeyman9474
I am writing code that includes a concatenation. SQL keeps changing concat( into fn{concat(. This limits my arguments to two and I have more tan two arguments. How can I add this to my view and not have it chnage to fn{
I don't think it is SQL Server that is causing it - there is something else at play. I can run this test successfully without any issues. create view myTestViewasselect concat ('a','b','c','d') as concatColumn;GOselect * from myTestView; |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2014-06-09 : 11:32:42
|
Which query editor are you using?`
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
|
|
|
|
|
|
fn{