
/*  HelpSQL.SQL  1996/03/27
*******************************************************************
**  sp_helpsql for Microsoft SQL Server 6.5                      **
*******************************************************************
*/

go
USE master
set nocount on
go

raiserror('Dumping tran master no_log ...',1,1)
go

DUMP TRANSACTION master WITH NO_LOG
go

IF (EXISTS (SELECT * FROM sysobjects WHERE name = 'sp_helpsql'))
	DROP PROC sp_helpsql
go

IF (EXISTS (SELECT * FROM sysobjects WHERE name = 'helpsql'))
	DROP TABLE helpsql
go

DUMP TRANSACTION master WITH NO_LOG
go

raiserror('Creating table helpsql ...',1,1)
go

CREATE TABLE helpsql (command varchar(30), ordering tinyint, helptext varchar(80))
go

CREATE INDEX helpsql_index ON helpsql(command)
go

raiserror('Creating procedure sp_helpsql ...',1,1)
go

CREATE PROC sp_helpsql
@in_command varchar(30) = NULL
AS
DECLARE @num_commands tinyint
DECLARE @original_command varchar(30)
/*******************************************************************/
/*  sp_helpsql gives help on SQL commands supported by SQL Server  */
/*      4 situations are covered:                                  */
/*          1. No additional parameters                            */
/*             Returns: Help on how to use sp_helpsql              */
/*          2. Partial parameter input by the user                 */
/*             Returns: The name of all commands that begin with   */
/*                      the string input by the user.  The user    */
/*                      can resubmit the request for help with     */
/*                      the correct command name.                  */
/*          3. A unique parameter passed from the user             */
/*             Returns: A brief definition and syntax on command.  */
/*          4. A parameter which does not match any help commands. */
/*             return:  No help available for command: parameter   */
/*******************************************************************/

/* first deal with no parameter passed, which means to simply give */
/* usage syntax and help                                           */
IF @in_command IS NULL
    BEGIN
	PRINT ' '
 	PRINT 'sp_helpsql supplies help on Transact-SQL statements, server-supplied stored '
        PRINT '    procedures, and the following special topics: '
	PRINT ' '
	PRINT '         Comments              Expression            Variables'
	PRINT '         Control of Flow       Functions             Wildcards'
	PRINT '         Cursors               Operators'
	PRINT '         Datatypes             Transactions'
	PRINT ' '
	PRINT "Syntax:  sp_helpsql ['topic']"
	PRINT ' '
	PRINT ' '
	PRINT "For parameter options and syntax restrictions, see the Books On-line."
	PRINT ' '
	/* all done, so leave now */
	RETURN
    END
ELSE
    BEGIN
	SELECT @original_command = @in_command
	SELECT @in_command = UPPER(@in_command)
	/* see if we got a unique hit on command */
	SELECT @num_commands = COUNT(DISTINCT command) FROM master..helpsql WHERE
		UPPER(command) LIKE @in_command
	IF @num_commands = 1
	    BEGIN
		SELECT 'Transact-SQL Syntax Help' = ('  ' + helptext)
			FROM master..helpsql
				WHERE UPPER(command) LIKE @in_command
			ORDER BY ordering
		RETURN
	    END
	ELSE
	/* what was input did not get a direct hit, so now look for a part */
	/* of a command as input */
	SELECT @in_command = @in_command + '%'
	SELECT @num_commands = COUNT(DISTINCT command) FROM master..helpsql WHERE
		UPPER(command) LIKE @in_command
	/* if num_command > 1 then more than 1 command has been found*/
	IF @num_commands > 1
	    BEGIN
		PRINT ' '
		PRINT 'You have entered a non-unique topic.  More information can be obtained'
		PRINT 'for the following topics:'
		PRINT ' '
		SELECT DISTINCT 'Transact-SQL command' = command FROM master..helpsql WHERE
			UPPER(command) LIKE @in_command
		RETURN
	    END
	ELSE
	/* if num_command = 1 then give help for that 1 command */
	IF @num_commands = 1
	    BEGIN
		SELECT 'Transact-SQL Syntax Help' = ('  ' + helptext)
			FROM master..helpsql
				WHERE UPPER(command) LIKE @in_command
			ORDER BY ordering
		RETURN
	    END
	ELSE
	/* if we got here we have no help on the command requested by the */
	/* user                                                           */
	    BEGIN
		DECLARE @nohelp varchar(72)
		SELECT @nohelp = 'No help available for ' + @original_command
		PRINT @nohelp
		RETURN
	    END
    END
go
DUMP TRANSACTION master WITH NO_LOG
go

raiserror('Next are numerous inserts to helpsql ...',1,1)
go

go
INSERT INTO helpsql VALUES("ALTER DATABASE",1,"ALTER DATABASE Statement")
INSERT INTO helpsql VALUES("ALTER DATABASE",2,"Increases the amount of disk space allocated to a database.")
INSERT INTO helpsql VALUES("ALTER DATABASE",3," ")
INSERT INTO helpsql VALUES("ALTER DATABASE",4,"ALTER DATABASE <database_name>")
INSERT INTO helpsql VALUES("ALTER DATABASE",5,"     [ON {DEFAULT | <database_device>} [= <size>] ")
INSERT INTO helpsql VALUES("ALTER DATABASE",6,"          [, <database_device> [= <size>]]...]")
INSERT INTO helpsql VALUES("ALTER DATABASE",7,"[FOR LOAD]")
INSERT INTO helpsql VALUES("ALTER DATABASE",8,"test")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("ALTER TABLE",1,"ALTER TABLE Statement")
INSERT INTO helpsql VALUES("ALTER TABLE",2,"Adds new columns or constraints to an existing table.")
INSERT INTO helpsql VALUES("ALTER TABLE",3," ")
INSERT INTO helpsql VALUES("ALTER TABLE",4,"ALTER TABLE <database>.[<owner>.]<table_name> ")
INSERT INTO helpsql VALUES("ALTER TABLE",5,"[WITH {CHECK | NOCHECK}]")
INSERT INTO helpsql VALUES("ALTER TABLE",6,"{{CHECK | NOCHECK} CONSTRAINT")
INSERT INTO helpsql VALUES("ALTER TABLE",7,"{<constraint_name> | ALL} |")
INSERT INTO helpsql VALUES("ALTER TABLE",8,"[ADD")
INSERT INTO helpsql VALUES("ALTER TABLE",9,"     {<col_name> <column_properties> [<column_constraints>]")
INSERT INTO helpsql VALUES("ALTER TABLE",10,"     | [[,] <table_constraint>]}")
INSERT INTO helpsql VALUES("ALTER TABLE",11,"          [, {<next_col_name> | <next_table_constraint>}]...]")
INSERT INTO helpsql VALUES("ALTER TABLE",12,"|")
INSERT INTO helpsql VALUES("ALTER TABLE",13,"[DROP CONSTRAINT] ")
INSERT INTO helpsql VALUES("ALTER TABLE",14,"     <constraint_name> [, <constraint_name2>]...]}")
INSERT INTO helpsql VALUES("ALTER TABLE",15," ")
INSERT INTO helpsql VALUES("ALTER TABLE",16,"<column_properties> =")
INSERT INTO helpsql VALUES("ALTER TABLE",17,"     <datatype> [NULL | IDENTITY[(<seed>, <increment>)]]")
INSERT INTO helpsql VALUES("ALTER TABLE",18," ")
INSERT INTO helpsql VALUES("ALTER TABLE",19,"<column_constraints> =")
INSERT INTO helpsql VALUES("ALTER TABLE",20,"  For a column-level constraint:")
INSERT INTO helpsql VALUES("ALTER TABLE",20,"    [CONSTRAINT <constraint_name> ]   ")
INSERT INTO helpsql VALUES("ALTER TABLE",21,"    {PRIMARY KEY [CLUSTERED | NONCLUSTERED][ (<col_name>)]  ")
INSERT INTO helpsql VALUES("ALTER TABLE",22,"         | UNIQUE [CLUSTERED | NONCLUSTERED] [(<col_name>)]")
INSERT INTO helpsql VALUES("ALTER TABLE",23,"               [WITH FILLFACTOR = <fillfactor> ]")
INSERT INTO helpsql VALUES("ALTER TABLE",24,"         | FOREIGN KEY [(<col_name>)] ")
INSERT INTO helpsql VALUES("ALTER TABLE",25,"               REFERENCES [(<ref_col>)][NOT FOR REPLICATION]")
INSERT INTO helpsql VALUES("ALTER TABLE",26," 		| CHECK [NOT FOR REPLICATION] (<expression>)} ")
INSERT INTO helpsql VALUES("ALTER TABLE",27,"<table_constraints> = ")
INSERT INTO helpsql VALUES("ALTER TABLE",28,"  For a table-level constraint:")
INSERT INTO helpsql VALUES("ALTER TABLE",29,"     [CONSTRAINT <constraint_name> ]")
INSERT INTO helpsql VALUES("ALTER TABLE",30,"          {PRIMARY KEY [CLUSTERED | NONCLUSTERED]")
INSERT INTO helpsql VALUES("ALTER TABLE",31,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
INSERT INTO helpsql VALUES("ALTER TABLE",32,"          | UNIQUE [CLUSTERED | NONCLUSTERED]")
INSERT INTO helpsql VALUES("ALTER TABLE",33,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
INSERT INTO helpsql VALUES("ALTER TABLE",34,"               [WITH FILLFACTOR = <fillfactor>]")
INSERT INTO helpsql VALUES("ALTER TABLE",35,"          | FOREIGN KEY (<col_name> [, <col_name2> [..., <col_name16>]])")
INSERT INTO helpsql VALUES("ALTER TABLE",36,"               REFERENCES [<owner>.]<ref_table> (<ref_col> ")
INSERT INTO helpsql VALUES("ALTER TABLE",37,"                    [, <ref_col2> [..., <ref_col16>]])")
INSERT INTO helpsql VALUES("ALTER TABLE",38,"               [NOT FOR REPLICATION] ")
INSERT INTO helpsql VALUES("ALTER TABLE",39,"          | CHECK [NOT FOR REPLICATION] (<expression>)} ")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("CASE",1,"CASE Expression")
INSERT INTO helpsql VALUES("CASE",2,"The CASE expression allows SQL expressions to be simplified for ")
INSERT INTO helpsql VALUES("CASE",3,"conditional values. The CASE expression in SQL Server 6.0 is ANSI ")
INSERT INTO helpsql VALUES("CASE",4,"SQL-92-compliant and allowed anywhere an expression is used.")
INSERT INTO helpsql VALUES("CASE",5," ")
INSERT INTO helpsql VALUES("CASE",6,"Simple CASE expression:")
INSERT INTO helpsql VALUES("CASE",7,"     CASE <expression>")
INSERT INTO helpsql VALUES("CASE",8,"          WHEN <expression1> THEN <expression1>")
INSERT INTO helpsql VALUES("CASE",9,"          [[WHEN <expression2> THEN <expression2>] [...]]")
INSERT INTO helpsql VALUES("CASE",10,"          [ELSE <expressionN>]")
INSERT INTO helpsql VALUES("CASE",11,"     END")
INSERT INTO helpsql VALUES("CASE",12," ")
INSERT INTO helpsql VALUES("CASE",13,"Searched CASE expression:")
INSERT INTO helpsql VALUES("CASE",14,"     CASE")
INSERT INTO helpsql VALUES("CASE",15,"          WHEN <Boolean_expression1> THEN <expression1>")
INSERT INTO helpsql VALUES("CASE",16,"          [[WHEN <Boolean_expression2> THEN <expression2> ] [...]]")
INSERT INTO helpsql VALUES("CASE",17,"          [ELSE <expressionN>]")
INSERT INTO helpsql VALUES("CASE",18,"     END")
INSERT INTO helpsql VALUES("CASE",19," ")
INSERT INTO helpsql VALUES("CASE",20,"CASE-related functions:")
INSERT INTO helpsql VALUES("CASE",21,"     COALESCE (<expression1>, <expression2>)")
INSERT INTO helpsql VALUES("CASE",22,"     COALESCE (<expression1>, <expression2>, ... <expressionN>)")
INSERT INTO helpsql VALUES("CASE",23,"     NULLIF (<expression1>, <expression2>)")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("CHECKPOINT",1,"CHECKPOINT Statement")
INSERT INTO helpsql VALUES("CHECKPOINT",2,"Forces all dirty pages (those that have been updated since the ")
INSERT INTO helpsql VALUES("CHECKPOINT",3,"last checkpoint) in the current database to be written to disk. ")
INSERT INTO helpsql VALUES("CHECKPOINT",4," ")
INSERT INTO helpsql VALUES("CHECKPOINT",5,"CHECKPOINT")
INSERT INTO helpsql VALUES("COMMENTS",1,"Comments")
INSERT INTO helpsql VALUES("COMMENTS",2,"Provide user-documented information about SQL statements, statement ")
INSERT INTO helpsql VALUES("COMMENTS",3,"blocks, and stored procedures.")
INSERT INTO helpsql VALUES("COMMENTS",4,"/* <text of comment> */")
INSERT INTO helpsql VALUES("COMMENTS",5,"Or")
INSERT INTO helpsql VALUES("COMMENTS",6,"-- <text of comment>")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("CONTROL OF FLOW",1,"Control-of-Flow Language")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",2,"Controls the flow of execution of SQL statements, statement blocks, and ")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",3,"stored procedures. These keywords can be used in ad hoc SQL ")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",4,"statements, in batches, and in stored procedures.")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",5," ")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",6,"These are the control-of-flow keywords:")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",7,"BEGIN...END      Defines a statement block.")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",8,"GOTO <label>     Continues processing at the statement following the ")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",9,"                 label as defined by <label>. ")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",10,"IF...ELSE        Defines conditional and, optionally, alternate ")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",11,"                 execution when a condition is false. ")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",12,"RETURN           Exits unconditionally.")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",13,"WAITFOR          Sets a delay for statement execution.")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",14,"WHILE            Repeats statements while a specific condition is true.")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",15,"...BREAK         Exits the innermost WHILE loop.")
INSERT INTO helpsql VALUES("CONTROL OF FLOW",16,"...CONTINUE      Restarts a WHILE loop.")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("BEGIN...END",1,"BEGIN...END Block")
INSERT INTO helpsql VALUES("BEGIN...END",2,"Encloses a series of SQL statements so that control-of-flow language, ")
INSERT INTO helpsql VALUES("BEGIN...END",3,"such as IF...ELSE, affects the performance of a group of statements ")
INSERT INTO helpsql VALUES("BEGIN...END",4,"instead of only the statement that immediately follows. ")
INSERT INTO helpsql VALUES("BEGIN...END",5," ")
INSERT INTO helpsql VALUES("BEGIN...END",6,"BEGIN...END blocks can be nested.")
INSERT INTO helpsql VALUES("BEGIN...END",7,"BEGIN")
INSERT INTO helpsql VALUES("BEGIN...END",8,"     {sql_statement | <statement_block>}")
INSERT INTO helpsql VALUES("BEGIN...END",9,"END")
INSERT INTO helpsql VALUES("GOTO...LABEL",1,"GOTO...LABEL Block")
INSERT INTO helpsql VALUES("GOTO...LABEL",2,"Alters the flow of execution to a label. The SQL statement(s) following ")
INSERT INTO helpsql VALUES("GOTO...LABEL",3,"GOTO are skipped and processing continues at the label. GOTO statements ")
INSERT INTO helpsql VALUES("GOTO...LABEL",4,"and labels can be used anywhere within a procedure, batch, or ")
INSERT INTO helpsql VALUES("GOTO...LABEL",5,"statement block, and they can be nested.")
INSERT INTO helpsql VALUES("GOTO...LABEL",6," ")
INSERT INTO helpsql VALUES("GOTO...LABEL",7,"Define the label:")
INSERT INTO helpsql VALUES("GOTO...LABEL",8,"     <label>:")
INSERT INTO helpsql VALUES("GOTO...LABEL",9,"Alter the execution:")
INSERT INTO helpsql VALUES("GOTO...LABEL",10,"     GOTO <label>")
go

DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("BEGIN DISTRIBUTED TRANSACTION",1,"BEGIN DISTRIBUTED TRANSACTION Statement")
INSERT INTO helpsql VALUES("BEGIN DISTRIBUTED TRANSACTION",1,"Used to start a transaction that is processed on one or")
INSERT INTO helpsql VALUES("BEGIN DISTRIBUTED TRANSACTION",1,"more remote servers. MS DTC manages the distributed transaction.")
INSERT INTO helpsql VALUES("BEGIN DISTRIBUTED TRANSACTION",1," ")
INSERT INTO helpsql VALUES("BEGIN DISTRIBUTED TRANSACTION",1,"BEGIN DISTRIBUTED TRANSACTION [<transaction_name>]")


DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("IF...ELSE",1,"IF...ELSE Block")
INSERT INTO helpsql VALUES("IF...ELSE",2,"Imposes conditions on the execution of a SQL statement. The SQL ")
INSERT INTO helpsql VALUES("IF...ELSE",3,"statement following an IF keyword and its condition is executed if the ")
INSERT INTO helpsql VALUES("IF...ELSE",4,"condition is satisfied (when the Boolean expression returns true). The ")
INSERT INTO helpsql VALUES("IF...ELSE",5,"optional ELSE keyword introduces an alternate SQL statement that is ")
INSERT INTO helpsql VALUES("IF...ELSE",6,"executed when the IF condition is not satisfied (when the Boolean ")
INSERT INTO helpsql VALUES("IF...ELSE",7,"expression returns false). ")
INSERT INTO helpsql VALUES("IF...ELSE",8," ")
INSERT INTO helpsql VALUES("IF...ELSE",9,"IF <Boolean_expression>")
INSERT INTO helpsql VALUES("IF...ELSE",10,"     {<sql_statement> | <statement_block>}")
INSERT INTO helpsql VALUES("IF...ELSE",11,"[ELSE [<Boolean_expression>]")
INSERT INTO helpsql VALUES("IF...ELSE",12,"     {<sql_statement> | <statement_block>}]")
INSERT INTO helpsql VALUES("RETURN",1,"RETURN Statement")
INSERT INTO helpsql VALUES("RETURN",2,"Exits unconditionally from a query or procedure. RETURN is immediate and ")
INSERT INTO helpsql VALUES("RETURN",3,"complete; statements following RETURN are not executed. ")
INSERT INTO helpsql VALUES("RETURN",4," ")
INSERT INTO helpsql VALUES("RETURN",5,"RETURN ([<integer_expression>])")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("WAITFOR",1,"WAITFOR Statement")
INSERT INTO helpsql VALUES("WAITFOR",2,"Specifies a time, time interval, or event that triggers execution of a ")
INSERT INTO helpsql VALUES("WAITFOR",3,"statement block, stored procedure, or transaction.")
INSERT INTO helpsql VALUES("WAITFOR",4," ")
INSERT INTO helpsql VALUES("WAITFOR",5,"WAITFOR {DELAY '<time>' | TIME '<time>'}")
INSERT INTO helpsql VALUES("WHILE",1,"WHILE Construct")
INSERT INTO helpsql VALUES("WHILE",2,"Sets a condition for the repeated execution of an <sql_statement> or ")
INSERT INTO helpsql VALUES("WHILE",3,"statement block. The statements are executed repeatedly as long as the ")
INSERT INTO helpsql VALUES("WHILE",4,"specified condition is true. The execution of statements in the WHILE ")
INSERT INTO helpsql VALUES("WHILE",5,"loop can be controlled from inside the loop with the BREAK and CONTINUE ")
INSERT INTO helpsql VALUES("WHILE",6,"keywords.")
INSERT INTO helpsql VALUES("WHILE",7," ")
INSERT INTO helpsql VALUES("WHILE",8,"WHILE <Boolean_expression> ")
INSERT INTO helpsql VALUES("WHILE",9,"       {<sql_statement> | <statement_block>}")
INSERT INTO helpsql VALUES("WHILE",10,"     [BREAK]")
INSERT INTO helpsql VALUES("WHILE",11,"       {<sql_statement> | <statement_block>}")
INSERT INTO helpsql VALUES("WHILE",12,"     [CONTINUE]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("CREATE DATABASE",1,"CREATE DATABASE Statement")
INSERT INTO helpsql VALUES("CREATE DATABASE",2,"Creates a new database. You must be in the master database to create a ")
INSERT INTO helpsql VALUES("CREATE DATABASE",3,"new database.")
INSERT INTO helpsql VALUES("CREATE DATABASE",4," ")
INSERT INTO helpsql VALUES("CREATE DATABASE",5,"CREATE DATABASE <database_name>")
INSERT INTO helpsql VALUES("CREATE DATABASE",6,"[ON {DEFAULT | <database_device>} [= <size>]")
INSERT INTO helpsql VALUES("CREATE DATABASE",7,"     [, <database_device> [= <size>]]...]")
INSERT INTO helpsql VALUES("CREATE DATABASE",8,"[LOG ON <database_device> [= <size>]")
INSERT INTO helpsql VALUES("CREATE DATABASE",9,"     [, <database_device> [= <size>]]...]")
INSERT INTO helpsql VALUES("CREATE DATABASE",10,"[FOR LOAD]")
INSERT INTO helpsql VALUES("CREATE DEFAULT",1,"CREATE DEFAULT Statement")
INSERT INTO helpsql VALUES("CREATE DEFAULT",2,"Creates an object that, when bound to a column or a user-defined ")
INSERT INTO helpsql VALUES("CREATE DEFAULT",3,"datatype, specifies a value to be inserted into the column to which it's ")
INSERT INTO helpsql VALUES("CREATE DEFAULT",4,"bound (or into all columns in the case of a user-defined datatype) when ")
INSERT INTO helpsql VALUES("CREATE DEFAULT",5,"no value is explicitly supplied during an insert.")
INSERT INTO helpsql VALUES("CREATE DEFAULT",6," ")
INSERT INTO helpsql VALUES("CREATE DEFAULT",7,"CREATE DEFAULT [<owner>.]<<default_name>>")
INSERT INTO helpsql VALUES("CREATE DEFAULT",8,"AS <constant_expression>")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("CREATE INDEX",1,"CREATE INDEX Statement")
INSERT INTO helpsql VALUES("CREATE INDEX",2,"Creates an index on a given table that either changes the physical ")
INSERT INTO helpsql VALUES("CREATE INDEX",3,"ordering of the table or provides the optimizer with a logical ordering ")
INSERT INTO helpsql VALUES("CREATE INDEX",4,"of the table to increase efficiency for queries. ")
INSERT INTO helpsql VALUES("CREATE INDEX",5," ")
INSERT INTO helpsql VALUES("CREATE INDEX",6,"CREATE [UNIQUE] [CLUSTERED | NONCLUSTERED] INDEX <index_name>")
INSERT INTO helpsql VALUES("CREATE INDEX",7,"     ON [[<database>.]<owner>.]<table_name> (<column_name> ")
INSERT INTO helpsql VALUES("CREATE INDEX",8,"          [, <column_name>]...)")
INSERT INTO helpsql VALUES("CREATE INDEX",9,"[WITH ")
INSERT INTO helpsql VALUES("CREATE INDEX",10,"     [PAD_INDEX,] ")
INSERT INTO helpsql VALUES("CREATE INDEX",11,"     [[,]FILLFACTOR = <fillfactor>] ")
INSERT INTO helpsql VALUES("CREATE INDEX",12,"     [[,] IGNORE_DUP_KEY]")
INSERT INTO helpsql VALUES("CREATE INDEX",13,"     [[,] SORTED_DATA | SORTED_DATA_REORG] ")
INSERT INTO helpsql VALUES("CREATE INDEX",14,"     [[,] IGNORE_DUP_ROW | ALLOW_DUP_ROW]]")
INSERT INTO helpsql VALUES("CREATE INDEX",15,"[ON <segment_name>]")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",1,"CREATE PROCEDURE Statement")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",2,"Creates a stored procedure (a precompiled collection of SQL statements")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",3,"that can take and/or return ")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",4,"user-supplied parameters.")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",5," ")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",6,"CREATE PROCedure [<owner>.] procedure_name [;<number>]")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",7,"     [(<parameter1> [, <parameter2>]...[<parameter255>])]")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",8,"[{FOR REPLICATION} | {WITH RECOMPILE}")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",9,"     [{[WITH] | [,]} ENCRYPTION]]")
INSERT INTO helpsql VALUES("CREATE PROCEDURE",10,"AS <sql_statements>")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("CREATE RULE",1,"CREATE RULE Statement")
INSERT INTO helpsql VALUES("CREATE RULE",2,"Creates an object called a rule, which, when bound to a column or a ")
INSERT INTO helpsql VALUES("CREATE RULE",3,"user-defined datatype, specifies the acceptable values that can be inserted ")
INSERT INTO helpsql VALUES("CREATE RULE",4,"into that column.")
INSERT INTO helpsql VALUES("CREATE RULE",5," ")
INSERT INTO helpsql VALUES("CREATE RULE",6,"CREATE RULE [<owner>.]<<rule_name>>")
INSERT INTO helpsql VALUES("CREATE RULE",7,"AS <condition_expression>")
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("CREATE SCHEMA",1,"CREATE SCHEMA Statement")
INSERT INTO helpsql VALUES("CREATE SCHEMA",2,"Creates a schema that can be thought of as a conceptual container object,")
INSERT INTO helpsql VALUES("CREATE SCHEMA",3,"which is the definition of the database without any data in it.")
INSERT INTO helpsql VALUES("CREATE SCHEMA",4,"CREATE SCHEMA")
INSERT INTO helpsql VALUES("CREATE SCHEMA",5,"     [AUTHORIZATION <owner>]")
INSERT INTO helpsql VALUES("CREATE SCHEMA",6,"          [<schema_element1> [<schema_element2> [...<schema_elementn>]]]")

