/* @(#) generic/sproc/ins_syn_sql 84.3 7/21/93 */

use master
go

/*
** Create a procedure to print out error messages
*/
if exists (select name from sysobjects where name = "sybsyntax_printmsg")
begin
	drop procedure sybsyntax_printmsg
end
go

create procedure sybsyntax_printmsg
	@message_num	int
as
	declare @msg varchar(255)
	exec sp_getmessage @message_num, @msg output
	print @msg

go

/* create the database, if it does not exist */
if not exists (select name from sysdatabases where name = "sybsyntax")
begin
	/* is the space left on the default database devices > size of model? */
	if  (select sum (high-low +1)  from sysdevices where status & 1 = 1)
	-  (select sum (isnull (size, 0)) from sysusages, sysdevices
		where vstart >= sysdevices.low
		and vstart <= sysdevices.high
		and sysdevices.status &1 = 1)
		> (select sum(sysusages.size) from sysusages where dbid = 3)
	begin
		create database sybsyntax
	end
	else
		/*
		** 18047, "There is not enough room on the default devices to create the sybsyntax database."
		*/
		exec sybsyntax_printmsg 18047

end
go

if exists (select name from sysdatabases where name = "sybsyntax")
	use sybsyntax
else
	/*
	** 18048, "The sybsyntax database couldn't be created."
	*/
	exec sybsyntax_printmsg 18048
go

/* create the sybsyntax table if it doesn't exist, and sybsyntax does */
if exists (select name from master..sysdatabases where name = "sybsyntax")
begin
	if not exists (select name
			from sybsyntax..sysobjects
			where name = "sybsyntax"
				and type = "U" and uid = 1)
	begin
	/* The table does not exist. Create it. */
		create table sybsyntax
		(commandname	varchar(50)	not null,
		module		varchar(20)	not null,
		linenum		smallint	not null,
		syntax		varchar(78)	not null,
		langid		smallint	null)
	end
end
go

/*
** If the table existed from before. It could be an older version.
** Check to make sure that it has a langid column.
*/
if not exists (select name from sybsyntax..syscolumns 
			 where id = object_id("sybsyntax..sybsyntax")
			 and name = "langid")
begin
	alter table sybsyntax..sybsyntax
	add langid smallint null
end
go

/* create the index on the sybsyntax table */
if not exists (select name from sysindexes where name = "sybsyntax_cuix")
begin
	create unique clustered index sybsyntax_cuix
		on sybsyntax(module, commandname, linenum)
end
go

/* delete existing rows for this module, if there are any
** For DB-Library/C, delete only DB-Library/C. For Transact-SQL,
** delete SQL, sprocs and utilities
*/

if exists (select module from sybsyntax
		where module = "Transact-SQL")

begin
	delete from sybsyntax where module = "Transact-SQL"
	delete from sybsyntax where module = "System Procedure"
	delete from sybsyntax where module like "% Utility"
	delete from sybsyntax where module like "OpenVMS"
	dump transaction sybsyntax with truncate_only
end
go

use master
go

/* drop the insert_syntax procedure, and re-create it */
if exists (select name from sysobjects where name = "insert_syntax")
begin
	drop procedure insert_syntax
end
go

create procedure insert_syntax
	@command varchar(50),
	@module varchar(20),
	@linenum smallint,
	@syntax varchar(78),
	@lang_id smallint = null
as
if exists (select name
		from master..sysdatabases
		where name = "sybsyntax")
begin
	insert sybsyntax..sybsyntax values
		(@command, @module, @linenum, @syntax, @lang_id)
end
go
use master
go


/* add execs here */




