PARSENAME
Declare @ObjectName nVarChar(1000)
Set @ObjectName = 'HeadOfficeSQL1.Northwind.dbo.Authors'
SELECT
PARSENAME(@ObjectName, 4) as Server
,PARSENAME(@ObjectName, 3) as DB
,PARSENAME(@ObjectName, 2) as Owner
,PARSENAME(@ObjectName, 1) as Object
返回:
伺服器 | DB |
---|---|
HeadofficeSQL1 |
北風 |
所有者 | 賓語 |
---|---|
DBO |
作者 |