QUOTED_IDENTIFIER

스페이스가 포함된 오브젝트를 참조할 수 있게 해준다.

USE Northwind

SET QUOTED_IDENTIFIER ON

GO

IF OBJECT_ID('dbo.listorders') IS NOT NULL

DROP PROC dbo.listorders

GO

CREATE PROC dbo.listorders

AS

SELECT * FROM "Order Details"

GO

SET QUOTED_IDENTIFIER OFF

GO

EXEC dbo.listorders