Update first 2 characters in SQL
How to Manually Restore a WordPress Website From a Backup
February 28, 2022How to Find a User’s Security Identifier (SID) in Windows
February 28, 2022DECLARE @ReplaceString CHAR(2) SET @ReplaceString = 'C:' UPDATE [DATABASENAME].[dbo].[TABLENAME] SET TABLENAME= REPLACE(TABLENAME, LEFT(TABLENAME, 2),@ReplaceString) WHERE LEFT(TABLENAME,2) = 'P:'
