Database Reference
In-Depth Information
SET NOCOUNT ON;
SELECT Title, Name, Intro
FROM Users
GO
However, the following is valid:
CREATE PROCEDURE GetUsers
WITH RECOMPILE, EXECUTE AS CALLER
AS
SET NOCOUNT ON;
SELECT Title, Name, Intro
FROM Users
GO
The
CREATE
/
ALTER
table syntax for SQL Azure is a bit trickier, because there are several unsupported
options:
•
ON keyword {
partition_schema
|
filegroup
}
(such as
ON PRIMARY
)
TEXTIMAGE_ON
•
FILESTREAM_ON
•
<column_definition>
•
•
FILESTREAM
•
NOT FOR REPLICATION
•
ROWGUIDCOL
•
SPARSE
<data type>
•
•
CONTENT
•
DOCUMENT
xml_schema_collection
•
<column_constraint>
•
FILLFACTOR
•
ON
•
•
NOT FOR REPLICATION
•
<column_set_definition>
<table_constraint>
•
FILLFACTOR
•
ON
•