menu
Logo
  • Why azing?
  • Blog
  • Help
ENarrow_drop_down
  • DE
  • EN
Suche in Checklisten
search
azing Logo ENarrow_drop_down
  • DE
  • EN
  • Why azing?
  • Help
2sxc
drive_folder_upload
  • homeChecklist Templates
  • south

folder_sharedPro: Data Management

  • homeChecklist Templates
  • south

folder_sharedPro: Data Management

Folders and checklists

  • check_circleItem - Copy
  • check_circleReplace all values in a 2sxc installation
  • insert_drive_fileSQL Script: Replace all values in 2sxc

Parts (0) expand_more

These are small document-parts which are used in other documents. They are not a starting point for any real activity. Because of this, they will be listed further down and the search will not list them unless requested. 

-- Use the following SQL to replace content in all 2sxc values
DECLARE @oldvalue NVARCHAR(MAX)
SET @oldvalue = 'Old value';
DECLARE @newvalue NVARCHAR(MAX)
SET @newvalue = 'New value'

-- Preview results
SELECT [Value] AS Original, REPLACE([Value], @oldvalue, @newvalue) as Replaced
FROM ToSIC_EAV_Values
WHERE [Value] LIKE N'%' + @oldvalue + '%' AND
ChangeLogDeleted IS NULL

-- Execute replace
--EXEC ToSIC_EAV_ChangeLogAdd @User = "Manual-Database-Replace"
--UPDATE ToSIC_EAV_Values
--SET [Value] = REPLACE([Value], @oldvalue, @newvalue)
--WHERE ([Value] LIKE N'%' + @oldvalue + '%') AND
--ChangeLogDeleted IS NULL
Logo
Legal | Content Copyright CC-BY 4.0
bug_reportReport Bug
  • info
  • Links
  • Permissions
code Share
code
URL copied to clipboard.
Embed Checklist close
Copy Copy
Content Copyright

CC-BY 4.0

Translations

None

2sxc - Content Management for DNN & Oqtane Logo

2sxc - Content Management for DNN & Oqtane

QR-Code
azing.org/2sxc/r/x-4PqOdT
View & Use

Public (can be used by everybody)

Edit & Admin

Default (all members can edit)

This catalog has a simple permission model, where all members have the same permissions. For advanced permissions, upgrade to Enterprise.

Here you can see how this document is used and linked by other documents

Used in (1)

Others referencing this

  1. Replace all values in a 2sxc installation
Uses these (0)

Documents linked from this document

How it Behaves

How this document is categorized changes how it behaves.

This is a main document, it is listed normally and appears in search result.

Type

This is a Template (Boilerplate). It's used for text snippets to copy/paste.

Get something to say?

Comment to start a discussion or make a note
send

please log on to chat

close

Durchsuche ganz Azing