exec insert_syntax 'alter database',
'Transact-SQL',          1 ,
'alter database - Increases the amount of space allocated to a'
go
exec insert_syntax 'alter database',
'Transact-SQL',          2 ,
'        database.'
go
exec insert_syntax 'alter database',
'Transact-SQL',          3 ,
'     alter database database_name'
go
exec insert_syntax 'alter database',
'Transact-SQL',          4 ,
'     [on {default | database_device } [= size]'
go
exec insert_syntax 'alter database',
'Transact-SQL',          5 ,
'         [, database_device [= size]]...]'
go
exec insert_syntax 'alter database',
'Transact-SQL',          6 ,
'     [log on { default | database_device } [ = size ]'
go
exec insert_syntax 'alter database',
'Transact-SQL',          7 ,
'         [ , database_device [= size]]...]'
go
exec insert_syntax 'alter database',
'Transact-SQL',          8 ,
'     [with override]'
go
exec insert_syntax 'alter database',
'Transact-SQL',          9 ,
'     [for load]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          1 ,
'alter table - Adds new columns; adds, changes, or drops'
go
exec insert_syntax 'alter table',
'Transact-SQL',          2 ,
'        constraints; partitions or unpartitions an'
go
exec insert_syntax 'alter table',
'Transact-SQL',          3 ,
'        existing table.'
go
exec insert_syntax 'alter table',
'Transact-SQL',          4 ,
'     alter table [database.[owner].]table_name'
go
exec insert_syntax 'alter table',
'Transact-SQL',          5 ,
'     {add column_name datatype'
go
exec insert_syntax 'alter table',
'Transact-SQL',          6 ,
'         [default {constant_expression | user | null}]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          7 ,
'         {[{identity | null}]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          8 ,
'         | [[constraint constraint_name]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          9 ,
'           {{unique | primary key}'
go
exec insert_syntax 'alter table',
'Transact-SQL',          10,
'             [clustered | nonclustered]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          11,
'             [with {fillfactor | max_rows_per_page} = x]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          12,
'                      [on segment_name]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          13,
'             | references [[database.]owner.]ref_table'
go
exec insert_syntax 'alter table',
'Transact-SQL',          14,
'                [(ref_column)]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          15,
'             | check (search_condition)}]}...'
go
exec insert_syntax 'alter table',
'Transact-SQL',          16,
'         {[, next_column]}...'
go
exec insert_syntax 'alter table',
'Transact-SQL',          17,
'     | add {[constraint constraint_name]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          18,
'         {unique | primary key}'
go
exec insert_syntax 'alter table',
'Transact-SQL',          19,
'           [clustered | nonclustered]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          20,
'           (column_name [{, column_name}...])'
go
exec insert_syntax 'alter table',
'Transact-SQL',          21,
'           [with {fillfactor | max_rows_per_page} = x]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          22,
'                [on segment_name]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          23,
'        | foreign key (column_name [{, column_name}...])'
go
exec insert_syntax 'alter table',
'Transact-SQL',          24,
'             references [[database.]owner.]ref_table'
go
exec insert_syntax 'alter table',
'Transact-SQL',          25,
'                 [(ref_column [{, ref_column}...])]'
go
exec insert_syntax 'alter table',
'Transact-SQL',          26,
'         | check (search_condition)}'
go
exec insert_syntax 'alter table',
'Transact-SQL',          27,
'     | drop constraint constraint_name'
go
exec insert_syntax 'alter table',
'Transact-SQL',          28,
'     | replace column_name'
go
exec insert_syntax 'alter table',
'Transact-SQL',          29,
'         default {constant_expression | user | null}'
go
exec insert_syntax 'alter table',
'Transact-SQL',          30,
'     | partition number_of_partitions'
go
exec insert_syntax 'alter table',
'Transact-SQL',          31,
'     | unpartition}'
go
exec insert_syntax 'begin transaction',
'Transact-SQL',          1 ,
'begin transaction - Marks the starting point of a user-defined'
go
exec insert_syntax 'begin transaction',
'Transact-SQL',          2 ,
'        transaction.'
go
exec insert_syntax 'begin transaction',
'Transact-SQL',          3 ,
'     begin tran[saction] [transaction_name]'
go
exec insert_syntax 'begin...end',
'Transact-SQL',          1 ,
'begin...end - Encloses a series of SQL statements so that'
go
exec insert_syntax 'begin...end',
'Transact-SQL',          2 ,
'        control-of-flow language, such as if...else, can'
go
exec insert_syntax 'begin...end',
'Transact-SQL',          3 ,
'        affect the performance of the whole group.'
go
exec insert_syntax 'begin...end',
'Transact-SQL',          4 ,
'        begin'
go
exec insert_syntax 'begin...end',
'Transact-SQL',          5 ,
'        statement block'
go
exec insert_syntax 'begin...end',
'Transact-SQL',          6 ,
'     end'
go
exec insert_syntax 'break',
'Transact-SQL',          1 ,
'break - Causes an exit from a while loop. break is often'
go
exec insert_syntax 'break',
'Transact-SQL',          2 ,
'        activated by an if test.'
go
exec insert_syntax 'break',
'Transact-SQL',          3 ,
'     while logical_expression'
go
exec insert_syntax 'break',
'Transact-SQL',          4 ,
'         statement'
go
exec insert_syntax 'break',
'Transact-SQL',          5 ,
'     break'
go
exec insert_syntax 'break',
'Transact-SQL',          6 ,
'         statement'
go
exec insert_syntax 'break',
'Transact-SQL',          7 ,
'     continue'
go
exec insert_syntax 'checkpoint',
'Transact-SQL',          1 ,
'checkpoint - Writes all dirty pages (pages that have been'
go
exec insert_syntax 'checkpoint',
'Transact-SQL',          2 ,
'        updated since they were last written) to the'
go
exec insert_syntax 'checkpoint',
'Transact-SQL',          3 ,
'        database device.'
go
exec insert_syntax 'checkpoint',
'Transact-SQL',          4 ,
'     checkpoint'
go
exec insert_syntax 'close',
'Transact-SQL',          1 ,
'close - Deactivates a cursor.'
go
exec insert_syntax 'close',
'Transact-SQL',          2 ,
'     close cursor_name'
go
exec insert_syntax 'commit',
'Transact-SQL',          1 ,
'commit - Marks the ending point of a user-defined'
go
exec insert_syntax 'commit',
'Transact-SQL',          2 ,
'        transaction.'
go
exec insert_syntax 'commit',
'Transact-SQL',          3 ,
'     commit [tran[saction] | work] [transaction_name]'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          1 ,
'compute Clause - Generates summary values that appear as'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          2 ,
'        additional rows in the query results. This allows'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          3 ,
'        you to see the detail and summary rows in one set'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          4 ,
'        of results. You can calculate summary values for'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          5 ,
'        subgroups, and you can calculate more than one'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          6 ,
'        aggregate for the same group.'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          7 ,
'     Start of select statement'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          8 ,
'     compute row_aggregate (column_name)'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          9 ,
'         [, row_aggregate(column_name)]...'
go
exec insert_syntax 'compute clause',
'Transact-SQL',          10,
'     [by column_name [, column_name]...]'
go
exec insert_syntax 'continue',
'Transact-SQL',          1 ,
'continue - Causes the while loop to restart. continue is'
go
exec insert_syntax 'continue',
'Transact-SQL',          2 ,
'        often activated by an if test.'
go
exec insert_syntax 'continue',
'Transact-SQL',          3 ,
'     while boolean_expression'
go
exec insert_syntax 'continue',
'Transact-SQL',          4 ,
'         statement'
go
exec insert_syntax 'continue',
'Transact-SQL',          5 ,
'     break'
go
exec insert_syntax 'continue',
'Transact-SQL',          6 ,
'         statement'
go
exec insert_syntax 'continue',
'Transact-SQL',          7 ,
'     continue'
go
exec insert_syntax 'create database',
'Transact-SQL',          1 ,
'create database - Creates a new database. Use create database from'
go
exec insert_syntax 'create database',
'Transact-SQL',          2 ,
'        the master database.'
go
exec insert_syntax 'create database',
'Transact-SQL',          3 ,
'     create database database_name'
go
exec insert_syntax 'create database',
'Transact-SQL',          4 ,
'     [on {default | database_device} [= size]'
go
exec insert_syntax 'create database',
'Transact-SQL',          5 ,
'         [, database_device [= size]]...]'
go
exec insert_syntax 'create database',
'Transact-SQL',          6 ,
'     [log on database_device [= size]'
go
exec insert_syntax 'create database',
'Transact-SQL',          7 ,
'         [, database_device [= size]]...]'
go
exec insert_syntax 'create database',
'Transact-SQL',          8 ,
'     [with override]'
go
exec insert_syntax 'create database',
'Transact-SQL',          9 ,
'     [for load]'
go
exec insert_syntax 'create default',
'Transact-SQL',          1 ,
'create default - Specifies a value to insert in a column (or in'
go
exec insert_syntax 'create default',
'Transact-SQL',          2 ,
'        all columns of a user-defined datatype) if no'
go
exec insert_syntax 'create default',
'Transact-SQL',          3 ,
'        value is explicitly supplied at insert time.'
go
exec insert_syntax 'create default',
'Transact-SQL',          4 ,
'     create default [owner.]default_name'
go
exec insert_syntax 'create default',
'Transact-SQL',          5 ,
'     as constant_expression'
go
exec insert_syntax 'create index',
'Transact-SQL',          1 ,
'create index - Creates an index on one or more columns in a'
go
exec insert_syntax 'create index',
'Transact-SQL',          2 ,
'        table.'
go
exec insert_syntax 'create index',
'Transact-SQL',          3 ,
'     create [unique] [clustered | nonclustered]'
go
exec insert_syntax 'create index',
'Transact-SQL',          4 ,
'         index index_name'
go
exec insert_syntax 'create index',
'Transact-SQL',          5 ,
'     on [[database.]owner.]table_name (column_name'
go
exec insert_syntax 'create index',
'Transact-SQL',          6 ,
'         [, column_name]...)'
go
exec insert_syntax 'create index',
'Transact-SQL',          7 ,
'     [with {{fillfactor | max_rows_per_page} = x,'
go
exec insert_syntax 'create index',
'Transact-SQL',          8 ,
'         ignore_dup_key, sorted_data,'
go
exec insert_syntax 'create index',
'Transact-SQL',          9 ,
'         [ignore_dup_row | allow_dup_row]}]'
go
exec insert_syntax 'create index',
'Transact-SQL',          10,
'     [on segment_name]'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          1 ,
'create procedure - Creates a stored procedure that can take one or'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          2 ,
'        more user-supplied parameters.'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          3 ,
'     create procedure [owner.]procedure_name[;number]'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          4 ,
'     [[(]@parameter_name'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          5 ,
'         datatype [(length) | (precision [, scale])]'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          6 ,
'         [= default][output]'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          7 ,
'     [, @parameter_name'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          8 ,
'         datatype [(length) | (precision [, scale])]'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          9 ,
'         [= default][output]]...[)]]'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          10,
'     [with recompile]'
go
exec insert_syntax 'create procedure',
'Transact-SQL',          11,
'     as SQL_statements'
go
exec insert_syntax 'create rule',
'Transact-SQL',          1 ,
'create rule - Specifies the domain of acceptable values for a'
go
exec insert_syntax 'create rule',
'Transact-SQL',          2 ,
'        particular column or for any column of a'
go
exec insert_syntax 'create rule',
'Transact-SQL',          3 ,
'        user-defined datatype.'
go
exec insert_syntax 'create rule',
'Transact-SQL',          4 ,
'     create rule [owner.]rule_name'
go
exec insert_syntax 'create rule',
'Transact-SQL',          5 ,
'     as condition_expression'
go
exec insert_syntax 'create schema',
'Transact-SQL',          1 ,
'create schema - Creates a new collection of tables, views, and'
go
exec insert_syntax 'create schema',
'Transact-SQL',          2 ,
'        permissions for a database user.'
go
exec insert_syntax 'create schema',
'Transact-SQL',          3 ,
'     create schema authorization authorization_name'
go
exec insert_syntax 'create schema',
'Transact-SQL',          4 ,
'     create_oject_statement'
go
exec insert_syntax 'create schema',
'Transact-SQL',          5 ,
'         [ create_object_statement ... ]'
go
exec insert_syntax 'create schema',
'Transact-SQL',          6 ,
'     [ permission_statement ... ]'
go
exec insert_syntax 'create table',
'Transact-SQL',          1 ,
'create table - Creates new tables and optional integrity'
go
exec insert_syntax 'create table',
'Transact-SQL',          2 ,
'        constraints.'
go
exec insert_syntax 'create table',
'Transact-SQL',          3 ,
'      create table [database.[owner].]table_name'
go
exec insert_syntax 'create table',
'Transact-SQL',          4 ,
'     (column_name datatype'
go
exec insert_syntax 'create table',
'Transact-SQL',          5 ,
'         [default {constant_expression | user | null}]'
go
exec insert_syntax 'create table',
'Transact-SQL',          6 ,
'         {[{identity | null | not null}]'
go
exec insert_syntax 'create table',
'Transact-SQL',          7 ,
'         | [[constraint constraint_name]'
go
exec insert_syntax 'create table',
'Transact-SQL',          8 ,
'             {{unique | primary key}'
go
exec insert_syntax 'create table',
'Transact-SQL',          9 ,
'              [clustered | nonclustered]'
go
exec insert_syntax 'create table',
'Transact-SQL',          10,
'              [with {fillfactor |max_rows_per_page}= x]'
go
exec insert_syntax 'create table',
'Transact-SQL',          11,
'                [on segment_name]'
go
exec insert_syntax 'create table',
'Transact-SQL',          12,
'             | references [[database.]owner.]ref_table'
go
exec insert_syntax 'create table',
'Transact-SQL',          13,
'                 [(ref_column)]'
go
exec insert_syntax 'create table',
'Transact-SQL',          14,
'             | check (search_condition)}]}...'
go
exec insert_syntax 'create table',
'Transact-SQL',          15,
'     | [constraint constraint_name]'
go
exec insert_syntax 'create table',
'Transact-SQL',          16,
'         {{unique | primary key}'
go
exec insert_syntax 'create table',
'Transact-SQL',          17,
'             [clustered | nonclustered]'
go
exec insert_syntax 'create table',
'Transact-SQL',          18,
'             (column_name [{, column_name}...])'
go
exec insert_syntax 'create table',
'Transact-SQL',          19,
'               {fillfactor |max_rows_per_page}= x]'
go
exec insert_syntax 'create table',
'Transact-SQL',          20,
'                 [on segment_name]'
go
exec insert_syntax 'create table',
'Transact-SQL',          21,
'         | foreign key (column_name [{,'
go
exec insert_syntax 'create table',
'Transact-SQL',          22,
'     column_name}...])'
go
exec insert_syntax 'create table',
'Transact-SQL',          23,
'             references [[database.]owner.]ref_table'
go
exec insert_syntax 'create table',
'Transact-SQL',          24,
'                 [(ref_column [{, ref_column}...])]'
go
exec insert_syntax 'create table',
'Transact-SQL',          25,
'          | check (search_condition)}'
go
exec insert_syntax 'create table',
'Transact-SQL',          26,
'     [{, {next_column | next_constraint}}...])'
go
exec insert_syntax 'create table',
'Transact-SQL',          27,
'     [with max_rows_per_page = x] [on segment_name]'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          1 ,
'create trigger - Creates a trigger, a type of stored procedure'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          2 ,
'        that is often used for enforcing integrity'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          3 ,
'        constraints. A trigger executes automatically'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          4 ,
'        when a user attempts a specified data'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          5 ,
'        modification statement on a specified table.'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          6 ,
'     create trigger [owner.]trigger_name'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          7 ,
'     on [owner.]table_name'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          8 ,
'     for {insert , update , delete}'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          9 ,
'     as SQL_statements'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          10,
'     Or, using the if update clause:'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          11,
'     create trigger [owner.]trigger_name'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          12,
'     on [owner.]table_name'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          13,
'     for {insert , update}'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          14,
'     as'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          15,
'         [if update (column_name)'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          16,
'             [{and | or} update (column_name)]...]'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          17,
'             SQL_statements'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          18,
'         [if update (column_name)'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          19,
'             [{and | or} update (column_name)]...'
go
exec insert_syntax 'create trigger',
'Transact-SQL',          20,
'             SQL_statements]...'
go
exec insert_syntax 'create view',
'Transact-SQL',          1 ,
'create view - Creates a view, which is an alternative way of'
go
exec insert_syntax 'create view',
'Transact-SQL',          2 ,
'        looking at the data in one or more tables.'
go
exec insert_syntax 'create view',
'Transact-SQL',          3 ,
'     create view [owner.]view_name'
go
exec insert_syntax 'create view',
'Transact-SQL',          4 ,
'     [(column_name [, column_name]...)]'
go
exec insert_syntax 'create view',
'Transact-SQL',          5 ,
'     as select [distinct] select_statement'
go
exec insert_syntax 'create view',
'Transact-SQL',          6 ,
'     [with check option]'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          1 ,
'dbcc - Database Consistency Checker (dbcc) checks the'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          2 ,
'        logical and physical consistency of a database.'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          3 ,
'        dbcc should be used regularly as a periodic check'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          4 ,
'        or if damage is suspected.'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          5 ,
'     dbcc'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          6 ,
'     {checktable({table_name|table_id}[, skip_ncindex])|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          7 ,
'      checkdb [(database_name [, skip_ncindex])]|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          8 ,
'      checkalloc [(database_name [, fix | nofix])]|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          9 ,
'      tablealloc ({table_name | table_id}'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          10,
'         [, {full | optimized | fast | null}'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          11,
'         [, fix | nofix]])|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          12,
'      indexalloc ({table_name | table_id}, index_id'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          13,
'         [, {full | optimized | fast | null}'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          14,
'         [, fix | nofix]])|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          15,
'      checkcatalog [(database_name)]|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          16,
'      dbrepair (database_name, dropdb)|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          17,
'      reindex ({table_name | table_id})|'
go
exec insert_syntax 'dbcc',
'Transact-SQL',          18,
'      fix_text ({table_name | table_id})}'
go
exec insert_syntax 'deallocate cursor',
'Transact-SQL',          1 ,
'deallocate cursor - Makes a cursor inaccessible and releases all'
go
exec insert_syntax 'deallocate cursor',
'Transact-SQL',          2 ,
'        memory resources committed to that cursor.'
go
exec insert_syntax 'deallocate cursor',
'Transact-SQL',          3 ,
'     deallocate cursor cursor_name'
go
exec insert_syntax 'declare',
'Transact-SQL',          1 ,
'declare - Declares the name and type of local variables for'
go
exec insert_syntax 'declare',
'Transact-SQL',          2 ,
'        a batch or procedure.  Local variables are'
go
exec insert_syntax 'declare',
'Transact-SQL',          3 ,
'        assigned values with a select statement.'
go
exec insert_syntax 'declare',
'Transact-SQL',          4 ,
'     Variable declaration:'
go
exec insert_syntax 'declare',
'Transact-SQL',          5 ,
'     declare @variable_name datatype'
go
exec insert_syntax 'declare',
'Transact-SQL',          6 ,
'     [, @variable_name datatype]...'
go
exec insert_syntax 'declare',
'Transact-SQL',          7 ,
'     Variable assignment:'
go
exec insert_syntax 'declare',
'Transact-SQL',          8 ,
'     select @variable = {expression | select_statement}'
go
exec insert_syntax 'declare',
'Transact-SQL',          9 ,
'     [, @variable = {expression | select_statement} ...]'
go
exec insert_syntax 'declare',
'Transact-SQL',          10,
'     [from table_list]'
go
exec insert_syntax 'declare',
'Transact-SQL',          11,
'     [where search_conditions]'
go
exec insert_syntax 'declare',
'Transact-SQL',          12,
'     [group by group_by_list]'
go
exec insert_syntax 'declare',
'Transact-SQL',          13,
'     [having search_conditions]'
go
exec insert_syntax 'declare',
'Transact-SQL',          14,
'     [order by order_by_list]'
go
exec insert_syntax 'declare',
'Transact-SQL',          15,
'     [compute function_list [by by_list]]'
go
exec insert_syntax 'declare cursor',
'Transact-SQL',          1 ,
'declare cursor - Defines a cursor.'
go
exec insert_syntax 'declare cursor',
'Transact-SQL',          2 ,
'     declare cursor_name cursor'
go
exec insert_syntax 'declare cursor',
'Transact-SQL',          3 ,
'     for select_statement'
go
exec insert_syntax 'declare cursor',
'Transact-SQL',          4 ,
'     [for {read only | update [of column_name_list]}]'
go
exec insert_syntax 'delete',
'Transact-SQL',          1 ,
'delete - Removes rows from a table.'
go
exec insert_syntax 'delete',
'Transact-SQL',          2 ,
'     delete [from]'
go
exec insert_syntax 'delete',
'Transact-SQL',          3 ,
'     [[database.]owner.]{view_name|table_name}'
go
exec insert_syntax 'delete',
'Transact-SQL',          4 ,
'     [where search_conditions]'
go
exec insert_syntax 'delete',
'Transact-SQL',          5 ,
'     delete [[database.]owner.]{table_name | view_name}'
go
exec insert_syntax 'delete',
'Transact-SQL',          6 ,
'     [from [[database.]owner.]{view_name|table_name'
go
exec insert_syntax 'delete',
'Transact-SQL',          7 ,
'      [(index index_name [ prefetch size ][lru|mru])]}'
go
exec insert_syntax 'delete',
'Transact-SQL',          8 ,
'      [, [[database.]owner.]{view_name|table_name'
go
exec insert_syntax 'delete',
'Transact-SQL',          9 ,
'      (index index_name [ prefetch size ][lru|mru])]}'
go
exec insert_syntax 'delete',
'Transact-SQL',          10,
'      ]...]'
go
exec insert_syntax 'delete',
'Transact-SQL',          11,
'     [where search_conditions]'
go
exec insert_syntax 'delete',
'Transact-SQL',          12,
'     delete [from]'
go
exec insert_syntax 'delete',
'Transact-SQL',          13,
'     [[database.]owner.]{table_name|view_name}'
go
exec insert_syntax 'delete',
'Transact-SQL',          14,
'     where current of cursor_name'
go
exec insert_syntax 'disk init',
'Transact-SQL',          1 ,
'disk init - Makes a physical device or file usable by SQL'
go
exec insert_syntax 'disk init',
'Transact-SQL',          2 ,
'        Server. (The master device is initialized by the'
go
exec insert_syntax 'disk init',
'Transact-SQL',          3 ,
'        sybinit installation program; it is not necessary'
go
exec insert_syntax 'disk init',
'Transact-SQL',          4 ,
'        to initialize this device with disk init.)'
go
exec insert_syntax 'disk init',
'Transact-SQL',          5 ,
'     disk init'
go
exec insert_syntax 'disk init',
'Transact-SQL',          6 ,
'     name = "device_name" ,'
go
exec insert_syntax 'disk init',
'Transact-SQL',          7 ,
'     physname = "physicalname" ,'
go
exec insert_syntax 'disk init',
'Transact-SQL',          8 ,
'     vdevno = virtual_device_number ,'
go
exec insert_syntax 'disk init',
'Transact-SQL',          9 ,
'     size = number_of_blocks'
go
exec insert_syntax 'disk init',
'Transact-SQL',          10,
'     [, vstart = virtual_address ,'
go
exec insert_syntax 'disk init',
'Transact-SQL',          11,
'     cntrltype = controller_number ]'
go
exec insert_syntax 'disk init',
'Transact-SQL',          12,
'     [, contiguous] (OpenVMS only)'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          1 ,
'disk mirror - Creates a software mirror that immediately takes'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          2 ,
'        over when the primary device fails. You can'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          3 ,
'        mirror the master device, devices that store'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          4 ,
'        data, and devices that store transaction logs.'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          5 ,
'        However, you cannot mirror dump devices.'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          6 ,
'     disk mirror'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          7 ,
'     name = "device_name" ,'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          8 ,
'     mirror = "physicalname"'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          9 ,
'     [ ,writes = { serial | noserial }]'
go
exec insert_syntax 'disk mirror',
'Transact-SQL',          10,
'     [ ,contiguous ] (OpenVMS only)'
go
exec insert_syntax 'disk refit',
'Transact-SQL',          1 ,
'disk refit - Rebuilds the master database''s sysusages and'
go
exec insert_syntax 'disk refit',
'Transact-SQL',          2 ,
'        sysdatabases system tables from information'
go
exec insert_syntax 'disk refit',
'Transact-SQL',          3 ,
'        contained in sysdevices. Use disk refit after'
go
exec insert_syntax 'disk refit',
'Transact-SQL',          4 ,
'        disk reinit as part of the procedure to restore'
go
exec insert_syntax 'disk refit',
'Transact-SQL',          5 ,
'        the master database.'
go
exec insert_syntax 'disk refit',
'Transact-SQL',          6 ,
'     disk refit'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          1 ,
'disk reinit - Rebuilds the master database''s sysdevices system'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          2 ,
'        table. Use disk reinit as part of the procedure'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          3 ,
'        to restore the master database.'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          4 ,
'     disk reinit'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          5 ,
'     name = "device_name",'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          6 ,
'     physname = "physicalname" ,'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          7 ,
'     vdevno = virtual_device_number ,'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          8 ,
'     size = number_of_blocks'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          9 ,
'     [, vstart = virtual_address ,'
go
exec insert_syntax 'disk reinit',
'Transact-SQL',          10,
'     cntrltype = controller_number]'
go
exec insert_syntax 'disk remirror',
'Transact-SQL',          1 ,
'disk remirror - Restarts disk mirroring after it is stopped by'
go
exec insert_syntax 'disk remirror',
'Transact-SQL',          2 ,
'        failure of a mirrored device or temporarily'
go
exec insert_syntax 'disk remirror',
'Transact-SQL',          3 ,
'        disabled by the disk unmirror command.'
go
exec insert_syntax 'disk remirror',
'Transact-SQL',          4 ,
'     disk remirror'
go
exec insert_syntax 'disk remirror',
'Transact-SQL',          5 ,
'     name = "device_name"'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          1 ,
'disk unmirror - Deactivates disk mirroring to allow hardware'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          2 ,
'        maintenance or the changing of a hardware device.'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          3 ,
'        disk unmirror disables either the original'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          4 ,
'        database device or the mirror so that it is no'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          5 ,
'        longer available to SQL Server for reads or'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          6 ,
'        writes. It does not remove the associated file'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          7 ,
'        from the operating system.'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          8 ,
'     disk unmirror'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          9 ,
'     name = "device_name"'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          10,
'     [ ,side = { "primary" | secondary }]'
go
exec insert_syntax 'disk unmirror',
'Transact-SQL',          11,
'     [ ,mode = { retain | remove }]'
go
exec insert_syntax 'drop database',
'Transact-SQL',          1 ,
'drop database - Removes one or more databases from SQL Server.'
go
exec insert_syntax 'drop database',
'Transact-SQL',          2 ,
'     drop database database_name [, database_name]...'
go
exec insert_syntax 'drop default',
'Transact-SQL',          1 ,
'drop default - Removes a user-defined default.'
go
exec insert_syntax 'drop default',
'Transact-SQL',          2 ,
'     drop default [owner.]default_name'
go
exec insert_syntax 'drop default',
'Transact-SQL',          3 ,
'     [, [owner.]default_name]...'
go
exec insert_syntax 'drop index',
'Transact-SQL',          1 ,
'drop index - Removes an index from a table in the current'
go
exec insert_syntax 'drop index',
'Transact-SQL',          2 ,
'        database.'
go
exec insert_syntax 'drop index',
'Transact-SQL',          3 ,
'     drop index table_name.index_name'
go
exec insert_syntax 'drop index',
'Transact-SQL',          4 ,
'     [, table_name.index_name]...'
go
exec insert_syntax 'drop procedure',
'Transact-SQL',          1 ,
'drop procedure - Removes user-defined stored procedures.'
go
exec insert_syntax 'drop procedure',
'Transact-SQL',          2 ,
'     drop proc[edure] [owner.]procedure_name'
go
exec insert_syntax 'drop procedure',
'Transact-SQL',          3 ,
'     [, [owner.]procedure_name] ...'
go
exec insert_syntax 'drop rule',
'Transact-SQL',          1 ,
'drop rule - Removes a user-defined rule.'
go
exec insert_syntax 'drop rule',
'Transact-SQL',          2 ,
'     drop rule [owner.]rule_name [, [owner.]rule_name]...'
go
exec insert_syntax 'drop table',
'Transact-SQL',          1 ,
'drop table - Removes a table definition and all of its data,'
go
exec insert_syntax 'drop table',
'Transact-SQL',          2 ,
'        indexes, triggers, and permissions from the'
go
exec insert_syntax 'drop table',
'Transact-SQL',          3 ,
'        database.'
go
exec insert_syntax 'drop table',
'Transact-SQL',          4 ,
'     drop table [[database.]owner.]table_name'
go
exec insert_syntax 'drop table',
'Transact-SQL',          5 ,
'     [, [[database.]owner.]table_name ]...'
go
exec insert_syntax 'drop trigger',
'Transact-SQL',          1 ,
'drop trigger - Removes a trigger.'
go
exec insert_syntax 'drop trigger',
'Transact-SQL',          2 ,
'     drop trigger [owner.]trigger_name'
go
exec insert_syntax 'drop trigger',
'Transact-SQL',          3 ,
'     [, [owner.]trigger_name]...'
go
exec insert_syntax 'drop view',
'Transact-SQL',          1 ,
'drop view - Removes one or more views from the current'
go
exec insert_syntax 'drop view',
'Transact-SQL',          2 ,
'        database.'
go
exec insert_syntax 'drop view',
'Transact-SQL',          3 ,
'     drop view [owner.]view_name [, [owner.]view_name]...'
go
exec insert_syntax 'dump database',
'Transact-SQL',          1 ,
'     dump database database_name'
go
exec insert_syntax 'dump database',
'Transact-SQL',          2 ,
'     to stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump database',
'Transact-SQL',          3 ,
'         [density = density_value,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          4 ,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          5 ,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          6 ,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          7 ,
'          file = file_name]'
go
exec insert_syntax 'dump database',
'Transact-SQL',          8 ,
'     [stripe on stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump database',
'Transact-SQL',          9 ,
'         [density = density_value,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          10,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          11,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          12,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          13,
'          file = file_name]]'
go
exec insert_syntax 'dump database',
'Transact-SQL',          14,
'     [[stripe on stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump database',
'Transact-SQL',          15,
'         [density = density_value,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          16,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          17,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          18,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          19,
'          file = file_name]]...]'
go
exec insert_syntax 'dump database',
'Transact-SQL',          20,
'     [with {'
go
exec insert_syntax 'dump database',
'Transact-SQL',          21,
'          density = density_value,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          22,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          23,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          24,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          25,
'          file = file_name,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          26,
'         [dismount | nodismount],'
go
exec insert_syntax 'dump database',
'Transact-SQL',          27,
'         [nounload | unload],'
go
exec insert_syntax 'dump database',
'Transact-SQL',          28,
'         retaindays = number_days,'
go
exec insert_syntax 'dump database',
'Transact-SQL',          29,
'         [noinit | init],'
go
exec insert_syntax 'dump database',
'Transact-SQL',          30,
'         notify = {client | operator_console}'
go
exec insert_syntax 'dump database',
'Transact-SQL',          31,
'         }]]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          1 ,
'dump transaction - Makes a copy of a transaction log'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          2 ,
'       and removes the inactive portion.'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          3 ,
'     To make a routine log dump:'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          4 ,
'     dump tran[saction] database_name'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          5 ,
'     to stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          6 ,
'         [density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          7 ,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          8 ,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          9 ,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          10,
'          file = file_name]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          11,
'     [stripe on stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          12,
'         [density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          13,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          14,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          15,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          16,
'          file = file_name]]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          17,
'     [[stripe on stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          18,
'         [density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          19,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          20,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          21,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          22,
'          file = file_name] ]...]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          23,
'     [with {'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          24,
'         density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          25,
'         blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          26,
'         capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          27,
'         dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          28,
'         file = file_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          29,
'         [dismount | nodismount],'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          30,
'         [nounload | unload],'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          31,
'         retaindays = number_days,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          32,
'         [noinit | init],'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          33,
'         notify = {client | operator_console}}]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          34,
'     To truncate the log without making a backup copy:'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          35,
'     dump tran[saction] database_name'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          36,
'     with truncate_only'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          37,
'     To truncate a log that is filled to capacity.'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          38,
'         Use only as a last resort:'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          39,
'     dump tran[saction] database_name'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          40,
'     with no_log'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          41,
'     To back up the log after a database device fails:'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          42,
'     dump tran[saction] database_name'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          43,
'     to stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          44,
'         [density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          45,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          46,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          47,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          48,
'          file = file_name]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          49,
'     [stripe on stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          50,
'         [density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          51,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          52,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          53,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          54,
'          file = file_name]]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          55,
'     [[stripe on stripe_device [ at backup_server_name ]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          56,
'         [density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          57,
'          blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          58,
'          capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          59,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          60,
'          file = file_name] ]...]'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          61,
'     [with {'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          62,
'         density = density_value,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          63,
'         blocksize = number_bytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          64,
'         capacity = number_kilobytes,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          65,
'         dumpvolume = volume_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          66,
'         file = file_name,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          67,
'         [dismount | nodismount],'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          68,
'         [nounload | unload],'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          69,
'         retaindays = number_days,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          70,
'         [noinit | init],'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          71,
'         no_truncate,'
go
exec insert_syntax 'dump transaction',
'Transact-SQL',          72,
'         notify = {client | operator_console}}]'
go
exec insert_syntax 'execute',
'Transact-SQL',          1 ,
'execute - Runs a system procedure or a user-defined stored'
go
exec insert_syntax 'execute',
'Transact-SQL',          2 ,
'        procedure.'
go
exec insert_syntax 'execute',
'Transact-SQL',          3 ,
'     [execute] [@return_status = ]'
go
exec insert_syntax 'execute',
'Transact-SQL',          4 ,
'     [[[server.]database.]owner.]procedure_name[;number]'
go
exec insert_syntax 'execute',
'Transact-SQL',          5 ,
'         [[@parameter_name =] value |'
go
exec insert_syntax 'execute',
'Transact-SQL',          6 ,
'             [@parameter_name =] @variable [output]'
go
exec insert_syntax 'execute',
'Transact-SQL',          7 ,
'         [,[@parameter_name =] value |'
go
exec insert_syntax 'execute',
'Transact-SQL',          8 ,
'             [@parameter_name =] @variable [output]...]]'
go
exec insert_syntax 'execute',
'Transact-SQL',          9 ,
'     [with recompile]'
go
exec insert_syntax 'fetch',
'Transact-SQL',          1 ,
'fetch - Returns a row or a set of rows from a cursor'
go
exec insert_syntax 'fetch',
'Transact-SQL',          2 ,
'        result set.'
go
exec insert_syntax 'fetch',
'Transact-SQL',          3 ,
'     fetch cursor_name [ into fetch_target_list ]'
go
exec insert_syntax 'goto label',
'Transact-SQL',          1 ,
'goto Label - Branches to a user-defined label.'
go
exec insert_syntax 'goto label',
'Transact-SQL',          2 ,
'     label:'
go
exec insert_syntax 'goto label',
'Transact-SQL',          3 ,
'     goto label'
go
exec insert_syntax 'grant',
'Transact-SQL',          1 ,
'grant - Assigns permissions to users.'
go
exec insert_syntax 'grant',
'Transact-SQL',          2 ,
'     To grant permission to access database objects:'
go
exec insert_syntax 'grant',
'Transact-SQL',          3 ,
'     grant {all [privileges]| permission_list}'
go
exec insert_syntax 'grant',
'Transact-SQL',          4 ,
'     on { table_name [(column_list)]'
go
exec insert_syntax 'grant',
'Transact-SQL',          5 ,
'         | view_name[(column_list)]'
go
exec insert_syntax 'grant',
'Transact-SQL',          6 ,
'         | stored_procedure_name}'
go
exec insert_syntax 'grant',
'Transact-SQL',          7 ,
'     to {public | name_list | role_name}'
go
exec insert_syntax 'grant',
'Transact-SQL',          8 ,
'     [with grant option]'
go
exec insert_syntax 'grant',
'Transact-SQL',          9 ,
'     To grant permission to create database objects:'
go
exec insert_syntax 'grant',
'Transact-SQL',          10,
'     grant {all [privileges] | command_list}'
go
exec insert_syntax 'grant',
'Transact-SQL',          11,
'     to {public | name_list | role_name}'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          1 ,
'group by and having Clauses - Used in select'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          2 ,
'        statements to divide a table into'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          3 ,
'        groups and to return only groups that match'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          4 ,
'        conditions in the having clause.'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          5 ,
'     Start of select statement'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          6 ,
'     [group by [all] aggregate_free_expression'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          7 ,
'     [, aggregate_free_expression]...]'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          8 ,
'     [having search_conditions]'
go
exec insert_syntax 'group by and having',
'Transact-SQL',          9 ,
'     End of select statement'
go
exec insert_syntax 'if...else',
'Transact-SQL',          1 ,
'if...else - Imposes conditions on the execution of a SQL'
go
exec insert_syntax 'if...else',
'Transact-SQL',          2 ,
'        statement. The statement following an if keyword'
go
exec insert_syntax 'if...else',
'Transact-SQL',          3 ,
'        and its condition is executed if the condition is'
go
exec insert_syntax 'if...else',
'Transact-SQL',          4 ,
'        satisfied (when the logical expression returns'
go
exec insert_syntax 'if...else',
'Transact-SQL',          5 ,
'        TRUE). The optional else keyword introduces an'
go
exec insert_syntax 'if...else',
'Transact-SQL',          6 ,
'        alternate SQL statement that executes when the if'
go
exec insert_syntax 'if...else',
'Transact-SQL',          7 ,
'        condition is not satisfied (when the logical'
go
exec insert_syntax 'if...else',
'Transact-SQL',          8 ,
'        expression returns FALSE).'
go
exec insert_syntax 'if...else',
'Transact-SQL',          9 ,
'     if logical_expression'
go
exec insert_syntax 'if...else',
'Transact-SQL',          10,
'     statements'
go
exec insert_syntax 'if...else',
'Transact-SQL',          11,
'     [else'
go
exec insert_syntax 'if...else',
'Transact-SQL',          12,
'     [if logical_expression]'
go
exec insert_syntax 'if...else',
'Transact-SQL',          13,
'     statement]'
go
exec insert_syntax 'insert',
'Transact-SQL',          1 ,
'insert - Adds new rows to a table or view.'
go
exec insert_syntax 'insert',
'Transact-SQL',          2 ,
'     insert [into]'
go
exec insert_syntax 'insert',
'Transact-SQL',          3 ,
'     [database.[owner.]]{table_name|view_name}'
go
exec insert_syntax 'insert',
'Transact-SQL',          4 ,
'     [(column_list)]'
go
exec insert_syntax 'insert',
'Transact-SQL',          5 ,
'     {values (expression [, expression]...)'
go
exec insert_syntax 'insert',
'Transact-SQL',          6 ,
'         |select_statement }'
go
exec insert_syntax 'kill',
'Transact-SQL',          1 ,
'kill - Kills a process.'
go
exec insert_syntax 'kill',
'Transact-SQL',          2 ,
'     kill spid'
go
exec insert_syntax 'load database',
'Transact-SQL',          1 ,
'load database - Loads a backup copy of a user database, including'
go
exec insert_syntax 'load database',
'Transact-SQL',          2 ,
'        its transaction log, that was created with dump'
go
exec insert_syntax 'load database',
'Transact-SQL',          3 ,
'        database. The listonly and headeronly options'
go
exec insert_syntax 'load database',
'Transact-SQL',          4 ,
'        display information about the dump files without'
go
exec insert_syntax 'load database',
'Transact-SQL',          5 ,
'        loading them.  Dumps and loads are performed'
go
exec insert_syntax 'load database',
'Transact-SQL',          6 ,
'        through Backup Server.'
go
exec insert_syntax 'load database',
'Transact-SQL',          7 ,
'     load database database_name'
go
exec insert_syntax 'load database',
'Transact-SQL',          8 ,
'     from stripe_device [at backup_server_name ]'
go
exec insert_syntax 'load database',
'Transact-SQL',          9 ,
'         [density = density_value,'
go
exec insert_syntax 'load database',
'Transact-SQL',          10,
'         blocksize = number_bytes,'
go
exec insert_syntax 'load database',
'Transact-SQL',          11,
'         dumpvolume = volume_name,'
go
exec insert_syntax 'load database',
'Transact-SQL',          12,
'         file = file_name]'
go
exec insert_syntax 'load database',
'Transact-SQL',          13,
'     [stripe on stripe_device [at backup_server_name ]'
go
exec insert_syntax 'load database',
'Transact-SQL',          14,
'              [density = density_value,'
go
exec insert_syntax 'load database',
'Transact-SQL',          15,
'          blocksize = number_bytes,'
go
exec insert_syntax 'load database',
'Transact-SQL',          16,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'load database',
'Transact-SQL',          17,
'          file = file_name]'
go
exec insert_syntax 'load database',
'Transact-SQL',          18,
'     [[stripe on stripe_device [at backup_server_name ]'
go
exec insert_syntax 'load database',
'Transact-SQL',          19,
'         [density = density_value,'
go
exec insert_syntax 'load database',
'Transact-SQL',          20,
'          blocksize = number_bytes,'
go
exec insert_syntax 'load database',
'Transact-SQL',          21,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'load database',
'Transact-SQL',          22,
'          file = file_name]]...]'
go
exec insert_syntax 'load database',
'Transact-SQL',          23,
'     [with {'
go
exec insert_syntax 'load database',
'Transact-SQL',          24,
'         density = density_value,'
go
exec insert_syntax 'load database',
'Transact-SQL',          25,
'         blocksize = number_bytes,'
go
exec insert_syntax 'load database',
'Transact-SQL',          26,
'         dumpvolume = volume_name,'
go
exec insert_syntax 'load database',
'Transact-SQL',          27,
'         file = file_name,'
go
exec insert_syntax 'load database',
'Transact-SQL',          28,
'         [dismount | nodismount],'
go
exec insert_syntax 'load database',
'Transact-SQL',          29,
'         [nounload | unload],'
go
exec insert_syntax 'load database',
'Transact-SQL',          30,
'         listonly [= full],'
go
exec insert_syntax 'load database',
'Transact-SQL',          31,
'         headeronly,'
go
exec insert_syntax 'load database',
'Transact-SQL',          32,
'         notify = {client | operator_console}'
go
exec insert_syntax 'load database',
'Transact-SQL',          33,
'         }]'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          1 ,
'load transaction - Loads a backup copy of the transaction log that'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          2 ,
'        was created with the dump transaction command.'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          3 ,
'        The listonly and headeronly options display'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          4 ,
'        information about the dump files without loading'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          5 ,
'        them. Dumps and loads are performed through'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          6 ,
'        Backup Server.'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          7 ,
'     load tran[saction] database_name'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          8 ,
'     from stripe_device [at backup_server_name]'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          9 ,
'         [density = density_value,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          10,
'          blocksize = number_bytes,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          11,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          12,
'          file = file_name]'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          13,
'     [stripe on stripe_device [at backup_server_name]'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          14,
'         [density = density_value,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          15,
'          blocksize = number_bytes,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          16,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          17,
'          file = file_name]'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          18,
'     [[stripe on stripe_device [at backup_server_name]'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          19,
'         [density = density_value,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          20,
'          blocksize = number_bytes,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          21,
'          dumpvolume = volume_name,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          22,
'          file = file_name]]...]'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          23,
'     [with {'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          24,
'         density = density_value,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          25,
'         blocksize = number_bytes,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          26,
'         dumpvolume = volume_name,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          27,
'         file = file_name,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          28,
'         [dismount | nodismount],'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          29,
'         [nounload | unload],'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          30,
'         listonly [= full],'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          31,
'         headeronly,'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          32,
'         notify = {client | operator_console}'
go
exec insert_syntax 'load transaction',
'Transact-SQL',          33,
'     }]'
go
exec insert_syntax 'online database',
'Transact-SQL',          1 ,
'online database - Marks a database available for public use after a'
go
exec insert_syntax 'online database',
'Transact-SQL',          2 ,
'        normal load sequence and, if needed, upgrades a'
go
exec insert_syntax 'online database',
'Transact-SQL',          3 ,
'        loaded database and transaction log dumps to the'
go
exec insert_syntax 'online database',
'Transact-SQL',          4 ,
'        current version of SQL Server.'
go
exec insert_syntax 'online database',
'Transact-SQL',          5 ,
'     online database database_name'
go
exec insert_syntax 'open',
'Transact-SQL',          1 ,
'open - Opens a cursor for processing.'
go
exec insert_syntax 'open',
'Transact-SQL',          2 ,
'     open cursor_name'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          1 ,
'order by Clause - Returns query results in the specified column(s)'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          2 ,
'        in sorted order.'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          3 ,
'     [Start of select statement]'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          4 ,
'     [order by {[table_name.| view_name.]column_name'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          5 ,
'         | select_list_number | expression} [asc | desc]'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          6 ,
'     [,{[table_name.| view_name.] column_name'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          7 ,
'           select_list_number|expression} [asc'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          8 ,
'     |desc]]...]'
go
exec insert_syntax 'order by clause',
'Transact-SQL',          9 ,
'     [End of select statement]'
go
exec insert_syntax 'prepare transaction',
'Transact-SQL',          1 ,
'prepare transaction - Used by DB-Library in a two-phase commit'
go
exec insert_syntax 'prepare transaction',
'Transact-SQL',          2 ,
'        application to see if a server is prepared to'
go
exec insert_syntax 'prepare transaction',
'Transact-SQL',          3 ,
'        commit a transaction.'
go
exec insert_syntax 'prepare transaction',
'Transact-SQL',          4 ,
'     prepare tran[saction]'
go
exec insert_syntax 'print',
'Transact-SQL',          1 ,
'print - Prints a user-defined message on the'
go
exec insert_syntax 'print',
'Transact-SQL',          2 ,
'        user''s screen.'
go
exec insert_syntax 'print',
'Transact-SQL',          3 ,
'     print'
go
exec insert_syntax 'print',
'Transact-SQL',          4 ,
'     {format_string | @local_variable |'
go
exec insert_syntax 'print',
'Transact-SQL',          5 ,
'     @@global_variable}'
go
exec insert_syntax 'print',
'Transact-SQL',          6 ,
'         [, arg_list]'
go
exec insert_syntax 'raiserror',
'Transact-SQL',          1 ,
'raiserror - Prints a user-defined error message on the'
go
exec insert_syntax 'raiserror',
'Transact-SQL',          2 ,
'        user''s screen and sets a system flag to record that an'
go
exec insert_syntax 'raiserror',
'Transact-SQL',          3 ,
'        error condition has occurred.'
go
exec insert_syntax 'raiserror',
'Transact-SQL',          4 ,
'     raiserror error_number'
go
exec insert_syntax 'raiserror',
'Transact-SQL',          5 ,
'     [{format_string | @local_variable}] [, arg_list]'
go
exec insert_syntax 'raiserror',
'Transact-SQL',          6 ,
'     [with errordata restricted_select_list]'
go
exec insert_syntax 'readtext',
'Transact-SQL',          1 ,
'readtext - Reads text and image values, starting from a'
go
exec insert_syntax 'readtext',
'Transact-SQL',          2 ,
'        specified offset and reading a specified number'
go
exec insert_syntax 'readtext',
'Transact-SQL',          3 ,
'        of bytes or characters.'
go
exec insert_syntax 'readtext',
'Transact-SQL',          4 ,
'     readtext [[database.]owner.]table_name.column_name'
go
exec insert_syntax 'readtext',
'Transact-SQL',          5 ,
'     text_pointer offset size [holdlock]'
go
exec insert_syntax 'readtext',
'Transact-SQL',          6 ,
'     [using {bytes | chars | characters}]'
go
exec insert_syntax 'readtext',
'Transact-SQL',          7 ,
'     [at isolation {read uncommitted | read committed |'
go
exec insert_syntax 'readtext',
'Transact-SQL',          8 ,
'             serializable}]'
go
exec insert_syntax 'reconfigure',
'Transact-SQL',          1 ,
'reconfigure - The reconfigure command currently has no effect;'
go
exec insert_syntax 'reconfigure',
'Transact-SQL',          2 ,
'        it is included to allow existing scripts to run'
go
exec insert_syntax 'reconfigure',
'Transact-SQL',          3 ,
'        without modification.'
go
exec insert_syntax 'return',
'Transact-SQL',          1 ,
'return - Exits from a batch or procedure unconditionally'
go
exec insert_syntax 'return',
'Transact-SQL',          2 ,
'        and provides an optional return status.'
go
exec insert_syntax 'return',
'Transact-SQL',          3 ,
'        Statements following return are not executed.'
go
exec insert_syntax 'return',
'Transact-SQL',          4 ,
'     return [integer_expression]'
go
exec insert_syntax 'revoke',
'Transact-SQL',          1 ,
'revoke - Revokes permissions from users.'
go
exec insert_syntax 'revoke',
'Transact-SQL',          2 ,
'     To revoke permission to access database objects:'
go
exec insert_syntax 'revoke',
'Transact-SQL',          3 ,
'     revoke [grant option for]'
go
exec insert_syntax 'revoke',
'Transact-SQL',          4 ,
'     {all [privileges] | permission_list}'
go
exec insert_syntax 'revoke',
'Transact-SQL',          5 ,
'     on { table_name [(column_list)]'
go
exec insert_syntax 'revoke',
'Transact-SQL',          6 ,
'         | view_name [(column_list)]'
go
exec insert_syntax 'revoke',
'Transact-SQL',          7 ,
'         | stored_procedure_name}'
go
exec insert_syntax 'revoke',
'Transact-SQL',          8 ,
'     from {public | name_list | role_name}'
go
exec insert_syntax 'revoke',
'Transact-SQL',          9 ,
'     [cascade]'
go
exec insert_syntax 'revoke',
'Transact-SQL',          10,
'     To revoke permission to create database objects:'
go
exec insert_syntax 'revoke',
'Transact-SQL',          11,
'     revoke {all [privileges] | command_list}'
go
exec insert_syntax 'revoke',
'Transact-SQL',          12,
'     from {public | name_list | role_name}'
go
exec insert_syntax 'rollback',
'Transact-SQL',          1 ,
'rollback - Rolls back a user-defined transaction to the last'
go
exec insert_syntax 'rollback',
'Transact-SQL',          2 ,
'        savepoint inside the transaction or to the'
go
exec insert_syntax 'rollback',
'Transact-SQL',          3 ,
'        beginning of the transaction.'
go
exec insert_syntax 'rollback',
'Transact-SQL',          4 ,
'     rollback {tran[saction] | work}'
go
exec insert_syntax 'rollback',
'Transact-SQL',          5 ,
'     [transaction_name | savepoint_name]'
go
exec insert_syntax 'rollback trigger',
'Transact-SQL',          1 ,
'rollback trigger - Rolls back the work done in a trigger, including'
go
exec insert_syntax 'rollback trigger',
'Transact-SQL',          2 ,
'        the data modification that caused the trigger to'
go
exec insert_syntax 'rollback trigger',
'Transact-SQL',          3 ,
'        fire, and issues an optional raiserror'
go
exec insert_syntax 'rollback trigger',
'Transact-SQL',          4 ,
'        statement.'
go
exec insert_syntax 'rollback trigger',
'Transact-SQL',          5 ,
'     rollback trigger'
go
exec insert_syntax 'rollback trigger',
'Transact-SQL',          6 ,
'     [with raiserror_statement]'
go
exec insert_syntax 'save transaction',
'Transact-SQL',          1 ,
'save transaction - Sets a savepoint within a transaction.'
go
exec insert_syntax 'save transaction',
'Transact-SQL',          2 ,
'     save transaction savepoint_name'
go
exec insert_syntax 'select',
'Transact-SQL',          1 ,
'select - Retrieves rows from database objects.'
go
exec insert_syntax 'select',
'Transact-SQL',          2 ,
'     select [all | distinct] select_list'
go
exec insert_syntax 'select',
'Transact-SQL',          3 ,
'     [into [[database.]owner.]table_name]'
go
exec insert_syntax 'select',
'Transact-SQL',          4 ,
'     [from [[database.]owner.]{view_name|table_name'
go
exec insert_syntax 'select',
'Transact-SQL',          5 ,
'       [(index index_name [ prefetch size ][lru|mru])]}'
go
exec insert_syntax 'select',
'Transact-SQL',          6 ,
'             [holdlock | noholdlock] [shared]'
go
exec insert_syntax 'select',
'Transact-SQL',          7 ,
'         [,[[database.]owner.]{view_name|table_name'
go
exec insert_syntax 'select',
'Transact-SQL',          8 ,
'       [(index index_name [ prefetch size ][lru|mru])]}'
go
exec insert_syntax 'select',
'Transact-SQL',          9 ,
'             [holdlock | noholdlock] [shared]]... ]'
go
exec insert_syntax 'select',
'Transact-SQL',          10,
'     [where search_conditions]'
go
exec insert_syntax 'select',
'Transact-SQL',          11,
'     [group by [all] aggregate_free_expression'
go
exec insert_syntax 'select',
'Transact-SQL',          12,
'         [, aggregate_free_expression]... ]'
go
exec insert_syntax 'select',
'Transact-SQL',          13,
'     [having search_conditions]'
go
exec insert_syntax 'select',
'Transact-SQL',          14,
'     [order by'
go
exec insert_syntax 'select',
'Transact-SQL',          15,
'     {[[[database.]owner.]{table_name.|view_name.}]'
go
exec insert_syntax 'select',
'Transact-SQL',          16,
'         column_name | select_list_number | expression}'
go
exec insert_syntax 'select',
'Transact-SQL',          17,
'             [asc | desc]'
go
exec insert_syntax 'select',
'Transact-SQL',          18,
'     [,{[[[database.]owner.]{table_name|view_name.}]'
go
exec insert_syntax 'select',
'Transact-SQL',          19,
'         column_name | select_list_number | expression}'
go
exec insert_syntax 'select',
'Transact-SQL',          20,
'             [asc | desc]]...]'
go
exec insert_syntax 'select',
'Transact-SQL',          21,
'     [compute row_aggregate(column_name)'
go
exec insert_syntax 'select',
'Transact-SQL',          22,
'             [, row_aggregate(column_name)]...'
go
exec insert_syntax 'select',
'Transact-SQL',          23,
'         [by column_name [, column_name]...]]'
go
exec insert_syntax 'select',
'Transact-SQL',          24,
'     [for {read only | update [of column_name_list]}]'
go
exec insert_syntax 'select',
'Transact-SQL',          25,
'     [at isolation {read uncommitted | read committed |'
go
exec insert_syntax 'select',
'Transact-SQL',          26,
'             serializable}]'
go
exec insert_syntax 'select',
'Transact-SQL',          27,
'     [for browse]'
go
exec insert_syntax 'set',
'Transact-SQL',          1 ,
'set - Sets SQL Server query-processing options for the'
go
exec insert_syntax 'set',
'Transact-SQL',          2 ,
'        duration of the user''s work session. Can be used'
go
exec insert_syntax 'set',
'Transact-SQL',          3 ,
'        to set some options inside a trigger or stored'
go
exec insert_syntax 'set',
'Transact-SQL',          4 ,
'        procedure.'
go
exec insert_syntax 'set',
'Transact-SQL',          5 ,
'     set ansinull {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          6 ,
'     set ansi_permissions {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          7 ,
'     set arithabort [arith_overflow | numeric_truncation]'
go
exec insert_syntax 'set',
'Transact-SQL',          8 ,
'          {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          9 ,
'     set arithignore [arith_overflow] {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          10,
'     set {chained, close on endtran, nocount, noexec,'
go
exec insert_syntax 'set',
'Transact-SQL',          11,
'          parseonly, procid, self_recursion, showplan}'
go
exec insert_syntax 'set',
'Transact-SQL',          12,
'          {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          13,
'     set char_convert {off | on [with {error | no_error}] |'
go
exec insert_syntax 'set',
'Transact-SQL',          14,
'          charset [with {error | no_error}]}'
go
exec insert_syntax 'set',
'Transact-SQL',          15,
'     set cursor rows number for cursor_name'
go
exec insert_syntax 'set',
'Transact-SQL',          16,
'     set {datefirst number, dateformat format,'
go
exec insert_syntax 'set',
'Transact-SQL',          17,
'          language language}'
go
exec insert_syntax 'set',
'Transact-SQL',          18,
'     set fipsflagger {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          19,
'     set flushmessage {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          20,
'     set identity_insert [database.[owner.]]table_name'
go
exec insert_syntax 'set',
'Transact-SQL',          21,
'           {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          22,
'     set offsets {select, from, order, compute, table,'
go
exec insert_syntax 'set',
'Transact-SQL',          23,
'          procedure, statement, param, execute} {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          24,
'     set prefetch [on|off]'
go
exec insert_syntax 'set',
'Transact-SQL',          25,
'     set quoted_identifier {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          26,
'     set role {"sa_role" | "sso_role" | "oper_role"}'
go
exec insert_syntax 'set',
'Transact-SQL',          27,
'          {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          28,
'     set {rowcount number, textsize number}'
go
exec insert_syntax 'set',
'Transact-SQL',          29,
'     set statistics {io, subquerycache, time} {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          30,
'     set string_rtruncation {on | off}'
go
exec insert_syntax 'set',
'Transact-SQL',          31,
'     set table count number'
go
exec insert_syntax 'set',
'Transact-SQL',          32,
'     set textsize {number}'
go
exec insert_syntax 'set',
'Transact-SQL',          33,
'     set transaction isolation level {0 | 1 | 3}'
go
exec insert_syntax 'setuser',
'Transact-SQL',          1 ,
'setuser - Allows a Database Owner to impersonate another'
go
exec insert_syntax 'setuser',
'Transact-SQL',          2 ,
'        user.'
go
exec insert_syntax 'setuser',
'Transact-SQL',          3 ,
'     setuser ["user_name"]'
go
exec insert_syntax 'shutdown',
'Transact-SQL',          1 ,
'shutdown - Shuts down the SQL Server from which the command'
go
exec insert_syntax 'shutdown',
'Transact-SQL',          2 ,
'        is issued, its local Backup Server, or a remote'
go
exec insert_syntax 'shutdown',
'Transact-SQL',          3 ,
'        Backup Server. This command can be issued only by'
go
exec insert_syntax 'shutdown',
'Transact-SQL',          4 ,
'        a System Administrator.'
go
exec insert_syntax 'shutdown',
'Transact-SQL',          5 ,
'     shutdown [srvname] [with {wait | nowait}]'
go
exec insert_syntax 'truncate table',
'Transact-SQL',          1 ,
'truncate table - Removes all rows from a table.'
go
exec insert_syntax 'truncate table',
'Transact-SQL',          2 ,
'     truncate table [[database.]owner.]table_name'
go
exec insert_syntax 'union operator',
'Transact-SQL',          1 ,
'union Operator - Returns a single result set that combines the'
go
exec insert_syntax 'union operator',
'Transact-SQL',          2 ,
'        results of two or more queries. Duplicate rows'
go
exec insert_syntax 'union operator',
'Transact-SQL',          3 ,
'        are eliminated from the result set unless the all'
go
exec insert_syntax 'union operator',
'Transact-SQL',          4 ,
'        keyword is specified.'
go
exec insert_syntax 'union operator',
'Transact-SQL',          5 ,
'            select select_list [into clause]'
go
exec insert_syntax 'union operator',
'Transact-SQL',          6 ,
'             [from clause] [where clause]'
go
exec insert_syntax 'union operator',
'Transact-SQL',          7 ,
'             [group by clause] [having clause]'
go
exec insert_syntax 'union operator',
'Transact-SQL',          8 ,
'     [union [all]'
go
exec insert_syntax 'union operator',
'Transact-SQL',          9 ,
'         select select_list'
go
exec insert_syntax 'union operator',
'Transact-SQL',          10,
'             [from clause] [where clause]'
go
exec insert_syntax 'union operator',
'Transact-SQL',          11,
'             [group by clause] [having clause] ]...'
go
exec insert_syntax 'union operator',
'Transact-SQL',          12,
'     [order by clause]'
go
exec insert_syntax 'union operator',
'Transact-SQL',          13,
'     [compute clause]'
go
exec insert_syntax 'update',
'Transact-SQL',          1 ,
'update - Changes data in existing rows, either by adding'
go
exec insert_syntax 'update',
'Transact-SQL',          2 ,
'        data or by modifying existing data.'
go
exec insert_syntax 'update',
'Transact-SQL',          3 ,
'     update [[database.]owner.]{table_name | view_name}'
go
exec insert_syntax 'update',
'Transact-SQL',          4 ,
'     set [[[database.]owner.]{table_name.|view_name.}]'
go
exec insert_syntax 'update',
'Transact-SQL',          5 ,
'         column_name1 ='
go
exec insert_syntax 'update',
'Transact-SQL',          6 ,
'             {expression1|NULL|(select_statement)}'
go
exec insert_syntax 'update',
'Transact-SQL',          7 ,
'         [, column_name2 ='
go
exec insert_syntax 'update',
'Transact-SQL',          8 ,
'             {expression2|NULL|(select_statement)}]...'
go
exec insert_syntax 'update',
'Transact-SQL',          9 ,
'     [from [[database.]owner.]{view_name|table_name'
go
exec insert_syntax 'update',
'Transact-SQL',          10,
'     [(index index_name [ prefetch size ][lru|mru])]}'
go
exec insert_syntax 'update',
'Transact-SQL',          11,
'          [,[[database.]owner.]{view_name|table_name'
go
exec insert_syntax 'update',
'Transact-SQL',          12,
'     [(index index_name [ prefetch size ][lru|mru])]}]'
go
exec insert_syntax 'update',
'Transact-SQL',          13,
'     ...]'
go
exec insert_syntax 'update',
'Transact-SQL',          14,
'     [where search_conditions]'
go
exec insert_syntax 'update',
'Transact-SQL',          15,
'     update [[database.]owner.]{table_name | view_name}'
go
exec insert_syntax 'update',
'Transact-SQL',          16,
'     set [[[database.]owner.]{table_name.|view_name.}]'
go
exec insert_syntax 'update',
'Transact-SQL',          17,
'         column_name1 ='
go
exec insert_syntax 'update',
'Transact-SQL',          18,
'            {expression1|NULL|(select_statement)}'
go
exec insert_syntax 'update',
'Transact-SQL',          19,
'         [, column_name2 ='
go
exec insert_syntax 'update',
'Transact-SQL',          20,
'            {expression2|NULL|(select_statement)}]...'
go
exec insert_syntax 'update',
'Transact-SQL',          21,
'     where current of cursor_name'
go
exec insert_syntax 'update statistics',
'Transact-SQL',          1 ,
'update statistics - Updates information about the distribution of key'
go
exec insert_syntax 'update statistics',
'Transact-SQL',          2 ,
'        values in specified indexes.'
go
exec insert_syntax 'update statistics',
'Transact-SQL',          3 ,
'     update statistics table_name [index_name]'
go
exec insert_syntax 'use',
'Transact-SQL',          1 ,
'use - Specifies the database with which you want to'
go
exec insert_syntax 'use',
'Transact-SQL',          2 ,
'        work.'
go
exec insert_syntax 'use',
'Transact-SQL',          3 ,
'     use database_name'
go
exec insert_syntax 'waitfor',
'Transact-SQL',          1 ,
'waitfor - Specifies a specific time, a time interval, or an'
go
exec insert_syntax 'waitfor',
'Transact-SQL',          2 ,
'        event for the execution of a statement block,'
go
exec insert_syntax 'waitfor',
'Transact-SQL',          3 ,
'        stored procedure, or transaction.'
go
exec insert_syntax 'waitfor',
'Transact-SQL',          4 ,
'     waitfor { delay time | time time | errorexit'
go
exec insert_syntax 'waitfor',
'Transact-SQL',          5 ,
'     | processexit | mirrorexit }'
go
exec insert_syntax 'where clause',
'Transact-SQL',          1 ,
'where Clause - Sets the search conditions in a select,'
go
exec insert_syntax 'where clause',
'Transact-SQL',          2 ,
'        insert, update, or delete statement.'
go
exec insert_syntax 'where clause',
'Transact-SQL',          3 ,
'     where [not] expression comparison_operator expression'
go
exec insert_syntax 'where clause',
'Transact-SQL',          4 ,
'     where [not] expression [not] like  "match_string"'
go
exec insert_syntax 'where clause',
'Transact-SQL',          5 ,
'          [escape "escape_character"]'
go
exec insert_syntax 'where clause',
'Transact-SQL',          6 ,
'     where [not] expression is [not] null'
go
exec insert_syntax 'where clause',
'Transact-SQL',          7 ,
'     where [not]'
go
exec insert_syntax 'where clause',
'Transact-SQL',          8 ,
'        expression [not] between expression and expression'
go
exec insert_syntax 'where clause',
'Transact-SQL',          9 ,
'     where [not]'
go
exec insert_syntax 'where clause',
'Transact-SQL',          10,
'        expression [not] in ({value_list | subquery})'
go
exec insert_syntax 'where clause',
'Transact-SQL',          11,
'     where [not] exists (subquery)'
go
exec insert_syntax 'where clause',
'Transact-SQL',          12,
'     where [not]'
go
exec insert_syntax 'where clause',
'Transact-SQL',          13,
'        expression comparison_operator {any|all} (subquery)'
go
exec insert_syntax 'where clause',
'Transact-SQL',          14,
'     where [not] column_name join_operator column_name'
go
exec insert_syntax 'where clause',
'Transact-SQL',          15,
'     where [not] boolean_expression'
go
exec insert_syntax 'where clause',
'Transact-SQL',          16,
'     where [not] expression {and | or} [not] expression'
go
exec insert_syntax 'while',
'Transact-SQL',          1 ,
'while - Sets a condition for the repeated execution of a'
go
exec insert_syntax 'while',
'Transact-SQL',          2 ,
'        statement or statement block. The statement(s)'
go
exec insert_syntax 'while',
'Transact-SQL',          3 ,
'        are executed repeatedly as long as the specified'
go
exec insert_syntax 'while',
'Transact-SQL',          4 ,
'        condition is true.'
go
exec insert_syntax 'while',
'Transact-SQL',          5 ,
'     while logical_expression'
go
exec insert_syntax 'while',
'Transact-SQL',          6 ,
'          statement'
go
exec insert_syntax 'writetext',
'Transact-SQL',          1 ,
'writetext - Permits non-logged, interactive updating of an'
go
exec insert_syntax 'writetext',
'Transact-SQL',          2 ,
'        existing text or image column.'
go
exec insert_syntax 'writetext',
'Transact-SQL',          3 ,
'     writetext [[database.]owner.]table_name.column_name'
go
exec insert_syntax 'writetext',
'Transact-SQL',          4 ,
'     text_pointer [with log] data'
go