INSERT INTO helpsql VALUES("CREATE TABLE",1,"CREATE TABLE Statement")
INSERT INTO helpsql VALUES("CREATE TABLE",2,"Creates a new table.")
INSERT INTO helpsql VALUES("CREATE TABLE",3," ")
INSERT INTO helpsql VALUES("CREATE TABLE",4,"CREATE TABLE [<database>.[<owner>].]<table_name> ")
INSERT INTO helpsql VALUES("CREATE TABLE",5," ")
INSERT INTO helpsql VALUES("CREATE TABLE",6,"     {<col_name> <column_properties> [<constraint> [<constraint> ")
INSERT INTO helpsql VALUES("CREATE TABLE",7,"          [... <constraint>]]]")
INSERT INTO helpsql VALUES("CREATE TABLE",8,"     | [[,] <constraint>]}")
INSERT INTO helpsql VALUES("CREATE TABLE",9,"          [[,] {<next_col_name> | ")
INSERT INTO helpsql VALUES("CREATE TABLE",10,"          <next_constraint>}...]")
INSERT INTO helpsql VALUES("CREATE TABLE",11," ")
INSERT INTO helpsql VALUES("CREATE TABLE",12,"[ON <segment_name>]")
INSERT INTO helpsql VALUES("CREATE TABLE",13," ")
INSERT INTO helpsql VALUES("CREATE TABLE",14,"<column_properties> =")
INSERT INTO helpsql VALUES("CREATE TABLE",15,"     <datatype> [NULL | NOT NULL | IDENTITY[(<seed>, <increment>)]]")
INSERT INTO helpsql VALUES("CREATE TABLE",16,"<constraint> =")
INSERT INTO helpsql VALUES("CREATE TABLE",17,"  For a PRIMARY KEY constraint:")
INSERT INTO helpsql VALUES("CREATE TABLE",18,"     [CONSTRAINT <constraint_name>]")
INSERT INTO helpsql VALUES("CREATE TABLE",19,"          PRIMARY KEY [CLUSTERED | NONCLUSTERED]")
INSERT INTO helpsql VALUES("CREATE TABLE",20,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
INSERT INTO helpsql VALUES("CREATE TABLE",21,"               [ON <segment_name>] ")
INSERT INTO helpsql VALUES("CREATE TABLE",22,"  For a UNIQUE constraint:")
INSERT INTO helpsql VALUES("CREATE TABLE",23,"     [CONSTRAINT <constraint_name>]")
INSERT INTO helpsql VALUES("CREATE TABLE",24,"          UNIQUE [CLUSTERED | NONCLUSTERED]")
INSERT INTO helpsql VALUES("CREATE TABLE",25,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
INSERT INTO helpsql VALUES("CREATE TABLE",26,"               [ON <segment_name>] ")
INSERT INTO helpsql VALUES("CREATE TABLE",27,"  For a FOREIGN KEY constraint:")
INSERT INTO helpsql VALUES("CREATE TABLE",28,"     [CONSTRAINT <constraint_name>]")
INSERT INTO helpsql VALUES("CREATE TABLE",29,"          [FOREIGN KEY (<col_name> [, <col_name2> ")
INSERT INTO helpsql VALUES("CREATE TABLE",30,"               [..., <col_name16> ]])]")
INSERT INTO helpsql VALUES("CREATE TABLE",31,"               REFERENCES [<owner>.]<ref_table> [(<ref_col> ")
INSERT INTO helpsql VALUES("CREATE TABLE",32,"               [, <ref_col2> [..., <ref_col16>]])]")
INSERT INTO helpsql VALUES("CREATE TABLE",33,"  For a DEFAULT constraint:")
INSERT INTO helpsql VALUES("CREATE TABLE",34,"     [CONSTRAINT <constraint_name>]")
INSERT INTO helpsql VALUES("CREATE TABLE",35,"          DEFAULT {<constant_expression> | <niladic-function> | NULL}")
INSERT INTO helpsql VALUES("CREATE TABLE",36,"               [FOR <col_name>]")
INSERT INTO helpsql VALUES("CREATE TABLE",37,"  For a CHECK constraint(s):")
INSERT INTO helpsql VALUES("CREATE TABLE",38,"     [CONSTRAINT <constraint_name>]")
INSERT INTO helpsql VALUES("CREATE TABLE",39,"          CHECK [NOT FOR REPLICATION] (<expression>) ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("CREATE TRIGGER",1,"CREATE TRIGGER Statement")
INSERT INTO helpsql VALUES("CREATE TRIGGER",2,"Creates a trigger, a special kind of stored procedure that is executed ")
INSERT INTO helpsql VALUES("CREATE TRIGGER",3,"automatically when a user attempts the specified data-modification ")
INSERT INTO helpsql VALUES("CREATE TRIGGER",4,"statement on the specified table.")
INSERT INTO helpsql VALUES("CREATE TRIGGER",5," ")
INSERT INTO helpsql VALUES("CREATE TRIGGER",6,"CREATE TRIGGER [<owner>.]<<trigger_name>>")
INSERT INTO helpsql VALUES("CREATE TRIGGER",7,"ON [<owner>.]<table_name>")
INSERT INTO helpsql VALUES("CREATE TRIGGER",8,"FOR {INSERT, UPDATE, DELETE}")
INSERT INTO helpsql VALUES("CREATE TRIGGER",9,"[WITH ENCRYPTION]")
INSERT INTO helpsql VALUES("CREATE TRIGGER",10,"AS <sql_statements> ")
INSERT INTO helpsql VALUES("CREATE TRIGGER",11," ")
INSERT INTO helpsql VALUES("CREATE TRIGGER",12,"Or, using the IF UPDATE clause:")
INSERT INTO helpsql VALUES("CREATE TRIGGER",13,"CREATE TRIGGER [<owner>.]<<trigger_name>>")
INSERT INTO helpsql VALUES("CREATE TRIGGER",14,"ON [<owner>.]<table_name>")
INSERT INTO helpsql VALUES("CREATE TRIGGER",15,"FOR {INSERT, UPDATE}")
INSERT INTO helpsql VALUES("CREATE TRIGGER",16,"[WITH ENCRYPTION]")
INSERT INTO helpsql VALUES("CREATE TRIGGER",17,"AS")
INSERT INTO helpsql VALUES("CREATE TRIGGER",18,"IF UPDATE (<column_name>)")
INSERT INTO helpsql VALUES("CREATE TRIGGER",19,"[{AND | OR} UPDATE (<column_name>)...] <sql_statements>")
INSERT INTO helpsql VALUES("CREATE VIEW",1,"CREATE VIEW Statement")
INSERT INTO helpsql VALUES("CREATE VIEW",2,"Creates a virtual table that represents an alternative way of looking at ")
INSERT INTO helpsql VALUES("CREATE VIEW",3,"the data in one or more tables. You can use views as security mechanisms ")
INSERT INTO helpsql VALUES("CREATE VIEW",4,"by granting permission on a view but not on underlying tables.")
INSERT INTO helpsql VALUES("CREATE VIEW",5," ")
INSERT INTO helpsql VALUES("CREATE VIEW",6,"CREATE VIEW [<owner>.]<view_name>")
INSERT INTO helpsql VALUES("CREATE VIEW",7,"[(<column_name> [, <column_name>]...)]")
INSERT INTO helpsql VALUES("CREATE VIEW",8,"[WITH ENCRYPTION]")
INSERT INTO helpsql VALUES("CREATE VIEW",9,"AS <select_statement> [WITH CHECK OPTION]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("CURSORS",1,"Cursors")
INSERT INTO helpsql VALUES("CURSORS",2,"Server cursors allow individual row operations to be performed on a ")
INSERT INTO helpsql VALUES("CURSORS",3,"given results set or on the entire set. In SQL Server 6.0, ANSI SQL ")
INSERT INTO helpsql VALUES("CURSORS",4,"cursors are server-based.")
INSERT INTO helpsql VALUES("CURSORS",5," ")
INSERT INTO helpsql VALUES("CURSORS",6,"DECLARE Statement     Defines a cursor.")
INSERT INTO helpsql VALUES("CURSORS",7,"OPEN Statement               Opens a declared cursor.")
INSERT INTO helpsql VALUES("CURSORS",8,"FETCH Statement              Retrieves a specific row from the cursor.")
INSERT INTO helpsql VALUES("CURSORS",9,"  ")
INSERT INTO helpsql VALUES("CURSORS",10,"FETCH [[NEXT | PRIOR | FIRST | LAST | ABSOLUTE ")
INSERT INTO helpsql VALUES("CURSORS",11,"     {n | @nvar} | RELATIVE {n | @nvar}] ")
INSERT INTO helpsql VALUES("CURSORS",12,"     FROM] cursor_name")
INSERT INTO helpsql VALUES("CURSORS",13,"     [INTO @variable_name1, @variable_name2,...]")
INSERT INTO helpsql VALUES("CURSORS",14," ")   
INSERT INTO helpsql VALUES("CURSORS",15,"CLOSE Statement              Closes an open cursor.")
INSERT INTO helpsql VALUES("CURSORS",16,"DEALLOCATE Statement         Removes the cursor data structures.")
INSERT INTO helpsql VALUES("DECLARE CURSOR",1,"DECLARE Statement")
INSERT INTO helpsql VALUES("DECLARE CURSOR",2,"Defines a cursor. Once declared, row sets for cursors are assigned by ")
INSERT INTO helpsql VALUES("DECLARE CURSOR",3,"using the OPEN statement. (The DECLARE statement can also be used to ")
INSERT INTO helpsql VALUES("DECLARE CURSOR",4,"define the name and type of local variables for a batch or procedure.) ")
INSERT INTO helpsql VALUES("DECLARE CURSOR",5," ")
INSERT INTO helpsql VALUES("DECLARE CURSOR",6,"DECLARE <cursor_name> [INSENSITIVE] [SCROLL] CURSOR ")
INSERT INTO helpsql VALUES("DECLARE CURSOR",7,"FOR <select_statement> ")
INSERT INTO helpsql VALUES("DECLARE CURSOR",8,"[FOR {READ ONLY | UPDATE [OF <column_list>]}]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("OPEN",1,"OPEN Statement")
INSERT INTO helpsql VALUES("OPEN",2,"Opens a cursor.")
INSERT INTO helpsql VALUES("OPEN",3," ")
INSERT INTO helpsql VALUES("OPEN",4,"OPEN <cursor_name>")
INSERT INTO helpsql VALUES("FETCH",1,"FETCH Statement")
INSERT INTO helpsql VALUES("FETCH",2,"Retrieves a specific row from the cursor.")
INSERT INTO helpsql VALUES("FETCH",3," ")
INSERT INTO helpsql VALUES("FETCH",4,"FETCH [[NEXT | PRIOR | FIRST | LAST | ")
INSERT INTO helpsql VALUES("FETCH",5,"     ABSOLUTE {<n> | @<nvar>} | RELATIVE {<n> | @<nvar>}] FROM] <cursor_name> ")
INSERT INTO helpsql VALUES("FETCH",6,"[INTO @<variable_name1>, @<variable_name2>, ...]")
INSERT INTO helpsql VALUES("CLOSE",1,"CLOSE Statement")
INSERT INTO helpsql VALUES("CLOSE",2,"Closes an open cursor. CLOSE leaves the data structures accessible for ")
INSERT INTO helpsql VALUES("CLOSE",3,"reopening; however, modifications or fetches are not allowed until the ")
INSERT INTO helpsql VALUES("CLOSE",4,"cursor is reopened.")
INSERT INTO helpsql VALUES("CLOSE",5," ")
INSERT INTO helpsql VALUES("CLOSE",6,"CLOSE <cursor_name>")
INSERT INTO helpsql VALUES("DEALLOCATE",1,"DEALLOCATE Statement")
INSERT INTO helpsql VALUES("DEALLOCATE",2,"Removes the cursor data structures. DEALLOCATE is different from CLOSE ")
INSERT INTO helpsql VALUES("DEALLOCATE",3,"in that a closed cursor can be re-opened. DEALLOCATE releases all data ")
INSERT INTO helpsql VALUES("DEALLOCATE",4,"structures associated with the cursor and removes the definition of the ")
INSERT INTO helpsql VALUES("DEALLOCATE",5,"cursor. ")
INSERT INTO helpsql VALUES("DEALLOCATE",6," ")
INSERT INTO helpsql VALUES("DEALLOCATE",7,"DEALLOCATE <cursor_name>")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("DATATYPES",1,"Datatypes")
INSERT INTO helpsql VALUES("DATATYPES",2,"Datatypes specify the data characteristics of columns, stored-procedure ")
INSERT INTO helpsql VALUES("DATATYPES",3,"parameters, and local variables. ")
INSERT INTO helpsql VALUES("DATATYPES",4," ")
INSERT INTO helpsql VALUES("DATATYPES",5,"Binary                  binary[(<n>)]")
INSERT INTO helpsql VALUES("DATATYPES",6,"                        varbinary[(<n>)]")
INSERT INTO helpsql VALUES("DATATYPES",7,"Character               char[(<n>)]")
INSERT INTO helpsql VALUES("DATATYPES",8,"                        varchar[(<n>)]")
INSERT INTO helpsql VALUES("DATATYPES",9,"Date and time           datetime")
INSERT INTO helpsql VALUES("DATATYPES",10,"                        smalldatetime")
INSERT INTO helpsql VALUES("DATATYPES",11,"Exact numeric           decimal[(<p>[, <s>])]")
INSERT INTO helpsql VALUES("DATATYPES",12,"                        numeric[(<p>[, <s>])]")
INSERT INTO helpsql VALUES("DATATYPES",13,"Approximate numeric     float[(<n>)]")
INSERT INTO helpsql VALUES("DATATYPES",14,"                        real")
INSERT INTO helpsql VALUES("DATATYPES",15,"Integer                 int")
INSERT INTO helpsql VALUES("DATATYPES",16,"                        smallint")
INSERT INTO helpsql VALUES("DATATYPES",17,"                        tinyint")
INSERT INTO helpsql VALUES("DATATYPES",18,"Monetary                money")
INSERT INTO helpsql VALUES("DATATYPES",19,"                        smallmoney")
INSERT INTO helpsql VALUES("DATATYPES",20,"Special                 bit")
INSERT INTO helpsql VALUES("DATATYPES",21,"                        timestamp")
INSERT INTO helpsql VALUES("DATATYPES",22,"                        user-defined datatypes")
INSERT INTO helpsql VALUES("DATATYPES",23,"Text and image          text")
INSERT INTO helpsql VALUES("DATATYPES",24,"                        image")
INSERT INTO helpsql VALUES("DATATYPES",25,"Synonyms                binary varying for varbinary")
INSERT INTO helpsql VALUES("DATATYPES",26,"                        char varying for varchar")
INSERT INTO helpsql VALUES("DATATYPES",27,"                        character for char")
INSERT INTO helpsql VALUES("DATATYPES",28,"                        character for char(1)")
INSERT INTO helpsql VALUES("DATATYPES",29,"                        character(<n>) for char(<n>)")
INSERT INTO helpsql VALUES("DATATYPES",30,"                        character varying(<n>) for varchar(<n>)")
INSERT INTO helpsql VALUES("DATATYPES",31,"                        dec for decimal")
INSERT INTO helpsql VALUES("DATATYPES",32,"                        double precision for float")
INSERT INTO helpsql VALUES("DATATYPES",33,"                        float[(<n>)] for n = 1-7 for real")
INSERT INTO helpsql VALUES("DATATYPES",34,"                        float[(<n>)] for n = 8-15 for float")
INSERT INTO helpsql VALUES("DATATYPES",35,"                        integer for int")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("DBCC",1,"DBCC Statement")
INSERT INTO helpsql VALUES("DBCC",2,"Used to check the logical and physical consistency of a database, check ")
INSERT INTO helpsql VALUES("DBCC",3,"memory usage, decrease the size of a database, check performance ")
INSERT INTO helpsql VALUES("DBCC",4,"statistics, and so on. DBCC is the SQL Server Database Consistency ")
INSERT INTO helpsql VALUES("DBCC",5,"Checker.")
INSERT INTO helpsql VALUES("DBCC",6," ")
INSERT INTO helpsql VALUES("DBCC",7,"DBCC { ")
INSERT INTO helpsql VALUES("DBCC",8,"     CHECKALLOC [(<database_name> [, NOINDEX])] | ")
INSERT INTO helpsql VALUES("DBCC",9,"     CHECKCATALOG [(<database_name>)] | ")
INSERT INTO helpsql VALUES("DBCC",10,"     CHECKTABLE (<table_name> [, NOINDEX | <index_id>]) | ")
INSERT INTO helpsql VALUES("DBCC",11,"     CHECKDB [(<database_name> [, NOINDEX])] | ")
INSERT INTO helpsql VALUES("DBCC",12,"     CHECKIDENT[(<table_name>)] | ")
INSERT INTO helpsql VALUES("DBCC",13,"     DBREINDEX([<databases>.<owner>.<table_name>[, <index_name>")
INSERT INTO helpsql VALUES("DBCC",14,"     [, fillfactor [,{SORTED_DATA | SORTED_DATA_REORG}]]]]")
INSERT INTO helpsql VALUES("DBCC",15,"     DBREPAIR (<database_name>, DROPDB) [, NOINIT]) | ")
INSERT INTO helpsql VALUES("DBCC",16,"     <dllname> (FREE) | ")
INSERT INTO helpsql VALUES("DBCC",17,"     INPUTBUFFER (<spid>) | ")
INSERT INTO helpsql VALUES("DBCC",18,"     MEMUSAGE | ")
INSERT INTO helpsql VALUES("DBCC",19,"     NEWALLOC [(<database_name> [, NOINDEX])] | ")
INSERT INTO helpsql VALUES("DBCC",20,"     OPENTRAN ({<database_name>} | {<database_id>}) ")
INSERT INTO helpsql VALUES("DBCC",21,"          [WITH TABLERESULTS] | ")
INSERT INTO helpsql VALUES("DBCC",22,"     OUTPUTBUFFER (<spid>) | ")
INSERT INTO helpsql VALUES("DBCC",23,"     PERFMON | ")
INSERT INTO helpsql VALUES("DBCC",24,"     PINTABLE (<database_id>, <table_id>) | ")
INSERT INTO helpsql VALUES("DBCC",25,"     PROCCACHE | ")
INSERT INTO helpsql VALUES("DBCC",26,"     SHOW_STATISTICS (<table_name>, <index_name>) | ")
INSERT INTO helpsql VALUES("DBCC",27,"     SHOWCONTIG (<table_id>, [<index_id>]) | ")
INSERT INTO helpsql VALUES("DBCC",28,"     SHRINKDB (<database_name> [, <new_size> [, 'MASTEROVERRIDE']]) | ")
INSERT INTO helpsql VALUES("DBCC",29,"     SQLPERF ({IOSTATS | LRUSTATS | NETSTATS | RASTATS [, CLEAR]} |")
INSERT INTO helpsql VALUES("DBCC",30,"          {THREADS} | {LOGSPACE}) | ")
INSERT INTO helpsql VALUES("DBCC",31,"     TEXTALL [({<database_name> | <database_id>}[, FULL | FAST])] | ")
INSERT INTO helpsql VALUES("DBCC",32,"     TEXTALLOC [({<table_name> | <table_id>}[, FULL | FAST])] | ")
INSERT INTO helpsql VALUES("DBCC",33,"     TRACEOFF (<trace#>) | ")
INSERT INTO helpsql VALUES("DBCC",34,"     TRACEON (<trace#>) | ")
INSERT INTO helpsql VALUES("DBCC",35,"     TRACESTATUS (<trace#> [, <trace#>...]) | ")
INSERT INTO helpsql VALUES("DBCC",36,"     UNPINTABLE (<database_id>, <table_id>) | ")
INSERT INTO helpsql VALUES("DBCC",37,"     UPDATEUSAGE ({0 | <database_name>} [, <table_name> ")
INSERT INTO helpsql VALUES("DBCC",38,"          [, <index_id>]]) [WITH COUNT_ROWS] |")
INSERT INTO helpsql VALUES("DBCC",39,"     USEROPTIONS} ")
INSERT INTO helpsql VALUES("DBCC",40,"	[WITH NO_INFOMSGS]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("DECLARE",1,"DECLARE Statement")
INSERT INTO helpsql VALUES("DECLARE",2,"Used to define the name and type of local variables for a batch or ")
INSERT INTO helpsql VALUES("DECLARE",3,"procedure, and to define cursors.")
INSERT INTO helpsql VALUES("DECLARE",4," ")
INSERT INTO helpsql VALUES("DECLARE",5,"DECLARE @<variable_name> <datatype> ")
INSERT INTO helpsql VALUES("DECLARE",6,"     [, @<variable_name> <datatype>...]")
INSERT INTO helpsql VALUES("DELETE",1,"DELETE Statement")
INSERT INTO helpsql VALUES("DELETE",2,"Removes rows from a table.")
INSERT INTO helpsql VALUES("DELETE",3," ")
INSERT INTO helpsql VALUES("DELETE",4,"DELETE [FROM] {<table_name> | <view_name>}")
INSERT INTO helpsql VALUES("DELETE",5,"     [WHERE clause]")
INSERT INTO helpsql VALUES("DELETE",6," ")
INSERT INTO helpsql VALUES("DELETE",7,"Transact-SQL extension Syntax:")
INSERT INTO helpsql VALUES("DELETE",8,"DELETE [FROM] {<table_name> | <view_name>}")
INSERT INTO helpsql VALUES("DELETE",9,"     [FROM {<table_name> | <view_name>}")
INSERT INTO helpsql VALUES("DELETE",10,"          [, {<table_name> | <view_name>}]...]")
INSERT INTO helpsql VALUES("DELETE",11,"               [..., {<table_name16> | <view_name16>}]] ")
INSERT INTO helpsql VALUES("DELETE",12,"[WHERE clause]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("DISK INIT",1,"DISK INIT Statement")
INSERT INTO helpsql VALUES("DISK INIT",2,"Creates a device on which a database or multiple databases can be ")
INSERT INTO helpsql VALUES("DISK INIT",3,"placed. A device is an operating-system file that SQL Server pre-")
INSERT INTO helpsql VALUES("DISK INIT",4,"allocates for database use.")
INSERT INTO helpsql VALUES("DISK INIT",5," ")
INSERT INTO helpsql VALUES("DISK INIT",6,"DISK INIT ")
INSERT INTO helpsql VALUES("DISK INIT",7,"     NAME = '<logical_name>',")
INSERT INTO helpsql VALUES("DISK INIT",8,"     PHYSNAME = '<physical_name>',")
INSERT INTO helpsql VALUES("DISK INIT",9,"     VDEVNO = <virtual_device_number>,")
INSERT INTO helpsql VALUES("DISK INIT",10,"     SIZE = <number_of_2K_blocks>")
INSERT INTO helpsql VALUES("DISK INIT",11,"[, VSTART = <virtual_address>]")
INSERT INTO helpsql VALUES("DISK MIRROR",1,"DISK MIRROR Statement")
INSERT INTO helpsql VALUES("DISK MIRROR",2,"Creates a software image of the SQL Server device.")
INSERT INTO helpsql VALUES("DISK MIRROR",3," ")
INSERT INTO helpsql VALUES("DISK MIRROR",4,"DISK MIRROR")
INSERT INTO helpsql VALUES("DISK MIRROR",5,"     NAME = '<logical_name>',")
INSERT INTO helpsql VALUES("DISK MIRROR",6,"     MIRROR = '<physical_name>'")
INSERT INTO helpsql VALUES("DISK MIRROR",7,"     [, WRITES = {SERIAL | NOSERIAL}]")
INSERT INTO helpsql VALUES("DISK UNMIRROR",1,"DISK UNMIRROR Statement")
INSERT INTO helpsql VALUES("DISK UNMIRROR",2,"Temporarily pauses software mirroring for the SQL Server device. Often ")
INSERT INTO helpsql VALUES("DISK UNMIRROR",3,"this is useful when large non-logged operations are occurring against ")
INSERT INTO helpsql VALUES("DISK UNMIRROR",4,"the database and when a database backup (using the DUMP statement) will ")
INSERT INTO helpsql VALUES("DISK UNMIRROR",5,"be performed after the non-logged operations finish.")
INSERT INTO helpsql VALUES("DISK UNMIRROR",6," ")
INSERT INTO helpsql VALUES("DISK UNMIRROR",7,"DISK UNMIRROR")
INSERT INTO helpsql VALUES("DISK UNMIRROR",8,"     NAME = '<logical_name>'")
INSERT INTO helpsql VALUES("DISK UNMIRROR",9,"     [, SIDE = {PRIMARY | SECONDARY}]")
INSERT INTO helpsql VALUES("DISK UNMIRROR",10,"     [, MODE = {RETAIN | REMOVE}]")
INSERT INTO helpsql VALUES("DISK REMIRROR",1,"DISK REMIRROR Statement")
INSERT INTO helpsql VALUES("DISK REMIRROR",2,"Resumes software mirroring for the SQL Server device.")
INSERT INTO helpsql VALUES("DISK REMIRROR",3," ")
INSERT INTO helpsql VALUES("DISK REMIRROR",4,"DISK REMIRROR")
INSERT INTO helpsql VALUES("DISK REMIRROR",5,"     NAME = '<logical_name>'")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("DISK REFIT",1,"DISK REFIT Statement")
INSERT INTO helpsql VALUES("DISK REFIT",2,"Restores usage information from the system tables when a device exists ")
INSERT INTO helpsql VALUES("DISK REFIT",3,"(the file is present) but the entries in the sysusages table no longer ")
INSERT INTO helpsql VALUES("DISK REFIT",4,"exist. This occurs after a damaged master database is restored and the ")
INSERT INTO helpsql VALUES("DISK REFIT",5,"master database is incomplete (databases and devices were added or ")
INSERT INTO helpsql VALUES("DISK REFIT",6,"altered since the last backup of master). ")
INSERT INTO helpsql VALUES("DISK REFIT",7," ")
INSERT INTO helpsql VALUES("DISK REFIT",8,"DISK REFIT")
INSERT INTO helpsql VALUES("DISK REINIT",1,"DISK REINIT Statement")
INSERT INTO helpsql VALUES("DISK REINIT",2,"Restores the device entries to the system tables when a device exists ")
INSERT INTO helpsql VALUES("DISK REINIT",3,"(the file is present) and the entry in the sysdevices table no longer ")
INSERT INTO helpsql VALUES("DISK REINIT",4,"exists. This occurs after a damaged master database is restored and the ")
INSERT INTO helpsql VALUES("DISK REINIT",5,"master database is incomplete (databases and devices were added or ")
INSERT INTO helpsql VALUES("DISK REINIT",6,"altered since the last backup of master). This is the first step for ")
INSERT INTO helpsql VALUES("DISK REINIT",7,"restoring access to user databases. The DISK REFIT statement completes ")
INSERT INTO helpsql VALUES("DISK REINIT",8,"the recovery.")
INSERT INTO helpsql VALUES("DISK REINIT",9," ")
INSERT INTO helpsql VALUES("DISK REINIT",10,"DISK REINIT")
INSERT INTO helpsql VALUES("DISK REINIT",11,"     NAME = '<logical_name>',")
INSERT INTO helpsql VALUES("DISK REINIT",12,"     PHYSNAME = '<physical_name>',")
INSERT INTO helpsql VALUES("DISK REINIT",13,"     VDEVNO = <virtual_device_number>,")
INSERT INTO helpsql VALUES("DISK REINIT",14,"     SIZE = <number_of_2K_blocks>")
INSERT INTO helpsql VALUES("DISK REINIT",15,"     [, VSTART = <virtual_address>]")
INSERT INTO helpsql VALUES("DISK RESIZE",1,"DISK RESIZE Statement")
INSERT INTO helpsql VALUES("DISK RESIZE",2,"Allows you to expand a device. You can use DISK RESIZE on any database ")
INSERT INTO helpsql VALUES("DISK RESIZE",3,"device, including the MASTER device.")
INSERT INTO helpsql VALUES("DISK RESIZE",4," ")
INSERT INTO helpsql VALUES("DISK RESIZE",5,"DISK RESIZE ")
INSERT INTO helpsql VALUES("DISK RESIZE",6,"     NAME = <logical_device_name>, ")
INSERT INTO helpsql VALUES("DISK RESIZE",7,"     SIZE = <final_size> ")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("DROP DATABASE",1,"DROP DATABASE Statement")
INSERT INTO helpsql VALUES("DROP DATABASE",2,"Removes one or more databases from SQL Server.")
INSERT INTO helpsql VALUES("DROP DATABASE",3," ")
INSERT INTO helpsql VALUES("DROP DATABASE",4,"DROP DATABASE <database_name> [, <database_name>...]")
INSERT INTO helpsql VALUES("DROP DEFAULT",1,"DROP DEFAULT Statement")
INSERT INTO helpsql VALUES("DROP DEFAULT",2,"Removes a user-defined default from a database. ")
INSERT INTO helpsql VALUES("DROP DEFAULT",3," ")
INSERT INTO helpsql VALUES("DROP DEFAULT",4,"DROP DEFAULT [<owner>.]<default_name> [, [<owner>.]<default_name>...]")
INSERT INTO helpsql VALUES("DROP INDEX",1,"DROP INDEX Statement")
INSERT INTO helpsql VALUES("DROP INDEX",2,"Removes an index from a database. ")
INSERT INTO helpsql VALUES("DROP INDEX",3," ")
INSERT INTO helpsql VALUES("DROP INDEX",4,"DROP INDEX [owner.]<table_name>.<index_name> ")
INSERT INTO helpsql VALUES("DROP INDEX",5,"              [, [owner.]<table_name>.<index_name>...]")
INSERT INTO helpsql VALUES("DROP PROCEDURE",1,"DROP PROCEDURE Statement")
INSERT INTO helpsql VALUES("DROP PROCEDURE",2,"Removes user-created stored procedures from the current database.")
INSERT INTO helpsql VALUES("DROP PROCEDURE",3," ")
INSERT INTO helpsql VALUES("DROP PROCEDURE",4,"DROP PROCedure [<owner>.]<procedure_name> ")
INSERT INTO helpsql VALUES("DROP PROCEDURE",5,"                   [, [<owner>.]<procedure_name>...]")
INSERT INTO helpsql VALUES("DROP RULE",1,"DROP RULE Statement")
INSERT INTO helpsql VALUES("DROP RULE",2,"Removes a user-specified rule from a database. ")
INSERT INTO helpsql VALUES("DROP RULE",3," ")
INSERT INTO helpsql VALUES("DROP RULE",4,"DROP RULE [<owner>.]<rule_name> ")
INSERT INTO helpsql VALUES("DROP RULE",5,"              [, [<owner>.]<rule_name>...]")
INSERT INTO helpsql VALUES("DROP TABLE",1,"DROP TABLE Statement")
INSERT INTO helpsql VALUES("DROP TABLE",2,"Removes a table definition and all data, indexes, triggers, constraints, and ")
INSERT INTO helpsql VALUES("DROP TABLE",3,"permission specifications for that table from the database.")
INSERT INTO helpsql VALUES("DROP TABLE",4," ")
INSERT INTO helpsql VALUES("DROP TABLE",5,"DROP TABLE [[<database>.]<owner>.]<table_name>")
INSERT INTO helpsql VALUES("DROP TABLE",6,"               [, [[<database>.]<owner>.]<table_name>...]")
INSERT INTO helpsql VALUES("DROP TRIGGER",1,"DROP TRIGGER Statement")
INSERT INTO helpsql VALUES("DROP TRIGGER",2,"Removes a trigger from a database. ")
INSERT INTO helpsql VALUES("DROP TRIGGER",3," ")
INSERT INTO helpsql VALUES("DROP TRIGGER",4,"DROP TRIGGER [<owner>.]<trigger_name> ")
INSERT INTO helpsql VALUES("DROP TRIGGER",5,"                 [, [<owner>.]<trigger_name>...]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("DROP VIEW",1,"DROP VIEW Statement")
INSERT INTO helpsql VALUES("DROP VIEW",2,"Removes a view from a database.")
INSERT INTO helpsql VALUES("DROP VIEW",3," ")
INSERT INTO helpsql VALUES("DROP VIEW",4,"DROP VIEW [<owner>.]<view_name> ")
INSERT INTO helpsql VALUES("DROP VIEW",5,"              [, [<owner>.]<view_name>...]")
INSERT INTO helpsql VALUES("DUMP",1,"DUMP Statement ")
INSERT INTO helpsql VALUES("DUMP",2,"Makes a backup copy of a database and its transaction log (DUMP ")
INSERT INTO helpsql VALUES("DUMP",3,"DATABASE) or only the transaction log (DUMP TRANSACTION) ")
INSERT INTO helpsql VALUES("DUMP",4,"in a form that can be read into SQL Server using the LOAD statement. ")
INSERT INTO helpsql VALUES("DUMP",5," ")
INSERT INTO helpsql VALUES("DUMP",6,"Dumping a database:")
INSERT INTO helpsql VALUES("DUMP",7,"     DUMP DATABASE {<dbname> | @<dbname_var>}")
INSERT INTO helpsql VALUES("DUMP",8,"          TO <dump_device> [, <dump_device2> [..., <dump_device32>]]")
INSERT INTO helpsql VALUES("DUMP",9,"      [WITH <options> ")
INSERT INTO helpsql VALUES("DUMP",10,"     [[,] STATS [=<percentage>]]]")
INSERT INTO helpsql VALUES("DUMP",11," ")
INSERT INTO helpsql VALUES("DUMP",12,"Dumping a transaction log:")
INSERT INTO helpsql VALUES("DUMP",13,"     DUMP TRANSACTION {<dbname> | @<dbname_var>} ")
INSERT INTO helpsql VALUES("DUMP",14,"         [TO <dump_device> [, <dump_device2> [..., <dump_device32>]]]")
INSERT INTO helpsql VALUES("DUMP",15,"     [WITH {TRUNCATE_ONLY | NO_LOG | NO_TRUNCATE}")
INSERT INTO helpsql VALUES("DUMP",16,"          {<options>}]")
INSERT INTO helpsql VALUES("DUMP",17," ")
INSERT INTO helpsql VALUES("DUMP",18,"Dumping a table:")
INSERT INTO helpsql VALUES("DUMP",19,"     DUMP TABLE [[<dbname>.]<owner>.]<table_name>")
INSERT INTO helpsql VALUES("DUMP",20,"          TO <dump_device> [, <dump_device2> [..., <dump_device32>]]")
INSERT INTO helpsql VALUES("DUMP",21,"          [WITH <options>]")
INSERT INTO helpsql VALUES("DUMP",22," ")
INSERT INTO helpsql VALUES("DUMP",23,"where")
INSERT INTO helpsql VALUES("DUMP",24,"<")
INSERT INTO helpsql VALUES("DUMP",25,"<dump_device> =")
INSERT INTO helpsql VALUES("DUMP",26,"     { <dump_device_name> | @<dump_device_namevar>} ")
INSERT INTO helpsql VALUES("DUMP",27,"     | {DISK | TAPE | FLOPPY | PIPE} = ")
INSERT INTO helpsql VALUES("DUMP",28,"          {'<temp_dump_device>' | @<temp_dump_device_var>} ")
INSERT INTO helpsql VALUES("DUMP",29,"     [VOLUME = {<volid> | @<volid_var>}]")
INSERT INTO helpsql VALUES("DUMP",30," ")
INSERT INTO helpsql VALUES("DUMP",31,"<options> =")
INSERT INTO helpsql VALUES("DUMP",32,"     [[,] {UNLOAD | NOUNLOAD}]")
INSERT INTO helpsql VALUES("DUMP",33,"     [[,] {INIT | NOINIT}]")
INSERT INTO helpsql VALUES("DUMP",34,"     [[,] {SKIP | NOSKIP}]")
INSERT INTO helpsql VALUES("DUMP",35,"     [[,] {{EXPIREDATE = {<date> | @<date_var>}} ")
INSERT INTO helpsql VALUES("DUMP",36,"          | {RETAINDAYS = {<days> | @<days_var>}}]")
INSERT INTO helpsql VALUES("DUMP",37,"     [[,] STATS [ = <percentage>]]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("EXECUTE",1,"EXECUTE Statement")
INSERT INTO helpsql VALUES("EXECUTE",2,"Executes a system procedure, a user-defined stored procedure, or an ")
INSERT INTO helpsql VALUES("EXECUTE",3,"extended stored procedure. Also supports the execution of a character ")
INSERT INTO helpsql VALUES("EXECUTE",4,"string within a Transact-SQL batch. ")
INSERT INTO helpsql VALUES("EXECUTE",5," ")
INSERT INTO helpsql VALUES("EXECUTE",6,"To execute a stored procedure:")
INSERT INTO helpsql VALUES("EXECUTE",7,"  EXEC[ute] ")
INSERT INTO helpsql VALUES("EXECUTE",8,"  {[@<return_status> =]")
INSERT INTO helpsql VALUES("EXECUTE",9,"     {[[[<server>.]<database>.]<owner>.]<procedure_name>[;<number>] | ")
INSERT INTO helpsql VALUES("EXECUTE",10,"          @<procedure_name_var>} ")
INSERT INTO helpsql VALUES("EXECUTE",11,"     [[@<parameter_name> =] {<value> | @<variable> [OUTPUT] | DEFAULT} ")
INSERT INTO helpsql VALUES("EXECUTE",12,"     [, [@<parameter_name> =] {<value> | @<variable> [OUTPUT] | ")
INSERT INTO helpsql VALUES("EXECUTE",13,"     DEFAULT}]...] [WITH RECOMPILE]}")
INSERT INTO helpsql VALUES("EXECUTE",14," ")
INSERT INTO helpsql VALUES("EXECUTE",15,"To execute a character string:")
INSERT INTO helpsql VALUES("EXECUTE",16,"  EXEC[ute] ({@<str_var> | '<tsql_string>'} [{@<str_var> | ")
INSERT INTO helpsql VALUES("EXECUTE",17,"     '<tsql_string>'}...])}")
INSERT INTO helpsql VALUES("EXPRESSION",1,"Expressions")
INSERT INTO helpsql VALUES("EXPRESSION",2,"Used as variables, constants, and column names in many SQL statements, ")
INSERT INTO helpsql VALUES("EXPRESSION",3,"functions and expressions. An expression returns values and can be ")
INSERT INTO helpsql VALUES("EXPRESSION",4,"nested.")
INSERT INTO helpsql VALUES("EXPRESSION",5," ")
INSERT INTO helpsql VALUES("EXPRESSION",6,"{<constant> | <column_name> | <function> | (<subquery>)}")
INSERT INTO helpsql VALUES("EXPRESSION",7,"[{operator | AND | OR | NOT}")
INSERT INTO helpsql VALUES("EXPRESSION",8,"{<constant> | <column_name> | <function> | (<subquery>)}...]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("FUNCTIONS",1,"Functions")
INSERT INTO helpsql VALUES("FUNCTIONS",2,"Functions return special information from the system about users, ")
INSERT INTO helpsql VALUES("FUNCTIONS",3,"expressions, a database or database objects, and so on. ")
INSERT INTO helpsql VALUES("FUNCTIONS",4," ")
INSERT INTO helpsql VALUES("FUNCTIONS",5,"+ (<expression> + <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",6,"ABS (<numeric_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",7,"ACOS (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",8,"ASCII (<char_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",9,"ASIN (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",10,"ATAN (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",11,"ATN2 (<float_expr1>1, <float_expr2>)")
INSERT INTO helpsql VALUES("FUNCTIONS",12,"AVG([ALL | DISTINCT] <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",13,"CEILING (<numeric_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",14,"CHAR (<integer_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",15,"CHARINDEX ('<pattern>', <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",16,"COALESCE (<expression1>, <expression2>, ... <expressionN>)")
INSERT INTO helpsql VALUES("FUNCTIONS",17,"COL_LENGTH ('<table_name>',  '<column_name>')")
INSERT INTO helpsql VALUES("FUNCTIONS",18,"COL_NAME (<table_id>,  <column_id>)")
INSERT INTO helpsql VALUES("FUNCTIONS",19,"CONVERT (<datatype>[(<length>)], <expression> [, <style>])")
INSERT INTO helpsql VALUES("FUNCTIONS",20,"COS (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",21,"COT (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",22,"COUNT(*)")
INSERT INTO helpsql VALUES("FUNCTIONS",23,"COUNT([ALL | DISTINCT] <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",24,"CURRENT_TIMESTAMP (Used with DEFAULT constraints ONLY)")
INSERT INTO helpsql VALUES("FUNCTIONS",25,"CURRENT_USER (Used with DEFAULT constraints ONLY)")
INSERT INTO helpsql VALUES("FUNCTIONS",26,"DATALENGTH ('<expression>')")
INSERT INTO helpsql VALUES("FUNCTIONS",27,"DATALENGTH (<expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",28,"DATEADD(<datepart>, <number>, <date>)")
INSERT INTO helpsql VALUES("FUNCTIONS",29,"DATEDIFF(<datepart>, <date1>, <date2>)")
INSERT INTO helpsql VALUES("FUNCTIONS",30,"DATENAME(<datepart>, <date>)")
INSERT INTO helpsql VALUES("FUNCTIONS",31,"DATEPART(<datepart>, <date>)")
INSERT INTO helpsql VALUES("FUNCTIONS",32,"DB_ID (['<database_name>'])")
INSERT INTO helpsql VALUES("FUNCTIONS",33,"DB_NAME ([<database_id>])")
INSERT INTO helpsql VALUES("FUNCTIONS",34,"DEGREES (<numeric_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",35,"DIFFERENCE (<char_expr1>, <char_expr2>)")
INSERT INTO helpsql VALUES("FUNCTIONS",36,"EXP (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",37,"FLOOR (<numeric_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",38,"GETDATE()")
INSERT INTO helpsql VALUES("FUNCTIONS",39,"GETANSINULL (['<database_name>']")
INSERT INTO helpsql VALUES("FUNCTIONS",40,"HOST_ID ( )")
INSERT INTO helpsql VALUES("FUNCTIONS",41,"HOST_NAME ( )")
INSERT INTO helpsql VALUES("FUNCTIONS",42,"IDENT_INCR ('<table_name>')")
INSERT INTO helpsql VALUES("FUNCTIONS",43,"IDENT_SEED ('<table_name>')")
INSERT INTO helpsql VALUES("FUNCTIONS",44,"INDEX_COL ('<table_name>', <index_id>, key_id)")
INSERT INTO helpsql VALUES("FUNCTIONS",45,"ISNULL (<expression>, <value>)")
INSERT INTO helpsql VALUES("FUNCTIONS",46,"LOG (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",47,"LOG10 (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",48,"LOWER (<char_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",49,"LTRIM (<char_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",50,"MAX([ALL | DISTINCT] <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",51,"MIN([ALL | DISTINCT] <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",52,"NULLIF (<expression1>, <expression2>)")
INSERT INTO helpsql VALUES("FUNCTIONS",53,"OBJECT_ID ('<object_name>')")
INSERT INTO helpsql VALUES("FUNCTIONS",54,"OBJECT_NAME (object_id)")
INSERT INTO helpsql VALUES("FUNCTIONS",55,"PATINDEX ('%<pattern>%', <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",56,"PI ( )")
INSERT INTO helpsql VALUES("FUNCTIONS",57,"POWER (<numeric_expr1>, <numeric_expr2>)")
INSERT INTO helpsql VALUES("FUNCTIONS",58,"RADIANS (<numeric_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",59,"RAND ([<seed>])")
INSERT INTO helpsql VALUES("FUNCTIONS",60,"REPLICATE (<char_expr>, <integer_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",61,"REVERSE (<char_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",62,"RIGHT (<char_expr>, <integer_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",63,"ROUND (<numeric_expr>, <length>)")
INSERT INTO helpsql VALUES("FUNCTIONS",64,"RTRIM (<char_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",65,"SESSION_USER (Used with DEFAULT constraints ONLY)")
INSERT INTO helpsql VALUES("FUNCTIONS",66,"SIGN (<numeric_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",67,"SIN (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",68,"SOUNDEX (<char_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",69,"SPACE (<integer_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",70,"SQRT (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",71,"STATS_DATE (<table_id>, <index_id>)")
INSERT INTO helpsql VALUES("FUNCTIONS",72,"STR (<float_expr> [, <length> [, <decimal>]]) ")
INSERT INTO helpsql VALUES("FUNCTIONS",73,"STUFF (<char_expr1>, <start>, <length>, <char_expr2>)")
INSERT INTO helpsql VALUES("FUNCTIONS",74,"SUBSTRING (<expression>, <start>, <length>)")
INSERT INTO helpsql VALUES("FUNCTIONS",75,"SUM([ALL | DISTINCT] <expression>)")
INSERT INTO helpsql VALUES("FUNCTIONS",76,"SUSER_ID (['<login_name>'])")
INSERT INTO helpsql VALUES("FUNCTIONS",77,"SUSER_NAME ([<server_user_id>])")
INSERT INTO helpsql VALUES("FUNCTIONS",78,"SYSTEM_USER (Used with DEFAULT constraints ONLY)")
INSERT INTO helpsql VALUES("FUNCTIONS",79,"TAN (<float_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",80,"TEXTPTR (<column_name>)")
INSERT INTO helpsql VALUES("FUNCTIONS",81,"TEXTVALID ('<table_name>.<column_name>', <text_ ptr>) ")
INSERT INTO helpsql VALUES("FUNCTIONS",82,"UPPER (<char_expr>)")
INSERT INTO helpsql VALUES("FUNCTIONS",83,"USER (Used with DEFAULT constraints ONLY)")
INSERT INTO helpsql VALUES("FUNCTIONS",84,"USER_ID (['<user_name>'])")
INSERT INTO helpsql VALUES("FUNCTIONS",85,"USER_NAME ([<user_id>])")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("GRANT",1,"GRANT Statement")
INSERT INTO helpsql VALUES("GRANT",2,"Assigns permissions to users, including the permission ")
INSERT INTO helpsql VALUES("GRANT",3,"to grant permisstions to other users.")
INSERT INTO helpsql VALUES("GRANT",4," ")
INSERT INTO helpsql VALUES("GRANT",5,"Statement permissions:")
INSERT INTO helpsql VALUES("GRANT",6,"     GRANT {ALL | <statement_list>} ")
INSERT INTO helpsql VALUES("GRANT",7,"     TO {PUBLIC | <name_list>}")
INSERT INTO helpsql VALUES("GRANT",8," ")
INSERT INTO helpsql VALUES("GRANT",9,"Object permissions:")
INSERT INTO helpsql VALUES("GRANT",10,"     GRANT {ALL [PRIVILEGES][<column_list>] | <permission_list> [<column_list>]}")
INSERT INTO helpsql VALUES("GRANT",11,"     ON {<table_name> [(<column_list>)] | ")
INSERT INTO helpsql VALUES("GRANT",12,"         <view_name> [(<column_list>)] | ")
INSERT INTO helpsql VALUES("GRANT",13,"         <stored_procedure_name> } ")
INSERT INTO helpsql VALUES("GRANT",14,"     TO {PUBLIC | <name_list>}")
INSERT INTO helpsql VALUES("GRANT",15,"     [WITH GRANT OPTION]")
INSERT INTO helpsql VALUES("INSERT",1,"INSERT Statement")
INSERT INTO helpsql VALUES("INSERT",2,"Adds a new row to a table or a view, which is optionally ")
INSERT INTO helpsql VALUES("INSERT",2,"returned from a stored procedure.")
INSERT INTO helpsql VALUES("INSERT",3," ")
INSERT INTO helpsql VALUES("INSERT",4,"INSERT [INTO]")
INSERT INTO helpsql VALUES("INSERT",5,"     {<table_name> | <view_name>} [(<column_list>)]")
INSERT INTO helpsql VALUES("INSERT",6,"{DEFAULT VALUES | <values_list> | <select_statement> } ")
INSERT INTO helpsql VALUES("INSERT",7,"EXECute {<procedure_name> | @<procedure_name_var>}")
INSERT INTO helpsql VALUES("INSERT",8,"[[@<parameter_name> =] {<value>| @<variable> [OUTPUT] | DEFAULT }")
INSERT INTO helpsql VALUES("INSERT",9,"[,[@<parameter_name> =] {<value>| @<variable> [OUTPUT] | DEFAULT}]...]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("KILL",1,"KILL Statement")
INSERT INTO helpsql VALUES("KILL",2,"Terminates a user's process based on the system process ID.")
INSERT INTO helpsql VALUES("KILL",3," ")
INSERT INTO helpsql VALUES("KILL",4,"KILL <spid>")
INSERT INTO helpsql VALUES("LOAD",1,"LOAD Statement")
INSERT INTO helpsql VALUES("LOAD",2,"Restores a backup copy of a user database and its transaction log (LOAD ")
INSERT INTO helpsql VALUES("LOAD",3,"DATABASE) or only the transaction log (LOAD TRANSACTION) from a dump ")
INSERT INTO helpsql VALUES("LOAD",4,"that was created using the DUMP statement or an individual table (LOAD TABLE). ")
INSERT INTO helpsql VALUES("LOAD",5,"The LOAD statement can also be used to retrieve header informantion from a ")
INSERT INTO helpsql VALUES("LOAD",6,"database dump (LOAD HEADERONLY).")
INSERT INTO helpsql VALUES("LOAD",7," ")
INSERT INTO helpsql VALUES("LOAD",8,"Loading a database:")
INSERT INTO helpsql VALUES("LOAD",9,"     LOAD DATABASE {<dbname> | @<dbname_var>}")
INSERT INTO helpsql VALUES("LOAD",10,"          FROM <dump_device> [, <dump_device2> [..., <dump_device32>]]")
INSERT INTO helpsql VALUES("LOAD",11,"     [WITH <options> ")
INSERT INTO helpsql VALUES("LOAD",12,"          [[,] STATS [ = <percentage>]]]")
INSERT INTO helpsql VALUES("LOAD",13," ")
INSERT INTO helpsql VALUES("LOAD",14,"Loading a transaction log:")
INSERT INTO helpsql VALUES("LOAD",15,"     LOAD TRANSACTION {<dbname> | @<dbname_var>} ")
INSERT INTO helpsql VALUES("LOAD",16,"          FROM <dump_device> [, <dump_device2> [..., <dump_device32>]]")
INSERT INTO helpsql VALUES("LOAD",17,"     [WITH <options>]")
INSERT INTO helpsql VALUES("LOAD",18," ")
INSERT INTO helpsql VALUES("LOAD",19,"Loading a table:")
INSERT INTO helpsql VALUES("LOAD",20,"     LOAD TABLE [[<dbname>.]<owner>.]<table_name>")
INSERT INTO helpsql VALUES("LOAD",21,"          FROM <dump_device> [, <dump_device2> [..., <dump_device32>]]")
INSERT INTO helpsql VALUES("LOAD",22,"     [WITH <options>]")
INSERT INTO helpsql VALUES("LOAD",23," ")
INSERT INTO helpsql VALUES("LOAD",24,"Loading header information:")
INSERT INTO helpsql VALUES("LOAD",25,"     LOAD HEADERONLY")
INSERT INTO helpsql VALUES("LOAD",26,"          FROM <dump_device>")
INSERT INTO helpsql VALUES("LOAD",27," ")
INSERT INTO helpsql VALUES("LOAD",28,"where")
INSERT INTO helpsql VALUES("LOAD",29," ")
INSERT INTO helpsql VALUES("LOAD",30,"<dump_device> =")
INSERT INTO helpsql VALUES("LOAD",31,"     { <dump_device_name> | @<dump_device_namevar>} ")
INSERT INTO helpsql VALUES("LOAD",32,"          | {DISK | TAPE | FLOPPY | PIPE} = ")
INSERT INTO helpsql VALUES("LOAD",33,"          {'<temp_dump_device>' | @<temp_dump_device_var>} ")
INSERT INTO helpsql VALUES("LOAD",34,"     [VOLUME = {<volid> | @<volid_var>}]")
INSERT INTO helpsql VALUES("LOAD",35," ")
INSERT INTO helpsql VALUES("LOAD",36,"<options> =")
INSERT INTO helpsql VALUES("LOAD",37,"     [[,] {UNLOAD | NOUNLOAD}]")
INSERT INTO helpsql VALUES("LOAD",38,"     [[,] {SKIP | NOSKIP}]")
INSERT INTO helpsql VALUES("LOAD",39,"     [[,] FILE = <fileno>]")
INSERT INTO helpsql VALUES("LOAD",40,"     [[,] STOPAT = {<date_time> | @<date_time>}]")
INSERT INTO helpsql VALUES("LOAD",42,"     [[,] SOURCE = <source_name>]")
INSERT INTO helpsql VALUES("LOAD",43,"     [[,] APPEND]")
INSERT INTO helpsql VALUES("LOAD",44,"     [[,] STATS [=<percentage>]]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("OPERATORS",1,"Operators")
INSERT INTO helpsql VALUES("OPERATORS",2,"Operators are symbols used to perform mathematical computations and/or ")
INSERT INTO helpsql VALUES("OPERATORS",3,"comparisons between columns or variables. Comparisons can be made ")
INSERT INTO helpsql VALUES("OPERATORS",4,"between like datatypes without any conversion, implicit conversion, or ")
INSERT INTO helpsql VALUES("OPERATORS",5,"if necessary, explicit conversion. When comparisons are made between ")
INSERT INTO helpsql VALUES("OPERATORS",6,"implicitly converted datatypes, the result will have the greater ")
INSERT INTO helpsql VALUES("OPERATORS",7,"precision, the larger scale, and/or the larger/longer datatype. ")
INSERT INTO helpsql VALUES("OPERATORS",8," ")
INSERT INTO helpsql VALUES("OPERATORS",9,"-      Subtraction")
INSERT INTO helpsql VALUES("OPERATORS",10,"%      Modulo")
INSERT INTO helpsql VALUES("OPERATORS",11,"&      Bitwise AND (two operands)")
INSERT INTO helpsql VALUES("OPERATORS",12,"*      Multiplication")
INSERT INTO helpsql VALUES("OPERATORS",13,"*=     Outer Join ")
INSERT INTO helpsql VALUES("OPERATORS",14,"+      Addition")
INSERT INTO helpsql VALUES("OPERATORS",15,"/      Division")
INSERT INTO helpsql VALUES("OPERATORS",16,"<      Less than")
INSERT INTO helpsql VALUES("OPERATORS",17,"< >    Not equal to")
INSERT INTO helpsql VALUES("OPERATORS",18,"<=     Less than or equal to")
INSERT INTO helpsql VALUES("OPERATORS",19,"=      Equal to")
INSERT INTO helpsql VALUES("OPERATORS",20,"=*     Outer Join")
INSERT INTO helpsql VALUES("OPERATORS",21,">      Greater than")
INSERT INTO helpsql VALUES("OPERATORS",22,">=     Greater than or equal to")
INSERT INTO helpsql VALUES("OPERATORS",23,"^      Bitwise exclusive OR (two operands)")
INSERT INTO helpsql VALUES("OPERATORS",24,"|      Bitwise OR (two operands)")
INSERT INTO helpsql VALUES("OPERATORS",25,"~      Bitwise NOT (one operand)")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("PRINT",1,"PRINT Statement")
INSERT INTO helpsql VALUES("PRINT",2,"Returns a user-defined message to the client's message handler.")
INSERT INTO helpsql VALUES("PRINT",3," ")
INSERT INTO helpsql VALUES("PRINT",4,"PRINT {'<any ASCII text>' | @<local_variable> | @@<global_variable>}")
INSERT INTO helpsql VALUES("RAISERROR",1,"RAISERROR Statement")
INSERT INTO helpsql VALUES("RAISERROR",2,"Returns a user-defined error message and sets a system flag to record ")
INSERT INTO helpsql VALUES("RAISERROR",3,"that an error has occurred. RAISERROR lets the client retrieve an entry ")
INSERT INTO helpsql VALUES("RAISERROR",4,"from the sysmessages table or build a message dynamically with user-")
INSERT INTO helpsql VALUES("RAISERROR",5,"specified severity and state information. Once defined, this message is ")
INSERT INTO helpsql VALUES("RAISERROR",6,"sent back to the client as a server error message.")
INSERT INTO helpsql VALUES("RAISERROR",7," ")
INSERT INTO helpsql VALUES("RAISERROR",8,"RAISERROR ({<msg_id> | <msg_str>}, <severity>, <state>")
INSERT INTO helpsql VALUES("RAISERROR",9,"          [, <argument1> [, <argument2>]] )")
INSERT INTO helpsql VALUES("RAISERROR",10,"     [WITH [LOG | NOWAIT | SETERROR]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("RECONFIGURE",1,"RECONFIGURE Statement")
INSERT INTO helpsql VALUES("RECONFIGURE",2,"Installs a changed configuration option used only with the sp_configure ")
INSERT INTO helpsql VALUES("RECONFIGURE",3,"system stored procedure.")
INSERT INTO helpsql VALUES("RECONFIGURE",4," ")
INSERT INTO helpsql VALUES("RECONFIGURE",5,"RECONFIGURE [WITH OVERRIDE]")
INSERT INTO helpsql VALUES("REVOKE",1,"REVOKE Statement")
INSERT INTO helpsql VALUES("REVOKE",2,"Revokes object and statement permissions from users.")
INSERT INTO helpsql VALUES("REVOKE",3," ")
INSERT INTO helpsql VALUES("REVOKE",4,"Statement permissions:")
INSERT INTO helpsql VALUES("REVOKE",5,"     REVOKE {ALL | <statement_list>} ")
INSERT INTO helpsql VALUES("REVOKE",6,"     FROM {PUBLIC | <name_list>}")
INSERT INTO helpsql VALUES("REVOKE",7," ")
INSERT INTO helpsql VALUES("REVOKE",8,"Object permissions:")
INSERT INTO helpsql VALUES("REVOKE",9,"     REVOKE [GRANT OPTION FOR]{ALL | <permission_list>} [(<column_list>)]")
INSERT INTO helpsql VALUES("REVOKE",10,"     ON {<table_name> [(<column_list>)] | ")
INSERT INTO helpsql VALUES("REVOKE",11,"          <view_name> [(<column_list>)] | ")
INSERT INTO helpsql VALUES("REVOKE",12,"          <stored_procedure_name> | ")
INSERT INTO helpsql VALUES("REVOKE",13,"          <extended_stored_procedure_name>} ")
INSERT INTO helpsql VALUES("REVOKE",14,"     FROM {PUBLIC | <name_list>}")
INSERT INTO helpsql VALUES("REVOKE",14,"     [CASCADE]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("SELECT",1,"SELECT Statement")
INSERT INTO helpsql VALUES("SELECT",2,"Retrieves rows from the database.")
INSERT INTO helpsql VALUES("SELECT",3," ")
INSERT INTO helpsql VALUES("SELECT",4,"     ")
INSERT INTO helpsql VALUES("SELECT",5," ")
INSERT INTO helpsql VALUES("SELECT",6,"SELECT [ALL | DISTINCT] <select_list>")
INSERT INTO helpsql VALUES("SELECT",7,"     INTO [<new_table_name>] ")
INSERT INTO helpsql VALUES("SELECT",8,"     [FROM <table_name> [, <table_name2> [..., <table_name16>]] ")
INSERT INTO helpsql VALUES("SELECT",9,"[WHERE <clause>] ")
INSERT INTO helpsql VALUES("SELECT",10,"[GROUP BY <clause>]")
INSERT INTO helpsql VALUES("SELECT",11,"[HAVING <clause>]")
INSERT INTO helpsql VALUES("SELECT",12,"[ORDER BY <clause>]")
INSERT INTO helpsql VALUES("SELECT",13,"[COMPUTE <clause>] ")
INSERT INTO helpsql VALUES("SELECT",14,"[FOR BROWSE]")
INSERT INTO helpsql VALUES("SELECT",15," ")
INSERT INTO helpsql VALUES("SELECT",16,"where")
INSERT INTO helpsql VALUES("SELECT",17," ")
INSERT INTO helpsql VALUES("SELECT",18,"<table_name> | <view_name> = ")
INSERT INTO helpsql VALUES("SELECT",19,"     [[<database>.]<owner>.]{<table_name>. | <view_name>.}")
INSERT INTO helpsql VALUES("SELECT",20," ")
INSERT INTO helpsql VALUES("SELECT",21,"<joined_table> =")
INSERT INTO helpsql VALUES("SELECT",22,"     {<table_name> CROSS JOIN <table_name> ")
INSERT INTO helpsql VALUES("SELECT",23,"     | <table_name> {INNER | LEFT [OUTER] | RIGHT [OUTER] | FULL [OUTER]} ")
INSERT INTO helpsql VALUES("SELECT",24,"     JOIN <table_name> ON <search_conditions>}")
INSERT INTO helpsql VALUES("SELECT",25," ")
INSERT INTO helpsql VALUES("SELECT",26,"<optimizer_hints> ")
INSERT INTO helpsql VALUES("SELECT",27,"     One or more of the following, separated with a space:")
INSERT INTO helpsql VALUES("SELECT",28,"          [INDEX = {<index_name> | <index_id>}]")
INSERT INTO helpsql VALUES("SELECT",29,"          [NOLOCK]")
INSERT INTO helpsql VALUES("SELECT",30,"          [HOLDLOCK]")
INSERT INTO helpsql VALUES("SELECT",31,"          [UPDLOCK]")
INSERT INTO helpsql VALUES("SELECT",32,"          [TABLOCK]")
INSERT INTO helpsql VALUES("SELECT",33,"          [PAGLOCK]")
INSERT INTO helpsql VALUES("SELECT",34,"          [TABLOCKX]")
INSERT INTO helpsql VALUES("SELECT",35,"          [FASTFIRSTROW]")
INSERT INTO helpsql VALUES("SELECT",36," ")
INSERT INTO helpsql VALUES("SELECT",37,"WHERE <clause> = ")
INSERT INTO helpsql VALUES("SELECT",38,"     WHERE <search_conditions>")
INSERT INTO helpsql VALUES("SELECT",39," ")
INSERT INTO helpsql VALUES("SELECT",40,"GROUP BY <clause> = ")
INSERT INTO helpsql VALUES("SELECT",41,"     GROUP BY [ALL] <aggregate_free_expression> ")
INSERT INTO helpsql VALUES("SELECT",42,"          [[, <aggregate_free_expression>]...]")
INSERT INTO helpsql VALUES("SELECT",43,"          [WITH {CUBE | ROLLUP}]")
INSERT INTO helpsql VALUES("SELECT",44," ")
INSERT INTO helpsql VALUES("SELECT",45,"HAVING <clause> = ")
INSERT INTO helpsql VALUES("SELECT",46,"     HAVING <search_conditions>")
INSERT INTO helpsql VALUES("SELECT",47," ")
INSERT INTO helpsql VALUES("SELECT",48,"ORDER BY <clause> = ")
INSERT INTO helpsql VALUES("SELECT",49,"     ORDER BY {{<table_name>. | <view_name>.}<column_name> | ")
INSERT INTO helpsql VALUES("SELECT",50,"               <select_list_number> | <expression>} [ASC | DESC] ")
INSERT INTO helpsql VALUES("SELECT",51,"             [...{{<table_name16>. | <view_name16>.}<column_name> | ")
INSERT INTO helpsql VALUES("SELECT",52,"                      <select_list_number> | <expression>} [ASC | DESC]]")
INSERT INTO helpsql VALUES("SELECT",53," ")
INSERT INTO helpsql VALUES("SELECT",54,"COMPUTE <clause> = ")
INSERT INTO helpsql VALUES("SELECT",55,"     COMPUTE <row_aggregate>(<column_name>) ")
INSERT INTO helpsql VALUES("SELECT",56,"               [, <row_aggregate>(<column_name>)...]")
INSERT INTO helpsql VALUES("SELECT",57,"     [BY <column_name> [, <column_name>]...] ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("SET",1,"SET Statement")
INSERT INTO helpsql VALUES("SET",2,"Sets SQL Server query-processing options for the duration of the user's ")
INSERT INTO helpsql VALUES("SET",3,"work session, or for the duration of a running trigger or a stored ")
INSERT INTO helpsql VALUES("SET",4,"procedure.")
INSERT INTO helpsql VALUES("SET",5," ")
INSERT INTO helpsql VALUES("SET",6,"SET {")
INSERT INTO helpsql VALUES("SET",7," ANSI_DEFAULTS {ON | OFF} ") 
INSERT INTO helpsql VALUES("SET",8,"| ANSI_NULLS {OFF | ON}")
INSERT INTO helpsql VALUES("SET",9,"| ANSI_PADDING {OFF | ON}")
INSERT INTO helpsql VALUES("SET",10,"| ANSI_WARNINGS {OFF | ON}")
INSERT INTO helpsql VALUES("SET",11,"| ARITHABORT ")
INSERT INTO helpsql VALUES("SET",12,"| ARITHIGNORE ")
INSERT INTO helpsql VALUES("SET",13,"| CURSOR_CLOSE_ON_COMMIT {OFF | ON}")
INSERT INTO helpsql VALUES("SET",14,"| DISABLE_DEF_CNST_CHK {OFF | ON}")
INSERT INTO helpsql VALUES("SET",15,"| FIPS_FLAGGER {OFF | <level>}")
INSERT INTO helpsql VALUES("SET",16,"| FMTONLY ")
INSERT INTO helpsql VALUES("SET",17,"| FORCEPLAN ")
INSERT INTO helpsql VALUES("SET",18,"| IDENTITY_INSERT [<database>.[<owner>.]]<tablename>")
INSERT INTO helpsql VALUES("SET",19,"| IMPLICIT_TRANSACTIONS {OFF | ON}")
INSERT INTO helpsql VALUES("SET",20,"| NOCOUNT ")
INSERT INTO helpsql VALUES("SET",21,"| NOEXEC ")
INSERT INTO helpsql VALUES("SET",22,"| NUMERIC_ROUNDABORT {OFF | ON}")
INSERT INTO helpsql VALUES("SET",23,"| OFFSETS {<keyword_list>} ")
INSERT INTO helpsql VALUES("SET",24,"| PARSEONLY ")
INSERT INTO helpsql VALUES("SET",25,"| PROCID ")
INSERT INTO helpsql VALUES("SET",26,"| QUOTED_IDENTIFIER")
INSERT INTO helpsql VALUES("SET",27,"| SHOWPLAN ")
INSERT INTO helpsql VALUES("SET",28,"| STATISTICS IO ")
INSERT INTO helpsql VALUES("SET",29,"| STATISTICS TIME {ON | OFF}")
INSERT INTO helpsql VALUES("SET",30,"      ")
INSERT INTO helpsql VALUES("SET",31,"| DATEFIRST <number> ")
INSERT INTO helpsql VALUES("SET",32,"| DATEFORMAT <format> ")
INSERT INTO helpsql VALUES("SET",33,"| DEADLOCKPRIORITY {LOW | NORMAL}")
INSERT INTO helpsql VALUES("SET",34,"| LANGUAGE <language>")
INSERT INTO helpsql VALUES("SET",35,"| REMOTE_PROC_TRANSACTIONS {OFF | ON}")
INSERT INTO helpsql VALUES("SET",36,"| ROWCOUNT {<number> | @<int_variable>} ")
INSERT INTO helpsql VALUES("SET",37,"| TEXTSIZE <number>")
INSERT INTO helpsql VALUES("SET",38,"| TRANSACTION ISOLATION LEVEL {READ COMMITTED | READ ")
INSERT INTO helpsql VALUES("SET",39,"     UNCOMMITTED | REPEATABLE READ | SERIALIZABLE}")
INSERT INTO helpsql VALUES("SET",40,"| XACT_ABORT {OFF | ON}}")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("SETUSER",1,"SETUSER Statement")
INSERT INTO helpsql VALUES("SETUSER",2,"Allows a database owner to impersonate another user. The SETUSER ")
INSERT INTO helpsql VALUES("SETUSER",3,"statement is used by the system administrator or a database owner when ")
INSERT INTO helpsql VALUES("SETUSER",4,"he or she wants to adopt the identity of another user in order to use ")
INSERT INTO helpsql VALUES("SETUSER",5,"another user's database object, to grant permissions to that object, to ")
INSERT INTO helpsql VALUES("SETUSER",6,"create an object, and so on.")
INSERT INTO helpsql VALUES("SETUSER",7," ")
INSERT INTO helpsql VALUES("SETUSER",8,"SETUSER ['<username>' [WITH NORESET]]")
INSERT INTO helpsql VALUES("SHUTDOWN",1,"SHUTDOWN Statement")
INSERT INTO helpsql VALUES("SHUTDOWN",2,"Stops SQL Server. Only the system administrator can execute this statement.")
INSERT INTO helpsql VALUES("SHUTDOWN",3," ")
INSERT INTO helpsql VALUES("SHUTDOWN",4,"SHUTDOWN [WITH NOWAIT]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_column_privileges",1,"sp_column_privileges Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_column_privileges",2,"Returns the following column privilege information for a ")
INSERT INTO helpsql VALUES("sp_column_privileges",3,"single table in the current environment. (The GRANTOR is the")
INSERT INTO helpsql VALUES("sp_column_privileges",4,"dbo, the object owner, or user to whom the dbo issued WITH GRANT permission.)")
INSERT INTO helpsql VALUES("sp_column_privileges",5," 	TABLE_QUALIFIER  	TABLE_OWNER 	TABLE_NAME")
INSERT INTO helpsql VALUES("sp_column_privileges",6,"  	COLUMN_NAME 	GRANTOR 		GRANTEE")
INSERT INTO helpsql VALUES("sp_column_privileges",7,"  	PRIVILEGE")
INSERT INTO helpsql VALUES("sp_column_privileges",8,"  ")
INSERT INTO helpsql VALUES("sp_column_privileges",9,"sp_column_privileges <table_name> [, <table_owner>] ")
INSERT INTO helpsql VALUES("sp_column_privileges",10,"     [, <table_qualifier>] [, <column_name>]")
INSERT INTO helpsql VALUES("sp_columns",1,"sp_columns Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_columns",2,"Returns column information for a single object that can be queried in ")
INSERT INTO helpsql VALUES("sp_columns",3,"the current environment. The returned columns belong to a table or a ")
INSERT INTO helpsql VALUES("sp_columns",4,"view and contain the following column headings:")
INSERT INTO helpsql VALUES("sp_columns",5," ")
INSERT INTO helpsql VALUES("sp_columns",6," 	")
INSERT INTO helpsql VALUES("sp_columns",7,"  	TABLE_QUALIFIER		TABLE_OWNER			TABLE_NAME 	")
INSERT INTO helpsql VALUES("sp_columns",8,"  	COLUMN_NAME 		DATA_TYPE			TYPE_NAME 	")	
INSERT INTO helpsql VALUES("sp_columns",9,"  	PRECISION 			LENGTH 			SCALE		")
INSERT INTO helpsql VALUES("sp_columns",10," 	RADIX				NULLABLE 			REMARKS ")
INSERT INTO helpsql VALUES("sp_columns",11," 	COLUMN_DEF 			SQL_DATA_TYPE 		SQL_DATETIME_SUB ")
INSERT INTO helpsql VALUES("sp_columns",12," 	CHAR_OCTET_LENGTH		ORDINAL_POSITION 		IS_NULLABLE ")
INSERT INTO helpsql VALUES("sp_columns",13," 	SS_DATA_TYPE")
INSERT INTO helpsql VALUES("sp_columns",14," ")
INSERT INTO helpsql VALUES("sp_columns",15,"sp_columns <object_name> [, <object_owner>] [, <object_qualifier>] ")
INSERT INTO helpsql VALUES("sp_columns",16,"     [, <column_name>]")
INSERT INTO helpsql VALUES("sp_columns",17," ")
INSERT INTO helpsql VALUES("sp_databases",1,"sp_databases Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_databases",2,"Lists databases, their size and remarks, present in the SQL Server  ")
INSERT INTO helpsql VALUES("sp_databases",3,"installation or accessible through a database gateway.")
INSERT INTO helpsql VALUES("sp_databases",4," ")
INSERT INTO helpsql VALUES("sp_databases",5," 	DATABASE		DATABASE_SIZE		REMARKS")
INSERT INTO helpsql VALUES("sp_databases",6," ")
INSERT INTO helpsql VALUES("sp_databases",7,"sp_databases")
INSERT INTO helpsql VALUES("sp_datatype_info",1,"sp_datatype_info Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_datatype_info",2,"Returns the following columns of information about the datatypes ")
INSERT INTO helpsql VALUES("sp_datatype_info",3,"supported by the current environment.")
INSERT INTO helpsql VALUES("sp_datatype_info",4," 	TYPE_NAME		DATA_TYPE		PRECISION")
INSERT INTO helpsql VALUES("sp_datatype_info",5," 	LITERAL_PREFIX		LITERAL_SUFFIX		CREATE_PARAMS")
INSERT INTO helpsql VALUES("sp_datatype_info",6," 	NULLABLE		CASE_SENSITIVE		SEARCHABLE")
INSERT INTO helpsql VALUES("sp_datatype_info",7," 	UNSIGNED_ATTRIBUTE	MONEY			AUTO_INCREMENT")
INSERT INTO helpsql VALUES("sp_datatype_info",8," 	LOCAL_TYPE_NAME		MINIMUM_SCALE		MAXIMUM_SCALE")
INSERT INTO helpsql VALUES("sp_datatype_info",9," 	SQL_DATA_TYPE		SQL_DATETIME_SUB	NUM_PREC_RADIX")
INSERT INTO helpsql VALUES("sp_datatype_info",10," 	INTERVAL_PRECISION	USERTYPE")
INSERT INTO helpsql VALUES("sp_datatype_info",11," ")
INSERT INTO helpsql VALUES("sp_datatype_info",12,"sp_datatype_info [<data_type>]")
INSERT INTO helpsql VALUES("sp_fkeys",1,"sp_fkeys Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_fkeys",2,"Returns logical foreign key information for the current environment.")
INSERT INTO helpsql VALUES("sp_fkeys",3,"  ")
INSERT INTO helpsql VALUES("sp_fkeys",4," 	PKTABLE_QUALIFIER  	PKTABLE_OWNER  		PKTABLE_NAME ")
INSERT INTO helpsql VALUES("sp_fkeys",5,"  	PKCOLUMN_NAME  		FKTABLE_QUALIFIER  	FKTABLE_OWNER ")
INSERT INTO helpsql VALUES("sp_fkeys",6," 	FKTABLE_NAME  		FKCOLUMN_NAME  		KEY_SEQ ")
INSERT INTO helpsql VALUES("sp_fkeys",7,"  	UPDATE_RULE  		DELETE_RULE  		FK_NAME ")
INSERT INTO helpsql VALUES("sp_fkeys",8,"	PK_NAME")
INSERT INTO helpsql VALUES("sp_fkeys",9,"  ")
INSERT INTO helpsql VALUES("sp_fkeys",10,"sp_fkeys [<pktable_name>] [, <pktable_owner>] [, <pktable_qualifier>] ")
INSERT INTO helpsql VALUES("sp_fkeys",11,"     [, <fktable_name>] [, <fktable_owner>] [, <fktable_qualifier>]")
INSERT INTO helpsql VALUES("sp_pkeys",1,"sp_pkeys Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_pkeys",2,"Returns primary key information for a single table in the current ")
INSERT INTO helpsql VALUES("sp_pkeys",3,"environment.")
INSERT INTO helpsql VALUES("sp_pkeys",4,"	TABLE_QUALIFIER		TABLE_OWNER 		TABLE_NAME ")
INSERT INTO helpsql VALUES("sp_pkeys",5,"	COLUMN_NAME 		KEY_SEQ  		PK_NAME")
INSERT INTO helpsql VALUES("sp_pkeys",6," ")
INSERT INTO helpsql VALUES("sp_pkeys",7,"sp_pkeys <table_name> [, <table_owner>] [, <table_qualifier>]")
INSERT INTO helpsql VALUES("sp_server_info",1,"sp_server_info Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_server_info",2,"Returns the following list of attribute names and matching values ")
INSERT INTO helpsql VALUES("sp_server_info",3,"for SQL Server, the database gateway, and/or the underlying data source.")
INSERT INTO helpsql VALUES("sp_server_info",4," ")
INSERT INTO helpsql VALUES("sp_server_info",5," 	attribute_id 		attribute_name		attribute_value")
INSERT INTO helpsql VALUES("sp_server_info",6," ")
INSERT INTO helpsql VALUES("sp_server_info",7,"sp_server_info [[@attribute_id =] <attribute_id>]")
INSERT INTO helpsql VALUES("sp_special_columns",1,"sp_special_columns Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_special_columns",2,"Returns the optimal set of columns that uniquely identify a row in the ")
INSERT INTO helpsql VALUES("sp_special_columns",3,"table and columns that are automatically updated when any value in the ")
INSERT INTO helpsql VALUES("sp_special_columns",4,"row is updated by a transaction.")
INSERT INTO helpsql VALUES("sp_special_columns",5," ")
INSERT INTO helpsql VALUES("sp_special_columns",6,"SCOPE			COLUMN_NAME 		DATA_TYPE  ")
INSERT INTO helpsql VALUES("sp_special_columns",7,"TYPE_NAME 		PRECISION		LENGTH ")
INSERT INTO helpsql VALUES("sp_special_columns",8,"SCALE 		PSEUDO_COLUMN")
INSERT INTO helpsql VALUES("sp_special_columns",9," ")
INSERT INTO helpsql VALUES("sp_special_columns",10,"sp_special_columns <table_name> [, <table_owner>] [, <table_qualifier>] ")
INSERT INTO helpsql VALUES("sp_special_columns",11,"     [, <col_type>] [, scope] [, nullable]")
INSERT INTO helpsql VALUES("sp_sproc_columns",1,"sp_sproc_columns Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_sproc_columns",2,"Returns the following columns of information for a single stored procedure ")
INSERT INTO helpsql VALUES("sp_sproc_columns",3,"in the current environment.")
INSERT INTO helpsql VALUES("sp_sproc_columns",4," ")
INSERT INTO helpsql VALUES("sp_sproc_columns",5,"PROCEDURE_QUALIFIER 	PROCEDURE_OWNER		PROCEDURE_NAME ")
INSERT INTO helpsql VALUES("sp_sproc_columns",6,"COLUMN_NAME 		COLUMN_TYPE 		DATA_TYPE ")
INSERT INTO helpsql VALUES("sp_sproc_columns",7,"TYPE_NAME		PRECISION		LENGTH  ")
INSERT INTO helpsql VALUES("sp_sproc_columns",8,"SCALE 		RADIX 			NULLABLE  ")
INSERT INTO helpsql VALUES("sp_sproc_columns",9,"REMARKS		COLUMN_DEF		SQL_DATA_TYPE	")
INSERT INTO helpsql VALUES("sp_sproc_columns",10,"SQL_DATETIME_SUB   	CHAR_OCTET_LENGTH   	ORDINAL_POSITION 	")
INSERT INTO helpsql VALUES("sp_sproc_columns",11,"IS_NULLABLE 		SS_DATA_TYPE")
INSERT INTO helpsql VALUES("sp_sproc_columns",12," ")
INSERT INTO helpsql VALUES("sp_sproc_columns",13,"sp_sproc_columns <procedure_name> [, <procedure_owner>] ")
INSERT INTO helpsql VALUES("sp_sproc_columns",14,"     [, <procedure_qualifier>] [, <column_name>]")
INSERT INTO helpsql VALUES("sp_statistics",1,"sp_statistics Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_statistics",2,"Returns a list of all indexes on a specified table.")
INSERT INTO helpsql VALUES("sp_statistics",3," ")
INSERT INTO helpsql VALUES("sp_statistics",4,"TABLE QUALIFIER  		TABLE_OWNER  		TABLE_NAME  ")
INSERT INTO helpsql VALUES("sp_statistics",5,"NON_UNIQUE 			INDEX_QUALIFIER		INDEX_NAME ") 
INSERT INTO helpsql VALUES("sp_statistics",6,"TYPE 				SEQ_IN_INDEX  		COLUMN_NAME ")
INSERT INTO helpsql VALUES("sp_statistics",7,"COLLATION 			CARDINALITY  		PAGES ")
INSERT INTO helpsql VALUES("sp_statistics",8,"FILTER_CONDITION")
INSERT INTO helpsql VALUES("sp_statistics",9," ")
INSERT INTO helpsql VALUES("sp_statistics",10,"sp_statistics <table_name> [, <table_owner>] [, <table_qualifier>] ")
INSERT INTO helpsql VALUES("sp_statistics",11,"     [, <index_name>] [, <is_unique>]")
INSERT INTO helpsql VALUES("sp_stored_procedures",1,"sp_stored_procedures Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_stored_procedures",2,"Returns a list of the following columns for the stored procedures in the ")
INSERT INTO helpsql VALUES("sp_stored_procedures",3,"current environment .") 
INSERT INTO helpsql VALUES("sp_stored_procedures",4," ")
INSERT INTO helpsql VALUES("sp_stored_procedures",5,"PROCEDURE_QUALIFIER 	PROCEDURE_OWNER		PROCEDURE_NAME ")
INSERT INTO helpsql VALUES("sp_stored_procedures",6,"NUM_INPUT_PARAMS  	NUM_OUTPUT_PARAMS  	NUM_RESULT_SETS ")
INSERT INTO helpsql VALUES("sp_stored_procedures",7,"REMARKS		PROCEDURE_TYPE ")
INSERT INTO helpsql VALUES("sp_stored_procedures",8," ")
INSERT INTO helpsql VALUES("sp_stored_procedures",9,"sp_stored_procedures [<procedure_name>] [, <procedure_owner>] ")
INSERT INTO helpsql VALUES("sp_stored_procedures",10,"     [, <procedure_qualifier>]")
INSERT INTO helpsql VALUES("sp_table_privileges",1,"sp_table_privileges Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_table_privileges",2,"Returns the following privilege information for a single table in the current ")
INSERT INTO helpsql VALUES("sp_table_privileges",3,"environment, where the GRANTOR can be a user granted the permission to ")
INSERT INTO helpsql VALUES("sp_table_privileges",4,"grant by the dbo.")
INSERT INTO helpsql VALUES("sp_table_privileges",5," ")
INSERT INTO helpsql VALUES("sp_table_privileges",6," 		TABLE_QUALIFIER		TABLE_OWNER 		TABLE_NAME")
INSERT INTO helpsql VALUES("sp_table_privileges",7," 		GRANTOR			GRANTEE			PRIVILEGE")	
INSERT INTO helpsql VALUES("sp_table_privileges",8," 		IS_GRANTABLE")
INSERT INTO helpsql VALUES("sp_table_privileges",9," ")
INSERT INTO helpsql VALUES("sp_table_privileges",10,"sp_table_privileges <table_name> [, <table_owner>] [, <table_qualifier>]")
INSERT INTO helpsql VALUES("sp_tables",1,"sp_tables Catalog Stored Procedure")
INSERT INTO helpsql VALUES("sp_tables",2,"Returns a list of columns for objects that can be queried in the current environment ")
INSERT INTO helpsql VALUES("sp_tables",3,"(that is, any object that can appear in a FROM clause).")
INSERT INTO helpsql VALUES("sp_tables",4," ")
INSERT INTO helpsql VALUES("sp_tables",5,"	TABLE_QUALIFIER		TABLE_OWNER  		TABLE_NAME  ")
INSERT INTO helpsql VALUES("sp_tables",6,"	TABLE_TYPE  		REMARKS")
INSERT INTO helpsql VALUES("sp_tables",7," ")
INSERT INTO helpsql VALUES("sp_tables",8,"sp_tables [<table_name>] [, <table_owner>] [, <table_qualifier>] ")
INSERT INTO helpsql VALUES("sp_tables",9,"     [, <table_type>]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("xp_cmdshell",1,"xp_cmdshell Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_cmdshell",2,"Executes a given command string as an operating-system command shell and ")
INSERT INTO helpsql VALUES("xp_cmdshell",3,"returns any output as rows of text.")
INSERT INTO helpsql VALUES("xp_cmdshell",4," ")
INSERT INTO helpsql VALUES("xp_cmdshell",5,"xp_cmdshell <command_string> [, no_output]")
INSERT INTO helpsql VALUES("xp_deletemail",1,"xp_deletemail Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_deletemail",2,"Deletes a message from the SQL Server inbox. This procedure is used by ")
INSERT INTO helpsql VALUES("xp_deletemail",3,"the sp_processmail system stored procedure to process mail in the SQL ")
INSERT INTO helpsql VALUES("xp_deletemail",4,"Server inbox.")
INSERT INTO helpsql VALUES("xp_deletemail",5," ")
INSERT INTO helpsql VALUES("xp_deletemail",6,"xp_deletemail [@msg_id = ] <msg_id>")

INSERT INTO helpsql VALUES("xp_enumgroups",1,"xp_enumgroups Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_enumgroups",2,"Provides a list of local Windows NT - based groups or a list of groups ")
INSERT INTO helpsql VALUES("xp_enumgroups",3,"defined in a specified Windows NT domain.")
INSERT INTO helpsql VALUES("xp_enumgroups",4," ")
INSERT INTO helpsql VALUES("xp_enumgroups",5,"xp_enumgroups [<domain_name>]")
INSERT INTO helpsql VALUES("xp_findnextmsg",1,"xp_findnextmsg Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_findnextmsg",2,"Accepts a message ID for input and returns the message ID for output. ")
INSERT INTO helpsql VALUES("xp_findnextmsg",3," ")
INSERT INTO helpsql VALUES("xp_findnextmsg",4,"xp_findnextmsg [@msg_id = <msg_id> [OUTPUT]] ")
INSERT INTO helpsql VALUES("xp_findnextmsg",5,"     [, @type = <type>] ")
INSERT INTO helpsql VALUES("xp_findnextmsg",6,"     [, @unread_only = {'TRUE' | 'FALSE'}])")
INSERT INTO helpsql VALUES("xp_grantlogin",1,"xp_grantlogin Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_grantlogin",2,"Grants SQL Server access to a Windows NT - based group or user.")
INSERT INTO helpsql VALUES("xp_grantlogin",3," ")
INSERT INTO helpsql VALUES("xp_grantlogin",4,"xp_grantlogin '<account_name>' [, {'admin' | 'repl' | 'user'}]")
INSERT INTO helpsql VALUES("xp_logevent",1,"xp_logevent Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_logevent",2,"Logs a user-defined message in the SQL Server log file and/or in the Windows ")
INSERT INTO helpsql VALUES("xp_logevent",3,"NT Event Viewer. When sending messages from Transact-SQL procedures, triggers, ")
INSERT INTO helpsql VALUES("xp_logevent",4,"batches, and so on, use the RAISERROR statement instead of xp_logevent.")
INSERT INTO helpsql VALUES("xp_logevent",5," ")
INSERT INTO helpsql VALUES("xp_logevent",6,"xp_logevent <error_number>, <message>, [<severity>]")
INSERT INTO helpsql VALUES("xp_loginconfig",1,"xp_loginconfig Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_loginconfig",2,"Reports the login security configuration of the server.")
INSERT INTO helpsql VALUES("xp_loginconfig",3," ")
INSERT INTO helpsql VALUES("xp_loginconfig",4,"xp_loginconfig ['<config_name>']")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("xp_logininfo",1,"xp_logininfo Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_logininfo",2,"Reports the account, the type of account, the privilege level of the ")
INSERT INTO helpsql VALUES("xp_logininfo",3,"account, the map name of the account, and the permission path by which ")
INSERT INTO helpsql VALUES("xp_logininfo",4,"the account has access to SQL Server.")
INSERT INTO helpsql VALUES("xp_logininfo",5," ")
INSERT INTO helpsql VALUES("xp_logininfo",6,"xp_logininfo ['<account_name>' [, 'all' | 'members'] ")
INSERT INTO helpsql VALUES("xp_logininfo",7,"     [, [@privilege] = <variable_name> OUTPUT]]")
INSERT INTO helpsql VALUES("xp_msver",1,"xp_msver Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_msver",2,"Returns and allows to be queried all SQL Server version information.")
INSERT INTO helpsql VALUES("xp_msver",3," ")
INSERT INTO helpsql VALUES("xp_msver",4,"xp_msver [<optname>]")
INSERT INTO helpsql VALUES("xp_readmail",1,"xp_readmail Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_readmail",2,"Reads a mail message from the SQL Server mail inbox. This procedure is ")
INSERT INTO helpsql VALUES("xp_readmail",3,"used by the sp_processmail system stored procedure to process all mail ")
INSERT INTO helpsql VALUES("xp_readmail",4,"in the SQL Server inbox.")
INSERT INTO helpsql VALUES("xp_readmail",5," ")
go

INSERT INTO helpsql VALUES("xp_readmail",6,"xp_readmail ([@msg_id = <msg_id>] ")
INSERT INTO helpsql VALUES("xp_readmail",7,"     [, @type = <type> [OUTPUT]] ")
INSERT INTO helpsql VALUES("xp_readmail",8,"     [, @peek = {'TRUE' | 'FALSE'}] ")
INSERT INTO helpsql VALUES("xp_readmail",9,"     [, @suppress_attach = {'TRUE' | 'FALSE'}] ")
INSERT INTO helpsql VALUES("xp_readmail",10,"     [, @originator = @<sender> OUTPUT] ")
INSERT INTO helpsql VALUES("xp_readmail",11,"     [, @subject = @<subject> OUTPUT] ")
INSERT INTO helpsql VALUES("xp_readmail",12,"     [, @message = @<body_of_message> OUTPUT] ")
INSERT INTO helpsql VALUES("xp_readmail",13,"     [, @recipients = @<recipient_list> OUTPUT] ")
INSERT INTO helpsql VALUES("xp_readmail",14,"     [, @cc_list = @<cc_list> OUTPUT] ")
INSERT INTO helpsql VALUES("xp_readmail",15,"     [, @bcc_list = @<bcc_list> OUTPUT]")
INSERT INTO helpsql VALUES("xp_readmail",16,"     [, @date_received = @<date> OUTPUT] ")
INSERT INTO helpsql VALUES("xp_readmail",17,"     [, @unread = {'TRUE' | 'FALSE'}] ")
INSERT INTO helpsql VALUES("xp_readmail",18,"     [, @attachments = @<temp_file_paths> OUTPUT]) ")
INSERT INTO helpsql VALUES("xp_readmail",19,"     [, @skipbytes = @<bytes_to> <skip> OUTPUT]) ")
INSERT INTO helpsql VALUES("xp_readmail",20,"     [, @msg_length = @<length_in_bytes> OUTPUT]) ")
INSERT INTO helpsql VALUES("xp_revokelogin",1,"xp_revokelogin Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_revokelogin",2,"Revokes SQL Server access from a Windows NT - based group or user.")
INSERT INTO helpsql VALUES("xp_revokelogin",3," ")
INSERT INTO helpsql VALUES("xp_revokelogin",4,"xp_revokelogin '<account_name>'")
INSERT INTO helpsql VALUES("xp_snmp_getstate",1,"xp_snmp_getstate Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_snmp_getstate",2,"Returns the following columns the SQL Server Simple Network Management ")
INSERT INTO helpsql VALUES("xp_snmp_getstate",3,"Protocol (SNMP) agent. The state of the SNMP agent indicates whether the")
INSERT INTO helpsql VALUES("xp_snmp_getstate",4,"agent is available to have the Microsoft SQL Server quried by an SNMP ")
INSERT INTO helpsql VALUES("xp_snmp_getstate",5,"client.")
INSERT INTO helpsql VALUES("xp_snmp_getstate",6," ")
INSERT INTO helpsql VALUES("xp_snmp_getstate",7,"xp_snmp_getstate [<return_status> OUTPUT]")
INSERT INTO helpsql VALUES("xp_snmp_raisetrap",1,"xp_snmp_raisetrap Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_snmp_raisetrap",2,"Permits a client to define and send an SNMP alert to an SNMP client.")
INSERT INTO helpsql VALUES("xp_snmp_raisetrap",3," ")
INSERT INTO helpsql VALUES("xp_snmp_raisetrap",4,"xp_snmp_raisetrap <server_name>, <database_name>, <error_message>,")
INSERT INTO helpsql VALUES("xp_snmp_raisetrap",5,"	<message_id>, <severity>, <user_name>, <comment>, <datetime>, ")
INSERT INTO helpsql VALUES("xp_snmp_raisetrap",6,"	<return_status>")
INSERT INTO helpsql VALUES("xp_sqlinventory",1,"xp_sqlinventory Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_sqlinventory",2,"Returns the following columns describing SQL Server Domain information.")
INSERT INTO helpsql VALUES("xp_sqlinventory",3," ")
INSERT INTO helpsql VALUES("xp_sqlinventory",4," 	SERVERNAME		SQLREGISTEREDOWNER	DOMAINNAME")
INSERT INTO helpsql VALUES("xp_sqlinventory",5,"  	MAJORVERSION 		MINORVERSION 		BUILDNUMBER ")
INSERT INTO helpsql VALUES("xp_sqlinventory",6,"	SERVERLOGINS  		MAXCONNECTIONS 		DBCOUNT  ")
INSERT INTO helpsql VALUES("xp_sqlinventory",7,"	TOTALDEVICESIZE		SORTORDER  		CODEPAGE ") 
INSERT INTO helpsql VALUES("xp_sqlinventory",8,"	PROCEDURECACHE 		SMPSTATUS 		CONFIGUREDMEMORY ") 
INSERT INTO helpsql VALUES("xp_sqlinventory",9,"	PRIORITYBOOST  		WORKINGSET  		PUBLISHER  ")
INSERT INTO helpsql VALUES("xp_sqlinventory",10,"	SUBSCRIBER  		DISTRIBUTION  		SUPPORTSSNMP  ")
INSERT INTO helpsql VALUES("xp_sqlinventory",11,"	SECURITYMODE 		NAMEDPIPE 		SPX ")
INSERT INTO helpsql VALUES("xp_sqlinventory",12,"	WINSOCKET		APPLETALK  		VINES ") 
INSERT INTO helpsql VALUES("xp_sqlinventory",13,"	DECNET  		CPUBRAND 		CPUMODEL ")
INSERT INTO helpsql VALUES("xp_sqlinventory",14,"	CPUSTEPLEVEL		CPUCOUNT 		SERVERTOTALMEMORY ") 
INSERT INTO helpsql VALUES("xp_sqlinventory",15,"	OPERATINGSYSTEM		OPERATINGSYSTEMBUILD 	TOTALPHYSICALDISK ")
INSERT INTO helpsql VALUES("xp_sqlinventory",16,"	AVAILABLEPHYSICALDISK")
INSERT INTO helpsql VALUES("xp_sqlinventory",17," ")
INSERT INTO helpsql VALUES("xp_sqlinventory",18,"xp_sqlinventory {'<database_name>', '<table_name>', <interval> | stop}")
INSERT INTO helpsql VALUES("xp_sqltrace",1,"xp_sqltrace Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_sqltrace",2,"Allows database administrators and application developers to ")
INSERT INTO helpsql VALUES("xp_sqltrace",3,"monitor and record database activity. Multiple instances of")
INSERT INTO helpsql VALUES("xp_sqltrace",4,"xp_sqltrace can be run simultaneously. ")
INSERT INTO helpsql VALUES("xp_sqltrace",5," ")
INSERT INTO helpsql VALUES("xp_sqltrace",6," ")
INSERT INTO helpsql VALUES("xp_sqltrace",7,"xp_sqltrace [[@Function = ]<function>][,[@EventFilter =]<eventfilter>] ")
INSERT INTO helpsql VALUES("xp_sqltrace",8,"[,[@LangFilter = ]'<langfilter>'][,[@RPCFilter = ]'<rpcfilter>']")
INSERT INTO helpsql VALUES("xp_sqltrace",9,"[,[@UserFilter = ]<userfilter>][,[@Appfilter = ]<appfilter>]")
INSERT INTO helpsql VALUES("xp_sqltrace",10,"[,[@HostFilter =]<hostfilter>][,[@BufSize = ]<bufsize>]")
INSERT INTO helpsql VALUES("xp_sqltrace",11,"[,[@Timeout = ]<timeout>][,[@Traceid = ]<traceid>][,[@Fulltext = ]<fulltext>]")
INSERT INTO helpsql VALUES("xp_sqltrace",12,"[,[@FullFilePath = ]'<outputfilename>'] [,[@InterEvents =]<integerevents>]  ")
INSERT INTO helpsql VALUES("sp_xpoption",1,"sp_xpoption Stored Procedure")
INSERT INTO helpsql VALUES("sp_xpoption",2,"Sets the value of extended stored procedure options.")
INSERT INTO helpsql VALUES("sp_xpoption",3," ")
INSERT INTO helpsql VALUES("sp_xpoption",4,"sp_xpoption {<xpname>, <option_name>, [<option_value>]}")


go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("xp_sendmail",1,"xp_sendmail Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_sendmail",2,"Sends a message, and/or a query results set, and/or an attachment to the ")
INSERT INTO helpsql VALUES("xp_sendmail",3,"specified recipients.")
INSERT INTO helpsql VALUES("xp_sendmail",4," ")
INSERT INTO helpsql VALUES("xp_sendmail",5,"xp_sendmail @recipient = <recipient> [; <recipient2>; ")
INSERT INTO helpsql VALUES("xp_sendmail",6,"               [...; <recipientn>]]")
INSERT INTO helpsql VALUES("xp_sendmail",7,"     [, @message = <message>] ")
INSERT INTO helpsql VALUES("xp_sendmail",8,"     [, @query = <query>] ")
INSERT INTO helpsql VALUES("xp_sendmail",9,"     [, @attachments = <attachments>] ")
INSERT INTO helpsql VALUES("xp_sendmail",10,"     [, @copy_recipients = <recipient> [; <recipient2>; ")
INSERT INTO helpsql VALUES("xp_sendmail",11,"          [...; <recipientn>]]] ")
INSERT INTO helpsql VALUES("xp_sendmail",12,"     [, @blind_copy_recipients = <recipient> [; <recipient2>; ")
INSERT INTO helpsql VALUES("xp_sendmail",13,"          [...; <recipientn>]]]")
INSERT INTO helpsql VALUES("xp_sendmail",14,"     [, @subject = <subject>] ")
INSERT INTO helpsql VALUES("xp_sendmail",15,"     [, @type = <type>] ")
INSERT INTO helpsql VALUES("xp_sendmail",16,"     [, @attach_results = {'TRUE' | 'FALSE'}] ")
INSERT INTO helpsql VALUES("xp_sendmail",17,"     [, @no_output = {'TRUE' | 'FALSE'}] ")
INSERT INTO helpsql VALUES("xp_sendmail",18,"     [, @no_header = {'TRUE' | 'FALSE'}] ")
INSERT INTO helpsql VALUES("xp_sendmail",19,"     [, @width = <width>] ")
INSERT INTO helpsql VALUES("xp_sendmail",20,"     [, @separator = <separator>] ")
INSERT INTO helpsql VALUES("xp_sendmail",21,"     [, @echo_error = {'TRUE' | 'FALSE'}] ")
INSERT INTO helpsql VALUES("xp_sendmail",22,"     [, @set_user = <user>] ")
INSERT INTO helpsql VALUES("xp_sendmail",23,"     [, @dbuse = <dbname>]")
INSERT INTO helpsql VALUES("xp_sprintf",1,"xp_sprintf Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_sprintf",2,"Formats and stores a series of characters and values in the string ")
INSERT INTO helpsql VALUES("xp_sprintf",3,"output parameter. Each format argument is replaced with the ")
INSERT INTO helpsql VALUES("xp_sprintf",4,"corresponding argument.")
INSERT INTO helpsql VALUES("xp_sprintf",5," ")
INSERT INTO helpsql VALUES("xp_sprintf",6,"xp_sprintf @<string> OUTPUT, <format> [, <argument>]...")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("xp_sscanf",1,"xp_sscanf Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_sscanf",2,"Reads data from the string into the argument locations given by each ")
INSERT INTO helpsql VALUES("xp_sscanf",3,"format argument.")
INSERT INTO helpsql VALUES("xp_sscanf",4," ")
INSERT INTO helpsql VALUES("xp_sscanf",5,"xp_sscanf <string, <format>, [, <argument>]...")
INSERT INTO helpsql VALUES("xp_startmail",1,"xp_startmail Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_startmail",2,"Starts a SQL Server mail client session.")
INSERT INTO helpsql VALUES("xp_startmail",3," ")
INSERT INTO helpsql VALUES("xp_startmail",4,"xp_startmail ['<user>'] [, '<password>'] ")
INSERT INTO helpsql VALUES("xp_stopmail",1,"xp_stopmail Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_stopmail",2,"Stops a SQL Server mail client session.")
INSERT INTO helpsql VALUES("xp_stopmail",3," ")
INSERT INTO helpsql VALUES("xp_stopmail",4,"xp_stopmail")
INSERT INTO helpsql VALUES("xp_unc_to_drive",1,"xp_unc_to_drive Extended Stored Procedure")
INSERT INTO helpsql VALUES("xp_unc_to_drive",2,"Converts a UNC path to a local drive.")
INSERT INTO helpsql VALUES("xp_unc_to_drive",3," ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_addarticle",1,"sp_addarticle Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_addarticle",2,"Creates an article and adds it to a publication.")
INSERT INTO helpsql VALUES("sp_addarticle",3," ")
INSERT INTO helpsql VALUES("sp_addarticle",4,"sp_addarticle <publication>, <article>, <source_table> ")
INSERT INTO helpsql VALUES("sp_addarticle",5,"     [, <destination_table>] [, <vertical_partition>] [, <type>] ")
INSERT INTO helpsql VALUES("sp_addarticle",6,"     [, <filter>] [, <sync_object>] [, <ins_cmd>] [, <del_cmd>] ")
INSERT INTO helpsql VALUES("sp_addarticle",7,"     [, <upd_cmd>] [, <creation_script>] [, <description>] ")
INSERT INTO helpsql VALUES("sp_addarticle",8,"     [, <pre_creation_cmd>] [, <filter_clause>] ")
INSERT INTO helpsql VALUES("sp_addpublication",1,"sp_addpublication Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_addpublication",2,"Creates a publication.")
INSERT INTO helpsql VALUES("sp_addpublication",3," ")
INSERT INTO helpsql VALUES("sp_addpublication",4,"sp_addpublication <publication>, <taskid> ")
INSERT INTO helpsql VALUES("sp_addpublication",5,"     [, @restricted = {'TRUE' | 'FALSE'} ")
INSERT INTO helpsql VALUES("sp_addpublication",6,"     [, @sync_method = {'NATIVE' | 'CHARACTER'} ")
INSERT INTO helpsql VALUES("sp_addpublication",7,"     [, @repl_freq = {'CONTINUOUS' | 'SNAPSHOT'} ")
INSERT INTO helpsql VALUES("sp_addpublication",8,"     [, @description = 'string description' ")
INSERT INTO helpsql VALUES("sp_addpublication",9,"     [, @status = 'INACTIVE' | 'ACTIVE']]]]] ")
INSERT INTO helpsql VALUES("sp_addpublisher",1,"sp_addpublisher Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_addpublisher",2,"Adds a new publication server.")
INSERT INTO helpsql VALUES("sp_addpublisher",3," ")
INSERT INTO helpsql VALUES("sp_addpublisher",4,"sp_addpublisher <publisher> [, 'dist']")
INSERT INTO helpsql VALUES("sp_addsubscriber",1,"sp_addsubscriber Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_addsubscriber",2,"Adds a new subscriber server and sets up a trusted remote login ")
INSERT INTO helpsql VALUES("sp_addsubscriber",3,"mapping from SA of the subscriber to the ")
INSERT INTO helpsql VALUES("sp_addsubscriber",4,"repl_subscriber login ID on the publisher (unless system administrator ")
INSERT INTO helpsql VALUES("sp_addsubscriber",5,"on the subscriber is already mapped to system administrator on the ")
INSERT INTO helpsql VALUES("sp_addsubscriber",6,"publisher).")
INSERT INTO helpsql VALUES("sp_addsubscriber",7," ")
INSERT INTO helpsql VALUES("sp_addsubscriber",8,"sp_addsubscriber <subscriber> [, <type>] [, <login>] [, <password>] ")
INSERT INTO helpsql VALUES("sp_addsubscriber",9,"      [, <commit_batch_size>] [, <status_batch_size>] [, <flush_frequency>] ")
INSERT INTO helpsql VALUES("sp_addsubscriber",10,"      [, <frequency_type>] [, <frequency_interval>] ")
INSERT INTO helpsql VALUES("sp_addsubscriber",11,"      [, <frequency_relative_interval>] [, <frequency_recurrence_factor>] ")
INSERT INTO helpsql VALUES("sp_addsubscriber",12,"      [, <frequency_subday>] [, <frequency_subday_interval>] ")
INSERT INTO helpsql VALUES("sp_addsubscriber",13,"      [, <active_start_time_of_day>] [, <active_end_time_of_day>] ")
INSERT INTO helpsql VALUES("sp_addsubscriber",14,"      [, <active_start_date>] [, <active_end_date>][,<description>] ")
INSERT INTO helpsql VALUES("sp_addsubscription",1,"sp_addsubscription Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_addsubscription",2,"Adds a subscription to an article and sets the subscriber's status.")
INSERT INTO helpsql VALUES("sp_addsubscription",3," ")
INSERT INTO helpsql VALUES("sp_addsubscription",4,"sp_addsubscription <publication> [, '<article>'] , <subscriber> ")
INSERT INTO helpsql VALUES("sp_addsubscription",5,"     [, <destination_db>] ")
INSERT INTO helpsql VALUES("sp_addsubscription",6,"     [, @sync_type = {'AUTOMATIC' | 'MANUAL' | 'NONE' }] ")
INSERT INTO helpsql VALUES("sp_addsubscription",7,"     [, @status = {'INACTIVE' | 'ACTIVE' | 'SUBSCRIBED' }] ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_articlecolumn",1,"sp_articlecolumn Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_articlecolumn",2,"Modifies columns for an article. Use sp_articlecolumn to create vertical ")
INSERT INTO helpsql VALUES("sp_articlecolumn",3,"partitions.")
INSERT INTO helpsql VALUES("sp_articlecolumn",4," ")
INSERT INTO helpsql VALUES("sp_articlecolumn",5,"sp_articlecolumn <publication>, <article> [, '<column>' ")
INSERT INTO helpsql VALUES("sp_articlecolumn",6,"     [, @operation = { 'ADD' | 'DROP' }] ")
INSERT INTO helpsql VALUES("sp_articlefilter",1,"sp_articlefilter Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_articlefilter",2,"Creates a filter stored procedure used to horizontally partition data ")
INSERT INTO helpsql VALUES("sp_articlefilter",3,"replicated from a published table.")
INSERT INTO helpsql VALUES("sp_articlefilter",4," ")
INSERT INTO helpsql VALUES("sp_articlefilter",5,"sp_articlefilter <publication>, <article> [, <filter_name>] ")
INSERT INTO helpsql VALUES("sp_articlefilter",6,"     [, <filter_clause>]")
INSERT INTO helpsql VALUES("sp_articletextcol",1,"sp_articletextcol Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_articletextcol",2,"Sets the replication column status of a Text\Image column")
INSERT INTO helpsql VALUES("sp_articletextcol",3," ")
INSERT INTO helpsql VALUES("sp_articletextcol",4,"sp_articletextcol <artid>, <colid>, ")
INSERT INTO helpsql VALUES("sp_articletextcol",5,"    <type> = {'PUBLISH' | 'NONSQLSUB'},  <operation> = { 'ADD' | 'DROP'}")
INSERT INTO helpsql VALUES("sp_articleview",1,"sp_articleview Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_articleview",2,"Creates the synchronization object for an article ")
INSERT INTO helpsql VALUES("sp_articleview",3,"when a table is filtered vertically and/or horizontally. ")
INSERT INTO helpsql VALUES("sp_articleview",4,"This synchronization object is a view that is used as the filtered ")
INSERT INTO helpsql VALUES("sp_articleview",5,"source of the schema and data for the destination tables. ")
INSERT INTO helpsql VALUES("sp_articleview",6," ")
INSERT INTO helpsql VALUES("sp_articleview",7,"sp_articleview <publication>, <article> [, <view_name>] ")
INSERT INTO helpsql VALUES("sp_articleview",8,"     [, <filter_clause>]")
INSERT INTO helpsql VALUES("sp_changearticle",1,"sp_changearticle Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_changearticle",2,"Changes an article's properties.")
INSERT INTO helpsql VALUES("sp_changearticle",3," ")
INSERT INTO helpsql VALUES("sp_changearticle",4,"sp_changearticle <publication>, <article> [, <property>, <value>]")
INSERT INTO helpsql VALUES("sp_changepublication",1,"sp_changepublication Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_changepublication",2,"Changes publication properties.")
INSERT INTO helpsql VALUES("sp_changepublication",3," ")
INSERT INTO helpsql VALUES("sp_changepublication",4,"sp_changepublication <publication> [, <property>, '<value>']")
INSERT INTO helpsql VALUES("sp_changesubscriber",1,"sp_changesubscriber Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_changesubscriber",2,"Changes the options for a subscription server. Any distribution task ")
INSERT INTO helpsql VALUES("sp_changesubscriber",3,"for the publisher's subscribers will be updated.")
INSERT INTO helpsql VALUES("sp_changesubscriber",4," ")
INSERT INTO helpsql VALUES("sp_changesubscriber",5,"sp_changesubscriber <subscriber> [, <type> ] [, <login> ] [, <password>] ")
INSERT INTO helpsql VALUES("sp_changesubscriber",6,"     [, <commit_batch_size> ] [, <status_batch_size> ] [, <flush_frequency>] ")
INSERT INTO helpsql VALUES("sp_changesubscriber",7,"     [, <frequency_type> ] [, <frequency_interval>] ")
INSERT INTO helpsql VALUES("sp_changesubscriber",8,"     [, <frequency_relative_interval> ] [, <frequency_recurrence_factor>] ")
INSERT INTO helpsql VALUES("sp_changesubscriber",9,"     [, <frequency_subday> ] [, <frequency_subday_interval>] ")
INSERT INTO helpsql VALUES("sp_changesubscriber",10,"     [, <active_start_time_of_day> ] [, <active_end_time_of_day>] ")
INSERT INTO helpsql VALUES("sp_changesubscriber",11,"     [, <active_start_date> ] [, <active_end_date>] [, <description>] ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_changesubscription",1,"sp_changesubscription Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_changesubscription",2,"Is executed on a subscription server to change subscription properties ")
INSERT INTO helpsql VALUES("sp_changesubscription",3,"for an article or a publication.")
INSERT INTO helpsql VALUES("sp_changesubscription",4," ")
INSERT INTO helpsql VALUES("sp_changesubscription",5,"sp_changesubscription <publication>, <article>, <subscriber> ")
INSERT INTO helpsql VALUES("sp_changesubscription",6,"     [, '<property>', '<value>']")
INSERT INTO helpsql VALUES("sp_changesubstatus",1,"sp_changesubstatus Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_changesubstatus",2,"Changes the status of an existing subscriber.")
INSERT INTO helpsql VALUES("sp_changesubstatus",3," ")
INSERT INTO helpsql VALUES("sp_changesubstatus",4,"sp_changesubstatus [<publication> [, <article> [, <subscriber>[,]]]]")
INSERT INTO helpsql VALUES("sp_changesubstatus",5,"     <status> [, previous_status]")
INSERT INTO helpsql VALUES("sp_create_distribution_tables",1,"sp_create_distribution_tables Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_create_distribution_tables",2,"Creates the tables in the distribution database.")
INSERT INTO helpsql VALUES("sp_create_distribution_tables",3," ")
INSERT INTO helpsql VALUES("sp_create_distribution_tables",4,"sp_create_distribution_tables")
INSERT INTO helpsql VALUES("sp_distcounters",1,"sp_distcounters Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_distcounters",2,"Displays the latest information for all subscription servers. Used by ")
INSERT INTO helpsql VALUES("sp_distcounters",3,"SQL Performance Monitor.")
INSERT INTO helpsql VALUES("sp_distcounters",4," ")
INSERT INTO helpsql VALUES("sp_distcounters",5,"sp_distcounters")
INSERT INTO helpsql VALUES("sp_droparticle",1,"sp_droparticle Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_droparticle",2,"Drops an article.")
INSERT INTO helpsql VALUES("sp_droparticle",3," ")
INSERT INTO helpsql VALUES("sp_droparticle",4,"sp_droparticle <publication>, <article> ")
INSERT INTO helpsql VALUES("sp_droppublication",1,"sp_droppublication Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_droppublication",2,"Drops a publication and its associated articles.")
INSERT INTO helpsql VALUES("sp_droppublication",3," ")
INSERT INTO helpsql VALUES("sp_droppublication",4,"sp_droppublication <publication>")
INSERT INTO helpsql VALUES("sp_droppublisher",1,"sp_droppublisher Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_droppublisher",2,"Drops a publication server.")
INSERT INTO helpsql VALUES("sp_droppublisher",3," ")
INSERT INTO helpsql VALUES("sp_droppublisher",4,"sp_droppublisher <publisher> [, dist]")
INSERT INTO helpsql VALUES("sp_dropsubscriber",1,"sp_dropsubscriber Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropsubscriber",2,"Drops a subscription server.")
INSERT INTO helpsql VALUES("sp_dropsubscriber",3," ")
INSERT INTO helpsql VALUES("sp_dropsubscriber",4,"sp_dropsubscriber <subscriber>")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_dropsubscription",1,"sp_dropsubscription Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropsubscription",2,"On the publication server, drops subscriptions to a particular article, ")
INSERT INTO helpsql VALUES("sp_dropsubscription",3,"publication, or set of subscriptions.")
INSERT INTO helpsql VALUES("sp_dropsubscription",4," ")
INSERT INTO helpsql VALUES("sp_dropsubscription",5,"sp_dropsubscription '<publication>', '<article>', '<subscriber>'")
INSERT INTO helpsql VALUES("sp_dsninfo",1,"sp_dsninfo Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_dsninfo",2,"Returns the information value for a ODBC Data Source Name.")
INSERT INTO helpsql VALUES("sp_dsninfo",3," ")
INSERT INTO helpsql VALUES("sp_dsninfo",4,"sp_dsninfo dsn [, {infotype | NULL} [, {login | NULL} [, {password | NULL}]]]")
INSERT INTO helpsql VALUES("sp_enumfullsubscribers",1,"sp_enumfullsubscribers Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_enumfullsubscribers",2,"Returns a list of subscribers who have subscribed to all articles in a ")
INSERT INTO helpsql VALUES("sp_enumfullsubscribers",3,"specified publication.")
INSERT INTO helpsql VALUES("sp_enumfullsubscribers",4," ")
INSERT INTO helpsql VALUES("sp_enumfullsubscribers",5,"sp_enumfullsubscribers <publication>")
INSERT INTO helpsql VALUES("sp_enumdsn",1,"sp_enumdsn Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_enumdsn",2,"Provides a list of ODBC Data Source Names accessible to the publisher. ")
INSERT INTO helpsql VALUES("sp_enumdsn",3," ")
INSERT INTO helpsql VALUES("sp_enumdsn",4,"sp_enumdsn")
INSERT INTO helpsql VALUES("sp_helparticle",1,"sp_helparticle Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helparticle",2,"Displays information about an article.")
INSERT INTO helpsql VALUES("sp_helparticle",3," ")
INSERT INTO helpsql VALUES("sp_helparticle",4,"sp_helparticle <publication>[, <article>] [, <returnfilter>]")
INSERT INTO helpsql VALUES("sp_helparticlecolumns",1,"sp_helparticlecolumns Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helparticlecolumns",2,"Displays all columns in the underlying table. ")
INSERT INTO helpsql VALUES("sp_helparticlecolumns",3," ")
INSERT INTO helpsql VALUES("sp_helparticlecolumns",4,"sp_helparticlecolumns <publication>, <article>")
INSERT INTO helpsql VALUES("sp_helpdistributor",1,"sp_helpdistributor Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpdistributor",2,"Lists information about the distribution server, distribution database, ")
INSERT INTO helpsql VALUES("sp_helpdistributor",3,"working directory, and SQL Executive user account.")
INSERT INTO helpsql VALUES("sp_helpdistributor",4," ")
INSERT INTO helpsql VALUES("sp_helpdistributor",5,"sp_helpdistributor")
INSERT INTO helpsql VALUES("sp_helppublication",1,"sp_helppublication Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helppublication",2,"Displays information about a publication.")
INSERT INTO helpsql VALUES("sp_helppublication",3," ")
INSERT INTO helpsql VALUES("sp_helppublication",4,"sp_helppublication [<publication>]")
INSERT INTO helpsql VALUES("sp_helppublicationsync",1,"sp_helppublicationsync Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helppublicationsync",2,"Provides information about a scheduled synchronization task for a ")
INSERT INTO helpsql VALUES("sp_helppublicationsync",3,"publication.")
INSERT INTO helpsql VALUES("sp_helppublicationsync",4," ")
INSERT INTO helpsql VALUES("sp_helppublicationsync",5,"sp_helppublicationsync <publication>")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_helpreplicationdb",1,"sp_helpreplicationdb Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpreplicationdb",2,"Returns information about a specified database or a list of all ")
INSERT INTO helpsql VALUES("sp_helpreplicationdb",3,"publication databases on the server. ")
INSERT INTO helpsql VALUES("sp_helpreplicationdb",4," ")
INSERT INTO helpsql VALUES("sp_helpreplicationdb",5,"sp_helpreplicationdb [<databasename> [, {pub | sub}]]")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",1,"sp_helpsubscriberinfo Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",2,"Displays the following information about a subscription server.")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",3," ")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",4," 	publisher		subscriber		type ")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",5," 	login			password		commit_batch_size")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",6," 	flush_frequency	frequency_type	frequency_interval")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",7," 	frequency_recurrence_factor		frequency_subday")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",8," 	frequency_subday_interval		active_start_time_of_day")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",9," 	active_end_time_of_day			active_start_date")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",10," 	active_end_date	retryattempts	retrydelay")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",11," 	description")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",12," ")
INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",13,"sp_helpsubscriberinfo <subscriber>")
INSERT INTO helpsql VALUES("sp_helpsubscription",1,"sp_helpsubscription Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpsubscription",2,"Lists subscription information associated with a particular publication, ")
INSERT INTO helpsql VALUES("sp_helpsubscription",3,"article, subscriber, or set of subscriptions.")
INSERT INTO helpsql VALUES("sp_helpsubscription",4," ")
INSERT INTO helpsql VALUES("sp_helpsubscription",5,"sp_helpsubscription [<publication> [, <article> [, <subscriber> ]]] ")
INSERT INTO helpsql VALUES("sp_MSkill_job",1,"sp_MSkill_job Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_MSkill_job",2,"On the distribution server, removes a single job from the distribution ")
INSERT INTO helpsql VALUES("sp_MSkill_job",3,"database while continuing to send all other data to the subscriber.")
INSERT INTO helpsql VALUES("sp_MSkill_job",4," ")
INSERT INTO helpsql VALUES("sp_MSkill_job",5,"sp_MSkill_job <job_id>, <publisher>, <publisher_db> [, <subscriber> ")
INSERT INTO helpsql VALUES("sp_MSkill_job",6,"     [, <subscriber_db>]]")
INSERT INTO helpsql VALUES("sp_replcleanup",1,"sp_replcleanup Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_replcleanup",2,"Removes transactions from the distribution database tables after they ")
INSERT INTO helpsql VALUES("sp_replcleanup",3,"have been successfully distributed to the subscriber's database.")
INSERT INTO helpsql VALUES("sp_replcleanup",4," ")
INSERT INTO helpsql VALUES("sp_replcleanup",5,"sp_replcleanup <publisher>, <subscriber>, <retention>")
INSERT INTO helpsql VALUES("sp_replcmds",1,"sp_replcmds Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_replcmds",2,"Treats the first client that runs sp_replcmds within a given database as the ")
INSERT INTO helpsql VALUES("sp_replcmds",3,"logreader. If another client tries to run sp_replcmds it will ")
INSERT INTO helpsql VALUES("sp_replcmds",4,"receive error 18752, unless the first client has disconnected.")
INSERT INTO helpsql VALUES("sp_replcmds",5," ")
INSERT INTO helpsql VALUES("sp_replcmds",6,"sp_replcmds [<maxtrans>]")
INSERT INTO helpsql VALUES("sp_replcounters",1,"sp_replcounters Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_replcounters",2,"Returns replication statistics about latency, throughput, and ")
INSERT INTO helpsql VALUES("sp_replcounters",3,"transaction count for each published database. Used by SQL Performance ")
INSERT INTO helpsql VALUES("sp_replcounters",4,"Monitor.")
INSERT INTO helpsql VALUES("sp_replcounters",5," ")
INSERT INTO helpsql VALUES("sp_replcounters",6,"sp_replcounters")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_repldone",1,"sp_repldone Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_repldone",2,"Updates the record that identifies the server's last distributed ")
INSERT INTO helpsql VALUES("sp_repldone",3,"transaction.")
INSERT INTO helpsql VALUES("sp_repldone",4," ")
INSERT INTO helpsql VALUES("sp_repldone",5,"sp_repldone <page>, <row> [, <timestamp>] [, <numtrans>] [, <time>] [, <reset>] ")
INSERT INTO helpsql VALUES("sp_replflush",1,"sp_replflush Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_replflush",2,"Flushes the article cache.")
INSERT INTO helpsql VALUES("sp_replflush",3," ")
INSERT INTO helpsql VALUES("sp_replflush",4,"sp_replflush ")
INSERT INTO helpsql VALUES("sp_replica",1,"sp_replica Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_replica",2,"Remotely sets on a subscription server a sysobjects category bit that ")
INSERT INTO helpsql VALUES("sp_replica",3,"marks the table as a replica.")
INSERT INTO helpsql VALUES("sp_replica",4," ")
INSERT INTO helpsql VALUES("sp_replica",5,"sp_replica <tabname>, <replicated>")
INSERT INTO helpsql VALUES("sp_replstatus",1,"sp_replstatus Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_replstatus",2,"Used to update the internal table structure for replication (that ")
INSERT INTO helpsql VALUES("sp_replstatus",3,"indicates whether the table is being replicated).")
INSERT INTO helpsql VALUES("sp_replstatus",4," ")
INSERT INTO helpsql VALUES("sp_replstatus",5,"sp_replstatus <objectID>, <status>")
INSERT INTO helpsql VALUES("sp_replsync",1,"sp_replsync Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_replsync",2,"Used from a subscription server to acknowledge completion of a manual ")
INSERT INTO helpsql VALUES("sp_replsync",3,"synchronization.")
INSERT INTO helpsql VALUES("sp_replsync",4," ")
INSERT INTO helpsql VALUES("sp_replsync",5,"sp_replsync <publisher>, <publisher_db>, <publication> [, <article>]")
INSERT INTO helpsql VALUES("sp_repltrans",1,"sp_repltrans Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_repltrans",2,"Returns a result set of all the transactions in the publication database ")
INSERT INTO helpsql VALUES("sp_repltrans",3,"transaction log that are marked for replication but that have not been ")
INSERT INTO helpsql VALUES("sp_repltrans",4,"marked as distributed.")
INSERT INTO helpsql VALUES("sp_repltrans",5," ")
INSERT INTO helpsql VALUES("sp_repltrans",6,"sp_repltrans")
INSERT INTO helpsql VALUES("sp_textcolstatus",1,"sp_textcolstatus Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_textcolstatus",2,"Checks the replication column status of a Text\Image column")
INSERT INTO helpsql VALUES("sp_textcolstatus",3," ")
INSERT INTO helpsql VALUES("sp_textcolstatus",4,"sp_textcolstatus <artid>, <tabid>, <colid>,")
INSERT INTO helpsql VALUES("sp_textcolstatus",5,"    <type> = {'PUBLISH' | 'NONSQLSUB'},  <status> OUTPUT")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_subscribe",1,"sp_subscribe Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_subscribe",2,"Remotely adds a subscription to a particular article within a ")
INSERT INTO helpsql VALUES("sp_subscribe",3,"publication.")
INSERT INTO helpsql VALUES("sp_subscribe",4," ")
INSERT INTO helpsql VALUES("sp_subscribe",5,"sp_subscribe <publication>, [<article> [, <desitination_db> ")
INSERT INTO helpsql VALUES("sp_subscribe",6,"     [, @sync_type = {'AUTOMATIC' | 'MANUAL' | 'NONE'}]]] ")
INSERT INTO helpsql VALUES("sp_uninstall_publishing",1,"sp_uninstall_publishing Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_uninstall_publishing",2,"Drops all subscriptions, articles, publications, subscribers")
INSERT INTO helpsql VALUES("sp_uninstall_publishing",3," and distribution publishers on the server.")
INSERT INTO helpsql VALUES("sp_uninstall_publishing",4," ")
INSERT INTO helpsql VALUES("sp_uninstall_publishing",5,"sp_uninstall_publishing")
INSERT INTO helpsql VALUES("sp_unsubscribe",6,"sp_unsubscribe '<publication>', '<article>'")
INSERT INTO helpsql VALUES("sp_unsubscribe",1,"sp_unsubscribe Replication Stored Procedure")
INSERT INTO helpsql VALUES("sp_unsubscribe",2,"Remotely cancels a subscription to a particular article within a ")
INSERT INTO helpsql VALUES("sp_unsubscribe",3,"publication, to a whole publication, or to all publications. It also ")
INSERT INTO helpsql VALUES("sp_unsubscribe",4,"removes all pending jobs from the distribution database.")
INSERT INTO helpsql VALUES("sp_unsubscribe",5," ")
INSERT INTO helpsql VALUES("sp_unsubscribe",6,"sp_unsubscribe '<publication>', '<article>'")
INSERT INTO helpsql VALUES("sp_addalert",1,"sp_addalert SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_addalert",2,"Creates an alert.")
INSERT INTO helpsql VALUES("sp_addalert",3," ")
INSERT INTO helpsql VALUES("sp_addalert",4,"sp_addalert <name>, <message_id>, <severity> [, <enabled>] ")
INSERT INTO helpsql VALUES("sp_addalert",5,"     [, <delay_between_responses>] [, <notification_message>] ")
INSERT INTO helpsql VALUES("sp_addalert",6,"     [, <include_event_description_in>] [, <database_name>] ")
INSERT INTO helpsql VALUES("sp_addalert",7,"     [, <event_description_keyword>] [, <task_name>]")
INSERT INTO helpsql VALUES("sp_addnotification",1,"sp_addnotification SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_addnotification",2,"Sets up a notification for an alert.")
INSERT INTO helpsql VALUES("sp_addnotification",3," ")
INSERT INTO helpsql VALUES("sp_addnotification",4,"sp_addnotification <alert_name>, <operator_name>, <notification_method> ")
INSERT INTO helpsql VALUES("sp_addoperator",1,"sp_addoperator SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_addoperator",2,"Sets up an operator (notification recipient) for use with alerts.")
INSERT INTO helpsql VALUES("sp_addoperator",3," ")
INSERT INTO helpsql VALUES("sp_addoperator",4,"sp_addoperator <name> [, <enabled>] [, <email_address>] ")
INSERT INTO helpsql VALUES("sp_addoperator",5,"     [, <pager_number>] [, <weekday_pager_start_time>] ")
INSERT INTO helpsql VALUES("sp_addoperator",6,"     [, <weekday_pager_end_time>] [, <saturday_pager_start_time>] ")
INSERT INTO helpsql VALUES("sp_addoperator",7,"     [, <saturday_pager_end_time>] [, <sunday_pager_start_time>] ")
INSERT INTO helpsql VALUES("sp_addoperator",8,"     [, <sunday_pager_end_time>] [, <pager_days>] ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_addtask",1,"sp_addtask SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_addtask",2,"Creates a scheduled task.")
INSERT INTO helpsql VALUES("sp_addtask",3," ")
INSERT INTO helpsql VALUES("sp_addtask",4,"sp_addtask <name> [, <subsystem>] [, <server>] [, <username>] ")
INSERT INTO helpsql VALUES("sp_addtask",5,"     [, <databasename>] [, <enabled>] [, <freqtype>] [, <freqinterval>] ")
INSERT INTO helpsql VALUES("sp_addtask",6,"     [, <freqsubtype>] [, <freqsubinterval>] [, <freqrelativeinterval>] ")
INSERT INTO helpsql VALUES("sp_addtask",7,"     [, <freqrecurrencefactor>] [, <activestartdate>] [, <activeenddate>] ")
INSERT INTO helpsql VALUES("sp_addtask",8,"     [, <activestarttimeofday>] [, <activeendtimeofday>] [, <nextrundate>] ")
INSERT INTO helpsql VALUES("sp_addtask",9,"     [, <nextruntime>] [, <runpriority>] [, <emailoperatorname>] ")
INSERT INTO helpsql VALUES("sp_addtask",10,"     [, <retryattempts>] [, <retrydelay>] [, <command>] ")
INSERT INTO helpsql VALUES("sp_addtask",11,"     [, <loghistcompletionlevel>] [, <emailcompletionlevel>] ")
INSERT INTO helpsql VALUES("sp_addtask",12,"     [, <description>] [, <tagadditionalinfo>] [, <tagobjectid>] ")
INSERT INTO helpsql VALUES("sp_addtask",13,"     [, <tagobjecttype>] [, @newid OUTPUT] [,@cmdexecsuccesscode]")
INSERT INTO helpsql VALUES("sp_dropalert",1,"sp_dropalert SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropalert",2,"Drops an alert.")
INSERT INTO helpsql VALUES("sp_dropalert",3," ")
INSERT INTO helpsql VALUES("sp_dropalert",4,"sp_dropalert <name>")
INSERT INTO helpsql VALUES("sp_dropnotification",1,"sp_dropnotification SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropnotification",2,"Drops a notification for an alert.")
INSERT INTO helpsql VALUES("sp_dropnotification",3," ")
INSERT INTO helpsql VALUES("sp_dropnotification",4,"sp_dropnotification <alert_name>, <operator_name>")
INSERT INTO helpsql VALUES("sp_dropoperator",1,"sp_dropoperator SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropoperator",2,"Drops an operator.")
INSERT INTO helpsql VALUES("sp_dropoperator",3," ")
INSERT INTO helpsql VALUES("sp_dropoperator",4,"sp_dropoperator <name>")
INSERT INTO helpsql VALUES("sp_droptask",1,"sp_droptask SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_droptask",2,"Removes a scheduled task.")
INSERT INTO helpsql VALUES("sp_droptask",3," ")
INSERT INTO helpsql VALUES("sp_droptask",4,"sp_droptask {<name> | <loginname> | <id>}")
INSERT INTO helpsql VALUES("sp_helpalert",1,"sp_helpalert SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpalert",2,"Reports information about the alerts defined for the server.")
INSERT INTO helpsql VALUES("sp_helpalert",3," ")
INSERT INTO helpsql VALUES("sp_helpalert",4,"sp_helpalert [<having_name_like>]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_helphistory",1,"sp_helphistory SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_helphistory",2,"Reports the history of one or more scheduled events, alerts, or tasks. ")
INSERT INTO helpsql VALUES("sp_helphistory",3,"Some of the information in the systasks table is not displayed to users other ")
INSERT INTO helpsql VALUES("sp_helphistory",4,"than the system administrator. ")
INSERT INTO helpsql VALUES("sp_helphistory",5," ")
INSERT INTO helpsql VALUES("sp_helphistory",6,"sp_helphistory [, <taskname>] [, <taskid>] [, <eventid>] [, <messageid>] ")
INSERT INTO helpsql VALUES("sp_helphistory",7,"     [, <severity>] [, <source>] [, <category>] [, <startdate>] ")
INSERT INTO helpsql VALUES("sp_helphistory",8,"     [, <enddate>] [, <starttime>] [, <endtime>] [, <skipped>] ")
INSERT INTO helpsql VALUES("sp_helphistory",9,"     [, oldestfirst] [, <mode>] ")
INSERT INTO helpsql VALUES("sp_helpnotification",1,"sp_helpnotification SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpnotification",2,"Reports a list of notifications.")
INSERT INTO helpsql VALUES("sp_helpnotification",3," ")
INSERT INTO helpsql VALUES("sp_helpnotification",4,"sp_helpnotification <object_type>, <name>, <enum_type>, ")
INSERT INTO helpsql VALUES("sp_helpnotification",5,"     <notification_method> [, <target_name>]")
INSERT INTO helpsql VALUES("sp_helpoperator",1,"sp_helpoperator SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpoperator",2,"Reports information about the operators defined for the server.")
INSERT INTO helpsql VALUES("sp_helpoperator",3," ")
INSERT INTO helpsql VALUES("sp_helpoperator",4,"sp_helpoperator [<having_name_like>]")
INSERT INTO helpsql VALUES("sp_helptask",1,"sp_helptask SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_helptask",2,"Provides information about one or more tasks. Some of the information ")
INSERT INTO helpsql VALUES("sp_helptask",3,"in the systasks table is not displayed to users other than the system ")
INSERT INTO helpsql VALUES("sp_helptask",4,"administrator. ")
INSERT INTO helpsql VALUES("sp_helptask",5," ")
INSERT INTO helpsql VALUES("sp_helptask",6,"sp_helptask <taskname> [, <taskid>] [, <loginname>] [, <operatorname>] ")
INSERT INTO helpsql VALUES("sp_helptask",7,"     [, <subsystem>] [, <mode>]")
INSERT INTO helpsql VALUES("sp_purgehistory",1,"sp_purgehistory SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_purgehistory",2,"Removes information from the history log.")
INSERT INTO helpsql VALUES("sp_purgehistory",3," ")
INSERT INTO helpsql VALUES("sp_purgehistory",4,"sp_purgehistory [<taskname>] [, <taskid>] [, <eventid>] [, <messageid>] ")
INSERT INTO helpsql VALUES("sp_purgehistory",5,"     [, <severity>] [, <source>] [, <category>] [, <startdate>] ")
INSERT INTO helpsql VALUES("sp_purgehistory",6,"     [, <enddate>] [, <starttime>] [, <endtime>] [, <skipped>] ")
INSERT INTO helpsql VALUES("sp_runtask",1,"sp_runtask SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_runtask",2,"Immediately executes a SQL Executive scheduled task either from a  ")
INSERT INTO helpsql VALUES("sp_runtask",4,"command batch or from a user-defined stored procedure. ")
INSERT INTO helpsql VALUES("sp_runtask",5,"   ")
INSERT INTO helpsql VALUES("sp_runtask",6,"sp_runtask {'<task_name>' | @task_id=} ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_updatealert",1,"sp_updatealert SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_updatealert",2,"Updates information for an existing alert.")
INSERT INTO helpsql VALUES("sp_updatealert",3," ")
INSERT INTO helpsql VALUES("sp_updatealert",4,"sp_updatealert <name> [, <new_name>] [, <enabled>] [, <message_id>] ")
INSERT INTO helpsql VALUES("sp_updatealert",5,"     [, <severity>] [, <delay_between_responses>] ")
INSERT INTO helpsql VALUES("sp_updatealert",6,"     [, <notification_message>] [, <include_event_description_in>] ")
INSERT INTO helpsql VALUES("sp_updatealert",7,"     [, <database_name>] [, <event_description_keyword>] ")
INSERT INTO helpsql VALUES("sp_updatealert",8,"     [, <task_name>] [, <occurrence_count>] [, <count_reset_date>] ")
INSERT INTO helpsql VALUES("sp_updatealert",9,"     [, <count_reset_time>] [, <last_occurrence_date>] ")
INSERT INTO helpsql VALUES("sp_updatealert",10,"     [, <last_occurrence_time>] [, <last_response_date>] ")
INSERT INTO helpsql VALUES("sp_updatealert",11,"     [, <last_response _time>]")
INSERT INTO helpsql VALUES("sp_updatenotification",1,"sp_updatenotification SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_updatenotification",2,"Updates the notification method of an alert notification.")
INSERT INTO helpsql VALUES("sp_updatenotification",3," ")
INSERT INTO helpsql VALUES("sp_updatenotification",4,"sp_updatenotification <alert_name>, <operator_name>, ")
INSERT INTO helpsql VALUES("sp_updatenotification",5,"     <notification_method>")
INSERT INTO helpsql VALUES("sp_updateoperator",1,"sp_updateoperator SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_updateoperator",2,"Updates information about an operator.")
INSERT INTO helpsql VALUES("sp_updateoperator",3," ")
INSERT INTO helpsql VALUES("sp_updateoperator",4,"sp_updateoperator <name> [, <new_name>] [, <enabled>] ")
INSERT INTO helpsql VALUES("sp_updateoperator",5,"     [, <email_address>] [, <pager_number>] ")
INSERT INTO helpsql VALUES("sp_updateoperator",6,"     [, <weekday_pager_start_time>] [, <weekday_pager_end_time>] ")
INSERT INTO helpsql VALUES("sp_updateoperator",7,"     [, <saturday_pager_start_time>] [, <saturday_pager_end_time>] ")
INSERT INTO helpsql VALUES("sp_updateoperator",8,"     [, <sunday_pager_start_time>] [, <sunday_pager_end_time>] ")
INSERT INTO helpsql VALUES("sp_updateoperator",9,"     [, <pager_days>] ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_updatetask",1,"sp_updatetask SQL Executive Stored Procedure")
INSERT INTO helpsql VALUES("sp_updatetask",2,"Updates information about a task.")
INSERT INTO helpsql VALUES("sp_updatetask",3," ")
INSERT INTO helpsql VALUES("sp_updatetask",4,"sp_updatetask {<currentname> | <id>} [, <name>] [, <subsystem>] ")
INSERT INTO helpsql VALUES("sp_updatetask",5,"     [, <server>] [, <username>] [, <databasename>] [, <enabled>] ")
INSERT INTO helpsql VALUES("sp_updatetask",6,"     [, <freqtype>] [, <freqinterval>] [, <freqsubtype>] ")
INSERT INTO helpsql VALUES("sp_updatetask",7,"     [, <freqsubinterval>] [, <freqrelativeinterval>] ")
INSERT INTO helpsql VALUES("sp_updatetask",8,"     [, <freqrecurrencefactor>] [, <activestartdate>] ")
INSERT INTO helpsql VALUES("sp_updatetask",9,"     [, <activeenddate>] [, <activestarttimeofday>] ")
INSERT INTO helpsql VALUES("sp_updatetask",10,"     [, <activeendtimeofday>] [, <nextrundate>] [, <nextruntime>] ")
INSERT INTO helpsql VALUES("sp_updatetask",11,"     [, <runpriority>] [, <emailoperatorname>] [, <retryattempts>] ")
INSERT INTO helpsql VALUES("sp_updatetask",12,"     [, <retrydelay>] [, <command>] [, <loghistcompletionlevel>] ")
INSERT INTO helpsql VALUES("sp_updatetask",13,"     [, <emailcompletionlevel>] [, <description>] ")
INSERT INTO helpsql VALUES("sp_updatetask",14,"     [, <tagadditionalinfo>] [, <tagobjectid>] [, <tagobjecttype>] ")
INSERT INTO helpsql VALUES("sp_updatetask",15,"     [,@cmdexecsuccesscode]  ")
INSERT INTO helpsql VALUES("sp_addalias",1,"sp_addalias System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addalias",2,"Maps one user to another in a database.")
INSERT INTO helpsql VALUES("sp_addalias",3," ")
INSERT INTO helpsql VALUES("sp_addalias",4,"sp_addalias <login_ID>, <username>")
INSERT INTO helpsql VALUES("sp_addextendedproc",1,"sp_addextendedproc System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addextendedproc",2,"Registers the name of a new extended stored procedure to SQL Server.")
INSERT INTO helpsql VALUES("sp_addextendedproc",3," ")
INSERT INTO helpsql VALUES("sp_addextendedproc",4,"sp_addextendedproc <function_name>, <dll_name>")
INSERT INTO helpsql VALUES("sp_addgroup",1,"sp_addgroup System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addgroup",2,"Creates a group in the current database.")
INSERT INTO helpsql VALUES("sp_addgroup",3," ")
INSERT INTO helpsql VALUES("sp_addgroup",4,"sp_addgroup <grpname>")
INSERT INTO helpsql VALUES("sp_addlogin",1,"sp_addlogin System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addlogin",2,"Creates a new SQL Server user by adding an entry to ")
INSERT INTO helpsql VALUES("sp_addlogin",3,"master.dbo.syslogins.")
INSERT INTO helpsql VALUES("sp_addlogin",4," ")
INSERT INTO helpsql VALUES("sp_addlogin",5,"sp_addlogin <login_ID> [, <passwd> [, <defdb> [, <deflanguage>")
INSERT INTO helpsql VALUES("sp_addlogin",6,"	[,login_suid]]]] ")
INSERT INTO helpsql VALUES("sp_addmessage",1,"sp_addmessage System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addmessage",2,"Adds a new error message to the sysmessages table.")
INSERT INTO helpsql VALUES("sp_addmessage",3," ")
INSERT INTO helpsql VALUES("sp_addmessage",4,"sp_addmessage <msg_id>, <severity>, '<text of message>' ")
INSERT INTO helpsql VALUES("sp_addmessage",5,"          [, <language> [, TRUE | FALSE [, REPLACE]]]")
INSERT INTO helpsql VALUES("sp_bindsession",1,"sp_bindsession System Stored Procedure")
INSERT INTO helpsql VALUES("sp_bindsession",2,"Binds or unbinds a connection to other connections. A bound")
INSERT INTO helpsql VALUES("sp_bindsession",3,"connection allows two or more connections to participate in")
INSERT INTO helpsql VALUES("sp_bindsession",4,"the same transaction and share the transaction space until ")
INSERT INTO helpsql VALUES("sp_bindsession",5,"a ROLLBACK or COMMIT TRANSACTION. ")
INSERT INTO helpsql VALUES("sp_bindsession",6," ")
INSERT INTO helpsql VALUES("sp_bindsession",7,"sp_bindsession {'<bindtoken>' | 'NULL'}")

go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_addremotelogin",1,"sp_addremotelogin System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addremotelogin",2,"Adds a new remote login ID to master.dbo.sysremotelogins. ")
INSERT INTO helpsql VALUES("sp_addremotelogin",3," ")
INSERT INTO helpsql VALUES("sp_addremotelogin",4,"sp_addremotelogin <remoteserver> [, <login_ID> [, <remotename>]]")
INSERT INTO helpsql VALUES("sp_addsegment",1,"sp_addsegment System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addsegment",2,"Defines a segment on a database device in the current database.")
INSERT INTO helpsql VALUES("sp_addsegment",3," ")
INSERT INTO helpsql VALUES("sp_addsegment",4,"sp_addsegment <segname>, <logical_name>")
INSERT INTO helpsql VALUES("sp_addserver",1,"sp_addserver System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addserver",2,"Defines a remote server or the name of the local server.")
INSERT INTO helpsql VALUES("sp_addserver",3," ")
INSERT INTO helpsql VALUES("sp_addserver",4,"sp_addserver <server_name> [, LOCAL]")
INSERT INTO helpsql VALUES("sp_addtype",1,"sp_addtype System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addtype",2,"Creates a user-defined datatype.")
INSERT INTO helpsql VALUES("sp_addtype",3," ")
INSERT INTO helpsql VALUES("sp_addtype",4,"sp_addtype <typename>, <phystype> [, <nulltype>]")
INSERT INTO helpsql VALUES("sp_addumpdevice",1,"sp_addumpdevice System Stored Procedure")
INSERT INTO helpsql VALUES("sp_addumpdevice",2,"Adds a dump device to SQL Server.")
INSERT INTO helpsql VALUES("sp_addumpdevice",3," ")
INSERT INTO helpsql VALUES("sp_addumpdevice",4,"sp_addumpdevice {'disk' | 'diskette' | 'tape'}, '<logical_name>', ")
INSERT INTO helpsql VALUES("sp_addumpdevice",5,"     '<physical_name>' [, {{<cntrltype> [, noskip | skip ")
INSERT INTO helpsql VALUES("sp_addumpdevice",6,"     [, <media_capacity>]]} | ")
INSERT INTO helpsql VALUES("sp_addumpdevice",7,"     {@devstatus = {noskip | skip}}}]")
INSERT INTO helpsql VALUES("sp_adduser",1,"sp_adduser System Stored Procedure")
INSERT INTO helpsql VALUES("sp_adduser",2,"Adds a new user to the current database.")
INSERT INTO helpsql VALUES("sp_adduser",3," ")
INSERT INTO helpsql VALUES("sp_adduser",4,"sp_adduser <login_ID> [, <username> [, <grpname>]]")
INSERT INTO helpsql VALUES("sp_altermessage",1,"sp_altermessage System Stored Procedure")
INSERT INTO helpsql VALUES("sp_altermessage",2,"Alters the state of a sysmessages error.")
INSERT INTO helpsql VALUES("sp_altermessage",3," ")
INSERT INTO helpsql VALUES("sp_altermessage",4,"sp_altermessage <message_id>, WITH_LOG, {TRUE | FALSE}")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_bindefault",1,"sp_bindefault System Stored Procedure")
INSERT INTO helpsql VALUES("sp_bindefault",2,"Binds a default to a column or to a user-defined datatype.")
INSERT INTO helpsql VALUES("sp_bindefault",3," ")
INSERT INTO helpsql VALUES("sp_bindefault",4,"sp_bindefault <defname>, <objname> [, FUTUREONLY]")
INSERT INTO helpsql VALUES("sp_bindrule",1,"sp_bindrule System Stored Procedure")
INSERT INTO helpsql VALUES("sp_bindrule",2,"Binds a rule to a column or to a user-defined datatype.")
INSERT INTO helpsql VALUES("sp_bindrule",3," ")
INSERT INTO helpsql VALUES("sp_bindrule",4,"sp_bindrule <rulename>, <objname> [, FUTUREONLY]")
INSERT INTO helpsql VALUES("sp_certify_removable",1,"sp_certify_removable System Stored Procedure")
INSERT INTO helpsql VALUES("sp_certify_removable",2,"Verifies that a database is configured properly for distribution on ")
INSERT INTO helpsql VALUES("sp_certify_removable",3,"removable media. This procedure writes verification information to a ")
INSERT INTO helpsql VALUES("sp_certify_removable",4,"text file in the \LOG directory. The file is named according to the ")
INSERT INTO helpsql VALUES("sp_certify_removable",5,"following format:  CertifyR_[<dbname>].txt")
INSERT INTO helpsql VALUES("sp_certify_removable",6," ")
INSERT INTO helpsql VALUES("sp_certify_removable",7,"sp_certify_removable <dbname>[, AUTO]")
INSERT INTO helpsql VALUES("sp_changedbowner",1,"sp_changedbowner System Stored Procedure")
INSERT INTO helpsql VALUES("sp_changedbowner",2,"Changes the owner of a database.")
INSERT INTO helpsql VALUES("sp_changedbowner",3," ")
INSERT INTO helpsql VALUES("sp_changedbowner",4,"sp_changedbowner <login_ID> [, TRUE]")
INSERT INTO helpsql VALUES("sp_changegroup",1,"sp_changegroup System Stored Procedure")
INSERT INTO helpsql VALUES("sp_changegroup",2,"Changes a user's group.")
INSERT INTO helpsql VALUES("sp_changegroup",3," ")
INSERT INTO helpsql VALUES("sp_changegroup",4,"sp_changegroup <grpname>, <username>")
INSERT INTO helpsql VALUES("sp_change_users_logins",1,"sp_change_users_logins System Stored Procedure")
INSERT INTO helpsql VALUES("sp_change_users_logins",2,"Reestablishes foreign key relationships from the syslogins to sysusers ")
INSERT INTO helpsql VALUES("sp_change_users_logins",3,"and sysalternates tables in cases where cross-server DUMP or LOAD ")
INSERT INTO helpsql VALUES("sp_change_users_logins",4,"database activity has broken these relationships. Without reestablishing ")
INSERT INTO helpsql VALUES("sp_change_users_logins",5,"relationships, orphan users may exist. It is suggested that you use this ")
INSERT INTO helpsql VALUES("sp_change_users_logins",6,"stored procedure after running the LOAD DATABASE statement because ")
INSERT INTO helpsql VALUES("sp_change_users_logins",7,"sp_change_users_login eliminates the need for manual updates for aliases or ")
INSERT INTO helpsql VALUES("sp_change_users_logins",8,"alternate usernames.")
INSERT INTO helpsql VALUES("sp_change_users_logins",9," ")
INSERT INTO helpsql VALUES("sp_change_users_logins",10,"sp_change_users_login {Auto_Fix | Report | Update_One} [,<usernameorpattern> ")
INSERT INTO helpsql VALUES("sp_change_users_logins",11,"	[,<loginname>]]")
INSERT INTO helpsql VALUES("sp_configure",1,"sp_configure System Stored Procedure")
INSERT INTO helpsql VALUES("sp_configure",2,"Displays or changes configuration options. The following options can be modified using ")
INSERT INTO helpsql VALUES("sp_configure",3,"using sp_configure.")
INSERT INTO helpsql VALUES("sp_configure",4,"	affinity mask		[0-2147483647]		allow updates 		[0-1] ")	
INSERT INTO helpsql VALUES("sp_configure",5,"	backup buffer size   	[1-10]			backup threads 		[0-32]")
INSERT INTO helpsql VALUES("sp_configure",6,"	cursor threshold    	[-1-2147483647]		database size 		[2-10000]")
INSERT INTO helpsql VALUES("sp_configure",7,"	default language     	[0-9999]		default sortorder id 	[0-255]")
INSERT INTO helpsql VALUES("sp_configure",8,"	fill factor   		[[0-100]		free buffers 		[20-524288]")
INSERT INTO helpsql VALUES("sp_configure",9,"	hash buckets    	[4999-265003]		language in cache 	[3-100]")
INSERT INTO helpsql VALUES("sp_configure",10,"	LE threshold maximum    [2-500000]		LE threshold minimum 	[2-500000]")
INSERT INTO helpsql VALUES("sp_configure",11,"	LE threshold percent    [1-100]			locks 			[5000-2147483647]")
INSERT INTO helpsql VALUES("sp_configure",12,"	logwrite sleep (ms)    	[-1-500]		max async IO 		[1-255]")
INSERT INTO helpsql VALUES("sp_configure",13,"	max laywrite IO    	[1-255]			max text repl size	[0-2147483647]")
INSERT INTO helpsql VALUES("sp_configure",14,"	max worker threads 	[10-1024]		media retention    	[0-365]")
INSERT INTO helpsql VALUES("sp_configure",15,"	memory 			[1000-1048576]		nested triggers    	[0-1]	")		
INSERT INTO helpsql VALUES("sp_configure",16,"	network packet size 	[512-32767]		open databases     	[5-32767]")
INSERT INTO helpsql VALUES("sp_configure",17,"	open objects 		[100-2147483647] 	priority boost		[0-1] ")
INSERT INTO helpsql VALUES("sp_configure",18,"	procedure cache 	[1-99]			RA cache hit limit    	[1-255]		")
INSERT INTO helpsql VALUES("sp_configure",19,"	RA cache miss limit	[1-255] 		RA delay		[0-500]	 ")		
INSERT INTO helpsql VALUES("sp_configure",20,"	RA pre-fetches   	[1-1000]		RA slots per thread 	[1-255]	 ")		
INSERT INTO helpsql VALUES("sp_configure",21,"	RA worker threads   	[0-255]			recovery flags 		[0-1]			 ")  		
INSERT INTO helpsql VALUES("sp_configure",22,"	recovery interval  	[1-32767]		remote access 		[[0-1]		 ")		
INSERT INTO helpsql VALUES("sp_configure",23,"	remote conn timeout    	[-1-32767]		remote login timeout 	[0-2147483647]	 ")		
INSERT INTO helpsql VALUES("sp_configure",24,"	remote proc trans   	[0-1]			remote query timeout 	[0-2147483647]	 ")		
INSERT INTO helpsql VALUES("sp_configure",25,"	remote sites		[0-256]			resource timeout		[5-2147483647]	")	
INSERT INTO helpsql VALUES("sp_configure",26,"	set working set size  	[0-1]   		show advanced options 	[0-1]	 ")
INSERT INTO helpsql VALUES("sp_configure",27,"	SMP concurrency    	[-1-64]			sort pages 		[64-611]") 			
INSERT INTO helpsql VALUES("sp_configure",28,"	spin counter 		[1-2147483647]  	tempdb in ram(MB)  	[0-2044] ")
INSERT INTO helpsql VALUES("sp_configure",29,"	time slice    		[50-1000]		user connections	[5-32767] ")
INSERT INTO helpsql VALUES("sp_configure",30,"	user options		[0-4095]")
INSERT INTO helpsql VALUES("sp_configure",31,"	")
INSERT INTO helpsql VALUES("sp_configure",32,"sp_configure ['<config_name>' [, <config_value>]]")
INSERT INTO helpsql VALUES("sp_coalesce_fragments",1,"sp_coalesce_fragments System Stored Procedure")
INSERT INTO helpsql VALUES("sp_coalesce_fragments",2,"Deletes and updates rows in the sysusages system table and merges contiguous ")
INSERT INTO helpsql VALUES("sp_coalesce_fragments",3,"fragments from the same segment and database.")
INSERT INTO helpsql VALUES("sp_coalesce_fragments",4," ")
INSERT INTO helpsql VALUES("sp_coalesce_fragments",5,"sp_coalesce_fragments ")
INSERT INTO helpsql VALUES("sp_create_removable",1,"sp_create_removable System Stored Procedure")
INSERT INTO helpsql VALUES("sp_create_removable",2,"Creates a removable media database. ")
INSERT INTO helpsql VALUES("sp_create_removable",3," ")
INSERT INTO helpsql VALUES("sp_create_removable",4,"sp_create_removable <dbname>, <syslogical>, '<sysphysical>', <syssize>, ")
INSERT INTO helpsql VALUES("sp_create_removable",5,"     <loglogical>, '<logphysical>', <logsize>, <datalogical1>, ")
INSERT INTO helpsql VALUES("sp_create_removable",6,"     '<dataphysical1>', <datasize1> [... , <datalogical16>, ")
INSERT INTO helpsql VALUES("sp_create_removable",7,"     '<dataphysical16>', <datasize16>]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_dbinstall",1,"sp_dbinstall System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dbinstall",2,"Installs a database and its devices.")
INSERT INTO helpsql VALUES("sp_dbinstall",3," ")
INSERT INTO helpsql VALUES("sp_dbinstall",4,"sp_dbinstall <database>, <logical_dev_name>, '<physical_dev_name>', ")
INSERT INTO helpsql VALUES("sp_dbinstall",5,"     <size>, '<devtype>' [,'<location>'] ")
INSERT INTO helpsql VALUES("sp_dboption",1,"sp_dboption System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dboption",2,"Displays or changes database options.")
INSERT INTO helpsql VALUES("sp_dboption",3," ")
INSERT INTO helpsql VALUES("sp_dboption",4,"sp_dboption [<dbname>, '<optname>'] [,{TRUE | FALSE}]")
INSERT INTO helpsql VALUES("sp_dbremove",1,"sp_dbremove System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dbremove",2,"Used to remove an installed database, and optionally, any devices to ")
INSERT INTO helpsql VALUES("sp_dbremove",3,"which it has exclusive use. ")
INSERT INTO helpsql VALUES("sp_dbremove",4," ")
INSERT INTO helpsql VALUES("sp_dbremove",5,"sp_dbremove <database>[, dropdev]")
INSERT INTO helpsql VALUES("sp_defaultdb",1,"sp_defaultdb System Stored Procedure")
INSERT INTO helpsql VALUES("sp_defaultdb",2,"Changes a user's default database.")
INSERT INTO helpsql VALUES("sp_defaultdb",3," ")
INSERT INTO helpsql VALUES("sp_defaultdb",4,"sp_defaultdb <login_ID>, <defdb>")
INSERT INTO helpsql VALUES("sp_defaultlanguage",1,"sp_defaultlanguage System Stored Procedure")
INSERT INTO helpsql VALUES("sp_defaultlanguage",2,"Changes a user's default language.")
INSERT INTO helpsql VALUES("sp_defaultlanguage",3," ")
INSERT INTO helpsql VALUES("sp_defaultlanguage",4,"sp_defaultlanguage <login_ID> [, <language>]")
INSERT INTO helpsql VALUES("sp_depends",1,"sp_depends System Stored Procedure")
INSERT INTO helpsql VALUES("sp_depends",2,"Displays information about database object dependencies - the views and ")
INSERT INTO helpsql VALUES("sp_depends",3,"procedures that depend on the specified table or view, and the tables ")
INSERT INTO helpsql VALUES("sp_depends",4,"and views that are depended on by the specified view or procedure.")
INSERT INTO helpsql VALUES("sp_depends",5," ")
INSERT INTO helpsql VALUES("sp_depends",6,"sp_depends <objname>")
INSERT INTO helpsql VALUES("sp_devoption",1,"sp_devoption System Stored Procedure")
INSERT INTO helpsql VALUES("sp_devoption",2,"Displays or sets device status. Although primarily used on removable ")
INSERT INTO helpsql VALUES("sp_devoption",3,"media devices, this procedure can be used for all devices. ")
INSERT INTO helpsql VALUES("sp_devoption",4," ")
INSERT INTO helpsql VALUES("sp_devoption",5,"sp_devoption [<devicename> [, <optname> {, TRUE | FALSE} [, OVERRIDE]]]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_diskdefault",1,"sp_diskdefault System Stored Procedure")
INSERT INTO helpsql VALUES("sp_diskdefault",2,"Sets a database device's status to indicate whether the device can be ")
INSERT INTO helpsql VALUES("sp_diskdefault",3,"used for database storage when the user does not specify a database ")
INSERT INTO helpsql VALUES("sp_diskdefault",4,"device or specifies DEFAULT with the CREATE DATABASE or ALTER DATABASE ")
INSERT INTO helpsql VALUES("sp_diskdefault",5,"statements.")
INSERT INTO helpsql VALUES("sp_diskdefault",6," ")
INSERT INTO helpsql VALUES("sp_diskdefault",7,"sp_diskdefault <database_device>, {defaulton | defaultoff}")
INSERT INTO helpsql VALUES("sp_dropalias",1,"sp_dropalias System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropalias",2,"Removes the alias login ID identity that had been established by ")
INSERT INTO helpsql VALUES("sp_dropalias",3,"sp_addalias. ")
INSERT INTO helpsql VALUES("sp_dropalias",4," ")
INSERT INTO helpsql VALUES("sp_dropalias",5,"sp_dropalias <login_ID>")
INSERT INTO helpsql VALUES("sp_dropdevice",1,"sp_dropdevice System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropdevice",2,"Removes a SQL Server database device or dump device.")
INSERT INTO helpsql VALUES("sp_dropdevice",3," ")
INSERT INTO helpsql VALUES("sp_dropdevice",4,"sp_dropdevice <logical_name> [, DELFILE]")
INSERT INTO helpsql VALUES("sp_dropextendedproc",1,"sp_dropextendedproc System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropextendedproc",2,"Drops an extended stored procedure.")
INSERT INTO helpsql VALUES("sp_dropextendedproc",3," ")
INSERT INTO helpsql VALUES("sp_dropextendedproc",4,"sp_dropextendedproc <function_name>")
INSERT INTO helpsql VALUES("sp_dropgroup",1,"sp_dropgroup System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropgroup",2,"Removes a group from a database.")
INSERT INTO helpsql VALUES("sp_dropgroup",3," ")
INSERT INTO helpsql VALUES("sp_dropgroup",4,"sp_dropgroup <grpname>")
INSERT INTO helpsql VALUES("sp_droplanguage",1,"sp_droplanguage System Stored Procedure")
INSERT INTO helpsql VALUES("sp_droplanguage",2,"Drops an alternate language from the server and removes its row from ")
INSERT INTO helpsql VALUES("sp_droplanguage",3,"master.dbo.syslogins.")
INSERT INTO helpsql VALUES("sp_droplanguage",4," ")
INSERT INTO helpsql VALUES("sp_droplanguage",5,"sp_droplanguage <language> [, dropmessages]")
INSERT INTO helpsql VALUES("sp_droplogin",1,"sp_droplogin System Stored Procedure")
INSERT INTO helpsql VALUES("sp_droplogin",2,"Removes a SQL Server login ID by deleting the user's entry in ")
INSERT INTO helpsql VALUES("sp_droplogin",3,"master.dbo.syslogins.")
INSERT INTO helpsql VALUES("sp_droplogin",4," ")
INSERT INTO helpsql VALUES("sp_droplogin",5,"sp_droplogin <login_ID>")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_dropmessage",1,"sp_dropmessage System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropmessage",2,"Drops a specified error message from the sysmessages system table.")
INSERT INTO helpsql VALUES("sp_dropmessage",3," ")
INSERT INTO helpsql VALUES("sp_dropmessage",4,"sp_dropmessage <msg_id>, [<language> | 'ALL' ]")
INSERT INTO helpsql VALUES("sp_dropremotelogin",1,"sp_dropremotelogin System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropremotelogin",2,"Removes a remote user login.")
INSERT INTO helpsql VALUES("sp_dropremotelogin",3," ")
INSERT INTO helpsql VALUES("sp_dropremotelogin",4,"sp_dropremotelogin <remoteserver> [, <loginame> [, <remotename>]] ")
INSERT INTO helpsql VALUES("sp_dropsegment",1,"sp_dropsegment System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropsegment",2,"Drops a segment from a database or unmaps a segment from a database device.")
INSERT INTO helpsql VALUES("sp_dropsegment",3," ")
INSERT INTO helpsql VALUES("sp_dropsegment",4,"sp_dropsegment <segname> [, <logical_name>]")
INSERT INTO helpsql VALUES("sp_dropserver",1,"sp_dropserver System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropserver",2,"Drops a server from the list of known servers, deleting the entry from ")
INSERT INTO helpsql VALUES("sp_dropserver",3,"the master.dbo.sysservers table.")
INSERT INTO helpsql VALUES("sp_dropserver",4," ")
INSERT INTO helpsql VALUES("sp_dropserver",5,"sp_dropserver <server_name> [, droplogins]")
INSERT INTO helpsql VALUES("sp_droptype",1,"sp_droptype System Stored Procedure")
INSERT INTO helpsql VALUES("sp_droptype",2,"Deletes a user-defined datatype from systypes.")
INSERT INTO helpsql VALUES("sp_droptype",3," ")
INSERT INTO helpsql VALUES("sp_droptype",4,"sp_droptype <typename>")
INSERT INTO helpsql VALUES("sp_dropuser",1,"sp_dropuser System Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropuser",2,"Removes a user from the current database by deleting the entry from the ")
INSERT INTO helpsql VALUES("sp_dropuser",3,"current database's sysusers table.")
INSERT INTO helpsql VALUES("sp_dropuser",4," ")
INSERT INTO helpsql VALUES("sp_dropuser",5,"sp_dropuser <username>")
INSERT INTO helpsql VALUES("sp_extendsegment",1,"sp_extendsegment System Stored Procedure")
INSERT INTO helpsql VALUES("sp_extendsegment",2,"Extends the range of a segment to another database device.")
INSERT INTO helpsql VALUES("sp_extendsegment",3," ")
INSERT INTO helpsql VALUES("sp_extendsegment",4,"sp_extendsegment <segname>, <logical_name>")
INSERT INTO helpsql VALUES("sp_fallback_activate_svr_db",1,"sp_fallback_activate_svr_db System Stored Procedure ")
INSERT INTO helpsql VALUES("sp_fallback_activate_svr_db",2,"Activates fallback support for the specified fallback ")
INSERT INTO helpsql VALUES("sp_fallback_activate_svr_db",3,"enrolled databases for a primary server. ")
INSERT INTO helpsql VALUES("sp_fallback_activate_svr_db",4,"  ")
INSERT INTO helpsql VALUES("sp_fallback_activate_svr_db",5,"sp_fallback_activate_svr_db [<primary_svr_name>] [, <database>] ")
INSERT INTO helpsql VALUES("sp_fallback_deactivate_svr_db",1,"sp_fallback_deactivate_svr_db System Stored Procedure ")
INSERT INTO helpsql VALUES("sp_fallback_deactivate_svr_db",2,"Deactivates fallback suppport for the specified ")
INSERT INTO helpsql VALUES("sp_fallback_deactivate_svr_db",3,"activated databases on a primary server. Deactivation ")
INSERT INTO helpsql VALUES("sp_fallback_deactivate_svr_db",4,"leaves the databases enrolled.")
INSERT INTO helpsql VALUES("sp_fallback_deactivate_svr_db",5," ")
INSERT INTO helpsql VALUES("sp_fallback_deactivate_svr_db",6,"sp_fallback_deactivate_svr_db [<primary_server_name>] [,<database>]")
INSERT INTO helpsql VALUES("sp_fallback_enroll_svr_db",1,"sp_fallback_enroll_svr_db System Stored Procedure")
INSERT INTO helpsql VALUES("sp_fallback_enroll_svr_db",2,"Enrolls a primary server's database into the staging tables of a fallback ")
INSERT INTO helpsql VALUES("sp_fallback_enroll_svr_db",3,"server, which prepares the server for future fallback support activation.")
INSERT INTO helpsql VALUES("sp_fallback_enroll_svr_db",4," ")
INSERT INTO helpsql VALUES("sp_fallback_enroll_svr_db",5,"sp_fallback_enroll_svr_db {<fallback_svr_name>, <database>}")
INSERT INTO helpsql VALUES("sp_fallback_help",1,"sp_fallback_help System Stored Procedure")
INSERT INTO helpsql VALUES("sp_fallback_help",2,"Reports about enrollments and activations for fallback support and provides  ")
INSERT INTO helpsql VALUES("sp_fallback_help",3,"integrity checking.")
INSERT INTO helpsql VALUES("sp_fallback_help",4," ")
INSERT INTO helpsql VALUES("sp_fallback_help",5,"sp_fallback_help [<primary_svr_name>]")
INSERT INTO helpsql VALUES("sp_fallback_permanent_svr",1,"sp_fallback_permanent_svr System Stored Procedure")
INSERT INTO helpsql VALUES("sp_fallback_permanent_svr",2,"Establishes the local fallback support server as the sole owner of")
INSERT INTO helpsql VALUES("sp_fallback_permanent_svr",3,"the active databases for an obsolete primary server.")
INSERT INTO helpsql VALUES("sp_fallback_permanent_svr",4," ")
INSERT INTO helpsql VALUES("sp_fallback_permanent_svr",5,"sp_fallback_permanent_svr {'<primary_server_name>',1}")
INSERT INTO helpsql VALUES("sp_fallback_upd_dev_drive",1,"sp_fallback_upd_dev_drive System Stored Procedure")
INSERT INTO helpsql VALUES("sp_fallback_upd_dev_drive",2,"Creates cross references to the drive letters used by the primary and ")
INSERT INTO helpsql VALUES("sp_fallback_upd_dev_drive",3,"fallback support servers so both servers refer to the same physical drive.")
INSERT INTO helpsql VALUES("sp_fallback_upd_dev_drive",4," ")
INSERT INTO helpsql VALUES("sp_fallback_upd_dev_drive",5,"sp_fallback_upd_dev_drive {'<primary_server_name>', '<primary_drive>', '<fallback_drive>'}")
INSERT INTO helpsql VALUES("sp_fallback_withdraw_svr_db",1,"sp_fallback_withdraw_svr_db System Stored Procedure")
INSERT INTO helpsql VALUES("sp_fallback_withdraw_svr_db",2,"Erases the enrollment of inactive databases for a primary server. ")
INSERT INTO helpsql VALUES("sp_fallback_withdraw_svr_db",3," ")
INSERT INTO helpsql VALUES("sp_fallback_withdraw_svr_db",4,"sp_fallback_withdraw_svr_db {'<primary_server_name>' [,<database>]}")

INSERT INTO helpsql VALUES("sp_getbindtoken",1,"sp_getbindtoken System Stored Procedure")
INSERT INTO helpsql VALUES("sp_getbindtoken",2,"Creates a bound connection context and returns a unique ")
INSERT INTO helpsql VALUES("sp_getbindtoken",3,"identifier for the created context. This unique identifier ")
INSERT INTO helpsql VALUES("sp_getbindtoken",4,"is referred to as a bind token. This system stored procedure ")
INSERT INTO helpsql VALUES("sp_getbindtoken",5,"returns a string representation to use as a token for a  ")
INSERT INTO helpsql VALUES("sp_getbindtoken",6,"shared transaction between two clients. ")
INSERT INTO helpsql VALUES("sp_getbindtoken",3," ")
INSERT INTO helpsql VALUES("sp_getbindtoken",6,"sp_getbindtoken <return_value> OUTPUT [,@<for_xp_flag>]")
INSERT INTO helpsql VALUES("sp_helplogins",1,"sp_helplogins System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helplogins",2,"Provides informaton about current logins and associated users. ")
INSERT INTO helpsql VALUES("sp_helplogins",3," ")
INSERT INTO helpsql VALUES("sp_helplogins",4,"sp_helplogins [<login_name>]")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_help",1,"sp_help System Stored Procedure")
INSERT INTO helpsql VALUES("sp_help",2,"Reports information about a database object (any object listed in the ")
INSERT INTO helpsql VALUES("sp_help",3,"sysobjects table) or about a SQL Server - supplied or user-defined ")
INSERT INTO helpsql VALUES("sp_help",4,"datatype.")
INSERT INTO helpsql VALUES("sp_help",5," ")
INSERT INTO helpsql VALUES("sp_help",6,"sp_help [<objname>]")
INSERT INTO helpsql VALUES("sp_helpconstraint",1,"sp_helpconstraint System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpconstraint",2,"Returns a list of all constraint types, their user-defined or system- ")
INSERT INTO helpsql VALUES("sp_helpconstraint",3,"supplied name, and the columns on which they have been defined.")
INSERT INTO helpsql VALUES("sp_helpconstraint",4," ")
INSERT INTO helpsql VALUES("sp_helpconstraint",5,"sp_helpconstraint <table_name>")
INSERT INTO helpsql VALUES("sp_helpdb",1,"sp_helpdb System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpdb",2,"Reports information about a specified database or all databases.")
INSERT INTO helpsql VALUES("sp_helpdb",3," ")
INSERT INTO helpsql VALUES("sp_helpdb",4,"sp_helpdb [<dbname>]")
INSERT INTO helpsql VALUES("sp_helpdevice",1,"sp_helpdevice System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpdevice",2,"Reports information about SQL Server database devices and dump devices.")
INSERT INTO helpsql VALUES("sp_helpdevice",3," ")
INSERT INTO helpsql VALUES("sp_helpdevice",4,"sp_helpdevice [<logical_name>]")
INSERT INTO helpsql VALUES("sp_helpextendedproc",1,"sp_helpextendedproc System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpextendedproc",2,"Displays the currently defined extended stored procedures and the name ")
INSERT INTO helpsql VALUES("sp_helpextendedproc",3,"of the dynamic-link library to which the function belongs.")
INSERT INTO helpsql VALUES("sp_helpextendedproc",4," ")
INSERT INTO helpsql VALUES("sp_helpextendedproc",5,"sp_helpextendedproc [<function_name>]")
INSERT INTO helpsql VALUES("sp_helpgroup",1,"sp_helpgroup System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpgroup",2,"Reports information about a group or all groups in the current database.")
INSERT INTO helpsql VALUES("sp_helpgroup",3," ")
INSERT INTO helpsql VALUES("sp_helpgroup",4,"sp_helpgroup [<grpname>]")
INSERT INTO helpsql VALUES("sp_helpindex",1,"sp_helpindex System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpindex",2,"Reports information about the indexes on a table.")
INSERT INTO helpsql VALUES("sp_helpindex",3," ")
INSERT INTO helpsql VALUES("sp_helpindex",4,"sp_helpindex <tabname>")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_helplanguage",1,"sp_helplanguage System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helplanguage",2,"Reports information about a particular alternate language or about all ")
INSERT INTO helpsql VALUES("sp_helplanguage",3,"languages.")
INSERT INTO helpsql VALUES("sp_helplanguage",4," ")
INSERT INTO helpsql VALUES("sp_helplanguage",5,"sp_helplanguage [<language>]")
INSERT INTO helpsql VALUES("sp_helplog",1,"sp_helplog System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helplog",2,"Reports the name of the device that contains the first page of the log ")
INSERT INTO helpsql VALUES("sp_helplog",3,"in the current database.")
INSERT INTO helpsql VALUES("sp_helplog",4," ")
INSERT INTO helpsql VALUES("sp_helplog",5,"sp_helplog ")
INSERT INTO helpsql VALUES("sp_helpremotelogin",1,"sp_helpremotelogin System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpremotelogin",2,"Reports information about a particular remote server's logins or about ")
INSERT INTO helpsql VALUES("sp_helpremotelogin",3,"all remote servers' logins.")
INSERT INTO helpsql VALUES("sp_helpremotelogin",4," ")
INSERT INTO helpsql VALUES("sp_helpremotelogin",5,"sp_helpremotelogin [<remoteserver> [, <remotename>]]")
INSERT INTO helpsql VALUES("sp_helprotect",1,"sp_helprotect System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helprotect",2,"Reports permissions by database object for specific grantee, grantor or  ")
INSERT INTO helpsql VALUES("sp_helprotect",3,"permissions.")
INSERT INTO helpsql VALUES("sp_helprotect",4," ")
INSERT INTO helpsql VALUES("sp_helprotect",5,"sp_helprotect [<object_or_statement_name> [, <grantee_name> [, <grantor_name> ")
INSERT INTO helpsql VALUES("sp_helprotect",6,"		[, <permissions]]]]")
INSERT INTO helpsql VALUES("sp_helpsegment",1,"sp_helpsegment System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpsegment",2,"Reports information about a particular segment or about all segments in ")
INSERT INTO helpsql VALUES("sp_helpsegment",3,"the current database.")
INSERT INTO helpsql VALUES("sp_helpsegment",4," ")
INSERT INTO helpsql VALUES("sp_helpsegment",5,"sp_helpsegment [<segname>]")
INSERT INTO helpsql VALUES("sp_helpserver",1,"sp_helpserver System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpserver",2,"Provides the server name, the server's network name, the server's replication ")
INSERT INTO helpsql VALUES("sp_helpserver",3,"status, and the server's identification number.  ")
INSERT INTO helpsql VALUES("sp_helpserver",4," ")
INSERT INTO helpsql VALUES("sp_helpserver",5,"sp_helpserver [<server_name>]")
INSERT INTO helpsql VALUES("sp_helpsort",1,"sp_helpsort System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpsort",2,"Displays the SQL Server default sort order and character set.")
INSERT INTO helpsql VALUES("sp_helpsort",3," ")
INSERT INTO helpsql VALUES("sp_helpsort",4,"sp_helpsort")
INSERT INTO helpsql VALUES("sp_helpsql",1,"sp_helpsql System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpsql",2,"Provides syntax for Transact-SQL statements, system procedures, ")
INSERT INTO helpsql VALUES("sp_helpsql",3,"and other special topics.")
INSERT INTO helpsql VALUES("sp_helpsql",4," ")
INSERT INTO helpsql VALUES("sp_helpsql",5,"sp_helpsql ['<topic>']")
INSERT INTO helpsql VALUES("sp_helprevdatabase",1,"sp_helprevdatabase System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helprevdatabase",2,"Analyzes an existing database and creates a script that can ")
INSERT INTO helpsql VALUES("sp_helprevdatabase",3,"be used to replicate the database structure on another server.")
INSERT INTO helpsql VALUES("sp_helprevdatabase",4,"  ")
INSERT INTO helpsql VALUES("sp_helprevdatabase",5,"sp_helprevdatabase [<database>] ")
go
DUMP TRANSACTION master WITH NO_LOG
go

INSERT INTO helpsql VALUES("sp_helpstartup",1,"sp_helpstartup System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpstartup",2,"Reports a listing of all auto-start stored procedures.")
INSERT INTO helpsql VALUES("sp_helpstartup",3," ")
INSERT INTO helpsql VALUES("sp_helpstartup",4,"sp_helpstartup")
INSERT INTO helpsql VALUES("sp_helptext",1,"sp_helptext System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helptext",2,"Prints the text of a rule, a default, or an unencrypted stored ")
INSERT INTO helpsql VALUES("sp_helptext",3,"procedure, trigger, or view.")
INSERT INTO helpsql VALUES("sp_helptext",4," ")
INSERT INTO helpsql VALUES("sp_helptext",5,"sp_helptext <objname>")
INSERT INTO helpsql VALUES("sp_helpuser",1,"sp_helpuser System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helpuser",2,"Reports information about the users of a database.")
INSERT INTO helpsql VALUES("sp_helpuser",3," ")
INSERT INTO helpsql VALUES("sp_helpuser",4,"sp_helpuser [<username>]")
INSERT INTO helpsql VALUES("sp_helplock",1,"sp_lock System Stored Procedure")
INSERT INTO helpsql VALUES("sp_helplock",2,"Reports information about locks.")
INSERT INTO helpsql VALUES("sp_helplock",3," ")
INSERT INTO helpsql VALUES("sp_helplock",4,"sp_lock [<spid1> [, <spid2>]]")
INSERT INTO helpsql VALUES("sp_logdevice",1,"sp_logdevice System Stored Procedure")
INSERT INTO helpsql VALUES("sp_logdevice",2,"Puts the syslogs system table, which contains the transaction log, on a ")
INSERT INTO helpsql VALUES("sp_logdevice",3,"separate database device.")
INSERT INTO helpsql VALUES("sp_logdevice",4," ")
INSERT INTO helpsql VALUES("sp_logdevice",5,"sp_logdevice <dbname>, <database_device>")
INSERT INTO helpsql VALUES("sp_makestartup",1,"sp_makestartup System Stored Procedure")
INSERT INTO helpsql VALUES("sp_makestartup",2,"Sets a stored procedure for auto execution. Auto execution stored ")
INSERT INTO helpsql VALUES("sp_makestartup",3,"procedures are executed every time the server is started.")
INSERT INTO helpsql VALUES("sp_makestartup",4," ")
INSERT INTO helpsql VALUES("sp_makestartup",5,"sp_makestartup <procedure_name>")
INSERT INTO helpsql VALUES("sp_monitor",1,"sp_monitor System Stored Procedure")
INSERT INTO helpsql VALUES("sp_monitor",2,"Displays statistics about SQL Server.")
INSERT INTO helpsql VALUES("sp_monitor",3," ")
INSERT INTO helpsql VALUES("sp_monitor",4,"sp_monitor")
INSERT INTO helpsql VALUES("sp_password",1,"sp_password System Stored Procedure")
INSERT INTO helpsql VALUES("sp_password",2,"Adds or changes a password for a SQL Server login ID.")
INSERT INTO helpsql VALUES("sp_password",3," ")
INSERT INTO helpsql VALUES("sp_password",4,"sp_password <old>, <new> [, <login_ID>]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("sp_placeobject",1,"sp_placeobject System Stored Procedure")
INSERT INTO helpsql VALUES("sp_placeobject",2,"Puts future space allocations for a table or index on a particular ")
INSERT INTO helpsql VALUES("sp_placeobject",3,"segment.")
INSERT INTO helpsql VALUES("sp_placeobject",4," ")
INSERT INTO helpsql VALUES("sp_placeobject",5,"sp_placeobject <segname>, <objname>")
INSERT INTO helpsql VALUES("sp_processmail",1,"sp_processmail System Stored Procedure")
INSERT INTO helpsql VALUES("sp_processmail",2,"Uses extended stored procedures (xp_findnextmsg, xp_readmail, and ")
INSERT INTO helpsql VALUES("sp_processmail",3,"xp_deletemail) to process incoming mail messages (expected to be only a ")
INSERT INTO helpsql VALUES("sp_processmail",4,"single query) from the inbox for SQL Server. It uses the xp_sendmail ")
INSERT INTO helpsql VALUES("sp_processmail",5,"extended stored procedure to return the results set back to the message ")
INSERT INTO helpsql VALUES("sp_processmail",6,"sender.")
INSERT INTO helpsql VALUES("sp_processmail",7," ")
INSERT INTO helpsql VALUES("sp_processmail",8,"sp_processmail [@subject = <subject>] [[,] @filetype = <filetype>] ")
INSERT INTO helpsql VALUES("sp_processmail",9,"     [[,] @separator = <separator>] [[,] @set_user = <user>] ")
INSERT INTO helpsql VALUES("sp_processmail",10,"     [[,] @dbuse = <dbname>]")
INSERT INTO helpsql VALUES("sp_recompile",1,"sp_recompile System Stored Procedure")
INSERT INTO helpsql VALUES("sp_recompile",2,"Causes each stored procedure and trigger that uses the specified table ")
INSERT INTO helpsql VALUES("sp_recompile",3,"to be recompiled the next time the stored procedure and triggers are ")
INSERT INTO helpsql VALUES("sp_recompile",4,"run.")
INSERT INTO helpsql VALUES("sp_recompile",5," ")
INSERT INTO helpsql VALUES("sp_recompile",6,"sp_recompile <tabname>")
INSERT INTO helpsql VALUES("sp_remoteoption",1,"sp_remoteoption System Stored Procedure")
INSERT INTO helpsql VALUES("sp_remoteoption",2,"Displays or changes remote login options.")
INSERT INTO helpsql VALUES("sp_remoteoption",3," ")
INSERT INTO helpsql VALUES("sp_remoteoption",4,"sp_remoteoption [<remoteserver>, <loginame>, <remotename>, ")
INSERT INTO helpsql VALUES("sp_remoteoption",5,"     <optname>, {TRUE | FALSE}]")
INSERT INTO helpsql VALUES("sp_rename",1,"sp_rename System Stored Procedure")
INSERT INTO helpsql VALUES("sp_rename",2,"Changes the name of a user-created object in the current database.")
INSERT INTO helpsql VALUES("sp_rename",3," ")
INSERT INTO helpsql VALUES("sp_rename",4,"sp_rename <objname>, <newname> [, COLUMN | INDEX ]")
INSERT INTO helpsql VALUES("sp_renamedb",1,"sp_renamedb System Stored Procedure")
INSERT INTO helpsql VALUES("sp_renamedb",2,"Changes the name of a database.")
INSERT INTO helpsql VALUES("sp_renamedb",3," ")
INSERT INTO helpsql VALUES("sp_renamedb",4,"sp_renamedb <oldname>, <newname>")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("sp_serveroption",1,"sp_serveroption System Stored Procedure")
INSERT INTO helpsql VALUES("sp_serveroption",2,"Sets server options.")
INSERT INTO helpsql VALUES("sp_serveroption",3," ")
INSERT INTO helpsql VALUES("sp_serveroption",4,"sp_serveroption [<server_name>, <optname>, {TRUE | FALSE}]")
INSERT INTO helpsql VALUES("sp_setlangalias",1,"sp_setlangalias System Stored Procedure")
INSERT INTO helpsql VALUES("sp_setlangalias",2,"Assigns or changes the alias for an alternate language.")
INSERT INTO helpsql VALUES("sp_setlangalias",3," ")
INSERT INTO helpsql VALUES("sp_setlangalias",4,"sp_setlangalias <language>, <alias>")
INSERT INTO helpsql VALUES("sp_spaceused",1,"sp_spaceused System Stored Procedure")
INSERT INTO helpsql VALUES("sp_spaceused",2,"Displays the number of rows, the disk space reserved, and the disk space ")
INSERT INTO helpsql VALUES("sp_spaceused",3,"used by a table in a database, or displaces the disk space reserved and ")
INSERT INTO helpsql VALUES("sp_spaceused",4,"used by an entire database.")
INSERT INTO helpsql VALUES("sp_spaceused",5," ")
INSERT INTO helpsql VALUES("sp_spaceused",6,"sp_spaceused [<objname>] [[,] @updateusage = {TRUE | FALSE}]")
INSERT INTO helpsql VALUES("sp_unbindefault",1,"sp_unbindefault System Stored Procedure")
INSERT INTO helpsql VALUES("sp_unbindefault",2,"Unbinds (removes) a default from a column or from a user-defined ")
INSERT INTO helpsql VALUES("sp_unbindefault",3,"datatype in the current database.")
INSERT INTO helpsql VALUES("sp_unbindefault",4," ")
INSERT INTO helpsql VALUES("sp_unbindefault",5,"sp_unbindefault <objname> [, FUTUREONLY]")
INSERT INTO helpsql VALUES("sp_unbindrule",1,"sp_unbindrule System Stored Procedure")
INSERT INTO helpsql VALUES("sp_unbindrule",2,"Unbinds a rule from a column or a user-defined datatype in the current ")
INSERT INTO helpsql VALUES("sp_unbindrule",3,"database.")
INSERT INTO helpsql VALUES("sp_unbindrule",4," ")
INSERT INTO helpsql VALUES("sp_unbindrule",5,"sp_unbindrule <objname> [, FUTUREONLY]")
INSERT INTO helpsql VALUES("sp_unmakestartup",1,"sp_unmakestartup System Stored Procedure")
INSERT INTO helpsql VALUES("sp_unmakestartup",2,"Discontinues auto execution of the stored procedure.")
INSERT INTO helpsql VALUES("sp_unmakestartup",3," ")
INSERT INTO helpsql VALUES("sp_unmakestartup",4,"sp_unmakestartup <procedure_name>")
INSERT INTO helpsql VALUES("sp_who",1,"sp_who System Stored Procedure")
INSERT INTO helpsql VALUES("sp_who",2,"Provides information about current SQL Server users and processes. The information returned")
INSERT INTO helpsql VALUES("sp_who",3,"can be filtered to return only those processes that are not idle.")
INSERT INTO helpsql VALUES("sp_who",4," ")
INSERT INTO helpsql VALUES("sp_who",5,"sp_who [<login_name> | '<spid>' | <active>]")
INSERT INTO helpsql VALUES("sp_dropwebtask",1,"sp_dropwebtask Stored Procedure")
INSERT INTO helpsql VALUES("sp_dropwebtask",2,"Deletes a previously defined web task. The task to be deleted is ")
INSERT INTO helpsql VALUES("sp_dropwebtask",3,"identified by the output filename, by the procedure name, or by both ")
INSERT INTO helpsql VALUES("sp_dropwebtask",4,"paramters.")
INSERT INTO helpsql VALUES("sp_dropwebtask",5," ")
INSERT INTO helpsql VALUES("sp_dropwebtask",6,"sp_dropwebtask {@<procname> = <procname> | @<outputfile> = <outputfile> |")
INSERT INTO helpsql VALUES("sp_dropwebtask",7,"@<procname> = <procname>, @<outputfile> = <outputfile>}")
INSERT INTO helpsql VALUES("sp_makewebtask",1,"sp_makewebtask System Stored Procedure")
INSERT INTO helpsql VALUES("sp_makewebtask",2,"Creates a task that produces an HTML document. The HTML document contains ")
INSERT INTO helpsql VALUES("sp_makewebtask",3,"data returned by executed queries.")
INSERT INTO helpsql VALUES("sp_makewebtask",4," ")
INSERT INTO helpsql VALUES("sp_makewebtask",5,"sp_makewebtask{@outputfile = '<outputfile>', @query = '<query>'}  ")
INSERT INTO helpsql VALUES("sp_makewebtask",6,"[, @fixedfont = <fixedfont>][, @bold = <bold>][, @italic = <italic>]  ")
INSERT INTO helpsql VALUES("sp_makewebtask",7,"[, @colheaders = <colheaders>][,@lastupdated = <lastupdated>]")
INSERT INTO helpsql VALUES("sp_makewebtask",8,"  [,@HTMLheader = <HTMLheader>][, @username = <username>]")
INSERT INTO helpsql VALUES("sp_makewebtask",9,"[,@dbname = <dbname>][,@templatefile = '<templatefile>'] ")
INSERT INTO helpsql VALUES("sp_makewebtask",10,"[, @webpagetitle = '<webpagetitle>'][, @resultstitle = '<resultstitle>']")
INSERT INTO helpsql VALUES("sp_makewebtask",11,"[,[@URL = '<URL>',@reftext = '<reftext>'] | [@table_urls = <table_urls>")
INSERT INTO helpsql VALUES("sp_makewebtask",12,",@url_query = '<url_query>']][,@whentype = <whentype>]  ")
INSERT INTO helpsql VALUES("sp_makewebtask",13,"[,@targetdate = <targetdate>][,@targettime = <targettime>]")
INSERT INTO helpsql VALUES("sp_makewebtask",14,"[,@dayflags = <dayflags>][, @numunits = <numunits>]")
INSERT INTO helpsql VALUES("sp_makewebtask",15,"[,@unittype = <unittype>][,@procname = <procname>] ")
INSERT INTO helpsql VALUES("sp_makewebtask",16,"[,@maketask = <maketask>][,@rowcount = <rowcnt>]    ")
INSERT INTO helpsql VALUES("sp_makewebtask",17," [,@taborder = <taborder>][,@singlerow = <singlerow>] ")
INSERT INTO helpsql VALUES("sp_makewebtask",18,"[,@blobfmt = <blobfmt>]")
INSERT INTO helpsql VALUES("sp_runwebtask",1,"sp_runwebtask System Stored Procedure")
INSERT INTO helpsql VALUES("sp_runwebtask",2,"Executes a previously defined Web task and generates the HTML document.")
INSERT INTO helpsql VALUES("sp_runwebtask",3,"The task to run is identified by the output filename, by the ")
INSERT INTO helpsql VALUES("sp_runwebtask",4,"procedure name, or by both parameters.")
INSERT INTO helpsql VALUES("sp_runwebtask",5,"  ")
INSERT INTO helpsql VALUES("sp_runwebtask",6,"sp_runwebtask {@procname = <procname> | @outputfile = <outputfile> | ")
INSERT INTO helpsql VALUES("sp_runwebtask",7," @procname = <procname>, @outputfile = <outputfile>}")
INSERT INTO helpsql VALUES("sp_rename",1,"sp_rename System Stored Procedure")
INSERT INTO helpsql VALUES("sp_rename",2,"Changes the name of a user-created object in the current database.")
INSERT INTO helpsql VALUES("sp_rename",3," ")
INSERT INTO helpsql VALUES("sp_rename",4,"sp_rename {<oldname>, <newname> [,COLUMN | INDEX | OBJECT | USERDATATYPE]}")
INSERT INTO helpsql VALUES("sp_setnetname",1,"sp_setnetname System Stored Procedure")
INSERT INTO helpsql VALUES("sp_setnetname",2,"Sets the network names in sysservers to their actual network ")
INSERT INTO helpsql VALUES("sp_setnetname",3,"machine names for remote computers running SQL Server. Names  ")
INSERT INTO helpsql VALUES("sp_setnetname",4,"can include hyphens and other non-alphabetic characters. This ")
INSERT INTO helpsql VALUES("sp_setnetname",5,"procedure can be used to enable execution of remote stored procedure")
INSERT INTO helpsql VALUES("sp_setnetname",6," calls to machines that have network names containing invalid SQL ")
INSERT INTO helpsql VALUES("sp_setnetname",7,"Server identifiers.   ")
INSERT INTO helpsql VALUES("sp_setnetname",8," ")
INSERT INTO helpsql VALUES("sp_setnetname",9,"sp_setnetname @<server> [= '<server>'], @<netname> [= '<netname>']  ")

go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("READTEXT",1,"READTEXT Statement")
INSERT INTO helpsql VALUES("READTEXT",2,"Reads text and image values, starting from a specified offset and ")
INSERT INTO helpsql VALUES("READTEXT",3,"reading a specified number of bytes.")
INSERT INTO helpsql VALUES("READTEXT",4," ")
INSERT INTO helpsql VALUES("READTEXT",5,"READTEXT [[<database>.]<owner>.]<table_name>.<column_name> ")
INSERT INTO helpsql VALUES("READTEXT",6,"     <text_ptr> <offset> <size> [HOLDLOCK]")
INSERT INTO helpsql VALUES("UPDATETEXT",1,"UPDATETEXT Statement")
INSERT INTO helpsql VALUES("UPDATETEXT",2,"Updates an existing text or image field.")
INSERT INTO helpsql VALUES("UPDATETEXT",3," ")
INSERT INTO helpsql VALUES("UPDATETEXT",4,"UPDATETEXT [[<database>.]<owner>.]<table_name>.<dest_column_name> ")
INSERT INTO helpsql VALUES("UPDATETEXT",5,"     <dest_text_ptr> {NULL | <insert_offset>} {NULL | <delete_length>}")
INSERT INTO helpsql VALUES("UPDATETEXT",6,"     [WITH LOG]")
INSERT INTO helpsql VALUES("UPDATETEXT",7,"     [<inserted_data> | ")
INSERT INTO helpsql VALUES("UPDATETEXT",8,"     [{[<database>.]<owner>.]<table_name>.<src_column_name> ")
INSERT INTO helpsql VALUES("UPDATETEXT",9,"          <src_text_ptr>}]")
INSERT INTO helpsql VALUES("WRITETEXT",1,"WRITETEXT Statement")
INSERT INTO helpsql VALUES("WRITETEXT",2,"Permits nonlogged, interactive updating of an existing text or image ")
INSERT INTO helpsql VALUES("WRITETEXT",3,"field. This statement completely overwrites any existing data in the ")
INSERT INTO helpsql VALUES("WRITETEXT",4,"column it affects.")
INSERT INTO helpsql VALUES("WRITETEXT",5," ")
INSERT INTO helpsql VALUES("WRITETEXT",6,"WRITETEXT [[<database>.]<owner>.]<table_name>.<column_name> ")
INSERT INTO helpsql VALUES("WRITETEXT",7,"     <text_ptr> [WITH LOG] <data>")
INSERT INTO helpsql VALUES("TRANSACTIONS",1,"Transactions")
INSERT INTO helpsql VALUES("TRANSACTIONS",2,"A transaction is a single unit of work. An explicit transaction is a ")
INSERT INTO helpsql VALUES("TRANSACTIONS",3,"grouping of SQL statements surrounded by the transaction delimiters: ")
INSERT INTO helpsql VALUES("TRANSACTIONS",4,"BEGIN TRANSACTION, COMMIT TRANSACTION, and optionally, one or more of ")
INSERT INTO helpsql VALUES("TRANSACTIONS",5,"the following statements:")
INSERT INTO helpsql VALUES("TRANSACTIONS",6," ")
INSERT INTO helpsql VALUES("TRANSACTIONS",7,"     BEGIN TRANSACTION ")
INSERT INTO helpsql VALUES("TRANSACTIONS",8,"     COMMIT TRANSACTION ")
INSERT INTO helpsql VALUES("TRANSACTIONS",9,"     ROLLBACK TRANSACTION ")
INSERT INTO helpsql VALUES("TRANSACTIONS",10,"     SAVE TRANSACTION ")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("BEGIN TRANSACTION",1,"BEGIN TRANSACTION Statement")
INSERT INTO helpsql VALUES("BEGIN TRANSACTION",2,"Marks the starting point of a user-specified transaction.")
INSERT INTO helpsql VALUES("BEGIN TRANSACTION",3," ")
INSERT INTO helpsql VALUES("BEGIN TRANSACTION",4,"BEGIN TRANsaction [<transaction_name>]")
INSERT INTO helpsql VALUES("COMMIT TRANSACTION",1,"COMMIT TRANSACTION Statement")
INSERT INTO helpsql VALUES("COMMIT TRANSACTION",2,"Marks the end of a user-defined transaction.")
INSERT INTO helpsql VALUES("COMMIT TRANSACTION",3," ")
INSERT INTO helpsql VALUES("COMMIT TRANSACTION",4,"COMMIT TRANsaction [<transaction_name>]")
INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",1,"ROLLBACK TRANSACTION Statement")
INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",2,"Rolls back a user-specified transaction to the last savepoint inside a ")
INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",3,"transaction or to the beginning of a transaction.")
INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",4," ")
INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",5,"ROLLBACK TRANsaction [<transaction_name> | <savepoint_name>]")
INSERT INTO helpsql VALUES("SAVE TRANSACTION",1,"SAVE TRANSACTION Statement")
INSERT INTO helpsql VALUES("SAVE TRANSACTION",2,"Sets a savepoint within a transaction.")
INSERT INTO helpsql VALUES("SAVE TRANSACTION",3," ")
INSERT INTO helpsql VALUES("SAVE TRANSACTION",4,"SAVE TRANsaction <savepoint_name>")
INSERT INTO helpsql VALUES("TRUNCATE TABLE",1,"TRUNCATE TABLE Statement")
INSERT INTO helpsql VALUES("TRUNCATE TABLE",2,"Removes all rows from a table without logging the individual row ")
INSERT INTO helpsql VALUES("TRUNCATE TABLE",3,"deletes. This allows TRUNCATE TABLE to be efficient and quick, but ")
INSERT INTO helpsql VALUES("TRUNCATE TABLE",4,"unrecoverable.")
INSERT INTO helpsql VALUES("TRUNCATE TABLE",5," ")
INSERT INTO helpsql VALUES("TRUNCATE TABLE",6,"TRUNCATE TABLE [[<database>.]<owner>.]<table_name>")
INSERT INTO helpsql VALUES("UNION",1,"UNION Operator")
INSERT INTO helpsql VALUES("UNION",2,"Combines the results of two or more queries into a single results set ")
INSERT INTO helpsql VALUES("UNION",3,"consisting of all the rows belonging to any subset of the queries or to ")
INSERT INTO helpsql VALUES("UNION",4,"all queries in the union.")
INSERT INTO helpsql VALUES("UNION",5," ")
INSERT INTO helpsql VALUES("UNION",6,"SELECT <select_list> ")
INSERT INTO helpsql VALUES("UNION",7,"     [<INTO clause>] ")
INSERT INTO helpsql VALUES("UNION",8,"     [<FROM clause>] ")
INSERT INTO helpsql VALUES("UNION",9,"     [<WHERE clause>] ")
INSERT INTO helpsql VALUES("UNION",10,"     [<GROUP BY clause>] ")
INSERT INTO helpsql VALUES("UNION",11,"     [<HAVING clause>] ")
INSERT INTO helpsql VALUES("UNION",12,"[UNION [ALL] ")
INSERT INTO helpsql VALUES("UNION",13,"SELECT <select_list> ")
INSERT INTO helpsql VALUES("UNION",14,"     [<FROM clause>] ")
INSERT INTO helpsql VALUES("UNION",15,"     [<WHERE clause>] ")
INSERT INTO helpsql VALUES("UNION",16,"     [<GROUP BY clause>] ")
INSERT INTO helpsql VALUES("UNION",17,"     [<HAVING clause>]...] ")
INSERT INTO helpsql VALUES("UNION",18,"[<ORDER BY clause>] ")
INSERT INTO helpsql VALUES("UNION",19,"[<COMPUTE clause>]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("UPDATE",1,"UPDATE Statement")
INSERT INTO helpsql VALUES("UPDATE",2,"Changes data in existing rows, either by adding new data or by modifying ")
INSERT INTO helpsql VALUES("UPDATE",3,"existing data.")
INSERT INTO helpsql VALUES("UPDATE",4," ")
INSERT INTO helpsql VALUES("UPDATE",5,"UPDATE {<table_name> | <view_name>} ")
INSERT INTO helpsql VALUES("UPDATE",6,"SET [{<table_name> | <view_name>}] ")
INSERT INTO helpsql VALUES("UPDATE",7,"     {<column_name> | <column_list> |")
INSERT INTO helpsql VALUES("UPDATE",8,"     <variable_list> |")
INSERT INTO helpsql VALUES("UPDATE",9,"     <variable_and_column_list>}")
INSERT INTO helpsql VALUES("UPDATE",10,"          [[, {<column_listn> ")
INSERT INTO helpsql VALUES("UPDATE",11,"               | <variable_listn>")
INSERT INTO helpsql VALUES("UPDATE",12,"               | <variable_and_column_listn>}...]")
INSERT INTO helpsql VALUES("UPDATE",13,"[WHERE clause]")
INSERT INTO helpsql VALUES("UPDATE",14," ")
INSERT INTO helpsql VALUES("UPDATE",15,"Transact-SQL extension syntax:")
INSERT INTO helpsql VALUES("UPDATE",16,"UPDATE {<table_name> | <view_name>}")
INSERT INTO helpsql VALUES("UPDATE",17,"SET [{<table_name> | <view_name>}] ")
INSERT INTO helpsql VALUES("UPDATE",18,"     {<column_list> ")
INSERT INTO helpsql VALUES("UPDATE",19,"     | <variable_list>")
INSERT INTO helpsql VALUES("UPDATE",20,"     | <variable_and_column_list>}")
INSERT INTO helpsql VALUES("UPDATE",21,"          [, {<column_list2> ")
INSERT INTO helpsql VALUES("UPDATE",22,"               | <variable_list2>")
INSERT INTO helpsql VALUES("UPDATE",23,"               | <variable_and_column_list2>}")
INSERT INTO helpsql VALUES("UPDATE",24,"               ...     [, {<column_listN> ")
INSERT INTO helpsql VALUES("UPDATE",25,"                         | <variable_listN>")
INSERT INTO helpsql VALUES("UPDATE",26,"                         | <variable_and_column_listN>}]]")
INSERT INTO helpsql VALUES("UPDATE",27,"[FROM {<table_name> | <view_name>}[(<optimizer_hints>)]")
INSERT INTO helpsql VALUES("UPDATE",28,"     [, {<table_name2> | <view_name2>}[(<optimizer_hints>)]")
INSERT INTO helpsql VALUES("UPDATE",29,"          [..., {<table_name16> | <view_name16>}[(<optimizer_hints>)]]]] ")
INSERT INTO helpsql VALUES("UPDATE",30,"[<WHERE clause>]")
INSERT INTO helpsql VALUES("UPDATE",31," ")
INSERT INTO helpsql VALUES("UPDATE",32,"where")
INSERT INTO helpsql VALUES("UPDATE",33," ")
INSERT INTO helpsql VALUES("UPDATE",34,"<table_name> | <view_name> = ")
INSERT INTO helpsql VALUES("UPDATE",35,"     [[<database_name>.]<owner>.]{<table_name> | <view_name>}")
INSERT INTO helpsql VALUES("UPDATE",36," ")
INSERT INTO helpsql VALUES("UPDATE",37,"<column_list> = ")
INSERT INTO helpsql VALUES("UPDATE",38,"     <column_name> = {<expression> | DEFAULT | NULL}")
INSERT INTO helpsql VALUES("UPDATE",39," ")
INSERT INTO helpsql VALUES("UPDATE",40,"<variable_list> = ")
INSERT INTO helpsql VALUES("UPDATE",41,"     <variable_name> = {<expression> | NULL}")
INSERT INTO helpsql VALUES("UPDATE",42," ")
INSERT INTO helpsql VALUES("UPDATE",43,"<variable_and_column_list> = ")
INSERT INTO helpsql VALUES("UPDATE",44,"     <variable_name> = <column_name> = {<expression> | NULL}")
INSERT INTO helpsql VALUES("UPDATE",45," ")
INSERT INTO helpsql VALUES("UPDATE",46,"WHERE clause = ")
INSERT INTO helpsql VALUES("UPDATE",47,"     WHERE {<search_conditions> | CURRENT OF <cursor_name>}")
INSERT INTO helpsql VALUES("UPDATE STATISTICS",1,"UPDATE STATISTICS Statement")
INSERT INTO helpsql VALUES("UPDATE STATISTICS",2,"Updates information about the distribution of key values in specified ")
INSERT INTO helpsql VALUES("UPDATE STATISTICS",3,"indexes.")
INSERT INTO helpsql VALUES("UPDATE STATISTICS",4," ")
INSERT INTO helpsql VALUES("UPDATE STATISTICS",5,"UPDATE STATISTICS [[<database>.]<owner>.]<table_name> [<index_name>]")
go
DUMP TRANSACTION master WITH NO_LOG
go
INSERT INTO helpsql VALUES("USE",1,"USE Statement")
INSERT INTO helpsql VALUES("USE",2,"Changes the database context.")
INSERT INTO helpsql VALUES("USE",3," ")
INSERT INTO helpsql VALUES("USE",4,"USE <database_name>")
INSERT INTO helpsql VALUES("VARIABLES",1,"Variables")
INSERT INTO helpsql VALUES("VARIABLES",2,"Local variables are declared in the body of a batch or procedure with ")
INSERT INTO helpsql VALUES("VARIABLES",3,"the DECLARE statement and given values with a SELECT statement. Local ")
INSERT INTO helpsql VALUES("VARIABLES",4,"variables are often used in a batch or procedure as counters for WHILE ")
INSERT INTO helpsql VALUES("VARIABLES",5,"loops or for IF...ELSE blocks.")
INSERT INTO helpsql VALUES("VARIABLES",6," ")
INSERT INTO helpsql VALUES("VARIABLES",7,"Variable declaration:")
INSERT INTO helpsql VALUES("VARIABLES",8,"     DECLARE @<variable_name> <datatype> ")
INSERT INTO helpsql VALUES("VARIABLES",9,"          [, @<variable_name> <datatype>...]")
INSERT INTO helpsql VALUES("VARIABLES",10,"Variable assignment:")
INSERT INTO helpsql VALUES("VARIABLES",11,"     SELECT @<variable> = {<expression> | <select_statement>} ")
INSERT INTO helpsql VALUES("VARIABLES",12,"          [, @<variable> = {<expression> | <select_statement>}...] ")
INSERT INTO helpsql VALUES("VARIABLES",13,"     [FROM <table_list>] ")
INSERT INTO helpsql VALUES("VARIABLES",14,"     [WHERE <search_conditions>]")
INSERT INTO helpsql VALUES("VARIABLES",15,"     [GROUP BY clause]")
INSERT INTO helpsql VALUES("VARIABLES",16,"     [HAVING clause]")
INSERT INTO helpsql VALUES("VARIABLES",17,"     [ORDER BY clause] ")
INSERT INTO helpsql VALUES("WILDCARDS",1,"Wildcard Characters")
INSERT INTO helpsql VALUES("WILDCARDS",2,"Wildcard characters are used with the LIKE keyword to represent any ")
INSERT INTO helpsql VALUES("WILDCARDS",3,"character in a string when searching for a char, varchar, or datetime ")
INSERT INTO helpsql VALUES("WILDCARDS",4,"value.")
INSERT INTO helpsql VALUES("WILDCARDS",5," ")
INSERT INTO helpsql VALUES("WILDCARDS",6,"<expression> [NOT] LIKE '<string>'")
INSERT INTO helpsql VALUES("WILDCARDS",7," ")
INSERT INTO helpsql VALUES("WILDCARDS",8,"The string can include these wildcard characters:")
INSERT INTO helpsql VALUES("WILDCARDS",9,"%                Any string of zero or more characters")
INSERT INTO helpsql VALUES("WILDCARDS",10,"_ (underscore)   Any single character")
INSERT INTO helpsql VALUES("WILDCARDS",11,"[ ]              Any single character within the specified range ")
INSERT INTO helpsql VALUES("WILDCARDS",12,"                  ([a-f]) or set ([abcdef])")
INSERT INTO helpsql VALUES("WILDCARDS",13,"[^]              Any single character not within the specified range ")
INSERT INTO helpsql VALUES("WILDCARDS",14,"                  ([^a-f]) or set ([^abcdef])")
go
DUMP TRANSACTION master WITH NO_LOG
go
GRANT EXECUTE ON sp_helpsql TO public
GRANT SELECT ON  helpsql TO public
go

/*
PRINT ''
PRINT 'Checking objects created by helpsql.sql.'

EXEC sp_check_objects 'help'			
*/

PRINT ''
PRINT 'Running of helpsql.sql completed.'
go

DUMP TRANSACTION master WITH NO_LOG
go
CHECKPOINT
go
-- -
