SQL Server/T-SQL Tutorial/String Functions/QUOTENAME
Версия от 16:46, 26 мая 2010; (обсуждение)
QUOTENAME function
<source lang="sql">
5> USE Northwind; 6> DECLARE @db AS NVARCHAR(258); 7> SET @db = QUOTENAME(N"pubs"); 8> EXEC(N"USE " + @db + N" SELECT DB_NAME();"); 9> 10> GO</source>
QUOTENAME takes a character string and turns it in to a valid SQL Server identifier, which can be used as a name for a SQL
<source lang="sql">
Server object, such as a table, column, etc.
7> SELECT QUOTENAME("[bad] table name") 8> GO
bad table name]
(1 rows affected)</source>