exec insert_syntax 'abs',
'Transact-SQL',          1 ,
'  abs - Returns the absolute value of a given expression. Results'
go
exec insert_syntax 'abs',
'Transact-SQL',          2 ,
'       are of the same type and have the same precision and'
go
exec insert_syntax 'abs',
'Transact-SQL',          3 ,
'       scale as the numeric expression.'
go
exec insert_syntax 'abs',
'Transact-SQL',          4 ,
'     abs(numeric)'
go
exec insert_syntax 'acos',
'Transact-SQL',          1 ,
'  acos - Returns the angle (in radians) whose cosine'
go
exec insert_syntax 'acos',
'Transact-SQL',          2 ,
'       is the specified value.'
go
exec insert_syntax 'acos',
'Transact-SQL',          3 ,
'     acos(approx_numeric)'
go
exec insert_syntax 'ascii',
'Transact-SQL',          1 ,
'  ascii- Returns the ASCII code for the first'
go
exec insert_syntax 'ascii',
'Transact-SQL',          2 ,
'       character in the expression.'
go
exec insert_syntax 'ascii',
'Transact-SQL',          3 ,
'     ascii(char_expr)'
go
exec insert_syntax 'asin',
'Transact-SQL',          1 ,
'  asin - Returns the angle (in radians) whose sine is'
go
exec insert_syntax 'asin',
'Transact-SQL',          2 ,
'       the specified value.'
go
exec insert_syntax 'asin',
'Transact-SQL',          3 ,
'     asin(approx_numeric)'
go
exec insert_syntax 'atan',
'Transact-SQL',          1 ,
'  atan - Returns the angle (in radians) whose tangent'
go
exec insert_syntax 'atan',
'Transact-SQL',          2 ,
'       is the specified value.'
go
exec insert_syntax 'atan',
'Transact-SQL',          3 ,
'     atan(approx_numeric)'
go
exec insert_syntax 'atn2',
'Transact-SQL',          1 ,
'  atn2 - Returns the angle (in radians) whose tangent'
go
exec insert_syntax 'atn2',
'Transact-SQL',          2 ,
'       is (approx_numeric1/approx_numeric2).'
go
exec insert_syntax 'atn2',
'Transact-SQL',          3 ,
'     atn2(approx_numeric1, approx_numeric2)'
go
exec insert_syntax 'avg',
'Transact-SQL',          1 ,
'   avg - Average of (distinct) values in the numeric column.'
go
exec insert_syntax 'avg',
'Transact-SQL',          2 ,
'    avg([all | distinct] expression)'
go
exec insert_syntax 'ceiling',
'Transact-SQL',          1 ,
'  ceiling - Returns the smallest integer greater than or'
go
exec insert_syntax 'ceiling',
'Transact-SQL',          2 ,
'       equal to the specified value. Results are of'
go
exec insert_syntax 'ceiling',
'Transact-SQL',          3 ,
'       the same type as the numeric expression. For'
go
exec insert_syntax 'ceiling',
'Transact-SQL',          4 ,
'       numeric and decimal expressions, the results'
go
exec insert_syntax 'ceiling',
'Transact-SQL',          5 ,
'       have a precision equal to that of the'
go
exec insert_syntax 'ceiling',
'Transact-SQL',          6 ,
'       expression and a scale of 0.'
go
exec insert_syntax 'ceiling',
'Transact-SQL',          7 ,
'     ceiling(numeric)'
go
exec insert_syntax 'char',
'Transact-SQL',          1 ,
'  char - Converts a single-byte integer value to a character'
go
exec insert_syntax 'char',
'Transact-SQL',          2 ,
'       value. (char is usually used as the inverse of ascii.)'
go
exec insert_syntax 'char',
'Transact-SQL',          3 ,
'       integer_expr must be between 0 and 255. Returns a char'
go
exec insert_syntax 'char',
'Transact-SQL',          4 ,
'       datatype. If the resulting value is the first byte of'
go
exec insert_syntax 'char',
'Transact-SQL',          5 ,
'       a multibyte character, the character may be undefined.'
go
exec insert_syntax 'char',
'Transact-SQL',          6 ,
'     char(integer_expr)'
go
exec insert_syntax 'char_length',
'Transact-SQL',          1 ,
'  char_length - Returns an integer representing the number'
go
exec insert_syntax 'char_length',
'Transact-SQL',          2 ,
'       of characters in a character expression or text'
go
exec insert_syntax 'char_length',
'Transact-SQL',          3 ,
'       value. For variable-length data, char_length strips'
go
exec insert_syntax 'char_length',
'Transact-SQL',          4 ,
'       the expression of trailing blanks before counting'
go
exec insert_syntax 'char_length',
'Transact-SQL',          5 ,
'       the number of characters. For multi-byte character'
go
exec insert_syntax 'char_length',
'Transact-SQL',          6 ,
'       sets, the number of characters in the expression'
go
exec insert_syntax 'char_length',
'Transact-SQL',          7 ,
'       is usually less than the number of bytes; use datalength'
go
exec insert_syntax 'char_length',
'Transact-SQL',          8 ,
'       to determine the number of bytes.'
go
exec insert_syntax 'char_length',
'Transact-SQL',          9 ,
'     char_length(char_expr)'
go
exec insert_syntax 'charindex',
'Transact-SQL',          1 ,
'  charindex - Searches expression2 for the first occurrence of'
go
exec insert_syntax 'charindex',
'Transact-SQL',          2 ,
'       expression1 and returns an integer representing its'
go
exec insert_syntax 'charindex',
'Transact-SQL',          3 ,
'       starting position. If expression1 is not found, returns'
go
exec insert_syntax 'charindex',
'Transact-SQL',          4 ,
'       0. If expression1 contains wildcard characters,'
go
exec insert_syntax 'charindex',
'Transact-SQL',          5 ,
'       charindex treats them as literals.'
go
exec insert_syntax 'charindex',
'Transact-SQL',          6 ,
'     charindex (expression1, expression2)'
go
exec insert_syntax 'col_length',
'Transact-SQL',          1 ,
'  col_length - Returns the defined length of column. Use datalength'
go
exec insert_syntax 'col_length',
'Transact-SQL',          2 ,
'       to see the actual data size.'
go
exec insert_syntax 'col_length',
'Transact-SQL',          3 ,
'     col_length(object_name, column_name)'
go
exec insert_syntax 'col_name',
'Transact-SQL',          1 ,
'  col_name - Returns the column name.'
go
exec insert_syntax 'col_name',
'Transact-SQL',          2 ,
'     col_name(object_id, column_id[, database_id])'
go
exec insert_syntax 'convert',
'Transact-SQL',          1 ,
'  convert- Converts between a wide variety of datatypes and reformats'
go
exec insert_syntax 'convert',
'Transact-SQL',          2 ,
'       date/time and money data for display purposes.'
go
exec insert_syntax 'convert',
'Transact-SQL',          3 ,
'     convert (datatype [(length) |'
go
exec insert_syntax 'convert',
'Transact-SQL',          4 ,
'      (precision[, scale])], expression[, style])'
go
exec insert_syntax 'cos',
'Transact-SQL',          1 ,
'  cos - Returns the cosine of the specified angle (in radians).'
go
exec insert_syntax 'cos',
'Transact-SQL',          2 ,
'     cos(approx_numeric)'
go
exec insert_syntax 'cot',
'Transact-SQL',          1 ,
'  cot - Returns the cotangent of the specified angle (in radians).'
go
exec insert_syntax 'cot',
'Transact-SQL',          2 ,
'     cot(approx_numeric)'
go
exec insert_syntax 'count',
'Transact-SQL',          1 ,
'  count - Number of (distinct) non-null values in the column.'
go
exec insert_syntax 'count',
'Transact-SQL',          2 ,
'     count([all | distinct] expression)'
go
exec insert_syntax 'count(*)',
'Transact-SQL',          1 ,
' count(*) - Number of selected rows.'
go
exec insert_syntax 'count(*)',
'Transact-SQL',          2 ,
'     count(*)'
go
exec insert_syntax 'curunreservedpgs',
'Transact-SQL',          1 ,
'  curunreservedpgs - Returns the number of free pages in a'
go
exec insert_syntax 'curunreservedpgs',
'Transact-SQL',          2 ,
'       disk piece. If the database is open, the value is taken'
go
exec insert_syntax 'curunreservedpgs',
'Transact-SQL',          3 ,
'       from memory; if the database is not in use, the value is'
go
exec insert_syntax 'curunreservedpgs',
'Transact-SQL',          4 ,
'       taken from the unreservedpgs column in sysusages.'
go
exec insert_syntax 'curunreservedpgs',
'Transact-SQL',          5 ,
'     curunreservedpgs(dbid, lstart, unreservedpgs)'
go
exec insert_syntax 'data_pgs',
'Transact-SQL',          1 ,
'  data_pgs - Returns the number of pages used by table (doampg)'
go
exec insert_syntax 'data_pgs',
'Transact-SQL',          2 ,
'       or index (ioampg). The result does not include pages'
go
exec insert_syntax 'data_pgs',
'Transact-SQL',          3 ,
'       used for internal structures.'
go
exec insert_syntax 'data_pgs',
'Transact-SQL',          4 ,
'     data_pgs(object_id, {doampg | ioampg})'
go
exec insert_syntax 'datalength',
'Transact-SQL',          1 ,
'  datalength -  Returns the length of expression in bytes.'
go
exec insert_syntax 'datalength',
'Transact-SQL',          2 ,
'       expression is usually a column name. If expression is'
go
exec insert_syntax 'datalength',
'Transact-SQL',          3 ,
'       a character constant, it must be enclosed in quotes.'
go
exec insert_syntax 'datalength',
'Transact-SQL',          4 ,
'     datalength(expression)'
go
exec insert_syntax 'dateadd',
'Transact-SQL',          1 ,
'  dateadd - Returns the date produced by adding the specified number'
go
exec insert_syntax 'dateadd',
'Transact-SQL',          2 ,
'       of the specified date parts to the date. numeric_expression'
go
exec insert_syntax 'dateadd',
'Transact-SQL',          3 ,
'       can be any numeric type; the value is truncated to an'
go
exec insert_syntax 'dateadd',
'Transact-SQL',          4 ,
'       integer.'
go
exec insert_syntax 'dateadd',
'Transact-SQL',          5 ,
'     dateadd(datepart, numeric_expression, date)'
go
exec insert_syntax 'datediff',
'Transact-SQL',          1 ,
'  datediff - Returns date2 - date1, measured in the specified date part.'
go
exec insert_syntax 'datediff',
'Transact-SQL',          2 ,
'     datediff(datepart, date1, date2)'
go
exec insert_syntax 'datename',
'Transact-SQL',          1 ,
'  datename - Returns the name of the specified part (such as the'
go
exec insert_syntax 'datename',
'Transact-SQL',          2 ,
'       month "June") of a datetime value, as a character string. If'
go
exec insert_syntax 'datename',
'Transact-SQL',          3 ,
'       the result is numeric, such as "23" for the day, it is still'
go
exec insert_syntax 'datename',
'Transact-SQL',          4 ,
'       returned as a character string.'
go
exec insert_syntax 'datename',
'Transact-SQL',          5 ,
'     datename(datepart, date)'
go
exec insert_syntax 'datepart',
'Transact-SQL',          1 ,
'  datepart - Returns an integer value for the specified part of'
go
exec insert_syntax 'datepart',
'Transact-SQL',          2 ,
'       a datetime value.'
go
exec insert_syntax 'datepart',
'Transact-SQL',          3 ,
'     datepart(datepart, date)'
go
exec insert_syntax 'db_id',
'Transact-SQL',          1 ,
'  db_id - Returns the database ID number. database_name must be'
go
exec insert_syntax 'db_id',
'Transact-SQL',          2 ,
'       a character expression; if it is a constant expression,'
go
exec insert_syntax 'db_id',
'Transact-SQL',          3 ,
'       it must be enclosed in quotes. If no database_name is'
go
exec insert_syntax 'db_id',
'Transact-SQL',          4 ,
'       supplied, db_id returns the ID number of the current database.'
go
exec insert_syntax 'db_id',
'Transact-SQL',          5 ,
'     db_id([database_name])'
go
exec insert_syntax 'db_name',
'Transact-SQL',          1 ,
'  db_name - Returns the database name. database_id must be a numeric'
go
exec insert_syntax 'db_name',
'Transact-SQL',          2 ,
'       expression. If no database_id is supplied, db_name returns the'
go
exec insert_syntax 'db_name',
'Transact-SQL',          3 ,
'       name of the current database.'
go
exec insert_syntax 'db_name',
'Transact-SQL',          4 ,
'     db_name ([database_id])'
go
exec insert_syntax 'degrees',
'Transact-SQL',          1 ,
'  degrees - Converts radians to degrees. Results are of'
go
exec insert_syntax 'degrees',
'Transact-SQL',          2 ,
'       the same type as the numeric expression. For'
go
exec insert_syntax 'degrees',
'Transact-SQL',          3 ,
'       numeric and decimal expressions, the results'
go
exec insert_syntax 'degrees',
'Transact-SQL',          4 ,
'       have an internal precision of 77 and a scale'
go
exec insert_syntax 'degrees',
'Transact-SQL',          5 ,
'       equal to that of the expression. When money'
go
exec insert_syntax 'degrees',
'Transact-SQL',          6 ,
'       datatypes are used, internal conversion to'
go
exec insert_syntax 'degrees',
'Transact-SQL',          7 ,
'       float may cause loss of precision.'
go
exec insert_syntax 'degrees',
'Transact-SQL',          8 ,
'     degrees(numeric)'
go
exec insert_syntax 'difference',
'Transact-SQL',          1 ,
'  difference - Returns an integer representing the'
go
exec insert_syntax 'difference',
'Transact-SQL',          2 ,
'       difference between two soundex values.'
go
exec insert_syntax 'difference',
'Transact-SQL',          3 ,
'     difference(char_expr1, char_expr2)'
go
exec insert_syntax 'exp',
'Transact-SQL',          1 ,
'  exp - Returns the exponential value of the specified value.'
go
exec insert_syntax 'exp',
'Transact-SQL',          2 ,
'     exp(approx_numeric)'
go
exec insert_syntax 'floor',
'Transact-SQL',          1 ,
'  floor - Returns the largest integer less than or equal'
go
exec insert_syntax 'floor',
'Transact-SQL',          2 ,
'       to the specified value. Results are of the'
go
exec insert_syntax 'floor',
'Transact-SQL',          3 ,
'       same type as the numeric expression. For'
go
exec insert_syntax 'floor',
'Transact-SQL',          4 ,
'       numeric and decimal expressions, the results'
go
exec insert_syntax 'floor',
'Transact-SQL',          5 ,
'       have a precision equal to that of the'
go
exec insert_syntax 'floor',
'Transact-SQL',          6 ,
'       expression and a scale of 0.'
go
exec insert_syntax 'floor',
'Transact-SQL',          7 ,
'     floor(numeric)'
go
exec insert_syntax 'getdate',
'Transact-SQL',          1 ,
'  getdate - Returns the current system date and time.'
go
exec insert_syntax 'getdate',
'Transact-SQL',          2 ,
'     getdate( )'
go
exec insert_syntax 'hextoint',
'Transact-SQL',          1 ,
'  hextoint - Returns the platform-independent integer equivalent'
go
exec insert_syntax 'hextoint',
'Transact-SQL',          2 ,
'       of a hexadecimal string.'
go
exec insert_syntax 'hextoint',
'Transact-SQL',          3 ,
'     hextoint(hexadecimal_string)'
go
exec insert_syntax 'host_id',
'Transact-SQL',          1 ,
'  host_id - Returns the host process ID of the client process'
go
exec insert_syntax 'host_id',
'Transact-SQL',          2 ,
'       (not the Server process).'
go
exec insert_syntax 'host_id',
'Transact-SQL',          3 ,
'     host_id ( )'
go
exec insert_syntax 'host_name',
'Transact-SQL',          1 ,
'  host_name - Returns the current host computer name of the client'
go
exec insert_syntax 'host_name',
'Transact-SQL',          2 ,
'       process (not the Server process).'
go
exec insert_syntax 'host_name',
'Transact-SQL',          3 ,
'     host_name( )'
go
exec insert_syntax 'index_col',
'Transact-SQL',          1 ,
'  index_col - Returns the name of the indexed column; returns NULL'
go
exec insert_syntax 'index_col',
'Transact-SQL',          2 ,
'       if object_name is not a table or view name.'
go
exec insert_syntax 'index_col',
'Transact-SQL',          3 ,
'     index_col(object_name, index_id, key_# [, user_id])'
go
exec insert_syntax 'inttohex',
'Transact-SQL',          1 ,
'  inttohex - Returns the platform-independent hexadecimal'
go
exec insert_syntax 'inttohex',
'Transact-SQL',          2 ,
'       equivalent of an integer.'
go
exec insert_syntax 'inttohex',
'Transact-SQL',          3 ,
'     inttohex(integer_expression)'
go
exec insert_syntax 'isnull',
'Transact-SQL',          1 ,
'  isnull - Substitutes the value specified in expression2 when'
go
exec insert_syntax 'isnull',
'Transact-SQL',          2 ,
'       expression1 evaluates to NULL. The datatypes of the'
go
exec insert_syntax 'isnull',
'Transact-SQL',          3 ,
'       expressions must convert implicitly, or you'
go
exec insert_syntax 'isnull',
'Transact-SQL',          4 ,
'       must use the convert function.'
go
exec insert_syntax 'isnull',
'Transact-SQL',          5 ,
'     isnull (expression1, expression2)'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          1 ,
'  lct_admin - Manages the log segment''s last-chance threshold.'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          2 ,
'       lastchance creates a last-chance threshold in the'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          3 ,
'       specified database. logfull returns 1 if the last-chance'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          4 ,
'       threshold has been crossed in the specified database'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          5 ,
'       and 0 if it has not. unsuspend awakens suspended'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          6 ,
'       tasks in the database and disables the last-chance'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          7 ,
'       threshold if that threshold has been crossed.'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          8 ,
'       reserve returns the number of free log pages required to'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          9 ,
'       successfully dump a transaction log of the specified size.'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          10,
'     lct_admin({{ "lastchance" | "logfull" | "unsuspend"} ,'
go
exec insert_syntax 'lct_admin',
'Transact-SQL',          11,
'      database_id} | "reserve", log_pages})'
go
exec insert_syntax 'log',
'Transact-SQL',          1 ,
'  log - Returns the natural logarithm of the specified value.'
go
exec insert_syntax 'log',
'Transact-SQL',          2 ,
'       log(approx_numeric)'
go
exec insert_syntax 'log10',
'Transact-SQL',          1 ,
'  log10 - Returns the base 10 logarithm of the specified value.'
go
exec insert_syntax 'log10',
'Transact-SQL',          2 ,
'     log10(approx_numeric)'
go
exec insert_syntax 'lower',
'Transact-SQL',          1 ,
'  lower -  Converts uppercase to lowercase, returning a character value.'
go
exec insert_syntax 'lower',
'Transact-SQL',          2 ,
'     lower (char_expr)'
go
exec insert_syntax 'ltrim',
'Transact-SQL',          1 ,
'  ltrim - Removes leading blanks from the character expression.'
go
exec insert_syntax 'ltrim',
'Transact-SQL',          2 ,
'       Only values equivalent to the space character in the'
go
exec insert_syntax 'ltrim',
'Transact-SQL',          3 ,
'       current character set are removed.'
go
exec insert_syntax 'ltrim',
'Transact-SQL',          4 ,
'     ltrim(char_expr)'
go
exec insert_syntax 'max',
'Transact-SQL',          1 ,
'  max - Highest value in the expression.'
go
exec insert_syntax 'max',
'Transact-SQL',          2 ,
'     max(expression)'
go
exec insert_syntax 'min',
'Transact-SQL',          1 ,
'  min - Lowest value in the expression.'
go
exec insert_syntax 'min',
'Transact-SQL',          2 ,
'     min(expression)'
go
exec insert_syntax 'object_id',
'Transact-SQL',          1 ,
'  object_id - Returns the object ID.'
go
exec insert_syntax 'object_id',
'Transact-SQL',          2 ,
'     object_id(object_name)'
go
exec insert_syntax 'object_name',
'Transact-SQL',          1 ,
'  object_name - Returns the object name.'
go
exec insert_syntax 'object_name',
'Transact-SQL',          2 ,
'     object_name(object_id[, database_id])'
go
exec insert_syntax 'patindex',
'Transact-SQL',          1 ,
'  patindex - Returns an integer representing the'
go
exec insert_syntax 'patindex',
'Transact-SQL',          2 ,
'       starting position of the first occurrence of pattern'
go
exec insert_syntax 'patindex',
'Transact-SQL',          3 ,
'       in the specified character expression, or a zero if'
go
exec insert_syntax 'patindex',
'Transact-SQL',          4 ,
'       pattern is not found. By default, patindex returns the'
go
exec insert_syntax 'patindex',
'Transact-SQL',          5 ,
'       offset in characters; to return the offset in bytes'
go
exec insert_syntax 'patindex',
'Transact-SQL',          6 ,
'       (multibyte character strings), specify using bytes.'
go
exec insert_syntax 'patindex',
'Transact-SQL',          7 ,
'       The % wildcard character must precede and follow pattern'
go
exec insert_syntax 'patindex',
'Transact-SQL',          8 ,
'       (except when searching for first or last characters).'
go
exec insert_syntax 'patindex',
'Transact-SQL',          9 ,
'       Can be used on text data.'
go
exec insert_syntax 'patindex',
'Transact-SQL',          10,
'     patindex("%pattern%", char_expr [, using'
go
exec insert_syntax 'patindex',
'Transact-SQL',          11,
'      {bytes | chars | characters} ] )'
go
exec insert_syntax 'pi',
'Transact-SQL',          1 ,
'  pi - Returns the constant value of 3.1415926535897931.'
go
exec insert_syntax 'pi',
'Transact-SQL',          2 ,
'     pi()'
go
exec insert_syntax 'power',
'Transact-SQL',          1 ,
'  power - Returns the value of numeric raised to the power power. Results'
go
exec insert_syntax 'power',
'Transact-SQL',          2 ,
'       are of the same type as numeric. For expressions of type numeric'
go
exec insert_syntax 'power',
'Transact-SQL',          3 ,
'       or decimal, the results have an internal precision of 77 and a'
go
exec insert_syntax 'power',
'Transact-SQL',          4 ,
'       scale equal to that of the expression.'
go
exec insert_syntax 'power',
'Transact-SQL',          5 ,
'     power(numeric, power)'
go
exec insert_syntax 'proc_role',
'Transact-SQL',          1 ,
'  proc_role - Checks to see if the invoking user possesses the'
go
exec insert_syntax 'proc_role',
'Transact-SQL',          2 ,
'      correct role to execute the procedure. Returns 1 if the'
go
exec insert_syntax 'proc_role',
'Transact-SQL',          3 ,
'      invoker has the required role. Otherwise, returns 0.'
go
exec insert_syntax 'proc_role',
'Transact-SQL',          4 ,
'     proc_role ("sa_role" | "sso_role" | "oper_role")'
go
exec insert_syntax 'radians',
'Transact-SQL',          1 ,
'  radians - Converts degrees to radians. Results are of'
go
exec insert_syntax 'radians',
'Transact-SQL',          2 ,
'       the same type as numeric. For expressions of'
go
exec insert_syntax 'radians',
'Transact-SQL',          3 ,
'       type numeric or decimal, the results have an'
go
exec insert_syntax 'radians',
'Transact-SQL',          4 ,
'       internal precision of 77 and a scale equal to'
go
exec insert_syntax 'radians',
'Transact-SQL',          5 ,
'       that of the numeric expression. When money'
go
exec insert_syntax 'radians',
'Transact-SQL',          6 ,
'       datatypes are used, internal conversion to'
go
exec insert_syntax 'radians',
'Transact-SQL',          7 ,
'       float may cause loss of precision.'
go
exec insert_syntax 'radians',
'Transact-SQL',          8 ,
'     radians(numeric)'
go
exec insert_syntax 'rand',
'Transact-SQL',          1 ,
'  rand - Returns a random float value between 0 and'
go
exec insert_syntax 'rand',
'Transact-SQL',          2 ,
'       1, using the optional integer as a seed value.'
go
exec insert_syntax 'rand',
'Transact-SQL',          3 ,
'     rand([integer])'
go
exec insert_syntax 'replicate',
'Transact-SQL',          1 ,
'  replicate - Returns a string with the same datatype as char_expr,'
go
exec insert_syntax 'replicate',
'Transact-SQL',          2 ,
'       containing the same expression repeated the specified'
go
exec insert_syntax 'replicate',
'Transact-SQL',          3 ,
'       number of times or as many times as will fit into a'
go
exec insert_syntax 'replicate',
'Transact-SQL',          4 ,
'       255 byte space, whichever is less.'
go
exec insert_syntax 'replicate',
'Transact-SQL',          5 ,
'     replicate(char_expr, integer_expr)'
go
exec insert_syntax 'reserved_pgs',
'Transact-SQL',          1 ,
'  reserved_pgs - Returns the number of pages allocated to table'
go
exec insert_syntax 'reserved_pgs',
'Transact-SQL',          2 ,
'        or index. This function does report pages used for'
go
exec insert_syntax 'reserved_pgs',
'Transact-SQL',          3 ,
'        internal structures.'
go
exec insert_syntax 'reserved_pgs',
'Transact-SQL',          4 ,
'     reserved_pgs(object_id, {doampg|ioampg})'
go
exec insert_syntax 'reverse',
'Transact-SQL',          1 ,
'  reverse - Returns the reverse of char_expr; if char_expr is "abcd",'
go
exec insert_syntax 'reverse',
'Transact-SQL',          2 ,
'       it returns "dcba".'
go
exec insert_syntax 'reverse',
'Transact-SQL',          3 ,
'     reverse(char_expr)'
go
exec insert_syntax 'right',
'Transact-SQL',          1 ,
'  right - Returns the part of the character expression starting'
go
exec insert_syntax 'right',
'Transact-SQL',          2 ,
'       the specified number of characters from the right. Return'
go
exec insert_syntax 'right',
'Transact-SQL',          3 ,
'       value has the same datatype as the character expression.'
go
exec insert_syntax 'right',
'Transact-SQL',          4 ,
'     right(char_expr, integer_expr)'
go
exec insert_syntax 'round',
'Transact-SQL',          1 ,
'  round - Rounds the numeric so that it has integer significant'
go
exec insert_syntax 'round',
'Transact-SQL',          2 ,
'       digits. A positive integer determines the number of'
go
exec insert_syntax 'round',
'Transact-SQL',          3 ,
'       significant digits to the right of the decimal point;'
go
exec insert_syntax 'round',
'Transact-SQL',          4 ,
'       a negative integer, the number of significant digits'
go
exec insert_syntax 'round',
'Transact-SQL',          5 ,
'       to the left of the decimal point. Results are of the same'
go
exec insert_syntax 'round',
'Transact-SQL',          6 ,
'       type as the numeric expression and, for numeric and decimal'
go
exec insert_syntax 'round',
'Transact-SQL',          7 ,
'       expressions, have an internal precision of 77 and scale'
go
exec insert_syntax 'round',
'Transact-SQL',          8 ,
'       equal to that of the numeric expression.'
go
exec insert_syntax 'round',
'Transact-SQL',          9 ,
'     round(numeric, integer)'
go
exec insert_syntax 'rowcnt',
'Transact-SQL',          1 ,
'  rowcnt -Returns the number of rows in a table (estimate).'
go
exec insert_syntax 'rowcnt',
'Transact-SQL',          2 ,
'     rowcnt(doampg)'
go
exec insert_syntax 'rtrim',
'Transact-SQL',          1 ,
'  rtrim - Removes trailing blanks. Only values equivalent to the'
go
exec insert_syntax 'rtrim',
'Transact-SQL',          2 ,
'       space character in the current character set are removed.'
go
exec insert_syntax 'rtrim',
'Transact-SQL',          3 ,
'     rtrim(char_expr)'
go
exec insert_syntax 'show_role',
'Transact-SQL',          1 ,
'  show_role - Returns the user''s current active roles, if any'
go
exec insert_syntax 'show_role',
'Transact-SQL',          2 ,
'       (sa_role, sso_role, or oper_role). If the user has no'
go
exec insert_syntax 'show_role',
'Transact-SQL',          3 ,
'       roles, returns NULL.'
go
exec insert_syntax 'show_role',
'Transact-SQL',          4 ,
'     show_role( )'
go
exec insert_syntax 'sign',
'Transact-SQL',          1 ,
'  sign - Returns the positive (+1), zero (0), or negative (-1). Results'
go
exec insert_syntax 'sign',
'Transact-SQL',          2 ,
'       are of the same type, and have the same precision and scale,'
go
exec insert_syntax 'sign',
'Transact-SQL',          3 ,
'       as the numeric expression.'
go
exec insert_syntax 'sign',
'Transact-SQL',          4 ,
'     sign(numeric)'
go
exec insert_syntax 'sin',
'Transact-SQL',          1 ,
'  sin - Returns the sine of the specified angle (measured in radians).'
go
exec insert_syntax 'sin',
'Transact-SQL',          2 ,
'     sin(approx_numeric)'
go
exec insert_syntax 'soundex',
'Transact-SQL',          1 ,
'  soundex - Returns a four-character soundex code for character'
go
exec insert_syntax 'soundex',
'Transact-SQL',          2 ,
'       strings that are composed of a contiguous sequence of'
go
exec insert_syntax 'soundex',
'Transact-SQL',          3 ,
'       valid single- or double-byte roman letters.'
go
exec insert_syntax 'soundex',
'Transact-SQL',          4 ,
'     soundex(char_expr)'
go
exec insert_syntax 'space',
'Transact-SQL',          1 ,
'  space - Returns a string with the indicated'
go
exec insert_syntax 'space',
'Transact-SQL',          2 ,
'       number of single-byte spaces.'
go
exec insert_syntax 'space',
'Transact-SQL',          3 ,
'     space(integer_expr)'
go
exec insert_syntax 'sqrt',
'Transact-SQL',          1 ,
'  sqrt - Returns the square root of the specified value.'
go
exec insert_syntax 'sqrt',
'Transact-SQL',          2 ,
'     sqrt(approx_numeric)'
go
exec insert_syntax 'str',
'Transact-SQL',          1 ,
'  str - Returns a character representation of the floating point'
go
exec insert_syntax 'str',
'Transact-SQL',          2 ,
'       number. length sets the number of characters to be'
go
exec insert_syntax 'str',
'Transact-SQL',          3 ,
'       returned  (including the decimal point, all digits to'
go
exec insert_syntax 'str',
'Transact-SQL',          4 ,
'       the right and left of the decimal point, and blanks);'
go
exec insert_syntax 'str',
'Transact-SQL',          5 ,
'       decimal sets the number of decimal digits to be returned.'
go
exec insert_syntax 'str',
'Transact-SQL',          6 ,
'     str(approx_numeric[, length [, decimal] ])'
go
exec insert_syntax 'stuff',
'Transact-SQL',          1 ,
'  stuff - Deletes length characters from char_expr1 at start,'
go
exec insert_syntax 'stuff',
'Transact-SQL',          2 ,
'       then inserts char_expr2 into char_expr1 at start.'
go
exec insert_syntax 'stuff',
'Transact-SQL',          3 ,
'       To delete characters without inserting other characters,'
go
exec insert_syntax 'stuff',
'Transact-SQL',          4 ,
'       char_expr2 should be NULL (not "", which indicates'
go
exec insert_syntax 'stuff',
'Transact-SQL',          5 ,
'       a single space).'
go
exec insert_syntax 'stuff',
'Transact-SQL',          6 ,
'     stuff(char_expr1, start, length, char_expr2)'
go
exec insert_syntax 'substring',
'Transact-SQL',          1 ,
'  substring - Returns part of a character or binary string. start'
go
exec insert_syntax 'substring',
'Transact-SQL',          2 ,
'       specifies the character position at which the substring begins.'
go
exec insert_syntax 'substring',
'Transact-SQL',          3 ,
'       length specifies the number of characters in the substring.'
go
exec insert_syntax 'substring',
'Transact-SQL',          4 ,
'     substring(expression, start, length)'
go
exec insert_syntax 'sum',
'Transact-SQL',          1 ,
'  sum - Total of (distinct) values in the numeric column.'
go
exec insert_syntax 'sum',
'Transact-SQL',          2 ,
'     sum([all | distinct] expression)'
go
exec insert_syntax 'suser_id',
'Transact-SQL',          1 ,
'  suser_id - Returns the server user''s ID number from syslogins.'
go
exec insert_syntax 'suser_id',
'Transact-SQL',          2 ,
'       If no server_user_name is supplied, it returns the'
go
exec insert_syntax 'suser_id',
'Transact-SQL',          3 ,
'       server ID of the current user.'
go
exec insert_syntax 'suser_id',
'Transact-SQL',          4 ,
'     suser_id([server_user_name])'
go
exec insert_syntax 'suser_name',
'Transact-SQL',          1 ,
'  suser_name - Returns the server user''s name. Server user''s'
go
exec insert_syntax 'suser_name',
'Transact-SQL',          2 ,
'       IDs are stored in syslogins. If no server_user_id is'
go
exec insert_syntax 'suser_name',
'Transact-SQL',          3 ,
'       supplied, it returns the name of the current user.'
go
exec insert_syntax 'suser_name',
'Transact-SQL',          4 ,
'     suser_name ([server_user_id])'
go
exec insert_syntax 'tan',
'Transact-SQL',          1 ,
'  tan - Returns the tangent of the specified angle'
go
exec insert_syntax 'tan',
'Transact-SQL',          2 ,
'       (measured in radians).'
go
exec insert_syntax 'tan',
'Transact-SQL',          3 ,
'     tan(approx_numeric)'
go
exec insert_syntax 'textptr',
'Transact-SQL',          1 ,
'  textptr - Returns the text pointer value, a 16-byte binary value.'
go
exec insert_syntax 'textptr',
'Transact-SQL',          2 ,
'       The text pointer is checked to ensure that it points to'
go
exec insert_syntax 'textptr',
'Transact-SQL',          3 ,
'       the first text page.'
go
exec insert_syntax 'textptr',
'Transact-SQL',          4 ,
'     textptr (text_columname)'
go
exec insert_syntax 'tsequal',
'Transact-SQL',          1 ,
'  tsequal - Compares timestamp values to prevent update on a row'
go
exec insert_syntax 'tsequal',
'Transact-SQL',          2 ,
'       that has been modified since it was selected for browsing.'
go
exec insert_syntax 'tsequal',
'Transact-SQL',          3 ,
'       timestamp is the timestamp of the browsed row; timestamp2'
go
exec insert_syntax 'tsequal',
'Transact-SQL',          4 ,
'       is the timestamp of the stored row. Allows you to use'
go
exec insert_syntax 'tsequal',
'Transact-SQL',          5 ,
'       browse mode without calling DB-Library.'
go
exec insert_syntax 'tsequal',
'Transact-SQL',          6 ,
'     tsequal(timestamp, timestamp2)'
go
exec insert_syntax 'upper',
'Transact-SQL',          1 ,
'  upper - Converts lowercase to uppercase, returning a character value.'
go
exec insert_syntax 'upper',
'Transact-SQL',          2 ,
'     upper(char_expr)'
go
exec insert_syntax 'used_pgs',
'Transact-SQL',          1 ,
'  used_pgs - Returns the total number of pages used by a table'
go
exec insert_syntax 'used_pgs',
'Transact-SQL',          2 ,
'       and its clustered index.'
go
exec insert_syntax 'used_pgs',
'Transact-SQL',          3 ,
'     used_pgs(object_id, doampg, ioampg)'
go
exec insert_syntax 'user',
'Transact-SQL',          1 ,
'  user - Returns the user''s name.'
go
exec insert_syntax 'user',
'Transact-SQL',          2 ,
'     user'
go
exec insert_syntax 'user_id',
'Transact-SQL',          1 ,
'  user_id - Returns the user''s ID number. Reports the number'
go
exec insert_syntax 'user_id',
'Transact-SQL',          2 ,
'       from sysusers in the current database. If no user_name'
go
exec insert_syntax 'user_id',
'Transact-SQL',          3 ,
'       is supplied, it returns the ID of the current user.'
go
exec insert_syntax 'user_id',
'Transact-SQL',          4 ,
'     user_id([user_name])'
go
exec insert_syntax 'user_name',
'Transact-SQL',          1 ,
'  user_name - Returns the user''s name, based on the user''s ID'
go
exec insert_syntax 'user_name',
'Transact-SQL',          2 ,
'       in the current database. If no user_id is supplied, it'
go
exec insert_syntax 'user_name',
'Transact-SQL',          3 ,
'       returns the name of the current user.'
go
exec insert_syntax 'user_name',
'Transact-SQL',          4 ,
'     user_name([user_id])'
go
exec insert_syntax 'valid_name',
'Transact-SQL',          1 ,
'  valid_name - Returns 0 if the character expression is not a'
go
exec insert_syntax 'valid_name',
'Transact-SQL',          2 ,
'       valid identifier (illegal characters or more than 30'
go
exec insert_syntax 'valid_name',
'Transact-SQL',          3 ,
'       bytes long), a nonzero number if it is a valid identifier.'
go
exec insert_syntax 'valid_name',
'Transact-SQL',          4 ,
'     valid_name(character_expression)'
go
exec insert_syntax 'valid_user',
'Transact-SQL',          1 ,
'  valid_user - Returns 1 if the specified ID is a valid user'
go
exec insert_syntax 'valid_user',
'Transact-SQL',          2 ,
'       or alias in at least one database on this SQL Server.'
go
exec insert_syntax 'valid_user',
'Transact-SQL',          3 ,
'       You must have the sa_role or sso_role role to use this'
go
exec insert_syntax 'valid_user',
'Transact-SQL',          4 ,
'       function on a server_user_id other than your own.'
go
exec insert_syntax 'valid_user',
'Transact-SQL',          5 ,
'     valid_user(server_user_id)'
go




