ERROR QUERY

[THEXxmateo]

Hello, someone help me, Run this query and I get this error

 Spoiler

--Adding light tags
UPDATE PS_GameData.dbo.Chars
SET PS_GameData.dbo.Chars.CharName = CONCAT('L-*', PS_GameData.dbo.Chars.CharName)
FROM PS_GameData.dbo.Chars
INNER JOIN PS_GameData.dbo.UserMaxGrow
ON (PS_GameData.dbo.UserMaxGrow.UserUID = PS_GameData.dbo.Chars.UserUID)
WHERE PS_GameData.dbo.UserMaxGrow.Country=0;

--Adding fury tags
UPDATE PS_GameData.dbo.Chars
SET PS_GameData.dbo.Chars.CharName = CONCAT('D-*', PS_GameData.dbo.Chars.CharName)
FROM PS_GameData.dbo.Chars
INNER JOIN PS_GameData.dbo.UserMaxGrow
ON (PS_GameData.dbo.UserMaxGrow.UserUID = PS_GameData.dbo.Chars.UserUID)
WHERE PS_GameData.dbo.UserMaxGrow.Country=1;

--Adding light guild tags--
UPDATE PS_GameData.dbo.Guilds
SET PS_GameData.dbo.Guilds.GuildName = CONCAT('L-*', PS_GameData.dbo.Guilds.GuildName)
WHERE PS_GameData.dbo.Guilds.Country = 0;

--Adding fury guild tags
UPDATE PS_GameData.dbo.Guilds
SET PS_GameData.dbo.Guilds.GuildName = CONCAT('D-*', PS_GameData.dbo.Guilds.GuildName)
WHERE PS_GameData.dbo.Guilds.Country = 1;

ERROR
Msg 195, Level 15, State 10, Line 3
'CONCAT' is not a recognized built-in function name.
Msg 195, Level 15, State 10, Line 11
'CONCAT' is not a recognized built-in function name.
Msg 195, Level 15, State 10, Line 19
'CONCAT' is not a recognized built-in function name.
Msg 195, Level 15, State 10, Line 24
'CONCAT' is not a recognized built-in function name.

Help Please

[wallerus]

From what I can tell, CONCAT is used when you want to join one string with another, which is ok for what you want to do but you are probably better off using the + operator instead, it's simpler. Although not actually present in the script that would most efficiently get the job done.

-- Character Tags.
USE PS_GameData
UPDATE Chars
SET CharName =
	CASE
	WHEN Family IN (0,1) THEN 'L-*'
	WHEN Family IN (2,3) THEN 'F-*' 
END + CharName

-- Guild Tags.
USE PS_GameData
UPDATE Guilds
SET GuildName =
	CASE
	WHEN Country = 0 THEN 'L-*'
	WHEN Country = 1 THEN 'D-*'
END + GuildName

Credits to Nubness for teaching me more about CASE statements.

[sominus]

'CONCAT' is not a recognized built-in function name.

The CONCAT function requires SQL Server 2012

removed...

[THEXxmateo]

Originally Posted by sominus

'CONCAT' is not a recognized built-in function name.

The CONCAT function requires SQL Server 2012

removed...

Originally Posted by wallerus

From what I can tell, CONCAT is used when you want to join one string with another, which is ok for what you want to do but you are probably better off using the + operator instead, it's simpler. Although not actually present in the script that would most efficiently get the job done.

-- Character Tags.
USE PS_GameData
UPDATE Chars
SET CharName =
	CASE
	WHEN Family IN (0,1) THEN 'L-*'
	WHEN Family IN (2,3) THEN 'F-*' 
END + CharName

-- Guild Tags.
USE PS_GameData
UPDATE Guilds
SET GuildName =
	CASE
	WHEN Country = 0 THEN 'L-*'
	WHEN Country = 1 THEN 'D-*'
END + GuildName

Credits to Nubness for teaching me more about CASE statements.

Thank you so much guys!

---

It lacks the UserMaxGrow the script

sorry for my English

[wallerus]

Do you mean this?

INNER JOIN PS_GameData.dbo.UserMaxGrow
ON (PS_GameData.dbo.UserMaxGrow.UserUID = PS_GameData.dbo.Chars.UserUID)
WHERE PS_GameData.dbo.UserMaxGrow.Country=1;

If that's what you mean that it is totally unnecessary. This part of the script completely replaces that.

	CASE
	WHEN Family IN (0,1) THEN 'L-*'
	WHEN Family IN (2,3) THEN 'F-*'

Family IN (0,1) -- (Human,Elf)
Family IN (2,3) -- (Deatheater, Vile)

[THEXxmateo]

Originally Posted by wallerus

Do you mean this?

INNER JOIN PS_GameData.dbo.UserMaxGrow
ON (PS_GameData.dbo.UserMaxGrow.UserUID = PS_GameData.dbo.Chars.UserUID)
WHERE PS_GameData.dbo.UserMaxGrow.Country=1;

If that's what you mean that it is totally unnecessary. This part of the script completely replaces that.

	CASE
	WHEN Family IN (0,1) THEN 'L-*'
	WHEN Family IN (2,3) THEN 'F-*'

Family IN (0,1) -- (Human,Elf)
Family IN (2,3) -- (Deatheater, Vile)

Ahh I understand Thanks!

[MC Flip]

Since adding tags is not something you do every day (or at least shouldn't do if you're running a serious server), you can always go the a bit more complex, but still simple, way of achieving this. Simpler than figuring out why pre-made querries don't work for you.

If you want to tag specific characters (eg. GameSages), use this:

SELECT * FROM PS_GameData.dbo.Chars
WHERE CharName='INSERTCHARNAMEHERE'

This will display you all the characters data in the Chars.dbo, but you will not be able to simply edit the results (you can, with a more advanced querry).
Simply open the Chars.dbo and look for the character you want to edit, based on the CharID or UserID, whichever is easier for you.