SQL Server中对数据截取替换的方法详解

CREATE DATABASE TESTGOUSE TESTGOCREATE TABLE TestTable(UserName VARCHAR(50),UserPwd VARCHAR(50))GOINSERT INTO TestTable (UserName,UserPwd) VALUES ('ASDFFFF','WWWEEE')INSERT INTO TestTable (UserName,UserPwd) VALUES ('ASDFFFF','WWWEEE')INSERT INTO TestTable (UserName,UserPwd) VALUES ('ASDFFFF','WWWEEE')INSERT INTO TestTable (UserName,UserPwd) VALUES ('ASDFFFF','WWWEEE')INSERT INTO TestTable (UserName,UserPwd) VALUES ('ASDFFFF','WWWEEE')