exec insert_syntax 'sp_addalias',
'System Procedure',      1 ,
'sp_addalias - Allows a SQL Server user to be known in a'
go
exec insert_syntax 'sp_addalias',
'System Procedure',      2 ,
'        database as another user.'
go
exec insert_syntax 'sp_addalias',
'System Procedure',      3 ,
'     sp_addalias loginame, name_in_db'
go
exec insert_syntax 'sp_addauditrecord',
'System Procedure',      1 ,
'sp_addauditrecord - Allows users to enter user-defined audit records'
go
exec insert_syntax 'sp_addauditrecord',
'System Procedure',      2 ,
'        (comments) into the audit trail.'
go
exec insert_syntax 'sp_addauditrecord',
'System Procedure',      3 ,
'     sp_addauditrecord [text] [, db_name] [, obj_name]'
go
exec insert_syntax 'sp_addauditrecord',
'System Procedure',      4 ,
'      [, owner_name] [, dbid] [, objid]'
go
exec insert_syntax 'sp_addgroup',
'System Procedure',      1 ,
'sp_addgroup - Adds a group to a database. Groups are used as'
go
exec insert_syntax 'sp_addgroup',
'System Procedure',      2 ,
'        collective names in granting and revoking'
go
exec insert_syntax 'sp_addgroup',
'System Procedure',      3 ,
'        privileges.'
go
exec insert_syntax 'sp_addgroup',
'System Procedure',      4 ,
'     sp_addgroup grpname'
go
exec insert_syntax 'sp_addlanguage',
'System Procedure',      1 ,
'sp_addlanguage - Defines the names of the months and days for an'
go
exec insert_syntax 'sp_addlanguage',
'System Procedure',      2 ,
'        alternate language, and its date format.'
go
exec insert_syntax 'sp_addlanguage',
'System Procedure',      3 ,
'     sp_addlanguage language, alias, months, shortmons,'
go
exec insert_syntax 'sp_addlanguage',
'System Procedure',      4 ,
'      days, datefmt, datefirst'
go
exec insert_syntax 'sp_addlogin',
'System Procedure',      1 ,
'sp_addlogin - Adds a new user account to SQL Server.'
go
exec insert_syntax 'sp_addlogin',
'System Procedure',      2 ,
'     sp_addlogin loginame, passwd [, defdb [, deflanguage'
go
exec insert_syntax 'sp_addlogin',
'System Procedure',      3 ,
'      [, fullname]]]'
go
exec insert_syntax 'sp_addmessage',
'System Procedure',      1 ,
'sp_addmessage - Adds user-defined messages to sysusermessages for'
go
exec insert_syntax 'sp_addmessage',
'System Procedure',      2 ,
'        use by stored procedure print and raiserror calls'
go
exec insert_syntax 'sp_addmessage',
'System Procedure',      3 ,
'        and by sp_bindmsg.'
go
exec insert_syntax 'sp_addmessage',
'System Procedure',      4 ,
'     sp_addmessage message_num, message_text [, language]'
go
exec insert_syntax 'sp_addremotelogin',
'System Procedure',      1 ,
'sp_addremotelogin - Authorizes a new remote server user by adding an'
go
exec insert_syntax 'sp_addremotelogin',
'System Procedure',      2 ,
'        entry to master.dbo.sysremotelogins.'
go
exec insert_syntax 'sp_addremotelogin',
'System Procedure',      3 ,
'     sp_addremotelogin remoteserver [, loginame'
go
exec insert_syntax 'sp_addremotelogin',
'System Procedure',      4 ,
'      [, remotename] ]'
go
exec insert_syntax 'sp_addsegment',
'System Procedure',      1 ,
'sp_addsegment - Defines a segment on a database device in the'
go
exec insert_syntax 'sp_addsegment',
'System Procedure',      2 ,
'        current database.'
go
exec insert_syntax 'sp_addsegment',
'System Procedure',      3 ,
'     sp_addsegment segname, dbname, devname'
go
exec insert_syntax 'sp_addserver',
'System Procedure',      1 ,
'sp_addserver - Defines a remote server, or defines the name of'
go
exec insert_syntax 'sp_addserver',
'System Procedure',      2 ,
'        the local server.'
go
exec insert_syntax 'sp_addserver',
'System Procedure',      3 ,
'     sp_addserver lname [, {local | null} [, pname]]'
go
exec insert_syntax 'sp_addthreshold',
'System Procedure',      1 ,
'sp_addthreshold - Creates a threshold to monitor space on a'
go
exec insert_syntax 'sp_addthreshold',
'System Procedure',      2 ,
'        database segment. When free space on the segment'
go
exec insert_syntax 'sp_addthreshold',
'System Procedure',      3 ,
'        falls below the specified level, SQL Server'
go
exec insert_syntax 'sp_addthreshold',
'System Procedure',      4 ,
'        executes the associated stored procedure.'
go
exec insert_syntax 'sp_addthreshold',
'System Procedure',      5 ,
'     sp_addthreshold dbname, segname, free_space, proc_name'
go
exec insert_syntax 'sp_addtype',
'System Procedure',      1 ,
'sp_addtype - Creates a user-defined datatype.'
go
exec insert_syntax 'sp_addtype',
'System Procedure',      2 ,
'     sp_addtype typename,'
go
exec insert_syntax 'sp_addtype',
'System Procedure',      3 ,
'      phystype [(length) | (precision [, scale])]'
go
exec insert_syntax 'sp_addtype',
'System Procedure',      4 ,
'      [, "identity" | nulltype]'
go
exec insert_syntax 'sp_addumpdevice',
'System Procedure',      1 ,
'sp_addumpdevice - Adds a dump device to SQL Server.'
go
exec insert_syntax 'sp_addumpdevice',
'System Procedure',      2 ,
'     sp_addumpdevice {"tape" | "disk"}, logicalname,'
go
exec insert_syntax 'sp_addumpdevice',
'System Procedure',      3 ,
'      physicalname [, tapesize]'
go
exec insert_syntax 'sp_adduser',
'System Procedure',      1 ,
'sp_adduser - Adds a new user to the current database.'
go
exec insert_syntax 'sp_adduser',
'System Procedure',      2 ,
'     sp_adduser loginame [, name_in_db [, grpname]]'
go
exec insert_syntax 'sp_auditdatabase',
'System Procedure',      1 ,
'sp_auditdatabase - Establishes auditing of different types of events'
go
exec insert_syntax 'sp_auditdatabase',
'System Procedure',      2 ,
'        within a database, or of references to objects'
go
exec insert_syntax 'sp_auditdatabase',
'System Procedure',      3 ,
'        within that database from another database.'
go
exec insert_syntax 'sp_auditdatabase',
'System Procedure',      4 ,
'     sp_auditdatabase [dbname [, "ok | fail | both | off"'
go
exec insert_syntax 'sp_auditdatabase',
'System Procedure',      5 ,
'      [, {"d u g r t o"}]]]'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      1 ,
'sp_auditlogin - Audits a SQL Server user''s attempts to access'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      2 ,
'        tables and views; audits the text of a user''s'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      3 ,
'        command batches; lists users on which auditing is'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      4 ,
'        enabled; gives the auditing status of a user; or'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      5 ,
'        displays the status of table, view, or command'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      6 ,
'        text auditing.'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      7 ,
'     sp_auditlogin [login_name [, "table" | "view"'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      8 ,
'      [, "ok" | "fail" | "both" | "off"]]]'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      9 ,
'     sp_auditlogin [login_name [, "cmdtext"'
go
exec insert_syntax 'sp_auditlogin',
'System Procedure',      10,
'      [, "on" | "off"]]]'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      1 ,
'sp_auditobject - Audits accesses to tables and views.'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      2 ,
'     To audit existing tables and views:'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      3 ,
'     sp_auditobject objname, dbname'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      4 ,
'      [, {"ok" | "fail" | "both" | "off"}'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      5 ,
'         [, "{d i s u}"]]'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      6 ,
'     To audit newly created tables and views:'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      7 ,
'     sp_auditobject {"default table"|"default view"},'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      8 ,
'      dbname [, {"ok" | "fail" | "both" | "off"}'
go
exec insert_syntax 'sp_auditobject',
'System Procedure',      9 ,
'      [, "{d i s u}"]]'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      1 ,
'sp_auditoption - Enables or disables system-wide auditing and'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      2 ,
'        global audit options, or reports on the status of'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      3 ,
'        audit options.'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      4 ,
'     sp_auditoption [{"all" | "enable auditing" | "logouts"'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      5 ,
'      | "server boots" | "adhoc records"}'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      6 ,
'      [, {"on" | "off"}]]'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      7 ,
'     sp_auditoption {"logins" | "rpc connections" |'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      8 ,
'      "roles"} [, {"ok" | "fail" | "both" | "off"}]'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      9 ,
'     sp_auditoption "errors" [, {"nonfatal" | "fatal"'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      10,
'      | "both"}]'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      11,
'     sp_auditoption "{sa | sso | oper | navigator |'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      12,
'        replication} commands"'
go
exec insert_syntax 'sp_auditoption',
'System Procedure',      13,
'      [, {"ok" | "fail" | "both" | "off"}]'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      1 ,
'sp_auditsproc - Audits the execution of stored procedures and'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      2 ,
'        triggers.'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      3 ,
'     To establish auditing for existing stored procedures and triggers:'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      4 ,
'     sp_auditsproc [sproc_name | "all", dbname'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      5 ,
'      [, {"ok" | "fail" | "both" | "off"}]]'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      6 ,
'     To establish auditing for future stored procedures and triggers:'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      7 ,
'     sp_auditsproc "default", dbname'
go
exec insert_syntax 'sp_auditsproc',
'System Procedure',      8 ,
'      [, {"ok" | "fail" | "both" | "off"}]'
go
exec insert_syntax 'sp_bindcache',
'System Procedure',      1 ,
'sp_bindcache - Binds a database, table, index, text object, or'
go
exec insert_syntax 'sp_bindcache',
'System Procedure',      2 ,
'        image object to a data cache.'
go
exec insert_syntax 'sp_bindcache',
'System Procedure',      3 ,
'     sp_bindcache cachename, dbname'
go
exec insert_syntax 'sp_bindcache',
'System Procedure',      4 ,
'      [, [ownername.]tablename'
go
exec insert_syntax 'sp_bindcache',
'System Procedure',      5 ,
'      [, indexname | "text only"]]'
go
exec insert_syntax 'sp_bindefault',
'System Procedure',      1 ,
'sp_bindefault - Binds a user-defined default to a column or'
go
exec insert_syntax 'sp_bindefault',
'System Procedure',      2 ,
'        user-defined datatype.'
go
exec insert_syntax 'sp_bindefault',
'System Procedure',      3 ,
'     sp_bindefault defname, objname [, futureonly]'
go
exec insert_syntax 'sp_bindmsg',
'System Procedure',      1 ,
'sp_bindmsg - Binds a user message to a referential integrity'
go
exec insert_syntax 'sp_bindmsg',
'System Procedure',      2 ,
'        constraint or check constraint.'
go
exec insert_syntax 'sp_bindmsg',
'System Procedure',      3 ,
'     sp_bindmsg constrname, msgid'
go
exec insert_syntax 'sp_bindrule',
'System Procedure',      1 ,
'sp_bindrule - Binds a rule to a column or user-defined'
go
exec insert_syntax 'sp_bindrule',
'System Procedure',      2 ,
'        datatype.'
go
exec insert_syntax 'sp_bindrule',
'System Procedure',      3 ,
'     sp_bindrule rulename, objname [, futureonly]'
go
exec insert_syntax 'sp_cacheconfig',
'System Procedure',      1 ,
'sp_cacheconfig - Creates, configures, reconfigures, and drops data'
go
exec insert_syntax 'sp_cacheconfig',
'System Procedure',      2 ,
'        caches, and provides information about them.'
go
exec insert_syntax 'sp_cacheconfig',
'System Procedure',      3 ,
'     sp_cacheconfig [cachename [ ,"cache_size[P|K|M|G]" ]'
go
exec insert_syntax 'sp_cacheconfig',
'System Procedure',      4 ,
'      [,logonly | mixed ]]'
go
exec insert_syntax 'sp_cachestrategy',
'System Procedure',      1 ,
'sp_cachestrategy - Enables or disables prefetching (large I/O) and'
go
exec insert_syntax 'sp_cachestrategy',
'System Procedure',      2 ,
'        MRU cache replacement strategy for a table,'
go
exec insert_syntax 'sp_cachestrategy',
'System Procedure',      3 ,
'        index, text object, or image object.'
go
exec insert_syntax 'sp_cachestrategy',
'System Procedure',      4 ,
'     sp_cachestrategy dbname , [ownername.]tablename'
go
exec insert_syntax 'sp_cachestrategy',
'System Procedure',      5 ,
'      [, indexname | "text only" | "table only"'
go
exec insert_syntax 'sp_cachestrategy',
'System Procedure',      6 ,
'      [, { prefetch | mru }, { "on" | "off"}]]'
go
exec insert_syntax 'sp_changedbowner',
'System Procedure',      1 ,
'sp_changedbowner - Changes the owner of a database. Do not change'
go
exec insert_syntax 'sp_changedbowner',
'System Procedure',      2 ,
'        the owner of the sybsystemprocs database.'
go
exec insert_syntax 'sp_changedbowner',
'System Procedure',      3 ,
'     sp_changedbowner loginame [, true ]'
go
exec insert_syntax 'sp_changegroup',
'System Procedure',      1 ,
'sp_changegroup - Changes a user''s group.'
go
exec insert_syntax 'sp_changegroup',
'System Procedure',      2 ,
'     sp_changegroup grpname, username'
go
exec insert_syntax 'sp_checknames',
'System Procedure',      1 ,
'sp_checknames - Checks the current database for names that'
go
exec insert_syntax 'sp_checknames',
'System Procedure',      2 ,
'        contain characters not in the 7-bit ASCII set.'
go
exec insert_syntax 'sp_checknames',
'System Procedure',      3 ,
'     sp_checknames'
go
exec insert_syntax 'sp_checkreswords',
'System Procedure',      1 ,
'sp_checkreswords - Detects and displays identifiers that are'
go
exec insert_syntax 'sp_checkreswords',
'System Procedure',      2 ,
'        Transact-SQL reserved words.  Checks server'
go
exec insert_syntax 'sp_checkreswords',
'System Procedure',      3 ,
'        names, device names, database names, segment'
go
exec insert_syntax 'sp_checkreswords',
'System Procedure',      4 ,
'        names, user-defined datatypes, object names,'
go
exec insert_syntax 'sp_checkreswords',
'System Procedure',      5 ,
'        column names, user names, login names, and remote'
go
exec insert_syntax 'sp_checkreswords',
'System Procedure',      6 ,
'        login names.'
go
exec insert_syntax 'sp_checkreswords',
'System Procedure',      7 ,
'     sp_checkreswords [user_name_param]'
go
exec insert_syntax 'sp_chgattribute',
'System Procedure',      1 ,
'sp_chgattribute - Changes the max_rows_per_page value for future'
go
exec insert_syntax 'sp_chgattribute',
'System Procedure',      2 ,
'        space allocations of a table or index.'
go
exec insert_syntax 'sp_chgattribute',
'System Procedure',      3 ,
'     sp_chgattribute objname, optname, optvalue'
go
exec insert_syntax 'sp_clearstats',
'System Procedure',      1 ,
'sp_clearstats - Initiates a new accounting period for all server'
go
exec insert_syntax 'sp_clearstats',
'System Procedure',      2 ,
'        users or for a specified user. Prints statistics'
go
exec insert_syntax 'sp_clearstats',
'System Procedure',      3 ,
'        for the previous period by executing'
go
exec insert_syntax 'sp_clearstats',
'System Procedure',      4 ,
'        sp_reportstats.'
go
exec insert_syntax 'sp_clearstats',
'System Procedure',      5 ,
'     sp_clearstats [loginame]'
go
exec insert_syntax 'sp_commonkey',
'System Procedure',      1 ,
'sp_commonkey - Defines a common key-columns that are frequently'
go
exec insert_syntax 'sp_commonkey',
'System Procedure',      2 ,
'        joined-between two tables or views.'
go
exec insert_syntax 'sp_commonkey',
'System Procedure',      3 ,
'     sp_commonkey tabaname, tabbname, col1a, col1b'
go
exec insert_syntax 'sp_commonkey',
'System Procedure',      4 ,
'       [, col2a, col2b, ..., col8a, col8b]'
go
exec insert_syntax 'sp_configure',
'System Procedure',      1 ,
'sp_configure - Displays or changes configuration parameters.'
go
exec insert_syntax 'sp_configure',
'System Procedure',      2 ,
'     sp_configure [configname [configvalue] | group_name |'
go
exec insert_syntax 'sp_configure',
'System Procedure',      3 ,
'      non_unique_parameter_fragment]'
go
exec insert_syntax 'sp_configure',
'System Procedure',      4 ,
'     sp_configure "configuration file", 0, {"write" |'
go
exec insert_syntax 'sp_configure',
'System Procedure',      5 ,
'      "read" | "verify" | "restore"} "file_name"'
go
exec insert_syntax 'sp_cursorinfo',
'System Procedure',      1 ,
'sp_cursorinfo - Reports information about a specific cursor or'
go
exec insert_syntax 'sp_cursorinfo',
'System Procedure',      2 ,
'        all cursors that are active for your session.'
go
exec insert_syntax 'sp_cursorinfo',
'System Procedure',      3 ,
'     sp_cursorinfo [{cursor_level | null}] [, cursor_name]'
go
exec insert_syntax 'sp_dboption',
'System Procedure',      1 ,
'sp_dboption - Displays or changes database options.'
go
exec insert_syntax 'sp_dboption',
'System Procedure',      2 ,
'     sp_dboption [dbname, optname, {true | false}]'
go
exec insert_syntax 'sp_dbremap',
'System Procedure',      1 ,
'sp_dbremap - Forces SQL Server to recognize changes made by'
go
exec insert_syntax 'sp_dbremap',
'System Procedure',      2 ,
'        alter database. Run this procedure only if'
go
exec insert_syntax 'sp_dbremap',
'System Procedure',      3 ,
'        instructed to do so by a SQL Server message.'
go
exec insert_syntax 'sp_dbremap',
'System Procedure',      4 ,
'     sp_dbremap dbname'
go
exec insert_syntax 'sp_depends',
'System Procedure',      1 ,
'sp_depends - Displays information about database object'
go
exec insert_syntax 'sp_depends',
'System Procedure',      2 ,
'        dependencies-the view(s), trigger(s), and'
go
exec insert_syntax 'sp_depends',
'System Procedure',      3 ,
'        procedure(s) that depend on a specified table or'
go
exec insert_syntax 'sp_depends',
'System Procedure',      4 ,
'        view, and the table(s) and view(s) that the'
go
exec insert_syntax 'sp_depends',
'System Procedure',      5 ,
'        specified view, trigger, or procedure depends'
go
exec insert_syntax 'sp_depends',
'System Procedure',      6 ,
'        on.'
go
exec insert_syntax 'sp_depends',
'System Procedure',      7 ,
'     sp_depends objname'
go
exec insert_syntax 'sp_diskdefault',
'System Procedure',      1 ,
'sp_diskdefault - Specifies whether or not a database device can be'
go
exec insert_syntax 'sp_diskdefault',
'System Procedure',      2 ,
'        used for database storage if the user does not'
go
exec insert_syntax 'sp_diskdefault',
'System Procedure',      3 ,
'        specify a database device or specifies default'
go
exec insert_syntax 'sp_diskdefault',
'System Procedure',      4 ,
'        with the create database or alter database'
go
exec insert_syntax 'sp_diskdefault',
'System Procedure',      5 ,
'        commands.'
go
exec insert_syntax 'sp_diskdefault',
'System Procedure',      6 ,
'     sp_diskdefault logicalname, {defaulton | defaultoff}'
go
exec insert_syntax 'sp_displaylevel',
'System Procedure',      1 ,
'sp_displaylevel - Sets or  shows which SQL Server configuration'
go
exec insert_syntax 'sp_displaylevel',
'System Procedure',      2 ,
'        parameters  appear  in sp_configure output.'
go
exec insert_syntax 'sp_displaylevel',
'System Procedure',      3 ,
'     sp_displaylevel [loginame [, level]]'
go
exec insert_syntax 'sp_displaylogin',
'System Procedure',      1 ,
'sp_displaylogin - Displays information about a login account.'
go
exec insert_syntax 'sp_displaylogin',
'System Procedure',      2 ,
'     sp_displaylogin [loginame]'
go
exec insert_syntax 'sp_dropalias',
'System Procedure',      1 ,
'sp_dropalias - Removes the alias user name identity established'
go
exec insert_syntax 'sp_dropalias',
'System Procedure',      2 ,
'        with sp_addalias.'
go
exec insert_syntax 'sp_dropalias',
'System Procedure',      3 ,
'     sp_dropalias loginame'
go
exec insert_syntax 'sp_dropdevice',
'System Procedure',      1 ,
'sp_dropdevice - Drops a SQL Server database device or dump'
go
exec insert_syntax 'sp_dropdevice',
'System Procedure',      2 ,
'        device.'
go
exec insert_syntax 'sp_dropdevice',
'System Procedure',      3 ,
'     sp_dropdevice logicalname'
go
exec insert_syntax 'sp_dropglockpromote',
'System Procedure',      1 ,
'sp_dropglockpromote - Removes lock promotion values from a table or'
go
exec insert_syntax 'sp_dropglockpromote',
'System Procedure',      2 ,
'        database.'
go
exec insert_syntax 'sp_dropglockpromote',
'System Procedure',      3 ,
'     sp_dropglockpromote {"database" | "table"}, objname'
go
exec insert_syntax 'sp_dropgroup',
'System Procedure',      1 ,
'sp_dropgroup - Drops a group from a database.'
go
exec insert_syntax 'sp_dropgroup',
'System Procedure',      2 ,
'     sp_dropgroup grpname'
go
exec insert_syntax 'sp_dropkey',
'System Procedure',      1 ,
'sp_dropkey - Removes from the syskeys table a key that had'
go
exec insert_syntax 'sp_dropkey',
'System Procedure',      2 ,
'        been defined using sp_primarykey, sp_foreignkey,'
go
exec insert_syntax 'sp_dropkey',
'System Procedure',      3 ,
'        or sp_commonkey.'
go
exec insert_syntax 'sp_dropkey',
'System Procedure',      4 ,
'     sp_dropkey keytype, tabname [, deptabname]'
go
exec insert_syntax 'sp_droplanguage',
'System Procedure',      1 ,
'sp_droplanguage - Drops an alternate language from the server and'
go
exec insert_syntax 'sp_droplanguage',
'System Procedure',      2 ,
'        removes its row from master.dbo.syslanguages.'
go
exec insert_syntax 'sp_droplanguage',
'System Procedure',      3 ,
'     sp_droplanguage language [, dropmessages]'
go
exec insert_syntax 'sp_droplogin',
'System Procedure',      1 ,
'sp_droplogin - Drops a SQL Server user login by deleting the'
go
exec insert_syntax 'sp_droplogin',
'System Procedure',      2 ,
'        user''s entry in master.dbo.syslogins.'
go
exec insert_syntax 'sp_droplogin',
'System Procedure',      3 ,
'     sp_droplogin loginame'
go
exec insert_syntax 'sp_dropmessage',
'System Procedure',      1 ,
'sp_dropmessage - Drops user-defined messages from'
go
exec insert_syntax 'sp_dropmessage',
'System Procedure',      2 ,
'        sysusermessages.'
go
exec insert_syntax 'sp_dropmessage',
'System Procedure',      3 ,
'     sp_dropmessage message_num [, language]'
go
exec insert_syntax 'sp_dropremotelogin',
'System Procedure',      1 ,
'sp_dropremotelogin - Drops a remote user login.'
go
exec insert_syntax 'sp_dropremotelogin',
'System Procedure',      2 ,
'     sp_dropremotelogin remoteserver [, loginame'
go
exec insert_syntax 'sp_dropremotelogin',
'System Procedure',      3 ,
'      [, remotename] ]'
go
exec insert_syntax 'sp_dropsegment',
'System Procedure',      1 ,
'sp_dropsegment - Drops a segment from a database or unmaps a'
go
exec insert_syntax 'sp_dropsegment',
'System Procedure',      2 ,
'        segment from a particular database device.'
go
exec insert_syntax 'sp_dropsegment',
'System Procedure',      3 ,
'     sp_dropsegment segname, dbname [, device]'
go
exec insert_syntax 'sp_dropserver',
'System Procedure',      1 ,
'sp_dropserver - Drops a server from the list of known servers.'
go
exec insert_syntax 'sp_dropserver',
'System Procedure',      2 ,
'     sp_dropserver server [, droplogins]'
go
exec insert_syntax 'sp_dropthreshold',
'System Procedure',      1 ,
'sp_dropthreshold - Removes a free-space threshold from a segment.'
go
exec insert_syntax 'sp_dropthreshold',
'System Procedure',      2 ,
'     sp_dropthreshold dbname, segname, free_space'
go
exec insert_syntax 'sp_droptype',
'System Procedure',      1 ,
'sp_droptype - Drops a user-defined datatype.'
go
exec insert_syntax 'sp_droptype',
'System Procedure',      2 ,
'     sp_droptype typename'
go
exec insert_syntax 'sp_dropuser',
'System Procedure',      1 ,
'sp_dropuser - Drops a user from the current database.'
go
exec insert_syntax 'sp_dropuser',
'System Procedure',      2 ,
'     sp_dropuser name_in_db'
go
exec insert_syntax 'sp_estspace',
'System Procedure',      1 ,
'sp_estspace - Estimates the amount of space required for a'
go
exec insert_syntax 'sp_estspace',
'System Procedure',      2 ,
'        table and its indexes, and the time needed to'
go
exec insert_syntax 'sp_estspace',
'System Procedure',      3 ,
'        create the index.'
go
exec insert_syntax 'sp_estspace',
'System Procedure',      4 ,
'     sp_estspace table_name, no_of_rows [, fill_factor'
go
exec insert_syntax 'sp_estspace',
'System Procedure',      5 ,
'      [, cols_to_max [, textbin_len [, iosec]]]]'
go
exec insert_syntax 'sp_extendsegment',
'System Procedure',      1 ,
'sp_extendsegment - Extends the range of a segment to another'
go
exec insert_syntax 'sp_extendsegment',
'System Procedure',      2 ,
'        database device.'
go
exec insert_syntax 'sp_extendsegment',
'System Procedure',      3 ,
'     sp_extendsegment segname, dbname, devname'
go
exec insert_syntax 'sp_foreignkey',
'System Procedure',      1 ,
'sp_foreignkey - Defines a foreign key on a table or view in the'
go
exec insert_syntax 'sp_foreignkey',
'System Procedure',      2 ,
'        current database.'
go
exec insert_syntax 'sp_foreignkey',
'System Procedure',      3 ,
'     sp_foreignkey tabname, pktabname, col1 [, col2] ...'
go
exec insert_syntax 'sp_foreignkey',
'System Procedure',      4 ,
'      [, col8]'
go
exec insert_syntax 'sp_getmessage',
'System Procedure',      1 ,
'sp_getmessage - Retrieves stored message strings from sysmessages'
go
exec insert_syntax 'sp_getmessage',
'System Procedure',      2 ,
'        and sysusermessages for print and raiserror'
go
exec insert_syntax 'sp_getmessage',
'System Procedure',      3 ,
'        statements.'
go
exec insert_syntax 'sp_getmessage',
'System Procedure',      4 ,
'     sp_getmessage message_num, result output [, language]'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      1 ,
'sp_grantlogin (Windows NT only) - When Integrated'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      2 ,
'        Security mode or Mixed mode (with Named'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      3 ,
'        Pipes) is active, assigns SQL Server roles'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      4 ,
'        or default permissions to Windows NT users and'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      5 ,
'        groups.'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      6 ,
'     sp_grantlogin'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      7 ,
'       {login_name | group_name}'
go
exec insert_syntax 'sp_grantlogin',
'System Procedure',      8 ,
'       ["role_list" | default]'
go
exec insert_syntax 'sp_help',
'System Procedure',      1 ,
'sp_help - Reports information about a database object (any'
go
exec insert_syntax 'sp_help',
'System Procedure',      2 ,
'        object listed in sysobjects), and about SQL'
go
exec insert_syntax 'sp_help',
'System Procedure',      3 ,
'        Server-supplied or user-defined datatypes.'
go
exec insert_syntax 'sp_help',
'System Procedure',      4 ,
'     sp_help [objname]'
go
exec insert_syntax 'sp_helpartition',
'System Procedure',      1 ,
'sp_helpartition - Lists the first page and the control page for'
go
exec insert_syntax 'sp_helpartition',
'System Procedure',      2 ,
'        each partition in a partitioned table.'
go
exec insert_syntax 'sp_helpartition',
'System Procedure',      3 ,
'     sp_helpartition table_name'
go
exec insert_syntax 'sp_helpcache',
'System Procedure',      1 ,
'sp_helpcache - Displays information about the objects that are'
go
exec insert_syntax 'sp_helpcache',
'System Procedure',      2 ,
'        bound to a data cache or the amount of overhead'
go
exec insert_syntax 'sp_helpcache',
'System Procedure',      3 ,
'        required for a specified cache size.'
go
exec insert_syntax 'sp_helpcache',
'System Procedure',      4 ,
'     sp_helpcache {cache_name | "cache_size[P|K|M|G]"}'
go
exec insert_syntax 'sp_helpconstraint',
'System Procedure',      1 ,
'sp_helpconstraint - Reports information about any integrity'
go
exec insert_syntax 'sp_helpconstraint',
'System Procedure',      2 ,
'        constraints specified for a table. This'
go
exec insert_syntax 'sp_helpconstraint',
'System Procedure',      3 ,
'        information includes the constraint name and the'
go
exec insert_syntax 'sp_helpconstraint',
'System Procedure',      4 ,
'        definition of the bound default, unique or'
go
exec insert_syntax 'sp_helpconstraint',
'System Procedure',      5 ,
'        primary key constraint, referential constraint,'
go
exec insert_syntax 'sp_helpconstraint',
'System Procedure',      6 ,
'        or check constraint.'
go
exec insert_syntax 'sp_helpconstraint',
'System Procedure',      7 ,
'     sp_helpconstraint objname [, detail]'
go
exec insert_syntax 'sp_helpdb',
'System Procedure',      1 ,
'sp_helpdb - Reports information about a particular database'
go
exec insert_syntax 'sp_helpdb',
'System Procedure',      2 ,
'        or about all databases.'
go
exec insert_syntax 'sp_helpdb',
'System Procedure',      3 ,
'     sp_helpdb [dbname]'
go
exec insert_syntax 'sp_helpdevice',
'System Procedure',      1 ,
'sp_helpdevice - Reports information about a particular device or'
go
exec insert_syntax 'sp_helpdevice',
'System Procedure',      2 ,
'        about all SQL Server database devices and dump'
go
exec insert_syntax 'sp_helpdevice',
'System Procedure',      3 ,
'        devices.'
go
exec insert_syntax 'sp_helpdevice',
'System Procedure',      4 ,
'     sp_helpdevice [devname]'
go
exec insert_syntax 'sp_helpgroup',
'System Procedure',      1 ,
'sp_helpgroup - Reports information about a particular group or'
go
exec insert_syntax 'sp_helpgroup',
'System Procedure',      2 ,
'        about all groups in the current database.'
go
exec insert_syntax 'sp_helpgroup',
'System Procedure',      3 ,
'     sp_helpgroup [grpname]'
go
exec insert_syntax 'sp_helpindex',
'System Procedure',      1 ,
'sp_helpindex - Reports information about the indexes created on'
go
exec insert_syntax 'sp_helpindex',
'System Procedure',      2 ,
'        a table.'
go
exec insert_syntax 'sp_helpindex',
'System Procedure',      3 ,
'     sp_helpindex objname'
go
exec insert_syntax 'sp_helpjoins',
'System Procedure',      1 ,
'sp_helpjoins - Lists the columns in two tables or views that are'
go
exec insert_syntax 'sp_helpjoins',
'System Procedure',      2 ,
'        likely join candidates.'
go
exec insert_syntax 'sp_helpjoins',
'System Procedure',      3 ,
'     sp_helpjoins lefttab, righttab'
go
exec insert_syntax 'sp_helpkey',
'System Procedure',      1 ,
'sp_helpkey - Reports information about a primary, foreign, or'
go
exec insert_syntax 'sp_helpkey',
'System Procedure',      2 ,
'        common key of a particular table or view, or'
go
exec insert_syntax 'sp_helpkey',
'System Procedure',      3 ,
'        about all keys in the current database.'
go
exec insert_syntax 'sp_helpkey',
'System Procedure',      4 ,
'     sp_helpkey [tabname]'
go
exec insert_syntax 'sp_helplanguage',
'System Procedure',      1 ,
'sp_helplanguage - Reports information about a particular alternate'
go
exec insert_syntax 'sp_helplanguage',
'System Procedure',      2 ,
'        language or about all languages.'
go
exec insert_syntax 'sp_helplanguage',
'System Procedure',      3 ,
'     sp_helplanguage [language]'
go
exec insert_syntax 'sp_helplog',
'System Procedure',      1 ,
'sp_helplog - Reports the name of the device that contains the'
go
exec insert_syntax 'sp_helplog',
'System Procedure',      2 ,
'        first page of the transaction log.'
go
exec insert_syntax 'sp_helplog',
'System Procedure',      3 ,
'     sp_helplog'
go
exec insert_syntax 'sp_helpremotelogin',
'System Procedure',      1 ,
'sp_helpremotelogin - Reports information about a particular remote'
go
exec insert_syntax 'sp_helpremotelogin',
'System Procedure',      2 ,
'        server''s logins or about all remote servers'' '
go
exec insert_syntax 'sp_helpremotelogin',
'System Procedure',      3 ,
'        logins.'
go
exec insert_syntax 'sp_helpremotelogin',
'System Procedure',      4 ,
'     sp_helpremotelogin [remoteserver [, remotename]]'
go
exec insert_syntax 'sp_helprotect',
'System Procedure',      1 ,
'sp_helprotect - Reports on permissions for database objects,'
go
exec insert_syntax 'sp_helprotect',
'System Procedure',      2 ,
'        users, or groups.'
go
exec insert_syntax 'sp_helprotect',
'System Procedure',      3 ,
'     sp_helprotect [name [, username [, "grant"]]]'
go
exec insert_syntax 'sp_helpsegment',
'System Procedure',      1 ,
'sp_helpsegment - Reports information about a particular segment or'
go
exec insert_syntax 'sp_helpsegment',
'System Procedure',      2 ,
'        about all segments in the current database.'
go
exec insert_syntax 'sp_helpsegment',
'System Procedure',      3 ,
'     sp_helpsegment [segname]'
go
exec insert_syntax 'sp_helpserver',
'System Procedure',      1 ,
'sp_helpserver - Reports information about a particular remote'
go
exec insert_syntax 'sp_helpserver',
'System Procedure',      2 ,
'        server or about all remote servers.'
go
exec insert_syntax 'sp_helpserver',
'System Procedure',      3 ,
'     sp_helpserver [server]'
go
exec insert_syntax 'sp_helpsort',
'System Procedure',      1 ,
'sp_helpsort - Displays SQL Server''s default sort order and'
go
exec insert_syntax 'sp_helpsort',
'System Procedure',      2 ,
'        character set.'
go
exec insert_syntax 'sp_helpsort',
'System Procedure',      3 ,
'     sp_helpsort'
go
exec insert_syntax 'sp_helptext',
'System Procedure',      1 ,
'sp_helptext - Prints the text of a system procedure, trigger,'
go
exec insert_syntax 'sp_helptext',
'System Procedure',      2 ,
'        view, default, rule, or integrity check'
go
exec insert_syntax 'sp_helptext',
'System Procedure',      3 ,
'        constraint.'
go
exec insert_syntax 'sp_helptext',
'System Procedure',      4 ,
'     sp_helptext objname'
go
exec insert_syntax 'sp_helpthreshold',
'System Procedure',      1 ,
'sp_helpthreshold - Reports the segment, free-space value, status,'
go
exec insert_syntax 'sp_helpthreshold',
'System Procedure',      2 ,
'        and stored procedure associated with all'
go
exec insert_syntax 'sp_helpthreshold',
'System Procedure',      3 ,
'        thresholds in the current database or all'
go
exec insert_syntax 'sp_helpthreshold',
'System Procedure',      4 ,
'        thresholds for a particular segment.'
go
exec insert_syntax 'sp_helpthreshold',
'System Procedure',      5 ,
'     sp_helpthreshold [segname]'
go
exec insert_syntax 'sp_helpuser',
'System Procedure',      1 ,
'sp_helpuser - Reports information about a particular user or'
go
exec insert_syntax 'sp_helpuser',
'System Procedure',      2 ,
'        about all users in the current database.'
go
exec insert_syntax 'sp_helpuser',
'System Procedure',      3 ,
'     sp_helpuser [name_in_db]'
go
exec insert_syntax 'sp_indsuspect',
'System Procedure',      1 ,
'sp_indsuspect - Checks user tables for indexes marked as suspect'
go
exec insert_syntax 'sp_indsuspect',
'System Procedure',      2 ,
'        during recovery following a sort order change.'
go
exec insert_syntax 'sp_indsuspect',
'System Procedure',      3 ,
'     sp_indsuspect [tab_name]'
go
exec insert_syntax 'sp_lock',
'System Procedure',      1 ,
'sp_lock - Reports information about processes that'
go
exec insert_syntax 'sp_lock',
'System Procedure',      2 ,
'        currently hold locks.'
go
exec insert_syntax 'sp_lock',
'System Procedure',      3 ,
'     sp_lock [spid1 [, spid2]]'
go
exec insert_syntax 'sp_locklogin',
'System Procedure',      1 ,
'sp_locklogin - Locks a SQL Server account so that the user'
go
exec insert_syntax 'sp_locklogin',
'System Procedure',      2 ,
'        cannot log in, or displays a list of all locked'
go
exec insert_syntax 'sp_locklogin',
'System Procedure',      3 ,
'        accounts.'
go
exec insert_syntax 'sp_locklogin',
'System Procedure',      4 ,
'     sp_locklogin [loginame, "{lock | unlock}"]'
go
exec insert_syntax 'sp_logdevice',
'System Procedure',      1 ,
'sp_logdevice - Moves the transaction log of a database with log'
go
exec insert_syntax 'sp_logdevice',
'System Procedure',      2 ,
'        and data on the same device to a separate'
go
exec insert_syntax 'sp_logdevice',
'System Procedure',      3 ,
'        database device.'
go
exec insert_syntax 'sp_logdevice',
'System Procedure',      4 ,
'     sp_logdevice dbname, devname'
go
exec insert_syntax 'sp_loginconfig',
'System Procedure',      1 ,
'sp_loginconfig (Windows NT only) - Displays the'
go
exec insert_syntax 'sp_loginconfig',
'System Procedure',      2 ,
'        value of one or all integrated'
go
exec insert_syntax 'sp_loginconfig',
'System Procedure',      3 ,
'        security parameters.'
go
exec insert_syntax 'sp_loginconfig',
'System Procedure',      4 ,
'     sp_loginconfig ["parameter_name"]'
go
exec insert_syntax 'sp_logininfo',
'System Procedure',      1 ,
'sp_logininfo (Windows NT only) - Displays all roles'
go
exec insert_syntax 'sp_logininfo',
'System Procedure',      2 ,
'        granted to Windows NT users'
go
exec insert_syntax 'sp_logininfo',
'System Procedure',      3 ,
'        and groups with sp_grantlogin.'
go
exec insert_syntax 'sp_logininfo',
'System Procedure',      4 ,
'     sp_logininfo ["login_name" | "group_name"]'
go
exec insert_syntax 'sp_logiosize',
'System Procedure',      1 ,
'sp_logiosize - Changes the log I/O size used by SQL Server to a'
go
exec insert_syntax 'sp_logiosize',
'System Procedure',      2 ,
'        different memory pool when doing I/O for the'
go
exec insert_syntax 'sp_logiosize',
'System Procedure',      3 ,
'        transaction log of the current database.'
go
exec insert_syntax 'sp_logiosize',
'System Procedure',      4 ,
'     sp_logiosize ["default" | "size" | "all"]'
go
exec insert_syntax 'sp_modifylogin',
'System Procedure',      1 ,
'sp_modifylogin - Modifies the default database, default language,'
go
exec insert_syntax 'sp_modifylogin',
'System Procedure',      2 ,
'        or full name for a SQL Server login account.'
go
exec insert_syntax 'sp_modifylogin',
'System Procedure',      3 ,
'     sp_modifylogin account, column, value'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      1 ,
'sp_modifythreshold - Modifies a threshold by associating it with a'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      2 ,
'        different threshold procedure, free-space level,'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      3 ,
'        or segment name. You cannot use'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      4 ,
'        sp_modifythreshold to change the amount of free'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      5 ,
'        space or the segment name for the last-chance'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      6 ,
'        threshold.'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      7 ,
'     sp_modifythreshold dbname, segname, free_space'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      8 ,
'      [, new_proc_name] [, new_free_space]'
go
exec insert_syntax 'sp_modifythreshold',
'System Procedure',      9 ,
'      [, new_segname]'
go
exec insert_syntax 'sp_monitor',
'System Procedure',      1 ,
'sp_monitor - Displays statistics about SQL Server.'
go
exec insert_syntax 'sp_monitor',
'System Procedure',      2 ,
'     sp_monitor'
go
exec insert_syntax 'sp_password',
'System Procedure',      1 ,
'     sp_password caller_passwd, new_passwd [, loginame]'
go
exec insert_syntax 'sp_placeobject',
'System Procedure',      1 ,
'sp_placeobject - Puts future space allocations for a table or'
go
exec insert_syntax 'sp_placeobject',
'System Procedure',      2 ,
'        index on a particular segment.'
go
exec insert_syntax 'sp_placeobject',
'System Procedure',      3 ,
'     sp_placeobject segname, objname'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      1 ,
'sp_poolconfig - Creates, drops, resizes, and provides information'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      2 ,
'        about memory pools within data caches.'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      3 ,
'     To create a memory pool in an existing cache, or to change pool size:'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      4 ,
'     sp_poolconfig cache_name [, "mem_size[P|K|M|G]",'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      5 ,
'      "config_poolK" [, "affected_poolK"]]'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      6 ,
'     To change a pool''s wash size:'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      7 ,
'     sp_poolconfig cache_name, "io_size",'
go
exec insert_syntax 'sp_poolconfig',
'System Procedure',      8 ,
'      "wash=size[P|K|M|G]"'
go
exec insert_syntax 'sp_primarykey',
'System Procedure',      1 ,
'sp_primarykey - Defines a primary key on a table or view.'
go
exec insert_syntax 'sp_primarykey',
'System Procedure',      2 ,
'     sp_primarykey tabname, col1 [, col2, col3, ..., col8]'
go
exec insert_syntax 'sp_procqmode',
'System Procedure',      1 ,
'sp_procqmode - Displays the query processing mode of a stored'
go
exec insert_syntax 'sp_procqmode',
'System Procedure',      2 ,
'        procedure, view, or trigger.'
go
exec insert_syntax 'sp_procqmode',
'System Procedure',      3 ,
'     sp_procqmode [object_name [, detail]]'
go
exec insert_syntax 'sp_procxmode',
'System Procedure',      1 ,
'sp_procxmode - Displays or changes the transaction modes'
go
exec insert_syntax 'sp_procxmode',
'System Procedure',      2 ,
'        associated with stored procedures.'
go
exec insert_syntax 'sp_procxmode',
'System Procedure',      3 ,
'     sp_procxmode [procname [, tranmode]]'
go
exec insert_syntax 'sp_recompile',
'System Procedure',      1 ,
'sp_recompile - Causes each stored procedure and trigger that'
go
exec insert_syntax 'sp_recompile',
'System Procedure',      2 ,
'        uses the named table to be recompiled the next'
go
exec insert_syntax 'sp_recompile',
'System Procedure',      3 ,
'        time it runs.'
go
exec insert_syntax 'sp_recompile',
'System Procedure',      4 ,
'     sp_recompile objname'
go
exec insert_syntax 'sp_remap',
'System Procedure',      1 ,
'sp_remap - Remaps a release 4.8 or later pre-10.0 stored'
go
exec insert_syntax 'sp_remap',
'System Procedure',      2 ,
'        procedure, trigger, rule, default, or view to be'
go
exec insert_syntax 'sp_remap',
'System Procedure',      3 ,
'        compatible with releases 10.0 and later. Use'
go
exec insert_syntax 'sp_remap',
'System Procedure',      4 ,
'        sp_remap on pre-11.0 objects that the release'
go
exec insert_syntax 'sp_remap',
'System Procedure',      5 ,
'        11.0 upgrade procedure failed to remap.'
go
exec insert_syntax 'sp_remap',
'System Procedure',      6 ,
'     sp_remap objname'
go
exec insert_syntax 'sp_remoteoption',
'System Procedure',      1 ,
'sp_remoteoption - Displays or changes remote login options.'
go
exec insert_syntax 'sp_remoteoption',
'System Procedure',      2 ,
'     sp_remoteoption [remoteserver, loginame, remotename,'
go
exec insert_syntax 'sp_remoteoption',
'System Procedure',      3 ,
'      optname, optvalue]'
go
exec insert_syntax 'sp_rename',
'System Procedure',      1 ,
'sp_rename - Changes the name of a user-created object in the'
go
exec insert_syntax 'sp_rename',
'System Procedure',      2 ,
'        current database.'
go
exec insert_syntax 'sp_rename',
'System Procedure',      3 ,
'     sp_rename objname, newname'
go
exec insert_syntax 'sp_renamedb',
'System Procedure',      1 ,
'sp_renamedb - Changes the name of a database. You cannot rename'
go
exec insert_syntax 'sp_renamedb',
'System Procedure',      2 ,
'        system databases or databases with external'
go
exec insert_syntax 'sp_renamedb',
'System Procedure',      3 ,
'        referential integrity constraints.'
go
exec insert_syntax 'sp_renamedb',
'System Procedure',      4 ,
'     sp_renamedb dbname, newname'
go
exec insert_syntax 'sp_reportstats',
'System Procedure',      1 ,
'sp_reportstats - Reports statistics on system usage.'
go
exec insert_syntax 'sp_reportstats',
'System Procedure',      2 ,
'     sp_reportstats [loginame]'
go
exec insert_syntax 'sp_revokelogin',
'System Procedure',      1 ,
'sp_revokelogin (Windows NT only) - When Integrated'
go
exec insert_syntax 'sp_revokelogin',
'System Procedure',      2 ,
'        Security mode or Mixed mode (with'
go
exec insert_syntax 'sp_revokelogin',
'System Procedure',      3 ,
'        Named Pipes) is active, revokes SQL Server roles'
go
exec insert_syntax 'sp_revokelogin',
'System Procedure',      4 ,
'        and default permissions from Windows NT users and'
go
exec insert_syntax 'sp_revokelogin',
'System Procedure',      5 ,
'        groups.'
go
exec insert_syntax 'sp_revokelogin',
'System Procedure',      6 ,
'     sp_revokelogin {login_name | group_name}'
go
exec insert_syntax 'sp_role',
'System Procedure',      1 ,
'sp_role - Grants or revokes roles to a SQL Server login'
go
exec insert_syntax 'sp_role',
'System Procedure',      2 ,
'        account.'
go
exec insert_syntax 'sp_role',
'System Procedure',      3 ,
'     sp_role {"grant" | "revoke"},'
go
exec insert_syntax 'sp_role',
'System Procedure',      4 ,
'      {sa_role | sso_role | oper_role}, loginame'
go
exec insert_syntax 'sp_serveroption',
'System Procedure',      1 ,
'sp_serveroption - Displays or changes remote server options.'
go
exec insert_syntax 'sp_serveroption',
'System Procedure',      2 ,
'     sp_serveroption [server, optname, {true | false}]'
go
exec insert_syntax 'sp_setlangalias',
'System Procedure',      1 ,
'sp_setlangalias - Assigns or changes the alias for an alternate'
go
exec insert_syntax 'sp_setlangalias',
'System Procedure',      2 ,
'        language.'
go
exec insert_syntax 'sp_setlangalias',
'System Procedure',      3 ,
'     sp_setlangalias language, alias'
go
exec insert_syntax 'sp_setpglockpromote',
'System Procedure',      1 ,
'sp_setpglockpromote - Sets or changes the lock promotion thresholds for'
go
exec insert_syntax 'sp_setpglockpromote',
'System Procedure',      2 ,
'        a database, for a table, or for SQL Server.'
go
exec insert_syntax 'sp_setpglockpromote',
'System Procedure',      3 ,
'     sp_setpglockpromote {"database" | "table"}, objname,'
go
exec insert_syntax 'sp_setpglockpromote',
'System Procedure',      4 ,
'      new_lwm, new_hwm, new_pct'
go
exec insert_syntax 'sp_setpglockpromote',
'System Procedure',      5 ,
'     sp_setpglockpromote server, NULL, new_lwm, new_hwm,'
go
exec insert_syntax 'sp_setpglockpromote',
'System Procedure',      6 ,
'      new_pct'
go
exec insert_syntax 'sp_spaceused',
'System Procedure',      1 ,
'sp_spaceused - Displays the number of rows, the number of data'
go
exec insert_syntax 'sp_spaceused',
'System Procedure',      2 ,
'        pages, and the space used by one table or by all'
go
exec insert_syntax 'sp_spaceused',
'System Procedure',      3 ,
'        tables in the current database.'
go
exec insert_syntax 'sp_spaceused',
'System Procedure',      4 ,
'     sp_spaceused [objname [,1] ]'
go
exec insert_syntax 'sp_syntax',
'System Procedure',      1 ,
'sp_syntax - Displays the syntax of Transact-SQL statements,'
go
exec insert_syntax 'sp_syntax',
'System Procedure',      2 ,
'        system procedures, utilities, and other routines,'
go
exec insert_syntax 'sp_syntax',
'System Procedure',      3 ,
'        depending on which products and corresponding'
go
exec insert_syntax 'sp_syntax',
'System Procedure',      4 ,
'        sp_syntax scripts exist on your server.'
go
exec insert_syntax 'sp_syntax',
'System Procedure',      5 ,
'     sp_syntax word [, mod][, language]'
go
exec insert_syntax 'sp_sysmon',
'System Procedure',      1 ,
'sp_sysmon - Displays performance information.'
go
exec insert_syntax 'sp_sysmon',
'System Procedure',      2 ,
'     sp_sysmon [ interval]'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      1 ,
'sp_thresholdaction - Executes automatically when the number of free'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      2 ,
'        pages on the log segment falls below the'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      3 ,
'        last-chance threshold, unless the threshold is'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      4 ,
'        associated with a different procedure. Sybase'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      5 ,
'        does not provide this procedure.'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      6 ,
'     When a threshold is crossed, SQL Server passes the following'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      7 ,
'     parameters to the threshold procedure by position:'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      8 ,
'     sp_thresholdaction @dbname,'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      9 ,
'             @segment_name,'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      10,
'             @space_left,'
go
exec insert_syntax 'sp_thresholdaction',
'System Procedure',      11,
'             @status'
go
exec insert_syntax 'sp_unbindcache',
'System Procedure',      1 ,
'sp_unbindcache - Unbinds a database, table, index, text object, or'
go
exec insert_syntax 'sp_unbindcache',
'System Procedure',      2 ,
'        image object from a data cache.'
go
exec insert_syntax 'sp_unbindcache',
'System Procedure',      3 ,
'     sp_unbindcache dbname [,[owner.]tablename'
go
exec insert_syntax 'sp_unbindcache',
'System Procedure',      4 ,
'      [, indexname | "text only"]]'
go
exec insert_syntax 'sp_unbindcache_all',
'System Procedure',      1 ,
'sp_unbindcache_all - Unbinds all objects that are bound to a cache.'
go
exec insert_syntax 'sp_unbindcache_all',
'System Procedure',      2 ,
'     sp_unbindcache_all cache_name'
go
exec insert_syntax 'sp_unbindefault',
'System Procedure',      1 ,
'sp_unbindefault - Unbinds a created default value from a column or'
go
exec insert_syntax 'sp_unbindefault',
'System Procedure',      2 ,
'        from a user-defined datatype.'
go
exec insert_syntax 'sp_unbindefault',
'System Procedure',      3 ,
'     sp_unbindefault objname [, futureonly]'
go
exec insert_syntax 'sp_unbindmsg',
'System Procedure',      1 ,
'sp_unbindmsg - Unbinds a user-defined message from a'
go
exec insert_syntax 'sp_unbindmsg',
'System Procedure',      2 ,
'        constraint.'
go
exec insert_syntax 'sp_unbindmsg',
'System Procedure',      3 ,
'     sp_unbindmsg constrname'
go
exec insert_syntax 'sp_unbindrule',
'System Procedure',      1 ,
'sp_unbindrule - Unbinds a rule from a column or from a'
go
exec insert_syntax 'sp_unbindrule',
'System Procedure',      2 ,
'        user-defined datatype.'
go
exec insert_syntax 'sp_unbindrule',
'System Procedure',      3 ,
'     sp_unbindrule objname [, futureonly]'
go
exec insert_syntax 'sp_volchanged',
'System Procedure',      1 ,
'sp_volchanged - Notifies the Backup Server that the operator'
go
exec insert_syntax 'sp_volchanged',
'System Procedure',      2 ,
'        performed the requested volume handling during a'
go
exec insert_syntax 'sp_volchanged',
'System Procedure',      3 ,
'        dump or load.'
go
exec insert_syntax 'sp_volchanged',
'System Procedure',      4 ,
'     sp_volchanged session_id, devname, action'
go
exec insert_syntax 'sp_volchanged',
'System Procedure',      5 ,
'      [, fname [, vname]]'
go
exec insert_syntax 'sp_who',
'System Procedure',      1 ,
'sp_who - Reports information about all current SQL Server'
go
exec insert_syntax 'sp_who',
'System Procedure',      2 ,
'        users and processes or about a particular user or'
go
exec insert_syntax 'sp_who',
'System Procedure',      3 ,
'        process.'
go
exec insert_syntax 'sp_who',
'System Procedure',      4 ,
'     sp_who [loginame | "spid"]'
go





