Home Dashboard Directory Help
Search

Use Concat function in View Alter In Design View Will Cause "SQL Execution Error" by 亂馬客


Status: 

Closed


1
0
Sign in
to vote
Type: Bug
ID: 794216
Opened: 7/17/2013 2:01:42 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Hi,
I create a view in sql 2012, code is below,
create VIEW [dbo].[view2] AS
Select Concat( 1 , 2 , 3) AS c123
GO

The use SSMS open in Design View, will become

SELECT         { fn CONCAT(1, 2, 3) } AS c123
Details
Sign in to post a comment.
Posted by 亂馬客 on 8/6/2013 at 1:45 AM
Hi Sir,
Yes, Use T-SQL editor is good! Thanks.
Posted by Microsoft on 8/5/2013 at 3:51 PM
Hello 亂馬客.

The best workaround for this is to use the Concat function in the T-SQL editor, rather than in design view.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Microsoft on 7/26/2013 at 1:25 PM
Hello 亂馬客. (Not sure if those characters came out right. Apologies if they didn't.) Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
ConcatError.jpg 7/17/2013 96 KB