REPLACE makes sense only if a table has aPRIMARY KEYorUNIQUEindex. Otherwise, it becomes equivalent to INSERT, because there is no index to be used to determine whether a new row duplicates another. 只有当表具有PRIMARY KEY或UNIQUE索引时,REPLACE才有意义。否则,它就相当于INSERT,因为没有索引可以用...
. We've got lots of great SQL Server experts to answer whatever question you can come up with. All Forums SQL Server 2012 Forums Transact-SQL (2012) REGEXP_REPLACE in TSQL