exec insert_syntax 'sp_column_privileges',
'System Procedure',      1 ,
'sp_column_privileges - Returns permissions information for one or more'
go
exec insert_syntax 'sp_column_privileges',
'System Procedure',      2 ,
'        columns in a table or view.'
go
exec insert_syntax 'sp_column_privileges',
'System Procedure',      3 ,
'     sp_column_privileges table_name [, table_owner'
go
exec insert_syntax 'sp_column_privileges',
'System Procedure',      4 ,
'     [, table_qualifier [, column_name]]]'
go
exec insert_syntax 'sp_columns',
'System Procedure',      1 ,
'sp_columns - Returns information about the type of data that'
go
exec insert_syntax 'sp_columns',
'System Procedure',      2 ,
'        can be stored in one or more columns.'
go
exec insert_syntax 'sp_columns',
'System Procedure',      3 ,
'     sp_columns table_name [, table_owner ]'
go
exec insert_syntax 'sp_columns',
'System Procedure',      4 ,
'     [, table_qualifier] [, column_name]'
go
exec insert_syntax 'sp_databases',
'System Procedure',      1 ,
'sp_databases - Returns a list of databases on a SQL Server.'
go
exec insert_syntax 'sp_databases',
'System Procedure',      2 ,
'     sp_databases'
go
exec insert_syntax 'sp_datatype_info',
'System Procedure',      1 ,
'sp_datatype_info - Returns information about a particular datatype'
go
exec insert_syntax 'sp_datatype_info',
'System Procedure',      2 ,
'        or about all supported datatypes.'
go
exec insert_syntax 'sp_datatype_info',
'System Procedure',      3 ,
'     sp_datatype_info [data_type]'
go
exec insert_syntax 'sp_fkeys',
'System Procedure',      1 ,
'sp_fkeys - Returns information about foreign key constraints'
go
exec insert_syntax 'sp_fkeys',
'System Procedure',      2 ,
'        created in the current database with the create'
go
exec insert_syntax 'sp_fkeys',
'System Procedure',      3 ,
'        table or alter table command.'
go
exec insert_syntax 'sp_fkeys',
'System Procedure',      4 ,
'     sp_fkeys pktable_name [, pktable_owner]'
go
exec insert_syntax 'sp_fkeys',
'System Procedure',      5 ,
'     [, pktable_qualifier] [, fktable_name]'
go
exec insert_syntax 'sp_fkeys',
'System Procedure',      6 ,
'     [, fktable_owner] [, fktable_qualifier]'
go
exec insert_syntax 'sp_pkeys',
'System Procedure',      1 ,
'sp_pkeys - Returns information about primary key constraints'
go
exec insert_syntax 'sp_pkeys',
'System Procedure',      2 ,
'        created for a single table with the create table'
go
exec insert_syntax 'sp_pkeys',
'System Procedure',      3 ,
'        or alter table command.'
go
exec insert_syntax 'sp_pkeys',
'System Procedure',      4 ,
'     sp_pkeys table_name [, table_owner]'
go
exec insert_syntax 'sp_pkeys',
'System Procedure',      5 ,
'     [, table_qualifier]'
go
exec insert_syntax 'sp_server_info',
'System Procedure',      1 ,
'sp_server_info - Returns a list of server attribute names and'
go
exec insert_syntax 'sp_server_info',
'System Procedure',      2 ,
'        matching values for SQL Server.'
go
exec insert_syntax 'sp_server_info',
'System Procedure',      3 ,
'     sp_server_info [attribute_id]'
go
exec insert_syntax 'sp_special_columns',
'System Procedure',      1 ,
'sp_special_columns - Returns the optimal set of columns that uniquely'
go
exec insert_syntax 'sp_special_columns',
'System Procedure',      2 ,
'        identify a row in a table or view; can also'
go
exec insert_syntax 'sp_special_columns',
'System Procedure',      3 ,
'        return a list of timestamp columns, whose values'
go
exec insert_syntax 'sp_special_columns',
'System Procedure',      4 ,
'        are automatically generated when any value in the'
go
exec insert_syntax 'sp_special_columns',
'System Procedure',      5 ,
'        row is updated by a transaction.'
go
exec insert_syntax 'sp_special_columns',
'System Procedure',      6 ,
'     sp_special_columns table_name [, table_owner]'
go
exec insert_syntax 'sp_special_columns',
'System Procedure',      7 ,
'     [, table_qualifier] [, col_type]'
go
exec insert_syntax 'sp_sproc_columns',
'System Procedure',      1 ,
'sp_sproc_columns - Returns information about a stored procedure''s'
go
exec insert_syntax 'sp_sproc_columns',
'System Procedure',      2 ,
'        input and return parameters.'
go
exec insert_syntax 'sp_sproc_columns',
'System Procedure',      3 ,
'     sp_sproc_columns procedure_name [, procedure_owner]'
go
exec insert_syntax 'sp_sproc_columns',
'System Procedure',      4 ,
'     [, procedure_qualifier] [, column_name]'
go
exec insert_syntax 'sp_statistics',
'System Procedure',      1 ,
'sp_statistics - Returns a list of indexes on a single table.'
go
exec insert_syntax 'sp_statistics',
'System Procedure',      2 ,
'     sp_statistics table_name [, table_owner]'
go
exec insert_syntax 'sp_statistics',
'System Procedure',      3 ,
'     [, table_qualifier] [, index_name] [, is_unique]'
go
exec insert_syntax 'sp_stored_procedures',
'System Procedure',      1 ,
'sp_stored_procedures - Returns information about one or more stored'
go
exec insert_syntax 'sp_stored_procedures',
'System Procedure',      2 ,
'        procedures.'
go
exec insert_syntax 'sp_stored_procedures',
'System Procedure',      3 ,
'     sp_stored_procedures [sp_name] [, sp_owner]'
go
exec insert_syntax 'sp_stored_procedures',
'System Procedure',      4 ,
'     [, sp_qualifier]'
go
exec insert_syntax 'sp_table_privileges',
'System Procedure',      1 ,
'sp_table_privileges - Returns privilege information for all columns in'
go
exec insert_syntax 'sp_table_privileges',
'System Procedure',      2 ,
'        a table or view.'
go
exec insert_syntax 'sp_table_privileges',
'System Procedure',      3 ,
'     sp_table_privileges table_name [, table_owner'
go
exec insert_syntax 'sp_table_privileges',
'System Procedure',      4 ,
'     [, table_qualifier]]'
go
exec insert_syntax 'sp_tables',
'System Procedure',      1 ,
'sp_tables - Returns a list of objects that can appear in a'
go
exec insert_syntax 'sp_tables',
'System Procedure',      2 ,
'        from clause.'
go
exec insert_syntax 'sp_tables',
'System Procedure',      3 ,
'     sp_tables [table_name] [, table_owner]'
go
exec insert_syntax 'sp_tables',
'System Procedure',      4 ,
'     [, table_qualifier][, table_type]'
go





