SQL troubles with LOWER

Question

我有一个问题在SQL中使用LOWER与我的SQL Server 2008r2我认为我对使用LOWER有误解，我总是得到相同的错误语法不正确'，'，

INSERT INTO [ch-s-0008180].HolidayTracker.dbo.HtUser(FirstName,LastName,Email,UserName,AdAccount,AdDomain)
SELECT u1.firstName,u1.lastName,u1.email,'CH'+(LOWER(LEFT(u1.firstName,2))+(LOWER(LEFT(u1.lastName,3)),'EUROPE'+(LOWER(LEFT(u1.firstName,2))+(LOWER(LEFT(u1.lastName,3)),''
FROM HolidayTracker.dbo.HTUser u1
    LEFT JOIN HolidayTracker.dbo.HtUser u2 ON u1.firstName = u2.FirstName AND u1.lastName = u2.LastName AND u1.email = u2.Email

感谢您的帮助和快速回答

Answer 1

在LOWER之前有额外的(。下面是修改后的查询:

INSERT  INTO [ch-s-0008180].HolidayTracker.dbo.HtUser(FirstName,LastName,Email,UserName,AdAccount,AdDomain)
SELECT  u1.firstName, 
        u1.lastName, 
        u1.email, 
        'CH' + LOWER(LEFT(u1.firstName,2)) + LOWER(LEFT(u1.lastName,3)), 
        'EUROPE' + LOWER(LEFT(u1.firstName,2)) + LOWER(LEFT(u1.lastName,3)),
        ''
FROM    HolidayTracker.dbo.HTUser u1
        LEFT JOIN HolidayTracker.dbo.HtUser u2 
            ON  u1.firstName = u2.FirstName AND 
                u1.lastName = u2.LastName AND 
                u1.email = u2.Email

代码的颜色混乱。EUROPE中的不逃逸'

Answer 2

没有正确关闭括号。

'CH'+(LOWER ...,'' FROM