exec insert_syntax 'backupserver',
'UNIX Utility',          1 ,
'backupserver - The executable form of the Backup Server'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          2 ,
'        program.'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          3 ,
'     backupserver [-Cserver_connections] [-Sb_servername]'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          4 ,
'     [-Iinterfaces_file] [-eerror_log_file]'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          5 ,
'     [-Msybmultbuf_binary] [-Nnetwork_connections]'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          6 ,
'     [-Ttrace_value] [-LSybase_language_name]'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          7 ,
'     [-JSybase_character_set_name]'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          8 ,
'     or'
go
exec insert_syntax 'backupserver',
'UNIX Utility',          9 ,
'     backupserver [-v]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          1 ,
'bcp - Copies a database table to or from an operating'
go
exec insert_syntax 'bcp',
'UNIX Utility',          2 ,
'        system file in a user- specified format.'
go
exec insert_syntax 'bcp',
'UNIX Utility',          3 ,
'     bcp [[database_name.]owner.]table_name {in | out}'
go
exec insert_syntax 'bcp',
'UNIX Utility',          4 ,
'     datafile'
go
exec insert_syntax 'bcp',
'UNIX Utility',          5 ,
'     [-m maxerrors] [-f formatfile] [-e errfile]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          6 ,
'     [-F firstrow] [-L lastrow] [-b batchsize] [-n]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          7 ,
'     [-c [-N]] [-t field_terminator] [-r row_terminator]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          8 ,
'     [-U username] [-P password] [-I interfaces_file]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          9 ,
'     [-S server] [-a display_charset]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          10,
'     [-q datafile_charset] [-z language] [-v]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          11,
'     [-A packet_size] [-J client_charset]'
go
exec insert_syntax 'bcp',
'UNIX Utility',          12,
'     [-T text_or_image_size] [-E ] [-X] [-y sybase_dir]'
go
exec insert_syntax 'buildmaster',
'UNIX Utility',          1 ,
'buildmaster - Builds the master device and creates the master,'
go
exec insert_syntax 'buildmaster',
'UNIX Utility',          2 ,
'        model, and tempdb databases on the device.'
go
exec insert_syntax 'buildmaster',
'UNIX Utility',          3 ,
'     buildmaster [-d disk] [-c cno] [-s size] [-m]'
go
exec insert_syntax 'buildmaster',
'UNIX Utility',          4 ,
'     [-q] [-x]'
go
exec insert_syntax 'buildmaster',
'UNIX Utility',          5 ,
'     or'
go
exec insert_syntax 'buildmaster',
'UNIX Utility',          6 ,
'     buildmaster -v'
go
exec insert_syntax 'dataserver',
'UNIX Utility',          1 ,
'dataserver - The executable form of the SQL Server program.'
go
exec insert_syntax 'dataserver',
'UNIX Utility',          2 ,
'     dataserver -ddevicename [-cconfigurationfile]'
go
exec insert_syntax 'dataserver',
'UNIX Utility',          3 ,
'     [-eerrorlogfile] [-m]'
go
exec insert_syntax 'dataserver',
'UNIX Utility',          4 ,
'     [-rmastermirror] [-Msharedmem_directory]'
go
exec insert_syntax 'dataserver',
'UNIX Utility',          5 ,
'     [-iinterfaces_file_directory] [-sservername]'
go
exec insert_syntax 'dataserver',
'UNIX Utility',          6 ,
'     [-psso_login_name]'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          1 ,
'defncopy - Copies definitions for specified views, rules,'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          2 ,
'        defaults, triggers, or procedures from a database'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          3 ,
'        to an operating system file or from an operating'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          4 ,
'        system file to a database.'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          5 ,
'        The defncopy utility cannot copy table'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          6 ,
'        definitions or reports created with Report'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          7 ,
'        Workbench.'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          8 ,
'     defncopy [-U username][-P password] [-S server ]'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          9 ,
'     [-I interfaces_file] [-a display_charset]'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          10,
'     [-J client_charset] [-z language] [-X]'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          11,
'     {in filename dbname | out filename dbname'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          12,
'     [owner.]objectname [[owner.]objectname]...}'
go
exec insert_syntax 'defncopy',
'UNIX Utility',          13,
'     defncopy [-v]'
go
exec insert_syntax 'isql',
'UNIX Utility',          1 ,
'isql - Interactive SQL parser to SQL Server.'
go
exec insert_syntax 'isql',
'UNIX Utility',          2 ,
'     isql [-e] [-F] [-p] [-n] [-v] [-X] [-Y]'
go
exec insert_syntax 'isql',
'UNIX Utility',          3 ,
'     [-a display_charset] [-c cmdend] [-E editor]'
go
exec insert_syntax 'isql',
'UNIX Utility',          4 ,
'     [-h headers] [-H hostname] [-i inputfile]'
go
exec insert_syntax 'isql',
'UNIX Utility',          5 ,
'     [-I interfaces_file] [-J client_charset]'
go
exec insert_syntax 'isql',
'UNIX Utility',          6 ,
'     [-l login_timeout] [-m errorlevel]'
go
exec insert_syntax 'isql',
'UNIX Utility',          7 ,
'     [-o outputfile] [-P password] [-s colseparator]'
go
exec insert_syntax 'isql',
'UNIX Utility',          8 ,
'     [-S server] [-t timeout] [-U username]'
go
exec insert_syntax 'isql',
'UNIX Utility',          9 ,
'     [-w columnwidth] [-y sybase_directory]'
go
exec insert_syntax 'isql',
'UNIX Utility',          10,
'     [-z language] [-A size]'
go
exec insert_syntax 'isql',
'UNIX Utility',          11,
'     To terminate a command: go'
go
exec insert_syntax 'isql',
'UNIX Utility',          12,
'     To clear the query buffer: reset'
go
exec insert_syntax 'isql',
'UNIX Utility',          13,
'     To call the default editor: vi'
go
exec insert_syntax 'isql',
'UNIX Utility',          14,
'     To execute an operating system command: !! command'
go
exec insert_syntax 'isql',
'UNIX Utility',          15,
'     To exit from isql: quit or exit'
go
exec insert_syntax 'langinstall',
'UNIX Utility',          1 ,
'langinstall - Installs one new language on SQL Server.'
go
exec insert_syntax 'langinstall',
'UNIX Utility',          2 ,
'     langinstall  [-S server] [-I interfaces_file]'
go
exec insert_syntax 'langinstall',
'UNIX Utility',          3 ,
'     [-P password] [-R release_number] language'
go
exec insert_syntax 'langinstall',
'UNIX Utility',          4 ,
'     character_set'
go
exec insert_syntax 'langinstall',
'UNIX Utility',          5 ,
'     langinstall [-v]'
go
exec insert_syntax 'showserver',
'UNIX Utility',          1 ,
'showserver - Shows SQL Servers and Backup Servers currently'
go
exec insert_syntax 'showserver',
'UNIX Utility',          2 ,
'        running on the local machine.'
go
exec insert_syntax 'showserver',
'UNIX Utility',          3 ,
'     showserver'
go
exec insert_syntax 'startserver',
'UNIX Utility',          1 ,
'startserver - Starts a SQL Server and/or a Backup Server.'
go
exec insert_syntax 'startserver',
'UNIX Utility',          2 ,
'     startserver [[-f runserverfile] [-m]] ...'
go





exec insert_syntax 'backupserver',
'NT Utility',            1 ,
'backupserver - The executable form of the Backup Server'
go
exec insert_syntax 'backupserver',
'NT Utility',            2 ,
'        program.'
go
exec insert_syntax 'backupserver',
'NT Utility',            3 ,
'     bcksrvr [-Cserver_connections] [-Sb_servername]'
go
exec insert_syntax 'backupserver',
'NT Utility',            4 ,
'       [-Isqlini_filename] [-v] [-eerror_log_file]'
go
exec insert_syntax 'backupserver',
'NT Utility',            5 ,
'       [-Nnetwork_connections] [-Ttrace_value]'
go
exec insert_syntax 'backupserver',
'NT Utility',            6 ,
'       [-LSybase_language_name]'
go
exec insert_syntax 'backupserver',
'NT Utility',            7 ,
'       [-JSybase_character_set_name]'
go
exec insert_syntax 'bcp',
'NT Utility',            1 ,
'bcp - Copies a database table to or from an operating'
go
exec insert_syntax 'bcp',
'NT Utility',            2 ,
'        system file in a user- specified format.'
go
exec insert_syntax 'bcp',
'NT Utility',            3 ,
'     bcp [[database_name.]owner.]table_name {in | out}'
go
exec insert_syntax 'bcp',
'NT Utility',            4 ,
'         datafile'
go
exec insert_syntax 'bcp',
'NT Utility',            5 ,
'      [-m maxerrors] [-f formatfile] [-e errfile]'
go
exec insert_syntax 'bcp',
'NT Utility',            6 ,
'      [-F firstrow] [-L lastrow] [-b batchsize]'
go
exec insert_syntax 'bcp',
'NT Utility',            7 ,
'      [-n] [-c] [-t field_terminator] [-r row_terminator]'
go
exec insert_syntax 'bcp',
'NT Utility',            8 ,
'      [-U username] [-P password] [-I sqlini_file]'
go
exec insert_syntax 'bcp',
'NT Utility',            9 ,
'      [-S server] [-a display_charset]'
go
exec insert_syntax 'bcp',
'NT Utility',            10,
'      [-q datafile_charset] [-z language] [-v]'
go
exec insert_syntax 'bcp',
'NT Utility',            11,
'      [-A packet size] [-J client_charset]'
go
exec insert_syntax 'bcp',
'NT Utility',            12,
'      [-T text_or_image_size] [-E] [-N] [-X]'
go
exec insert_syntax 'bcp',
'NT Utility',            13,
'      [-y sybase_dir]'
go
exec insert_syntax 'buildmaster',
'NT Utility',            1 ,
'buildmaster - Builds the master device and creates the master,'
go
exec insert_syntax 'buildmaster',
'NT Utility',            2 ,
'        model, and tempdb databases on the device.'
go
exec insert_syntax 'buildmaster',
'NT Utility',            3 ,
'     bldmastr [-d physicalname] [-c cntrltype]'
go
exec insert_syntax 'buildmaster',
'NT Utility',            4 ,
'       [-s size] [-m] [-x]'
go
exec insert_syntax 'defncopy',
'NT Utility',            1 ,
'defncopy - Copies definitions for specified views, rules,'
go
exec insert_syntax 'defncopy',
'NT Utility',            2 ,
'        defaults, triggers, or procedures from a database'
go
exec insert_syntax 'defncopy',
'NT Utility',            3 ,
'        to an operating system file or from an operating'
go
exec insert_syntax 'defncopy',
'NT Utility',            4 ,
'        system file to a database.'
go
exec insert_syntax 'defncopy',
'NT Utility',            5 ,
'        The defncopy utility cannot copy table'
go
exec insert_syntax 'defncopy',
'NT Utility',            6 ,
'        definitions or reports created with Report'
go
exec insert_syntax 'defncopy',
'NT Utility',            7 ,
'        Workbench.'
go
exec insert_syntax 'defncopy',
'NT Utility',            8 ,
'     defncopy [-U username][-P password] -S server [-v]'
go
exec insert_syntax 'defncopy',
'NT Utility',            9 ,
'       [-I sqlini_file] [-a display_charset]'
go
exec insert_syntax 'defncopy',
'NT Utility',            10,
'       [-J client_charset] [-z language] [-X]'
go
exec insert_syntax 'defncopy',
'NT Utility',            11,
'       {in filename dbname | out filename dbname'
go
exec insert_syntax 'defncopy',
'NT Utility',            12,
'         [owner.]objectname [[owner.]objectname]...}'
go
exec insert_syntax 'isql',
'NT Utility',            1 ,
'isql - Interactive SQL parser to SQL Server.'
go
exec insert_syntax 'isql',
'NT Utility',            2 ,
'     isql [-e] [-F] -p] [-n] [-v] [-X] [-Y]'
go
exec insert_syntax 'isql',
'NT Utility',            3 ,
'       [-a display_charset] [-c cmdend] [-E editor]'
go
exec insert_syntax 'isql',
'NT Utility',            4 ,
'       [-h headers] [-H hostname] [-i inputfile]'
go
exec insert_syntax 'isql',
'NT Utility',            5 ,
'       [-I sqlini_file] [-J client_charset]'
go
exec insert_syntax 'isql',
'NT Utility',            6 ,
'       [-l login_timeout] [-m errorlevel]'
go
exec insert_syntax 'isql',
'NT Utility',            7 ,
'       [-o outputfile] [-P password] [-s colseparator]'
go
exec insert_syntax 'isql',
'NT Utility',            8 ,
'       [-S server] [-t timeout] [-U username]'
go
exec insert_syntax 'isql',
'NT Utility',            9 ,
'       [-w columnwidth] [-y sybase_directory]'
go
exec insert_syntax 'isql',
'NT Utility',            10,
'       [-z language] [-A size]'
go
exec insert_syntax 'isql',
'NT Utility',            11,
'         To terminate a command: go'
go
exec insert_syntax 'isql',
'NT Utility',            12,
'         To clear the query buffer: reset'
go
exec insert_syntax 'isql',
'NT Utility',            13,
'         To call the editor: edit'
go
exec insert_syntax 'isql',
'NT Utility',            14,
'         To exit from isql: quit or exit'
go
exec insert_syntax 'langinstall',
'NT Utility',            1 ,
'langinstall - Installs one new language on SQL Server.'
go
exec insert_syntax 'langinstall',
'NT Utility',            2 ,
'     langinst [-S server] [-I sqlini_file]'
go
exec insert_syntax 'langinstall',
'NT Utility',            3 ,
'       [-P password] [-R release_number] [-v]'
go
exec insert_syntax 'langinstall',
'NT Utility',            4 ,
'       language character_set'
go
exec insert_syntax 'services manager',
'NT Utility',            1 ,
'services manager - Starts, pauses, and stops SQL Server, Backup'
go
exec insert_syntax 'services manager',
'NT Utility',            2 ,
'        Server, and SQL Server Monitor as Windows NT'
go
exec insert_syntax 'services manager',
'NT Utility',            3 ,
'        services.'
go
exec insert_syntax 'services manager',
'NT Utility',            4 ,
'     srvmgr'
go
exec insert_syntax 'services manager',
'NT Utility',            5 ,
'       or double-click the Services Manager icon in the Sybase for Windows'
go
exec insert_syntax 'services manager',
'NT Utility',            6 ,
'       NT program group.'
go
exec insert_syntax 'sqledit',
'NT Utility',            1 ,
'sqledit - Edits the sql.ini interfaces file and libtcl.cfg'
go
exec insert_syntax 'sqledit',
'NT Utility',            2 ,
'        configuration file, which allow you to specify'
go
exec insert_syntax 'sqledit',
'NT Utility',            3 ,
'        network information. The sqledit executable,'
go
exec insert_syntax 'sqledit',
'NT Utility',            4 ,
'        sqledit.exe, is located in the bin directory of'
go
exec insert_syntax 'sqledit',
'NT Utility',            5 ,
'        the Sybase release directory.'
go
exec insert_syntax 'sqlserver',
'NT Utility',            1 ,
'sqlserver - The executable form of the SQL Server program.'
go
exec insert_syntax 'sqlserver',
'NT Utility',            2 ,
'     sqlsrvr -ddevicename [-eerrorlogfile] [-m]'
go
exec insert_syntax 'sqlserver',
'NT Utility',            3 ,
'       [-rmastermirror] [-Msharedmem_directory]'
go
exec insert_syntax 'sqlserver',
'NT Utility',            4 ,
'       [-iinterfaces_file_directory] [-sservername]'
go
exec insert_syntax 'sqlserver',
'NT Utility',            5 ,
'       [-psso_login_name] [-g] [-Gmachine_name]'
go
exec insert_syntax 'sqlserver',
'NT Utility',            6 ,
'       [-cconfiguration_file_path]'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            1 ,
'sybping and wsybping - Diagnostic utilities that test the'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            2 ,
'        Net-Library-to-server connection across your'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            3 ,
'        network software and report information about'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            4 ,
'        successful and unsuccessful connection attempts.'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            5 ,
'        The sybping and wsybping executables (sybping.exe'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            6 ,
'        and wsybping.exe) are located in the bin'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            7 ,
'        directory of the SYBASE release directory.'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            8 ,
'     For Windows NT:'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            9 ,
'       sybping'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            10,
'       or double-click the SYBPING icon in the Sybase for Windows NT'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            11,
'          program group'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            12,
'     For Windows:'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            13,
'       wsybping'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            14,
'       or double-click the WSYBPING icon in the Sybase for Windows'
go
exec insert_syntax 'sybping and wsybping',
'NT Utility',            15,
'         program group.'
go
exec insert_syntax 'wdllvers',
'NT Utility',            1 ,
'wdllvers - Provides the following information about the'
go
exec insert_syntax 'wdllvers',
'NT Utility',            2 ,
'        Sybase DLLs (Dynamic Link Libraries) loaded into'
go
exec insert_syntax 'wdllvers',
'NT Utility',            3 ,
'        memory:'
go
exec insert_syntax 'wdllvers',
'NT Utility',            4 ,
'               DLL name'
go
exec insert_syntax 'wdllvers',
'NT Utility',            5 ,
'               DLL usage count'
go
exec insert_syntax 'wdllvers',
'NT Utility',            6 ,
'               DLL file size'
go
exec insert_syntax 'wdllvers',
'NT Utility',            7 ,
'               DLL file date'
go
exec insert_syntax 'wdllvers',
'NT Utility',            8 ,
'               Directory path from which the DLL was'
go
exec insert_syntax 'wdllvers',
'NT Utility',            9 ,
'               loaded'
go
exec insert_syntax 'wdllvers',
'NT Utility',            10,
'        The wdllvers executable (wdllvers.exe) is located'
go
exec insert_syntax 'wdllvers',
'NT Utility',            11,
'        in the bin directory of the Sybase release'
go
exec insert_syntax 'wdllvers',
'NT Utility',            12,
'        directory.'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            1 ,
'wisql32 and wisql - Windows NT and Windows application versions of'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            2 ,
'        isql, the interactive SQL parser to SQL Server'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            3 ,
'        used to connect to and query a SQL Server or Open'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            4 ,
'        Server. Use wisql32 or wisql to perform ad hoc or'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            5 ,
'        diagnostic queries of a database. You can use'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            6 ,
'        wisql32 or wisql, for example, in a situation'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            7 ,
'        where wsybping indicates a successful connection,'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            8 ,
'        but your Open Client application fails to run.'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            9 ,
'        The executables (wisql32.exe and wisql.exe) are'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            10,
'        located in the bin directory of the Sybase'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            11,
'        release directory.'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            12,
'     For Windows NT:'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            13,
'       wisql32'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            14,
'       or double-click the WISQL32 icon in the Sybase for Windows NT'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            15,
'         program group.'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            16,
'     For Windows:'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            17,
'       wisql'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            18,
'       or double-click the WISQL icon in the Sybase for Windows'
go
exec insert_syntax 'wisql32 and wisql',
'NT Utility',            19,
'         program group.'
go

/* add execs here */


/* drop the insert_syntax procedure */
if exists (select name from sysobjects where name = "insert_syntax")
begin
	drop procedure insert_syntax
end
go

/* drop the sybsyntax_printmsg procedure */
if exists (select name from sysobjects where name = "sybsyntax_printmsg")
begin
	drop procedure sybsyntax_printmsg
end
go

/* If sp_syntax already exists, drop it so that we might replace it */
if exists (select *
	from sysobjects
		where sysstat & 7 = 4
			and name = 'sp_syntax')
begin
	drop procedure sp_syntax
end
go

create procedure sp_syntax
	@word varchar(50) = null,	/* command */
	@mod varchar(20) = null,	/* module */
	@language varchar(30) = null	/* language */
as

set nocount on
declare	@pattern	varchar(52),
	@counter	tinyint,
	@mincommand	varchar(50),
	@modpattern	varchar(22),
	@modcount	tinyint,
	@minmod		varchar(20),
	@msg		varchar(255),
	@msgparam	varchar(30),
	@lang_id	smallint,
	@returncode smallint
/*
**  If we're in a transaction, disallow this since it might make recovery
**  impossible.
*/
if @@trancount > 0
begin
	/*
	** 17260, "Can't run %1! from within a transaction."
	*/
	exec sp_getmessage 17260, @msg output
	print @msg, "sp_syntax"
	return (1)
end

/*
** Check that language is valid.
*/
if @language is not NULL
begin
    execute @returncode = sp_validlang @language
    if @returncode != 0
    begin
	    /* Us_english is always valid */
	    if @language != "us_english"
	    begin
		    /* 
		    ** 17201, "'%1!' is not an official language
		    **	name from Syslanguages."
		    */
		    exec sp_getmessage 17201, @msg output
		    print @msg, @language
		    return @returncode
	    end

	    /* set to us_english */
	    select @lang_id = NULL
    end

    else
    select @lang_id = langid from syslanguages
		where @language = name

end

/* set search string to %word% */

select @pattern = "%" + lower(@word) + "%",
	@modpattern = "%" + lower(@mod) + "%"


/* if no command/routine name is given, print the syntax and return*/

if @word is null
begin
	/*
	** 17970, "sp_syntax provides syntax help for Sybase products."
	*/
	exec sp_getmessage 17970, @msg output, @language
	print @msg
	/*
	** 17971, "These modules are installed on this Server:"
	*/
	exec sp_getmessage 17971, @msg output, @language
	print @msg
	print ""
	select distinct module Module from sybsyntax..sybsyntax
	print""
	/*
	** 17972, "Usage:  sp_syntax command [, module, language]"
	*/
	exec sp_getmessage 17972, @msg output, @language
	print @msg
	return
end

/* if no commands match, print a message and return */

if (select count(*) from sybsyntax..sybsyntax
	where commandname like @pattern) = 0
begin
	/*
	** 17973, "No command or routine has a name like '%1!'"
	*/
	exec sp_getmessage 17973, @msg output, @language
	print @msg, @word
	return
end

/* if no modules match, print a message and return */

if @mod is not null and (select count(*) from sybsyntax..sybsyntax
	where lower(module) like @modpattern) = 0
begin
	/*
	** 17974, "No module has a name like '%1!'"
	*/
	exec sp_getmessage 17974, @msg output, @language
	print @msg, @mod
	return
end

/* if command/module combo has no matches, print message and return */
if (select count(*) from sybsyntax..sybsyntax
		where lower (module) like @modpattern
		and lower (commandname) like @pattern
		and langid = @lang_id) = 0
begin
	/*
	** 17975, "No command or routine has a name like '%1!' and a module like '%2!'"
	*/
	exec sp_getmessage 17975, @msg output, @language
	print @msg, @word, @mod
	return
end

/* Put a list of all desired module names into #tempsyntax1.
** If a module was specified, find all %mod% matches.
** If @mod is null, select modules from the table with a
** matching %word%
*/

create table #tempsyntax1 (module varchar(20))
if @mod is not null
begin
	insert #tempsyntax1
		select distinct(module)
		from sybsyntax..sybsyntax
		where lower(module) like @modpattern
		and langid = @lang_id
end
else
begin
	insert #tempsyntax1
		select distinct(module)
		from sybsyntax..sybsyntax
		where commandname like @pattern
		and langid = @lang_id
end

select @modcount = (select count(*) from #tempsyntax1)

/* create a table to store the results */
create table #tempsyntax2 (c1 varchar(78))


/* find the first module in alpha order */
select @minmod = min(module)
	from #tempsyntax1

/* the loop that finds all the answers */
while @modcount > 0
begin

	/* Put module name into results */
	insert #tempsyntax2 values (@minmod)
		/* count matches for this module */
		select @counter = (select count(*)
			from sybsyntax..sybsyntax
			where commandname like @pattern
				and linenum = 1
				and module = @minmod
				and langid = @lang_id)
	/*find the first word in alpha order */
	select @mincommand = min(commandname)
		from sybsyntax..sybsyntax
		where commandname like @pattern
			and module = @minmod
			and langid = @lang_id
	while @counter > 0
	begin
		/* select the syntax info into the results */
		insert #tempsyntax2
		select syntax from sybsyntax..sybsyntax
			where commandname = @mincommand
				and module = @minmod
				and langid = @lang_id
				order by linenum
		/* add a blank line between commands */
		insert #tempsyntax2
			select ""
		select @counter = @counter - 1
		/*find the first word in alpha order */
		select @mincommand = min(commandname)
			from sybsyntax..sybsyntax
			where commandname like @pattern
				and commandname > @mincommand
				and module = @minmod
				and langid = @lang_id
	end
	/* find the next module in alpha order */
	select @minmod = min(module)
		from #tempsyntax1
		where module > @minmod
	select @modcount = @modcount - 1
end

/*
** 18049, "Syntax Help"
*/
exec sp_getmessage 18049, @msg output, @language
print @msg
select "" = c1 from #tempsyntax2
go

/* add guest user to sybsyntax db so everybody can access it */
use sybsyntax
go

if not exists (select * from sysusers where name="guest")
	exec sp_adduser guest
go

/* grant permission for sp_syntax to be executed by anybody */
use master
go

grant execute on sp_syntax to public
go