Liren Large Software Subsidy 5/05.iso/a/a025/8.ddi/HELPSQL.SQ@/HELPSQL.bin

Text File | 1992-09-15 | 119.4 KB | 1,774 lines

/******************************************************************/
/*  Microsoft - sp_helpsql    1988, 1989, 1992             */
/******************************************************************/
use master
go

dump transaction master with truncate_only
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 truncate_only
go

create table helpsql (command varchar(30), ordering tinyint, helptext varchar(72))
go

create index helpsql_index on helpsql(command)
go

create proc sp_helpsql
@in_command varchar(30)=null
as

declare @num_commands tinyint
declare @original_command varchar(30)


/******************************************************************/
/*  Microsoft - sp_helpsql    1988, 1989, 1992                */
/******************************************************************/
/*  sp_helpsql gives help on SQL commands supported by SQL Server */
/*     4 situations must be covered:                             */
/*          1. no additional parameters                           */
/*             return: help on how to use help                    */
/*          2. partial parameter input by the user                */
/*             return: all commands that begin with the string    */
/*                     input by the user.  the user can resubmit  */
/*                     the request for help with more information */
/*          3. a unique parameter passed from the user            */
/*             return: brief definition and syntax on command     */
/*          4. a parameter which does not match any help keys     */
/*             return:  No help available for command: parameter  */
/******************************************************************/
/* gwc dec, 1988                                                  */

/* first deal with no parameter passed, which means to simply give */
/* usage syntax and help                                           */
if @in_command = NULL
    begin
        print ' '
        print 'sp_helpsql supplies help on Transact-SQL statements, system procedures, and'
        print '    special topics: '
        print ' '
        print "Syntax:  sp_helpsql ['topic']"
        print ' '
        print 'Help is available on all Transact-SQL statements, all system'
        print '    procedures and catalog stored procedures, and the following topics: '
        print '         aggregate functions   datatype              expression'
        print '         functions             like and wildcards    mathematical functions'
        print '         string functions      system functions      text functions'
        print ' '
        /* all done, so leave now */
        return
    end
else
    begin
        select @original_command = @in_command
        select @in_command = lower(@in_command)
        /* see if we got a unique hit on command */
        select @num_commands=count(distinct command) from master..helpsql where
                command like @in_command
        if @num_commands = 1
            begin
                select helptext from master..helpsql where command like
                        @in_command order by ordering
                return
            end

        /* 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
                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 command from master..helpsql where
                        command like @in_command
                return
            end
        else
        /* if num_command = 1 then give help for that 1 command */
        if @num_commands = 1
            begin
                select helptext from master..helpsql where 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 truncate_only
go
insert into helpsql values("alter database",1,"ALTER DATABASE")
insert into helpsql values("alter database",2,"Increases 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_in_megabytes>]")
insert into helpsql values("alter database",6,"       [, <database_device> [= <size_in_megabytes>]]...]")
insert into helpsql values("alter database",7,"")
insert into helpsql values("alter table",1,"ALTER TABLE")
insert into helpsql values("alter table",2,"Adds columns 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,"  ADD <column_name> <datatype> NULL [, <column_name> <datatype> NULL...]")
insert into helpsql values("alter table",6,"")
insert into helpsql values("begin...end",1,"BEGIN...END")
insert into helpsql values("begin...end",2,"Enclose 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 the whole group.")
insert into helpsql values("begin...end",4,"")
insert into helpsql values("begin...end",5,"   BEGIN")
insert into helpsql values("begin...end",6,"     <statement_block>")
insert into helpsql values("begin...end",7,"   END")
insert into helpsql values("begin...end",8,"")
insert into helpsql values("begin transaction",1,"BEGIN TRANSACTION")
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("begin transaction",5,"")
insert into helpsql values("break",1,"BREAK")
insert into helpsql values("break",2,"Controls operation of statements in a WHILE loop.")
insert into helpsql values("break",3,"")
insert into helpsql values("break",4,"   WHILE")
insert into helpsql values("break",5,"     <boolean_expression>")
insert into helpsql values("break",6,"     <sql_statement>")
insert into helpsql values("break",7,"   BREAK")
insert into helpsql values("break",8,"     <sql_statement>")
insert into helpsql values("break",9,"   CONTINUE")
insert into helpsql values("break",10,"")
insert into helpsql values("checkpoint",1,"CHECKPOINT")
insert into helpsql values("checkpoint",2,"Forces all dirty pages in the current database to be written to the")
insert into helpsql values("checkpoint",3,"disk.")
insert into helpsql values("checkpoint",4,"")
insert into helpsql values("checkpoint",5,"   CHECKPOINT")
insert into helpsql values("checkpoint",6,"")
insert into helpsql values("commit transaction",1,"COMMIT TRANSACTION")
insert into helpsql values("commit transaction",2,"Marks the end of a user-defined transaction.")
go
dump transaction master with truncate_only
go
insert into helpsql values("commit transaction",3,"")
insert into helpsql values("commit transaction",4,"   COMMIT TRANsaction [<transaction_name>]")
insert into helpsql values("commit transaction",5,"")
insert into helpsql values("compute",1,"COMPUTE Clause")
insert into helpsql values("compute",2,"Generates summary values in a SELECT statement with row aggregate")
insert into helpsql values("compute",3,"functions.")
insert into helpsql values("compute",4,"")
insert into helpsql values("compute",5,"See SELECT for syntax.")
insert into helpsql values("compute",6,"")
insert into helpsql values("continue",1,"CONTINUE")
insert into helpsql values("continue",2,"Causes the WHILE loop to restart.")
insert into helpsql values("continue",3,"")
insert into helpsql values("continue",4,"   WHILE")
insert into helpsql values("continue",5,"     <boolean_expression>")
insert into helpsql values("continue",6,"     <statement>")
insert into helpsql values("continue",7,"   BREAK")
insert into helpsql values("continue",8,"     <statement>")
insert into helpsql values("continue",9,"   CONTINUE")
insert into helpsql values("continue",10,"")
insert into helpsql values("convert",1,"CONVERT (Conversion function)")
insert into helpsql values("convert",2,"Converts expressions of one datatype to another datatype. Also obtains a")
insert into helpsql values("convert",3,"variety of special date formats.")
insert into helpsql values("convert",4,"")
insert into helpsql values("convert",5,"CONVERT(<datatype> [(<length>)], <expression> [, <style>])")
insert into helpsql values("convert",6,"")
insert into helpsql values("create database",1,"CREATE DATABASE")
insert into helpsql values("create database",2," Creates a database.")
insert into helpsql values("create database",3,"")
insert into helpsql values("create database",4,"    CREATE DATABASE <database_name>")
insert into helpsql values("create database",5,"      [ON DEFAULT | <database_device> [= <size_in_megabytes>]")
insert into helpsql values("create database",6,"        [, <database_device> [= <size_in_megabytes>]]...]")
insert into helpsql values("create database",7,"        [LOG ON <database_device> [= <size_in_megabytes>]")
insert into helpsql values("create database",8,"        [, <database_device> [= <size_in_megabytes>]]...]")
insert into helpsql values("create database",9,"")
insert into helpsql values("create default",1,"CREATE DEFAULT")
insert into helpsql values("create default",2,"Specifies a value to be inserted in a column if no value is")
insert into helpsql values("create default",3,"supplied at insert time.")
insert into helpsql values("create default",4,"")
insert into helpsql values("create default",5,"   CREATE DEFAULT [<owner.>]<default_name>")
insert into helpsql values("create default",6,"     AS <constant_expression>")
insert into helpsql values("create default",7,"")
insert into helpsql values("create index",1,"CREATE INDEX")
insert into helpsql values("create index",2,"Creates an index.")
insert into helpsql values("create index",3,"")
insert into helpsql values("create index",4,"   CREATE [UNIQUE] [CLUSTERED | NONCLUSTERED] INDEX <index_name>")
insert into helpsql values("create index",5,"     ON [[<database.>]<owner.>]<table_name.> (<column_name>")
go
dump transaction master with truncate_only
go
insert into helpsql values("create index",6,"       [, <column_name>]...)")
insert into helpsql values("create index",7,"       [WITH {FILLFACTOR = <x> , IGNORE_DUP_KEY, SORTED_DATA,")
insert into helpsql values("create index",8,"         [IGNORE_DUP_ROW | ALLOW_DUP_ROW]}]")
insert into helpsql values("create index",9,"     [ON <segment_name>]")
insert into helpsql values("create index",10,"")
insert into helpsql values("create procedure",1,"CREATE PROCEDURE")
insert into helpsql values("create procedure",2,"Creates a stored procedure that can take one or more user-supplied")
insert into helpsql values("create procedure",3,"parameters.")
insert into helpsql values("create procedure",4,"")
insert into helpsql values("create procedure",5,"   CREATE PROCedure [<owner.>]<procedure_name>[<;number>]")
insert into helpsql values("create procedure",6,"       [[(]<@parameter_name> <datatype> [= <default>] [OUTput]")
insert into helpsql values("create procedure",7,"       [, <@parameter_name> <datatype> [= <default>] [OUTput]]...[)]]")
insert into helpsql values("create procedure",8,"     [WITH RECOMPILE]")
insert into helpsql values("create procedure",9,"     AS <sql_statements>")
insert into helpsql values("create procedure",10,"")
insert into helpsql values("create rule",1,"CREATE RULE")
insert into helpsql values("create rule",2,"Specifies the acceptable values for a particular column or")
insert into helpsql values("create rule",3,"for any column of a specified user datatype.")
insert into helpsql values("create rule",4,"")
insert into helpsql values("create rule",5,"   CREATE RULE [<owner.>]<rule_name>")
insert into helpsql values("create rule",6,"     AS <condition_expression>")
insert into helpsql values("create rule",7,"")
insert into helpsql values("create table",1,"CREATE TABLE")
insert into helpsql values("create table",2,"Creates a 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,"     (<column_name> <datatype> [NOT NULL | NULL]")
insert into helpsql values("create table",6,"       [, <column_name> <datatype> [NOT NULL | NULL]]...)")
insert into helpsql values("create table",7,"       [ON <segment_name>]")
insert into helpsql values("create table",8,"")
insert into helpsql values("create trigger",1,"CREATE TRIGGER")
insert into helpsql values("create trigger",2,"Creates a trigger, which is a special kind of stored procedure often")
insert into helpsql values("create trigger",3,"used for enforcing integrity constraints.")
insert into helpsql values("create trigger",4,"")
insert into helpsql values("create trigger",5,"   CREATE TRIGGER [<owner.>]<trigger_name>")
insert into helpsql values("create trigger",6,"     ON [<owner.>]<table_name>")
insert into helpsql values("create trigger",7,"     {FOR {INSERT, UPDATE, DELETE}]")
insert into helpsql values("create trigger",8,"     AS <sql_statements> |")
insert into helpsql values("create trigger",9,"     FOR {INSERT, UPDATE}")
insert into helpsql values("create trigger",10,"     AS")
insert into helpsql values("create trigger",11,"     IF UPDATE (<column_name>)")
insert into helpsql values("create trigger",12,"     [{AND | OR} UPDATE (<column_name>)...] sql_statements}")
insert into helpsql values("create trigger",13,"")
insert into helpsql values("create view",1,"CREATE VIEW")
insert into helpsql values("create view",2,"Creates a view.")
go
dump transaction master with truncate_only
go
insert into helpsql values("create view",3,"")
insert into helpsql values("create view",4,"   CREATE VIEW [<owner.>]<view_name>")
insert into helpsql values("create view",5,"     [(<column_name> [, <column_name>]...)]")
insert into helpsql values("create view",6,"     AS <select_statement>")
insert into helpsql values("create view",7,"")
insert into helpsql values("dbcc",1,"DBCC")
insert into helpsql values("dbcc",2,"Checks the logical and physical consistency of a database.")
insert into helpsql values("dbcc",3,"")
insert into helpsql values("dbcc",4,"   DBCC")
insert into helpsql values("dbcc",5,"      {CHECKTABLE (<table_name>) | CHECKDB [(<database_name>)] |")
insert into helpsql values("dbcc",6,"        CHECKALLOC [(<database_name>)] |")
insert into helpsql values("dbcc",7,"        CHECKCATALOG [(<database_name>)] |")
insert into helpsql values("dbcc",8,"        DBREPAIR (<database_name>, DROPDB) | ")
insert into helpsql values("dbcc",9,"        MEMUSAGE | ALLOW11LOAD}")
insert into helpsql values("dbcc",10,"")
insert into helpsql values("declare",1,"DECLARE")
insert into helpsql values("declare",2,"Declares the name and type of local variables for a batch or")
insert into helpsql values("declare",3,"stored procedure.")
insert into helpsql values("declare",4,"")
insert into helpsql values("declare",5,"  DECLARE <@variable_name> <datatype> [, <@variable_name> <datatype>...]")
insert into helpsql values("declare",6,"")
insert into helpsql values("delete",1,"DELETE")
insert into helpsql values("delete",2,"Removes rows from a table.")
insert into helpsql values("delete",3,"")
insert into helpsql values("delete",4,"   DELETE [[<database.>]<owner.>]{<table_name> | <view_name>}")
insert into helpsql values("delete",5,"   [FROM [[<database.>]<owner.>]{<table_name> | <view_name>}")
insert into helpsql values("delete",6,"   [, [[<database.>]<owner.>]{<table_name> | <view_name>}]...]")
insert into helpsql values("delete",7,"       [WHERE <search_conditions>]")
insert into helpsql values("delete",8,"")
insert into helpsql values("delete",9,"   DELETE [FROM] [[<database.>]<owner.>]{<table_name> | <view_name>}")
insert into helpsql values("delete",10,"       [WHERE <search_conditions>]")
insert into helpsql values("delete",11,"")
insert into helpsql values("disk init",1,"DISK INIT")
insert into helpsql values("disk init",2,"Reserves and formats physical storage for a database device.")
insert into helpsql values("disk init",3,"")
insert into helpsql values("disk init",4,"   DISK INIT")
insert into helpsql values("disk init",5,"      NAME = <'logical_name'> ,")
insert into helpsql values("disk init",6,"      PHYSNAME = <'physical_name'> ,")
insert into helpsql values("disk init",7,"      VDEVNO = <virtual_device_number> ,")
insert into helpsql values("disk init",8,"      SIZE = <number_of_2K_blocks>")
insert into helpsql values("disk init",9,"      [, VSTART = <virtual_address> ,")
insert into helpsql values("disk init",10,"      CNTRLTYPE = <controller_number>]")
insert into helpsql values("disk init",11,"")
insert into helpsql values("disk mirror",1,"DISK MIRROR")
insert into helpsql values("disk mirror",2,"Creates a software mirror of a user database device, the Master database")
go
dump transaction master with truncate_only
go
insert into helpsql values("disk mirror",3,"device, or a database device for user-database transaction logs.")
insert into helpsql values("disk mirror",4,"")
insert into helpsql values("disk mirror",5,"   DISK MIRROR")
insert into helpsql values("disk mirror",6,"   NAME = <'logical_name'>,")
insert into helpsql values("disk mirror",7,"   MIRROR = <physical_name'> [, WRITES = {SERIAL | NOSERIAL}]")
insert into helpsql values("disk mirror",8,"")
insert into helpsql values("disk refit",1,"DISK REFIT")
insert into helpsql values("disk refit",2,"Restores a damaged Master database.  Used after DISK REINIT.")
insert into helpsql values("disk refit",3,"")
insert into helpsql values("disk refit",4,"   DISK REFIT")
insert into helpsql values("disk refit",5,"")
insert into helpsql values("disk reinit",1,"DISK REINIT")
insert into helpsql values("disk reinit",2,"Part of the procedure that restores a damaged Master database.")
insert into helpsql values("disk reinit",3,"")
insert into helpsql values("disk reinit",4,"   DISK REINIT")
insert into helpsql values("disk reinit",5,"      NAME = <'logical_name'> ,")
insert into helpsql values("disk reinit",6,"      PHYSNAME = <'physical_name'> ,")
insert into helpsql values("disk reinit",7,"      VDEVNO = <virtual_device_number> ,")
insert into helpsql values("disk reinit",8,"      SIZE = <number_of_2K_blocks>")
insert into helpsql values("disk reinit",9,"      [, VSTART = <virtual_address> ,")
insert into helpsql values("disk reinit",10,"      CNTRLTYPE = <controller_number>]")
insert into helpsql values("disk reinit",11,"")
insert into helpsql values("disk remirror",1,"DISK REMIRROR")
insert into helpsql values("disk remirror",2,"Resumes software mirroring for a database 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'>")
insert into helpsql values("disk remirror",6,"")
insert into helpsql values("disk unmirror",1,"DISK UNMIRROR")
insert into helpsql values("disk unmirror",2,"Suspends software mirroring for a database device.")
insert into helpsql values("disk unmirror",3,"")
insert into helpsql values("disk unmirror",4,"   DISK UNMIRROR")
insert into helpsql values("disk unmirror",5,"   NAME = <'logical_name'> [, SIDE = {PRIMARY | SECONDARY}]")
insert into helpsql values("disk unmirror",6,"   [, MODE = {RETAIN | REMOVE}]")
insert into helpsql values("disk unmirror",7,"")
insert into helpsql values("drop database",1,"DROP DATABASE")
insert into helpsql values("drop database",2,"Removes a database 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 database",5,"")
insert into helpsql values("drop default",1,"DROP DEFAULT")
insert into helpsql values("drop default",2,"Removes a user-specified 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>...]")
go
dump transaction master with truncate_only
go
insert into helpsql values("drop default",5,"")
insert into helpsql values("drop index",1,"DROP INDEX")
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 <table_name.><index_name> [, <table_name.><index_name>...]")
insert into helpsql values("drop index",5,"")
insert into helpsql values("drop procedure",1,"DROP PROCEDURE")
insert into helpsql values("drop procedure",2,"Removes a user-created stored procedure 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 procedure",6,"")
insert into helpsql values("drop rule",1,"DROP RULE")
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> [, [<owner.>]<rule_name>...]")
insert into helpsql values("drop rule",5,"")
insert into helpsql values("drop table",1,"DROP TABLE")
insert into helpsql values("drop table",2,"Removes a table definition and all data, indexes, triggers, and")
insert into helpsql values("drop table",3,"permission specifications for a 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 table",7,"")
insert into helpsql values("drop trigger",1,"DROP TRIGGER")
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> [, [<owner.>]<trigger_name>...]")
insert into helpsql values("drop trigger",5,"")
insert into helpsql values("drop view",1,"DROP VIEW")
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> [, [<owner.>]<view_name>...]")
insert into helpsql values("drop view",5,"")
insert into helpsql values("dump database",1,"DUMP DATABASE")
insert into helpsql values("dump database",2,"Makes a backup copy of a database and its transaction log.")
insert into helpsql values("dump database",3,"")
insert into helpsql values("dump database",4,"   DUMP DATABASE <database_name>")
insert into helpsql values("dump database",5,"     TO <dump_device>")
insert into helpsql values("dump database",6,"")
insert into helpsql values("dump transaction",1,"DUMP TRANSACTION")
insert into helpsql values("dump transaction",2,"Makes a backup copy of the transaction log.")
insert into helpsql values("dump transaction",3,"")
insert into helpsql values("dump transaction",4,"   DUMP TRANsaction <database_name>")
go
dump transaction master with truncate_only
go
insert into helpsql values("dump transaction",5,"     [TO <dump_device>]")
insert into helpsql values("dump transaction",6,"     [WITH TRUNCATE_ONLY | WITH NO_LOG | WITH NO_TRUNCATE]")
insert into helpsql values("dump transaction",7,"")
insert into helpsql values("execute",1,"EXECUTE")
insert into helpsql values("execute",2,"Runs a system procedure or a user-defined stored procedure.")
insert into helpsql values("execute",3,"")
insert into helpsql values("execute",4,"   [EXECute] [@return_status =]")
insert into helpsql values("execute",5,"     [[[server.]<database.>]<owner.>]<procedure_name>[<;number>]")
insert into helpsql values("execute",6,"     [[<@parameter_name> =] {<value> | @variable [OUTput]}")
insert into helpsql values("execute",7,"     [, [<@parameter_name> =] {<value> | @variable [OUTput]}]...]")
insert into helpsql values("execute",8,"     [WITH RECOMPILE]")
insert into helpsql values("execute",9,"")
insert into helpsql values("goto",1,"GOTO")
insert into helpsql values("goto",2,"Causes an unconditional branching to a user-defined label.")
insert into helpsql values("goto",3,"")
insert into helpsql values("goto",4,"   <label:>")
insert into helpsql values("goto",5,"   GOTO <label>")
insert into helpsql values("goto",6,"")
insert into helpsql values("grant",1,"GRANT")
insert into helpsql values("grant",2,"Assigns object and statement permissions to users.")
insert into helpsql values("grant",3,"")
insert into helpsql values("grant",4,"   Object permissions:")
insert into helpsql values("grant",5,"")
insert into helpsql values("grant",6,"   GRANT {ALL | <permission_list>}")
insert into helpsql values("grant",7,"    ON {<table_name> [(<column_list>)] | <view_name> [(<column_list>)] |")
insert into helpsql values("grant",8,"       <stored_procedure_name>}")
insert into helpsql values("grant",9,"    TO {PUBLIC | <name_list>}")
insert into helpsql values("grant",10,"")
insert into helpsql values("grant",11,"   Statement permissions:")
insert into helpsql values("grant",12,"")
insert into helpsql values("grant",13,"   GRANT {ALL | <statement_list>}")
insert into helpsql values("grant",14,"     TO {PUBLIC | <name_list>}")
insert into helpsql values("grant",15,"")
insert into helpsql values("group by",1,"GROUP BY")
insert into helpsql values("group by",2,"Divides a table into groups.")
insert into helpsql values("group by",3,"")
insert into helpsql values("group by",4,"   See SELECT for syntax.")
insert into helpsql values("group by",5,"")
insert into helpsql values("having",1,"HAVING")
insert into helpsql values("having",2,"Divides a table into groups.")
insert into helpsql values("having",3,"")
insert into helpsql values("having",4,"   See SELECT for syntax.")
insert into helpsql values("having",5,"")
insert into helpsql values("if...else",1,"IF...ELSE")
go
dump transaction master with truncate_only
go
insert into helpsql values("if...else",2,"Impose conditions on the execution of a SQL statement.")
insert into helpsql values("if...else",3,"")
insert into helpsql values("if...else",4,"   IF")
insert into helpsql values("if...else",5,"     <boolean_expression>")
insert into helpsql values("if...else",6,"     <sql_statement>")
insert into helpsql values("if...else",7,"     [ELSE")
insert into helpsql values("if...else",8,"     [<boolean_expression>]")
insert into helpsql values("if...else",9,"     <sql_statement>]")
insert into helpsql values("if...else",10,"")
insert into helpsql values("insert",1,"INSERT")
insert into helpsql values("insert",2,"Adds a new row to a table or view.")
insert into helpsql values("insert",3,"")
insert into helpsql values("insert",4,"   INSERT [INTO]")
insert into helpsql values("insert",5,"   [[<database.>]<owner.>]{<table_name> | <view_name>}")
insert into helpsql values("insert",6,"       [(<column_list>)]")
insert into helpsql values("insert",7,"     {VALUES (<constant_expression> [, <constant_expression>]...) |")
insert into helpsql values("insert",8,"       <select_statement>}")
insert into helpsql values("insert",9,"")
insert into helpsql values("kill",1,"KILL")
insert into helpsql values("kill",2,"Terminates a process.")
insert into helpsql values("kill",3,"")
insert into helpsql values("kill",4,"   KILL <spid>")
insert into helpsql values("kill",5,"")
insert into helpsql values("load database",1,"LOAD DATABASE")
insert into helpsql values("load database",2,"Loads a backup copy of a user database and its transaction log.")
insert into helpsql values("load database",3,"")
insert into helpsql values("load database",4,"   LOAD DATABASE <database_name>")
insert into helpsql values("load database",5,"     FROM <dump_device>")
insert into helpsql values("load database",6,"")
insert into helpsql values("load transaction",1,"LOAD TRANSACTION")
insert into helpsql values("load transaction",2,"Loads a backup copy of the transaction log.")
insert into helpsql values("load transaction",3,"")
insert into helpsql values("load transaction",4,"   LOAD TRANsaction <database_name>")
insert into helpsql values("load transaction",5,"     FROM <dump_device>")
insert into helpsql values("load transaction",6,"")
insert into helpsql values("order by",1,"ORDER BY")
insert into helpsql values("order by",2,"Returns query results in the specified column(s) in sorted order.")
insert into helpsql values("order by",3,"")
insert into helpsql values("order by",4,"   See SELECT for syntax.")
insert into helpsql values("order by",5,"")
insert into helpsql values("prepare transaction",1,"PREPARE TRANSACTION")
insert into helpsql values("prepare transaction",2,"Sees if a server is prepared to commit a transaction.")
insert into helpsql values("prepare transaction",3,"")
insert into helpsql values("prepare transaction",4,"   PREPARE TRANsaction")
go
dump transaction master with truncate_only
go
insert into helpsql values("prepare transaction",5,"")
insert into helpsql values("print",1,"PRINT")
insert into helpsql values("print",2,"Returns a user-defined message.")
insert into helpsql values("print",3,"")
insert into helpsql values("print",4,"   PRINT <'any_ASCII_text'> | <@local_variable> |")
insert into helpsql values("print",5,"       <@@global_variable>")
insert into helpsql values("print",6,"")
insert into helpsql values("raiserror",1,"RAISERROR")
insert into helpsql values("raiserror",2,"Returns a user-defined error message and sets a")
insert into helpsql values("raiserror",3,"system flag to record that an error has occurred.")
insert into helpsql values("raiserror",4,"")
insert into helpsql values("raiserror",5,"   RAISERROR <integer_expression> {<'text of message'> |")
insert into helpsql values("raiserror",6,"     <@local_variable>}")
insert into helpsql values("raiserror",7,"")
insert into helpsql values("readtext",1,"READTEXT")
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_pointer> <offset> <size>")
insert into helpsql values("readtext",7,"     [HOLDLOCK]")
insert into helpsql values("readtext",8,"")
insert into helpsql values("reconfigure",1,"RECONFIGURE")
insert into helpsql values("reconfigure",2,"Part of the procedure that sets configuration options, which control")
insert into helpsql values("reconfigure",3,"various aspects of SQL Server's memory allocation and performance.")
insert into helpsql values("reconfigure",4,"")
insert into helpsql values("reconfigure",5,"   RECONFIGURE [WITH OVERRIDE]")
insert into helpsql values("reconfigure",6,"")
insert into helpsql values("return",1,"RETURN")
insert into helpsql values("return",2,"Exits unconditionally from a query or procedure.")
insert into helpsql values("return",3,"")
insert into helpsql values("return",4,"   RETURN [integer_expression]")
insert into helpsql values("return",5,"")
insert into helpsql values("revoke",1,"REVOKE")
insert into helpsql values("revoke",2,"Revokes object and statement permissions from a user.")
insert into helpsql values("revoke",3,"")
insert into helpsql values("revoke",4,"   Object permissions:")
insert into helpsql values("revoke",5,"")
insert into helpsql values("revoke",6,"   REVOKE {ALL | <permission_list>}")
insert into helpsql values("revoke",7,"     ON {<table_name> [(<column_list>)] | <view_name>")
insert into helpsql values("revoke",8,"       [(<column_list>)] | <stored_procedure_name>}")
insert into helpsql values("revoke",9,"     FROM {PUBLIC | <name_list>}")
insert into helpsql values("revoke",10,"")
insert into helpsql values("revoke",11,"   Statement permissions:")
go
dump transaction master with truncate_only
go
insert into helpsql values("revoke",12,"")
insert into helpsql values("revoke",13,"   REVOKE {ALL | <statement_list>}")
insert into helpsql values("revoke",14,"     FROM {PUBLIC | <name_list>}")
insert into helpsql values("revoke",15,"")
insert into helpsql values("rollback transaction",1,"ROLLBACK TRANSACTION")
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("rollback transaction",6,"")
insert into helpsql values("save transaction",1,"SAVE TRANSACTION")
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("save transaction",5,"")
insert into helpsql values("select",1,"SELECT")
insert into helpsql values("select",2,"Retrieves rows from database tables.")
insert into helpsql values("select",3,"")
insert into helpsql values("select",4,"   SELECT [ALL | DISTINCT] <select_list>")
insert into helpsql values("select",5,"    [INTO [[<database.>]<owner.>]<table_name>]")
insert into helpsql values("select",6,"    [FROM [[<database.>]<owner.>]{<table_name> | <view_name>} [HOLDLOCK]")
insert into helpsql values("select",7,"       [,[[<database.>]<owner.>]{<table_name> | <view_name>}")
insert into helpsql values("select",8,"       [HOLDLOCK]]...]")
insert into helpsql values("select",9,"    [WHERE <search_conditions>]")
insert into helpsql values("select",10,"    [GROUP BY [ALL]")
insert into helpsql values("select",11,"       <aggregate_free_expression>")
insert into helpsql values("select",12,"       [, <aggregate_free_expression>]...]")
insert into helpsql values("select",13,"    [HAVING <search_conditions>]")
insert into helpsql values("select",14,"    [ORDER BY {[[[<database.>]<owner.>]{<table_name.> | <view_name.>}]")
insert into helpsql values("select",15,"       <column_name> | <select_list_number> | <expression> [ASC | DESC]")
insert into helpsql values("select",16,"       [,[[[<database.>]<owner.>]{<table_name.> | <view_name.>}]")
insert into helpsql values("select",17,"       <column_name> | <select_list_number> | <expression>}")
insert into helpsql values("select",18,"       [ASC | DESC]]...]")
insert into helpsql values("select",19,"    [COMPUTE <row_aggregate>(<column_name>)")
insert into helpsql values("select",20,"       [, <row_aggregate>(<column_name>)...]]")
insert into helpsql values("select",21,"     [BY <column_name> [, <column_name>]...]")
insert into helpsql values("select",22,"    [FOR BROWSE]")
insert into helpsql values("select",23,"")
insert into helpsql values("set",1,"SET")
insert into helpsql values("set",2,"Sets SQL Server query-processing options for the duration of the")
insert into helpsql values("set",3,"user's work session, or inside a trigger or stored procedure.")
insert into helpsql values("set",4,"")
insert into helpsql values("set",5,"   SET")
insert into helpsql values("set",6,"      {{ARITHABORT | ARITHIGNORE |")
insert into helpsql values("set",7,"       NOCOUNT | NOEXEC |")
insert into helpsql values("set",8,"       OFFSETS {<keyword_list>} | PARSEONLY | PROCID |")
go
dump transaction master with truncate_only
go
insert into helpsql values("set",9,"       SHOWPLAN | FORCEPLAN | STATISTICS IO | STATISTICS TIME}")
insert into helpsql values("set",10,"          {ON | OFF} |")
insert into helpsql values("set",11,"          DATEFIRST <number> | DATEFORMAT <format> |")
insert into helpsql values("set",12,"          LANGUAGE <language> | ROWCOUNT <number> |")
insert into helpsql values("set",13,"          TEXTSIZE <number>}")
insert into helpsql values("set",14,"")
insert into helpsql values("setuser",1,"SETUSER")
insert into helpsql values("setuser",2,"Impersonates another user.")
insert into helpsql values("setuser",3,"")
insert into helpsql values("setuser",4,"   SETUSER [<'username'>]")
insert into helpsql values("setuser",5,"")
insert into helpsql values("shutdown",1,"SHUTDOWN")
insert into helpsql values("shutdown",2,"Brings the system to a halt.")
insert into helpsql values("shutdown",3,"")
insert into helpsql values("shutdown",4,"   SHUTDOWN [WITH NOWAIT]")
insert into helpsql values("shutdown",5,"")
insert into helpsql values("truncate table",1,"TRUNCATE TABLE")
insert into helpsql values("truncate table",2,"Removes all rows in a table as quickly as possible.")
insert into helpsql values("truncate table",3,"")
insert into helpsql values("truncate table",4,"   TRUNCATE TABLE [[<database.>]<owner.>]<table_name>")
insert into helpsql values("truncate table",5,"")
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 A or B or both.")
insert into helpsql values("union",4,"")
insert into helpsql values("union",5,"   SELECT <select_list> [INTO <clause>]")
insert into helpsql values("union",6,"   [FROM <clause>] [WHERE <clause>]")
insert into helpsql values("union",7,"   [GROUP BY <clause>] [HAVING <clause>]...]")
insert into helpsql values("union",8,"")
insert into helpsql values("union",9,"   [UNION [ALL]")
insert into helpsql values("union",10,"   SELECT <select_list>")
insert into helpsql values("union",11,"   [FROM <clause>] [WHERE <clause>]")
insert into helpsql values("union",12,"   [GROUP BY <clause>] [HAVING <clause>]...]")
insert into helpsql values("union",13,"   [ORDER BY <clause>]")
insert into helpsql values("union",14,"   [COMPUTE <clause>]")
insert into helpsql values("union",15,"")
insert into helpsql values("update",1,"UPDATE")
insert into helpsql values("update",2,"Changes data in existing rows,")
insert into helpsql values("update",3,"either by adding new data or modifying existing data.")
insert into helpsql values("update",4,"")
insert into helpsql values("update",5,"   UPDATE [[<database.>]<owner.>]{<table_name> | <view_name>}")
insert into helpsql values("update",6,"     SET [[[<database.>]<owner.>]{<table_name.> | <view_name.>}]")
insert into helpsql values("update",7,"       <column_name1> = {<expression1> | NULL} | (select_statement)}")
insert into helpsql values("update",8,"       [, <column_name2> = {<expression2> | NULL |")
insert into helpsql values("update",9,"       (select_statement)}...]")
go
dump transaction master with truncate_only
go
insert into helpsql values("update",10,"     [FROM [[<database.>]<owner.>]{<table_name> | <view_name>}")
insert into helpsql values("update",11,"       [, [[<database.>]<owner.>]{<table_name> | <view_name>}]...]")
insert into helpsql values("update",12,"     [WHERE <search_conditions>]")
insert into helpsql values("update",13,"")
insert into helpsql values("update statistics",1,"UPDATE STATISTICS")
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>]")
insert into helpsql values("update statistics",6,"")
insert into helpsql values("use",1,"USE")
insert into helpsql values("use",2,"Sets the current database.")
insert into helpsql values("use",3,"")
insert into helpsql values("use",4,"   USE <database_name>")
insert into helpsql values("use",5,"")
insert into helpsql values("waitfor",1,"WAITFOR")
insert into helpsql values("waitfor",2,"Specifies a time, a time interval, or an event for ")
insert into helpsql values("waitfor",3,"executing a statement block, stored procedure, or transaction.")
insert into helpsql values("waitfor",4,"")
insert into helpsql values("waitfor",5,"   WAITFOR {DELAY <'time'> | TIME <'time'> | ERROREXIT | PROCESSEXIT |")
insert into helpsql values("waitfor",6,"     MIRROREXIT}")
insert into helpsql values("waitfor",7,"")
insert into helpsql values("where",1,"WHERE Clause")
insert into helpsql values("where",2,"Specifies the connection between tables named in a FROM clause, and")
insert into helpsql values("where",3,"restricts the rows to be included in the results.")
insert into helpsql values("where",4,"")
insert into helpsql values("where",5," WHERE [NOT] <expression> <comparison_operator> <expression>")
insert into helpsql values("where",6," WHERE [NOT] <column_name> [NOT] LIKE <'match_string'>")
insert into helpsql values("where",7," WHERE [NOT] <column_name> IS [NOT] NULL")
insert into helpsql values("where",8," WHERE [NOT] <expression> [NOT] BETWEEN <expression> AND <expression>")
insert into helpsql values("where",9," WHERE [NOT] <expression> [NOT] IN ({<value_list> | <subquery>})")
insert into helpsql values("where",10," WHERE [NOT] EXISTS (<subquery>)")
insert into helpsql values("where",11," WHERE [NOT] <expression> <comparison_operator> {ANY | ALL} (<subquery>)")
insert into helpsql values("where",12," WHERE [NOT] <column_name> <join_operator> <column_name>")
insert into helpsql values("where",13," WHERE [NOT] <boolean_expression>")
insert into helpsql values("where",14," WHERE [NOT] <expression> {AND | OR} [NOT] <expression>")
insert into helpsql values("where",15,"")
insert into helpsql values("while",1,"WHILE")
insert into helpsql values("while",2,"Sets a condition for the repeated execution of a statement or")
insert into helpsql values("while",3,"statement block.")
insert into helpsql values("while",4,"")
insert into helpsql values("while",5,"   WHILE")
insert into helpsql values("while",6,"     <boolean_expression>")
insert into helpsql values("while",7,"     <sql_statement>")
go
dump transaction master with truncate_only
go
insert into helpsql values("while",8,"")
insert into helpsql values("writetext",1,"WRITETEXT")
insert into helpsql values("writetext",2,"Permits nonlogged, interactive updating of an existing text field.")
insert into helpsql values("writetext",3,"")
insert into helpsql values("writetext",4," WRITETEXT [[<database.>]<owner.>]<table_name.><column_name> <text_ptr>")
insert into helpsql values("writetext",5,"     [WITH LOG] <data>")
insert into helpsql values("writetext",6,"")
insert into helpsql values("datatype",1,"Datatype")
insert into helpsql values("datatype",2,"Datatype                   Definition")
insert into helpsql values("datatype",3,"")
insert into helpsql values("datatype",4,"Binary(n)                 Fixed-length binary data. Maximum")
insert into helpsql values("datatype",5,"                          length=255 bytes.")
insert into helpsql values("datatype",6,"Bit                       A column that holds either 0 or 1.")
insert into helpsql values("datatype",7,"Char(n)                   Character data. Maximum length=255")
insert into helpsql values("datatype",8,"                          bytes.")
insert into helpsql values("datatype",9,"Datetime                  Dates and times with accuracy to milliseconds.")
insert into helpsql values("datatype",10,"Float                     Floating-point numbers.")
insert into helpsql values("datatype",11,"Image                     Large amounts of binary data (up to")
insert into helpsql values("datatype",12,"                          2,147,483,647 characters.)")
insert into helpsql values("datatype",13,"Int                       Integers between 2,147,483,647 and")
insert into helpsql values("datatype",14,"                          -2,147,483,648.")
insert into helpsql values("datatype",15,"Money                     Dollar and cent values.")
insert into helpsql values("datatype",16,"Real                      Floating point numbers with 7-digit precision.")
insert into helpsql values("datatype",17,"Smalldatetime             Dates and times with accuracy to the minute.")
insert into helpsql values("datatype",18,"Smallint                  Integers between 32,767 and -32,768.")
insert into helpsql values("datatype",19,"Smallmoney                Monetary values between 214,748.3647 and")
insert into helpsql values("datatype",20,"                          -214,748.3648.")
insert into helpsql values("datatype",21,"Text                      Large amounts of character data (up to")
insert into helpsql values("datatype",22,"                          2,147,483,647 characters.)")
insert into helpsql values("datatype",23,"Timestamp                 Automatically updated when you")
insert into helpsql values("datatype",24,"                          insert or update a row that has a timestamp")
insert into helpsql values("datatype",25,"                          column, or use BROWSE mode in a")
insert into helpsql values("datatype",26,"                          DB-LIBRARY application.")
insert into helpsql values("datatype",27,"Tinyint                   Whole integers between 0 and 255.")
insert into helpsql values("datatype",28,"Varbinary(n)              Variable-length binary data. Max")
insert into helpsql values("datatype",29,"                          length=255 bytes.")
insert into helpsql values("datatype",30,"Varchar(n)                Variable-length character data. Max")
insert into helpsql values("datatype",31,"                          length=255 bytes.")
insert into helpsql values("datatype",32,"")
insert into helpsql values("expression syntax",1,"Expression Syntax")
insert into helpsql values("expression syntax",2,"{<constant> | <column_name> | <function> | (<subquery>)}")
insert into helpsql values("expression syntax",3,"    [{<arithmetic_operator> | <bitwise_operator> | <string_operator>}")
insert into helpsql values("expression syntax",4,"    {<constant> | <column_name> | <function> | (<subquery>)}...]")
insert into helpsql values("expression syntax",5,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("expression syntax",6,"Boolean expression")
insert into helpsql values("expression syntax",7,"Returns true or false.")
insert into helpsql values("expression syntax",8,"")
insert into helpsql values("expression syntax",9,"Boolean Expression Syntax")
insert into helpsql values("expression syntax",10,"<expression> <comparison_operator> [ANY | ALL] <expression>")
insert into helpsql values("expression syntax",11,"  <expression> [NOT] IN <expression>")
insert into helpsql values("expression syntax",12,"  [NOT] EXISTS <expression>")
insert into helpsql values("expression syntax",13,"  <expression> [NOT] BETWEEN <expression> AND <expression>")
insert into helpsql values("expression syntax",14,"  <expression> [NOT] LIKE <expression>")
insert into helpsql values("expression syntax",15,"  NOT <expression> LIKE <expression>")
insert into helpsql values("expression syntax",16,"  <expression> IS [NOT] NULL")
insert into helpsql values("expression syntax",17,"  NOT <boolean_expression>")
insert into helpsql values("expression syntax",18,"  <boolean_expression> {AND | OR} <boolean_expression>")
insert into helpsql values("expression syntax",19,"  [NOT] <boolean_function>")
insert into helpsql values("expression syntax",20,"")
insert into helpsql values("expression syntax",21,"arithmetic_operator             bitwise_operator")
insert into helpsql values("expression syntax",22,"")
insert into helpsql values("expression syntax",23,"Symbol  Meaning                 Symbol  Meaning")
insert into helpsql values("expression syntax",24,"")
insert into helpsql values("expression syntax",25," +      addition                &      bitwise AND (two")
insert into helpsql values("expression syntax",26," -      subtraction                    operands)")
insert into helpsql values("expression syntax",27," *      multiplication          |      bitwise OR (two operands)")
insert into helpsql values("expression syntax",28," /      division                ^      bitwise exclusive OR (two")
insert into helpsql values("expression syntax",29," %      modulo                         operands)")
insert into helpsql values("expression syntax",30,"                                ~      bitwise NOT (one operand)")
insert into helpsql values("expression syntax",31,"")
insert into helpsql values("expression syntax",32,"string_operator")
insert into helpsql values("expression syntax",33,"")
insert into helpsql values("expression syntax",34," +      concatenation")
insert into helpsql values("expression syntax",35,"")
insert into helpsql values("expression syntax",36,"comparison_operator")
insert into helpsql values("expression syntax",37,"")
insert into helpsql values("expression syntax",38,"Symbol   Meaning")
insert into helpsql values("expression syntax",39,"")
insert into helpsql values("expression syntax",40," =       equal to")
insert into helpsql values("expression syntax",41," >       greater than")
insert into helpsql values("expression syntax",42," <       less than")
insert into helpsql values("expression syntax",43," >=      greater than or equal to")
insert into helpsql values("expression syntax",44," <=      less than or equal to")
insert into helpsql values("expression syntax",45," <>      not equal to")
insert into helpsql values("expression syntax",46," !=      not equal to")
insert into helpsql values("expression syntax",47," !>      not greater than")
insert into helpsql values("expression syntax",48," !<      not less than")
insert into helpsql values("expression syntax",49,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("like and wildcards",1,"LIKE and WILDCARDS")
insert into helpsql values("like and wildcards",2,"LIKE is available for char, varchar, and datetime columns.  It can be")
insert into helpsql values("like and wildcards",3,"used with these wildcards:")
insert into helpsql values("like and wildcards",4,"")
insert into helpsql values("like and wildcards",5,"Wildcard       Meaning")
insert into helpsql values("like and wildcards",6,"")
insert into helpsql values("like and wildcards",7," %             any string of 0 or more characters")
insert into helpsql values("like and wildcards",8," _             any single character")
insert into helpsql values("like and wildcards",9," [ ]           any single character within the specified range")
insert into helpsql values("like and wildcards",10,"               ([a-f]) or set ([abcdef])")
insert into helpsql values("like and wildcards",11," [^]           any single character not within the specified")
insert into helpsql values("like and wildcards",12,"               range ([^a-f]) or set ([^abcdef])")
insert into helpsql values("like and wildcards",13,"")
insert into helpsql values("like and wildcards",14,"Enclose the wildcard and the string in single quotation marks.")
insert into helpsql values("like and wildcards",15,"")
insert into helpsql values("functions",1,"FUNCTIONS")
insert into helpsql values("functions",2,"Return special information from the database.  Functions are")
insert into helpsql values("functions",3,"used in SELECT statements and are divided into aggregate functions,")
insert into helpsql values("functions",4,"date functions, mathematical functions, string functions, system")
insert into helpsql values("functions",5,"functions, text/image functions, and type-converion functions.  Each")
insert into helpsql values("functions",6,"of these groups is described separately within the online help.")
insert into helpsql values("functions",7,"")
insert into helpsql values("functions",8,"Help is available for the following function groups:")
insert into helpsql values("functions",9,"")
insert into helpsql values("functions",10,"AGGREGATE    DATE    MATH    STRING    SYSTEM    TEXT    CONVERSION")
insert into helpsql values("aggregate functions",1,"AGGREGATE FUNCTIONS")
insert into helpsql values("aggregate functions",2,"Return summary values.  They can be used in the select")
insert into helpsql values("aggregate functions",3,"list or the HAVING clause of a SELECT statement or subquery,")
insert into helpsql values("aggregate functions",4,"and often appear in a statement that includes a GROUP BY")
insert into helpsql values("aggregate functions",5,"clause.  (A similar type of aggregate function, called a")
insert into helpsql values("aggregate functions",6,"row aggregate function, is used in the COMPUTE clause.)")
insert into helpsql values("aggregate functions",7,"")
insert into helpsql values("aggregate functions",8,"Help is available for the following aggregate functions:")
insert into helpsql values("aggregate functions",9,"")
insert into helpsql values("aggregate functions",10,"SUM     AVG     COUNT     COUNT(*)     MAX     MIN")
insert into helpsql values("sum function",1,"SUM")
insert into helpsql values("sum function",2,"Returns the total of the [DISTINCT] non-null values in the")
insert into helpsql values("sum function",3,"numeric expression.")
insert into helpsql values("sum function",4,"")
insert into helpsql values("sum function",5,"    SUM([DISTINCT] <expression>)")
insert into helpsql values("avg function",1,"AVG")
insert into helpsql values("avg function",2,"Returns the average of the [DISTINCT] non-null values in the ")
insert into helpsql values("avg function",3,"numeric expression.")
insert into helpsql values("avg function",4,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("avg function",5,"    AVG([DISTINCT] <expression>)")
insert into helpsql values("count function",1,"COUNT")
insert into helpsql values("count function",2,"Returns the number of [DISTINCT] non-null values in")
insert into helpsql values("count function",3,"the expression.")
insert into helpsql values("count function",4,"")
insert into helpsql values("count function",5,"    COUNT([DISTINCT]<expression> )")
insert into helpsql values("count(*) function",1,"COUNT(*)")
insert into helpsql values("count(*) function",2,"Returns the number of selected rows.")
insert into helpsql values("count(*) function",3,"")
insert into helpsql values("count(*) function",4,"COUNT(*)")
insert into helpsql values("max function",1,"MAX")
insert into helpsql values("max function",2,"Returns the highest value in the expression.")
insert into helpsql values("max function",3,"")
insert into helpsql values("max function",4,"    MAX(<expression>)")
insert into helpsql values("min function",1,"MIN")
insert into helpsql values("min function",2,"Returns the lowest value in the expression.")
insert into helpsql values("min function",3,"")
insert into helpsql values("min function",4,"    MIN(<expression>)")
insert into helpsql values("conversion function",1,"CONVERSION FUNCTION")
insert into helpsql values("conversion function",2,"Converts expressions of one datatype to another.  Also")
insert into helpsql values("conversion function",3,"obtains a variety of special date formats.")
insert into helpsql values("conversion function",4,"")
insert into helpsql values("conversion function",5,"CONVERT(<datatype> [(<length>)], <expression> [, <style>])")
insert into helpsql values("date functions",1,"DATE FUNCTIONS")
insert into helpsql values("date functions",2,"Manipulate datetime values.")
insert into helpsql values("date functions",3,"")
insert into helpsql values("date functions",4,"Dates are made up of the following parts:")
insert into helpsql values("date functions",5,"")
insert into helpsql values("date functions",6,"Date Part     Abbreviation      Values")
insert into helpsql values("date functions",7,"")
insert into helpsql values("date functions",8,"year          yy                1753 - 9999")
insert into helpsql values("date functions",9,"quarter       qq                1 - 4")
insert into helpsql values("date functions",10,"month         mm                1 - 12")
insert into helpsql values("date functions",11,"day of year   dy                1 - 366")
insert into helpsql values("date functions",12,"day           dd                1 - 31")
insert into helpsql values("date functions",13,"weekday       dw                1 - 7")
insert into helpsql values("date functions",14,"week          wk                1 - 53")
insert into helpsql values("date functions",15,"hour          hh                0 - 23")
insert into helpsql values("date functions",16,"minute        mi                0 - 59")
insert into helpsql values("date functions",17,"second        ss                0 - 59")
insert into helpsql values("date functions",18,"millisecond   ms                0 - 999")
insert into helpsql values("date functions",19,"")
insert into helpsql values("date functions",20,"Help is available on the following date functions:")
insert into helpsql values("date functions",21,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("date functions",22,"GETDATE     DATENAME     DATEPART      DATEDIFF     DATEADD")
insert into helpsql values("getdate function",1,"GETDATE")
insert into helpsql values("getdate function",2,"Returns the current date and time in SQL Server's")
insert into helpsql values("getdate function",3,"standard internal format for datetime values.  GETDATE")
insert into helpsql values("getdate function",4,"takes the NULL parameter ( ).")
insert into helpsql values("getdate function",5,"")
insert into helpsql values("getdate function",6,"    GETDATE( )")
insert into helpsql values("datename function",1,"DATENAME")
insert into helpsql values("datename function",2,"Returns the specified datepart (the first parameter) of")
insert into helpsql values("datename function",3,"the specified date (the second parameter) as a character string.")
insert into helpsql values("datename function",4,"")
insert into helpsql values("datename function",5,"    DATENAME(<datepart>, <date>)")
insert into helpsql values("datepart function",1,"DATEPART")
insert into helpsql values("datepart function",2,"Returns the specified datepart (the first parameter) of")
insert into helpsql values("datepart function",3,"the specified date (the second parameter) as an integer.")
insert into helpsql values("datepart function",4,"")
insert into helpsql values("datepart function",5,"    DATEPART(<datepart>, <date>)")
insert into helpsql values("datediff function",1,"DATEDIFF")
insert into helpsql values("datediff function",2,"Returns the calculated number of dateparts between two")
insert into helpsql values("datediff function",3,"specified dates.  It takes three parameters.  The")
insert into helpsql values("datediff function",4,"first part is a datepart.  The second and third are dates.")
insert into helpsql values("datediff function",5,"The result is a signed integer value equal to <date2> minus")
insert into helpsql values("datediff function",6,"<date1> in dateparts.")
insert into helpsql values("datediff function",7,"")
insert into helpsql values("datediff function",8,"    DATEDIFF(<datepart>, <date1>, <date2>)")
insert into helpsql values("datediff function",9,"")
insert into helpsql values("dateadd function",1,"DATEADD")
insert into helpsql values("dateadd function",2,"Returns a date produced by adding an interval to a date you specify.  It")
insert into helpsql values("dateadd function",3,"takes three parameters: <datepart>, <number>, and <date>.  The result")
insert into helpsql values("dateadd function",4,"is a datetime value equal to the date plus the number of dateparts.")
insert into helpsql values("dateadd function",5,"")
insert into helpsql values("dateadd function",6,"   DATEADD (<datepart>, <number>, <date>)")
insert into helpsql values("dateadd function",7,"")
insert into helpsql values("mathematical functions",1,"MATHEMATICAL FUNCTIONS")
insert into helpsql values("mathematical functions",2,"Return values commonly needed for operations on mathematical data.")
insert into helpsql values("mathematical functions",3,"Mathematical function names are not keywords.")
insert into helpsql values("mathematical functions",4,"")
insert into helpsql values("mathematical functions",5,"Help is available for the following mathematical functions:")
insert into helpsql values("mathematical functions",6,"")
insert into helpsql values("mathematical functions",7,"ABS         ACOS         ASIN         ATAN         ATN2")
insert into helpsql values("mathematical functions",8,"CEILING     COS          COT          DEGREES      EXP")
insert into helpsql values("mathematical functions",9,"FLOOR       LOG          LOG10        PI           POWER")
insert into helpsql values("mathematical functions",10,"RADIANS     RAND         ROUND        SIGN         SIN")
insert into helpsql values("mathematical functions",11,"SQRT        TAN")
insert into helpsql values("mathematical functions",12,"")
insert into helpsql values("abs function",1,"ABS")
go
dump transaction master with truncate_only
go
insert into helpsql values("abs function",2,"Returns the absolute value of an expression.")
insert into helpsql values("abs function",3,"The expression can be of integer, float, or money type.")
insert into helpsql values("abs function",4,"Results are of the same type as the numeric expression.")
insert into helpsql values("abs function",5,"")
insert into helpsql values("abs function",6,"    ABS(<numeric_expr>)")
insert into helpsql values("abs function",7,"")
insert into helpsql values("acos function",1,"ACOS")
insert into helpsql values("acos function",2,"Returns an angle (in radians) whose cosine is")
insert into helpsql values("acos function",3,"the specified floating-point value.")
insert into helpsql values("acos function",4,"")
insert into helpsql values("acos function",5,"    ACOS(<float_expr>)")
insert into helpsql values("acos function",6,"")
insert into helpsql values("asin function",1,"ASIN")
insert into helpsql values("asin function",2,"Returns an angle (in radians) whose sine is")
insert into helpsql values("asin function",3,"the specified floating-point value.")
insert into helpsql values("asin function",4,"")
insert into helpsql values("asin function",5,"    ASIN(<float_expr>)")
insert into helpsql values("asin function",6,"")
insert into helpsql values("atan function",1,"ATAN")
insert into helpsql values("atan function",2,"Returns an angle (in radians) whose tangent is")
insert into helpsql values("atan function",3,"the specified floating-point value.")
insert into helpsql values("atan function",4,"")
insert into helpsql values("atan function",5,"    ATAN(<float_expr>)")
insert into helpsql values("atan function",6,"")
insert into helpsql values("atn2 function",1,"ATN2")
insert into helpsql values("atn2 function",2,"Returns an angle (in radians) whose tangent is")
insert into helpsql values("atn2 function",3,"the specified (<float_expr1>|<float_expr2>).")
insert into helpsql values("atn2 function",4,"")
insert into helpsql values("atn2 function",5,"    ATN2(<float_expr1>, <float_expr2>)")
insert into helpsql values("atn2 function",6,"")
insert into helpsql values("ceiling function",1,"CEILING")
insert into helpsql values("ceiling function",2,"Returns the smallest integer greater than or equal")
insert into helpsql values("ceiling function",3,"to the specified value.  The expression can be of")
insert into helpsql values("ceiling function",4,"Integer, Float, or Money type.  Results are of the")
insert into helpsql values("ceiling function",5,"same type as the numeric expression.")
insert into helpsql values("ceiling function",6,"")
insert into helpsql values("ceiling function",7,"    CEILING(<numeric_expr>)")
insert into helpsql values("ceiling function",8,"")
insert into helpsql values("cos function",1,"COS")
insert into helpsql values("cos function",2,"Returns the trigonometric cosine of the specified")
insert into helpsql values("cos function",3,"angle (in radians).")
insert into helpsql values("cos function",4,"")
insert into helpsql values("cos function",5,"    COS(<float_expr>)")
insert into helpsql values("cos function",6,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("cot function",1,"COT")
insert into helpsql values("cot function",2,"Returns the trigonometric cotangent of the specified")
insert into helpsql values("cot function",3,"angle (in radians).")
insert into helpsql values("cot function",4,"")
insert into helpsql values("cot function",5,"    COT(<float_expr>)")
insert into helpsql values("cot function",6,"")
insert into helpsql values("degrees function",1,"DEGREES")
insert into helpsql values("degrees function",2,"Converts radians to degrees.")
insert into helpsql values("degrees function",4,"")
insert into helpsql values("degrees function",5,"    DEGREES(<numeric_expr>)")
insert into helpsql values("degrees function",6,"")
insert into helpsql values("exp function",1,"EXP")
insert into helpsql values("exp function",2,"Returns the exponential value of the specified")
insert into helpsql values("exp function",3,"value.")
insert into helpsql values("exp function",4,"")
insert into helpsql values("exp function",5,"    EXP(<float_expr>)")
insert into helpsql values("exp function",6,"")
insert into helpsql values("floor function",1,"FLOOR")
insert into helpsql values("floor function",2,"Returns the largest integer less than or equal")
insert into helpsql values("floor function",3,"to the specified value.  The expression can be of")
insert into helpsql values("floor function",4,"Integer, Float, or Money type.  Results are of the")
insert into helpsql values("floor function",5,"same type as the numeric expression.")
insert into helpsql values("floor function",6,"")
insert into helpsql values("floor function",7,"    FLOOR(<numeric_expr>)")
insert into helpsql values("floor function",8,"")
insert into helpsql values("log function",1,"LOG")
insert into helpsql values("log function",2,"Returns the natural logarithm of the specified value.")
insert into helpsql values("log function",3,"")
insert into helpsql values("log function",4,"    LOG(<float_expr>)")
insert into helpsql values("log function",5,"")
insert into helpsql values("log10 function",1,"LOG10")
insert into helpsql values("log10 function",2,"Returns the base 10 logarithm of the specified value.")
insert into helpsql values("log10 function",3,"")
insert into helpsql values("log10 function",4,"    LOG10(<float_expr>)")
insert into helpsql values("log10 function",5,"")
insert into helpsql values("pi function",1,"PI")
insert into helpsql values("pi function",2,"Returns the constant value of 3.1415926535897936.")
insert into helpsql values("pi function",3,"")
insert into helpsql values("pi function",4,"    PI()")
insert into helpsql values("power function",1,"POWER")
insert into helpsql values("power function",2,"Returns the value of <numeric_expr> to the power")
insert into helpsql values("power function",3,"of <y>. The expression and y can be of Integer,")
insert into helpsql values("power function",4,"Float, or Money type.  Results are of the same")
insert into helpsql values("power function",5,"type as the numeric expression.")
go
dump transaction master with truncate_only
go
insert into helpsql values("power function",6,"")
insert into helpsql values("power function",7,"    POWER(<numeric_expr>, <y>)")
insert into helpsql values("radians function",1,"RADIANS")
insert into helpsql values("radians function",2,"Converts degrees to radians.  The expression can be")
insert into helpsql values("radians function",3,"of Integer, Float, or Money type.  Results are of the")
insert into helpsql values("radians function",4,"same type as the numeric expression")
insert into helpsql values("radians function",5,"")
insert into helpsql values("radians function",6,"    RADIANS(<numeric_expr>)")
insert into helpsql values("rand function",1,"RAND")
insert into helpsql values("rand function",2,"Returns a random floating-point number between 0 and 1, using")
insert into helpsql values("rand function",3,"<integer_expr> as the optional seed.")
insert into helpsql values("rand function",4,"")
insert into helpsql values("rand function",5,"    RAND([integer_expr])")
insert into helpsql values("round function",1,"ROUND")
insert into helpsql values("round function",2,"Rounds off a numeric expression to the precision")
insert into helpsql values("round function",3,"specified in <integer_expr>.  The expression can")
insert into helpsql values("round function",4,"be of Integer, Float, or Money type.  Results")
insert into helpsql values("round function",5,"are of the same type as the numeric expression.")
insert into helpsql values("round function",6,"")
insert into helpsql values("round function",7,"    ROUND(<numeric_expr>, <integer_expr>)")
insert into helpsql values("sign function",1,"SIGN")
insert into helpsql values("sign function",2,"Returns positive (+1), zero (0), or negative (-1).")
insert into helpsql values("sign function",3,"The expression can be of Integer, Float, or Money type.")
insert into helpsql values("sign function",4,"Results are of the same type as the numeric expression.")
insert into helpsql values("sign function",5,"")
insert into helpsql values("sign function",6,"    SIGN(<numeric_expr>)")
insert into helpsql values("sin function",1,"SIN")
insert into helpsql values("sin function",2,"Returns the trigonometric sine of the specified")
insert into helpsql values("sin function",3,"angle (measured in radians).")
insert into helpsql values("sin function",4,"")
insert into helpsql values("sin function",5,"    SIN(<float_expr>)")
insert into helpsql values("sqrt function",1,"SQRT")
insert into helpsql values("sqrt function",2,"Returns the square root of the specified value.")
insert into helpsql values("sqrt function",3,"")
insert into helpsql values("sqrt function",4,"    SQRT(<float_expr>)")
insert into helpsql values("tan function",1,"TAN")
insert into helpsql values("tan function",2,"Returns the trigonometric tangent of the specified")
insert into helpsql values("tan function",3,"angle (measured in radians).")
insert into helpsql values("tan function",4,"")
insert into helpsql values("tan function",5,"    TAN(<float_expr>)")
insert into helpsql values("string functions",1,"STRING FUNCTIONS")
insert into helpsql values("string functions",2,"Perform various operations on binary data, character")
insert into helpsql values("string functions",3,"strings, or expressions, including concatenation. Built-in")
insert into helpsql values("string functions",4,"string functions return values commonly needed for")
go
dump transaction master with truncate_only
go
insert into helpsql values("string functions",5,"operations on character data.")
insert into helpsql values("string functions",6,"")
insert into helpsql values("string functions",7,"Help is available for the following string functions:")
insert into helpsql values("string functions",8,"")
insert into helpsql values("string functions",9,"ASCII     CHAR       CHARINDEX     DATALENGTH     DIFFERENCE")
insert into helpsql values("string functions",10,"LOWER     LTRIM      PATINDEX      REPLICATE      REVERSE")
insert into helpsql values("string functions",11,"RIGHT     RTRIM      SOUNDEX       SPACE          STR")
insert into helpsql values("string functions",12,"STUFF     SUBSTRING  UPPER         +")
insert into helpsql values("ascii function",1,"ASCII")
insert into helpsql values("ascii function",2,"Returns the ASCII code value of the leftmost character of")
insert into helpsql values("ascii function",3,"a character expression.")
insert into helpsql values("ascii function",4,"")
insert into helpsql values("ascii function",5,"    ASCII(<char_expr>)")
insert into helpsql values("char function",1,"CHAR")
insert into helpsql values("char function",2,"Converts an ASCII code into a character.  The ASCII code")
insert into helpsql values("char function",3,"should be between 0 and 255; otherwise, NULL is returned.")
insert into helpsql values("char function",4,"")
insert into helpsql values("char function",5,"    CHAR(<integer_expr>)")
insert into helpsql values("charindex function",1,"CHARINDEX")
insert into helpsql values("charindex function",2,"Returns the starting position of the specified character expression.")
insert into helpsql values("charindex function",3,"The first parameter is the character expression.  The second parameter")
insert into helpsql values("charindex function",4,"is an expression, usually a column name, in which SQL Server")
insert into helpsql values("charindex function",5,"searchs for the character expression.  Not used with")
insert into helpsql values("charindex function",6,"Text and Image data.")
insert into helpsql values("charindex function",7,"")
insert into helpsql values("charindex function",8,"    CHARINDEX(<'char_expr'>, <expression>)")
insert into helpsql values("datalength function",1,"DATALENGTH")
insert into helpsql values("datalength function",2,"Returns the length of any type of data value or text field.")
insert into helpsql values("datalength function",3,"A null string returns a length of 1.")
insert into helpsql values("datalength function",4,"")
insert into helpsql values("datalength function",5,"DATALENGTH(<anytype_expr>)")
insert into helpsql values("difference function",1,"DIFFERENCE")
insert into helpsql values("difference function",2,"Returns the difference between the values of two character")
insert into helpsql values("difference function",3,"expressions as returned by the SOUNDEX function.")
insert into helpsql values("difference function",4,"")
insert into helpsql values("difference function",5,"    DIFFERENCE(<char_expr1>, <char_expr2>)")
insert into helpsql values("lower function",1,"LOWER")
insert into helpsql values("lower function",2,"Converts uppercase to lowercase.")
insert into helpsql values("lower function",3,"")
insert into helpsql values("lower function",4,"    LOWER(<char_expr>)")
insert into helpsql values("ltrim function",1,"LTRIM")
insert into helpsql values("ltrim function",2,"Removes leading blanks.")
insert into helpsql values("ltrim function",3,"")
insert into helpsql values("ltrim function",4,"    LTRIM(<char_expr>)")
go
dump transaction master with truncate_only
go
insert into helpsql values("ltrim function",5,"")
insert into helpsql values("patindex function",1,"PATINDEX")
insert into helpsql values("patindex function",2,"Returns the starting position of the first occurrence of <pattern>")
insert into helpsql values("patindex function",3,"in the specified column, or zeros if the pattern is not found. You")
insert into helpsql values("patindex function",4,"can use wildcard characters in <pattern> as long as % precedes and")
insert into helpsql values("patindex function",5,"follows <pattern>.")
insert into helpsql values("patindex function",6,"")
insert into helpsql values("patindex function",7,"    PATINDEX('%<pattern>%', <column_name>)")
insert into helpsql values("patindex function",8,"")
insert into helpsql values("replicate function",1,"REPLICATE")
insert into helpsql values("replicate function",2,"Repeats a character expression a specified number of times.")
insert into helpsql values("replicate function",3,"If <integer_expr> is negative, a null string is returned.")
insert into helpsql values("replicate function",4,"")
insert into helpsql values("replicate function",5,"    REPLICATE(<char_expr>, <integer_expr>)")
insert into helpsql values("replicate function",6,"")
insert into helpsql values("reverse function",1,"REVERSE")
insert into helpsql values("reverse function",2,"Returns the reverse of <char_expr>. The <char_expr> parameter can be")
insert into helpsql values("reverse function",3,"a constant, variable, or column.")
insert into helpsql values("reverse function",4,"")
insert into helpsql values("reverse function",5,"    REVERSE(<char_expr>)")
insert into helpsql values("reverse function",6,"")
insert into helpsql values("right function",1,"RIGHT")
insert into helpsql values("right function",2,"Returns part of a character string starting <integer_expr>")
insert into helpsql values("right function",3,"characters from the right.  If <integer_expr> is negative,")
insert into helpsql values("right function",4,"a null string is returned.")
insert into helpsql values("right function",5,"")
insert into helpsql values("rignt function",6,"    RIGHT(<char_expr>, <integer_expr>)")
insert into helpsql values("rtrim function",1,"RTRIM")
insert into helpsql values("rtrim function",2,"Removes trailing blanks.")
insert into helpsql values("rtrim function",3,"")
insert into helpsql values("rtrim function",4,"    RTRIM(<char_expr>)")
insert into helpsql values("soundex function",1,"SOUNDEX")
insert into helpsql values("soundex function",2,"Returns a 4-digit (SOUNDEX) code for use in evaluating")
insert into helpsql values("soundex function",3,"the similarity of two strings.")
insert into helpsql values("soundex function",4,"")
insert into helpsql values("soundex function",5,"    SOUNDEX(<char_expr>)")
insert into helpsql values("space function",1,"SPACE")
insert into helpsql values("space function",2,"Returns a string of repeated spaces. The number of spaces")
insert into helpsql values("space function",3,"is equal to <integer_expr>.  If <integer_expr> is negative, a")
insert into helpsql values("space function",4,"null string is returned.")
insert into helpsql values("space function",5,"    SPACE(<integer_expr>)")
insert into helpsql values("str function",1,"STR")
insert into helpsql values("str function",2,"Converts numeric data to character data.")
insert into helpsql values("str function",3,"")
insert into helpsql values("str function",4,"    STR(<float_expr>[, <length>[, <decimal>]])")
go
dump transaction master with truncate_only
go
insert into helpsql values("stuff function",1,"STUFF")
insert into helpsql values("stuff function",2,"Deletes <length> characters from <char_expr1> at <start>,")
insert into helpsql values("stuff function",3,"then inserts <char_expr2> into <char_expr1> at <start>.  Not")
insert into helpsql values("stuff function",4,"used with Text or Image data.")
insert into helpsql values("stuff function",5,"    STUFF(<char_expr1>, <start>, <length>, <char_expr2>)")
insert into helpsql values("substring function",1,"SUBSTRING")
insert into helpsql values("substring function",2,"Returns part of a character or binary string.  The first")
insert into helpsql values("substring function",3,"parameter can be a character or binary string, a column")
insert into helpsql values("substring function",4,"name, or an expression that includes a column name.  The")
insert into helpsql values("substring function",5,"second parameter specifies the position at which the")
insert into helpsql values("substring function",6,"substring begins.  The third parameter specifies the number")
insert into helpsql values("substring function",7,"of characters in the substring.  Not used with Text or Image")
insert into helpsql values("substring function",8,"data.")
insert into helpsql values("substring function",9,"")
insert into helpsql values("substring function",10,"    SUBSTRING(<expression>, <start>, <length>)")
insert into helpsql values("upper function",1,"UPPER")
insert into helpsql values("upper function",2,"Converts lowercase to uppercase.")
insert into helpsql values("upper function",3,"")
insert into helpsql values("upper function",4,"    UPPER(<char_expr>)")
insert into helpsql values("+ function",1,"+")
insert into helpsql values("+ function",2,"Concatenates two or more character strings, binary")
insert into helpsql values("+ function",3,"strings, column names, or a combination of them.")
insert into helpsql values("+ function",4,"Enclose character string in single quoatation marks.")
insert into helpsql values("+ function",5,"")
insert into helpsql values("+ function",6,"<expression> + <expression>")
insert into helpsql values("system functions",1,"SYSTEM FUNCTIONS")
insert into helpsql values("system functions",2,"Return special information from the database.")
insert into helpsql values("system functions",3,"")
insert into helpsql values("system functions",4,"Help is available on the following system functions:")
insert into helpsql values("system functions",5,"")
insert into helpsql values("system functions",6,"COL_NAME     COL_LENGTH     DATALENGTH   DB_ID       DB_NAME")
insert into helpsql values("system functions",7,"HOST_ID      HOST_NAME      INDEX_COL    ISNULL      OBJECT_ID")
insert into helpsql values("system functions",8,"OBJECT_NAME  SUSER_ID       SUSER_NAME   USER_ID     USER_NAME")
insert into helpsql values("col_name function",1,"COL_NAME")
insert into helpsql values("col_name function",2,"Returns the column name.")
insert into helpsql values("col_name function",3,"")
insert into helpsql values("col_name function",4,"    COL_NAME(<object_id>, <column_id>)")
insert into helpsql values("col_length function",1,"COL_LENGTH")
insert into helpsql values("col_length function",2,"Returns the column length.")
insert into helpsql values("col_length function",3,"")
insert into helpsql values("col_length function",4,"   COL_LENGTH(<'object_name'>, <'column_name'>)")
insert into helpsql values("db_id function",1,"DB_ID")
insert into helpsql values("db_id function",2,"Returns the database identification number.")
insert into helpsql values("db_id function",3,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("db_id function",4,"DB_ID([<'database_name'>])")
insert into helpsql values("db_name function",1,"DB_NAME")
insert into helpsql values("db_name function",2,"Returns the database name.")
insert into helpsql values("db_name function",3,"")
insert into helpsql values("db_name function",4,"    DB_NAME([<database_id>])")
insert into helpsql values("host_id function",1,"HOST_ID")
insert into helpsql values("host_id function",2,"Returns the workstation identification number.")
insert into helpsql values("host_id function",3,"")
insert into helpsql values("host_id function",4,"    HOST_ID( )")
insert into helpsql values("host_name function",1,"HOST_NAME")
insert into helpsql values("host_name function",2,"Returns the current workstation name.")
insert into helpsql values("host_name function",3,"")
insert into helpsql values("host_name function",4,"    HOST_NAME( )")
insert into helpsql values("index_col function",1,"INDEX_COL")
insert into helpsql values("index_col function",2,"Returns the indexed column name.")
insert into helpsql values("index_col function",3,"")
insert into helpsql values("index_col function",4,"    INDEX_COL(<'object_name'>, <index_id>, <key>)")
insert into helpsql values("isnull function",1,"ISNULL")
insert into helpsql values("isnull function",2,"Returns the NULL entries with the specified value.")
insert into helpsql values("isnull function",3,"")
insert into helpsql values("isnull function",4,"    ISNULL(<expression>, <value>)")
insert into helpsql values("object_id function",1,"OBJECT_ID")
insert into helpsql values("object_id function",2,"Returns the database object identification number.")
insert into helpsql values("object_id function",3,"")
insert into helpsql values("object_id function",4,"    OBJECT_ID(<'database_object_name'>)")
insert into helpsql values("object_name function",1,"OBJECT_NAME")
insert into helpsql values("object_name function",2,"Returns the database object name.")
insert into helpsql values("object_name function",3,"")
insert into helpsql values("object_name function",4,"    OBJECT_NAME(<database_object_id>)")
insert into helpsql values("suser_id function",1,"SUSER_ID")
insert into helpsql values("suser_id function",2,"Returns the server user's login identification number.")
insert into helpsql values("suser_id function",3,"")
insert into helpsql values("suser_id function",4,"    SUSER_ID([<'server_username'>])")
insert into helpsql values("suser_name function",1,"SUSER_NAME")
insert into helpsql values("suser_name function",2,"Returns the server user's login identification.")
insert into helpsql values("suser_name function",3,"")
insert into helpsql values("suser_name function",4,"    SUSER_NAME([<server_user_id>])")
insert into helpsql values("user_id function",1,"USER_ID")
insert into helpsql values("user_id function",2,"Returns the user's database identification number.")
insert into helpsql values("user_id function",3,"")
insert into helpsql values("user_id function",4,"    USER_ID([<'username'>])")
insert into helpsql values("user_name function",1,"USER_NAME")
insert into helpsql values("user_name function",2,"Returns the user's name.")
insert into helpsql values("user_name function",3,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("user_name function",4,"    USER_NAME([<user_id>])")
insert into helpsql values("text functions",1,"TEXT/IMAGE FUNCTIONS")
insert into helpsql values("text functions",2,"Return values commonly needed for operations")
insert into helpsql values("text functions",3,"on Text and Image data.  Text and Image built-in")
insert into helpsql values("text functions",4,"function names are not keywords.")
insert into helpsql values("text functions",5,"")
insert into helpsql values("text functions",6,"Help is available on the following text functions:")
insert into helpsql values("text functions",7,"")
insert into helpsql values("text functions",8,"PATINDEX     TEXTPTR     TEXTVALID     TEXTSIZE")
insert into helpsql values("textptr function",1,"TEXTPTR")
insert into helpsql values("textptr function",2,"Returns the text pointer value in Varbinary format.  The")
insert into helpsql values("textptr function",3,"text pointer is checked to ensure that it points to the")
insert into helpsql values("textptr function",4,"first text page.")
insert into helpsql values("textptr function",5,"")
insert into helpsql values("textptr function",6,"    TEXTPTR(<column_name>)")
insert into helpsql values("textvalid function",1,"TEXTVALID")
insert into helpsql values("textvalid function",2,"Checks whether a given text pointer is valid.  Note that the")
insert into helpsql values("textvalid function",3,"identifier for the text column must include the table name.")
insert into helpsql values("textvalid function",4,"Returns 1 if the pointer is valid and 0 if the pointer")
insert into helpsql values("textvalid function",5,"is invalid.")
insert into helpsql values("textvalid function",6,"")
insert into helpsql values("textvalid function",7,"    TEXTVALID(<'table_name.column_name'>, <text_ptr>)")
insert into helpsql values("textsize function",1,"SET TEXTSIZE")
insert into helpsql values("textsize function",2,"A SET option that specifies the limit in bytes of the Text")
insert into helpsql values("textsize function",3,"or Image data to be returned with a SELECT statement.  The")
insert into helpsql values("textsize function",4,"current setting is stored in the @@TEXTSIZE global variable.")
insert into helpsql values("textsize function",5,"<n> is an integer that specifies the limit on the number of bytes")
insert into helpsql values("textsize function",6,"to be returned.  0 restores the default limit (4K).")
insert into helpsql values("textsize function",7,"")
insert into helpsql values("textsize function",8,"    SET TEXTSIZE {<n> | 0}")
insert into helpsql values("sp_addalias",1,"sp_addalias")
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_addalias",5,"")
insert into helpsql values("sp_addgroup",1,"sp_addgroup")
insert into helpsql values("sp_addgroup",2,"Adds a group to a database.")
insert into helpsql values("sp_addgroup",3,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_addgroup",4,"   sp_addgroup <grpname>")
insert into helpsql values("sp_addgroup",5,"")
insert into helpsql values("sp_addlogin",1,"sp_addlogin")
insert into helpsql values("sp_addlogin",2,"Authorizes a new SQL Server user by adding a login ID.")
insert into helpsql values("sp_addlogin",3,"")
insert into helpsql values("sp_addlogin",4,"   sp_addlogin <login_id> [, <passwd> [, <defdb> [, <deflanguage>]]]")
insert into helpsql values("sp_addlogin",5,"")
insert into helpsql values("sp_addremotelogin",1,"sp_addremotelogin")
insert into helpsql values("sp_addremotelogin",2,"")
insert into helpsql values("sp_addremotelogin",3,"Adds a remote login ID to the master.dbo.sysremotelogins system table.")
insert into helpsql values("sp_addremotelogin",4,"")
insert into helpsql values("sp_addremotelogin",5,"   sp_addremotelogin <remoteserver> [, <local_loginame> [, <remotename>]]")
insert into helpsql values("sp_addremotelogin",6,"")
insert into helpsql values("sp_addsegment",1,"sp_addsegment")
insert into helpsql values("sp_addsegment",2,"")
insert into helpsql values("sp_addsegment",3,"Defines a segment on a database device in the current database.")
insert into helpsql values("sp_addsegment",4,"")
insert into helpsql values("sp_addsegment",5,"   sp_addsegment <segname>, <logical_name>")
insert into helpsql values("sp_addsegment",6,"")
insert into helpsql values("sp_addserver",1,"sp_addserver")
insert into helpsql values("sp_addserver",2,"")
insert into helpsql values("sp_addserver",3,"Defines a remote server or defines the name of the local server.")
insert into helpsql values("sp_addserver",4,"")
insert into helpsql values("sp_addserver",5,"   sp_addserver <server_name> [, local]")
insert into helpsql values("sp_addserver",6,"")
insert into helpsql values("sp_addtype",1,"sp_addtype")
insert into helpsql values("sp_addtype",2,"")
insert into helpsql values("sp_addtype",3,"Creates a user-defined datatype.")
insert into helpsql values("sp_addtype",4,"")
insert into helpsql values("sp_addtype",5,"   sp_addtype <typename>, <phystype>[(<length>)] [, <nulltype>]")
insert into helpsql values("sp_addtype",6,"")
insert into helpsql values("sp_addumpdevice",1,"sp_addumpdevice")
insert into helpsql values("sp_addumpdevice",2,"")
insert into helpsql values("sp_addumpdevice",3,"Adds a dump device to SQL Server.")
insert into helpsql values("sp_addumpdevice",4,"")
insert into helpsql values("sp_addumpdevice",5,"   sp_addumpdevice 'DISK' | 'DISKETTE' | 'TAPE', <logical_name>,")
insert into helpsql values("sp_addumpdevice",6,"     <physical_name>, <cntrltype> [, NOSKIP | SKIP [, <media_capacity>]]")
insert into helpsql values("sp_addumpdevice",7,"")
insert into helpsql values("sp_adduser",1,"")
insert into helpsql values("sp_adduser",2,"sp_adduser")
insert into helpsql values("sp_adduser",3,"")
insert into helpsql values("sp_adduser",4,"Adds a new user to the current database.")
insert into helpsql values("sp_adduser",5,"")
insert into helpsql values("sp_adduser",6,"   sp_adduser <login_id> [, <username> [, <grpname>]]")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_adduser",7,"")
insert into helpsql values("sp_bindefault",1,"sp_bindefault")
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_bindefault",5,"")
insert into helpsql values("sp_bindrule",1,"sp_bindrule")
insert into helpsql values("sp_bindrule",2,"Binds a rule to a column or user datatype.")
insert into helpsql values("sp_bindrule",3,"")
insert into helpsql values("sp_bindrule",4,"   sp_bindrule <rule_name>, <objname> [, FUTUREONLY]")
insert into helpsql values("sp_bindrule",5,"")
insert into helpsql values("sp_changedbowner",1,"sp_changedbowner")
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>")
insert into helpsql values("sp_changedbowner",5,"")
insert into helpsql values("sp_changegroup",1,"sp_changegroup")
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_changegroup",5,"")
insert into helpsql values("sp_checknames",1,"sp_checknames")
insert into helpsql values("sp_checknames",2,"Checks the current database for names that contain characters not in the")
insert into helpsql values("sp_checknames",3," 7-bit ASCII set.")
insert into helpsql values("sp_checknames",4,"")
insert into helpsql values("sp_checknames",5,"   sp_checknames")
insert into helpsql values("sp_checknames",6,"")
insert into helpsql values("sp_commonkey",1,"sp_commonkey")
insert into helpsql values("sp_commonkey",2,"Defines a common key between two tables or views.")
insert into helpsql values("sp_commonkey",3,"")
insert into helpsql values("sp_commonkey",4,"   sp_commonkey <tabaname>, <tabbname>, <col1a>, <col1b> [, <col2a>,")
insert into helpsql values("sp_commonkey",5,"     <col2b>, ... <col8a>, <col8b>]")
insert into helpsql values("sp_commonkey",6,"")
insert into helpsql values("sp_configure",1,"sp_configure")
insert into helpsql values("sp_configure",2,"Displays or changes configuration options.")
insert into helpsql values("sp_configure",3,"")
insert into helpsql values("sp_configure",4,"   sp_configure [<config_name> [, <config_value>]]")
insert into helpsql values("sp_configure",5,"")
insert into helpsql values("sp_dboption",1,"sp_dboption")
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_dboption",5,"")
insert into helpsql values("sp_defaultdb",1,"sp_defaultdb")
go
dump transaction master with truncate_only
go
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_defaultdb",5,"")
insert into helpsql values("sp_defaultlanguage",1,"sp_defaultlanguage")
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_defaultlanguage",5,"")
insert into helpsql values("sp_depends",1,"sp_depends")
insert into helpsql values("sp_depends",2,"Displays information about database object dependencies.")
insert into helpsql values("sp_depends",3,"")
insert into helpsql values("sp_depends",4,"   sp_depends <objname>")
insert into helpsql values("sp_depends",5,"")
insert into helpsql values("sp_diskdefault",1,"sp_diskdefault")
insert into helpsql values("sp_diskdefault",2,"Sets a database device's status to DEFAULTON or DEFAULTOFF.")
insert into helpsql values("sp_diskdefault",3,"")
insert into helpsql values("sp_diskdefault",4,"   sp_diskdefault <database_device>, {DEFAULTON | DEFAULTOFF}")
insert into helpsql values("sp_diskdefault",5,"")
insert into helpsql values("sp_dropalias",1,"sp_dropalias")
insert into helpsql values("sp_dropalias",2,"Removes an alias login ID.")
insert into helpsql values("sp_dropalias",3,"")
insert into helpsql values("sp_dropalias",4,"   sp_dropalias <login_id>")
insert into helpsql values("sp_dropalias",5,"")
insert into helpsql values("sp_dropdevice",1,"sp_dropdevice")
insert into helpsql values("sp_dropdevice",2,"Removes a database device or dump device.")
insert into helpsql values("sp_dropdevice",3,"")
insert into helpsql values("sp_dropdevice",4,"   sp_dropdevice <logical_name>")
insert into helpsql values("sp_dropdevice",5,"")
insert into helpsql values("sp_dropgroup",1,"sp_dropgroup")
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_dropgroup",5,"")
insert into helpsql values("sp_dropkey",1,"sp_dropkey")
insert into helpsql values("sp_dropkey",2,"Removes a key that had been defined using")
insert into helpsql values("sp_dropkey",3,"sp_primarykey, sp_foreignkey, or sp_commonkey.")
insert into helpsql values("sp_dropkey",4,"")
insert into helpsql values("sp_dropkey",5,"   sp_dropkey <keytype>, <tabname> [, <deptabname>]")
insert into helpsql values("sp_dropkey",6,"")
insert into helpsql values("sp_droplanguage",1,"sp_droplanguage")
insert into helpsql values("sp_droplanguage",2,"Removes an alternate language from the server.")
insert into helpsql values("sp_droplanguage",3,"")
insert into helpsql values("sp_droplanguage",4,"   sp_droplanguage <language> [, DROPMESSAGES]")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_droplanguage",5,"")
insert into helpsql values("sp_droplogin",1,"sp_droplogin")
insert into helpsql values("sp_droplogin",2,"Removes a SQL Server login_id.")
insert into helpsql values("sp_droplogin",3,"")
insert into helpsql values("sp_droplogin",4,"   sp_droplogin <login_id>")
insert into helpsql values("sp_droplogin",5,"")
insert into helpsql values("sp_dropremotelogin",1,"sp_dropremotelogin")
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_dropremotelogin",5,"")
insert into helpsql values("sp_dropsegment",1,"sp_dropsegment")
insert into helpsql values("sp_dropsegment",2,"Removes a segment from a database or unmaps a segment from")
insert into helpsql values("sp_dropsegment",3,"a database device.")
insert into helpsql values("sp_dropsegment",4,"")
insert into helpsql values("sp_dropsegment",5,"   sp_dropsegment <segname> [, <logical_name>]")
insert into helpsql values("sp_dropsegment",6,"")
insert into helpsql values("sp_dropserver",1,"sp_dropserver")
insert into helpsql values("sp_dropserver",2,"Removes a server from the list of known servers.")
insert into helpsql values("sp_dropserver",3,"")
insert into helpsql values("sp_dropserver",4,"   sp_dropserver <server_name> [, <droplogins>]")
insert into helpsql values("sp_dropserver",5,"")
insert into helpsql values("sp_droptype",1,"sp_droptype")
insert into helpsql values("sp_droptype",2,"Removes a user-defined datatype.")
insert into helpsql values("sp_droptype",3,"")
insert into helpsql values("sp_droptype",4,"   sp_droptype <typename>")
insert into helpsql values("sp_droptype",5,"")
insert into helpsql values("sp_dropuser",1,"sp_dropuser")
insert into helpsql values("sp_dropuser",2,"Removes a user from the current database.")
insert into helpsql values("sp_dropuser",3,"")
insert into helpsql values("sp_dropuser",4,"   sp_dropuser <username>")
insert into helpsql values("sp_dropuser",5,"")
insert into helpsql values("sp_extendsegment",1,"sp_extendsegment")
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_extendsegment",5,"")
insert into helpsql values("sp_foreignkey",1,"sp_foreignkey")
insert into helpsql values("sp_foreignkey",2,"Defines a foreign key in a table or view.")
insert into helpsql values("sp_foreignkey",3,"")
insert into helpsql values("sp_foreignkey",4,"   sp_foreignkey <tabname>, <pktabname>, <col1> [, <col2>,")
insert into helpsql values("sp_foreignkey",5,"     <col3>, ..., <col8>]")
insert into helpsql values("sp_foreignkey",6,"")
insert into helpsql values("sp_help",1,"sp_help")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_help",2,"Reports information about a database object or about a SQL")
insert into helpsql values("sp_help",3,"Server-supplied or user-defined datatype.")
insert into helpsql values("sp_help",4,"")
insert into helpsql values("sp_help",5,"   sp_help [<objname>]")
insert into helpsql values("sp_help",6,"")
insert into helpsql values("sp_helpdb",1,"sp_helpdb")
insert into helpsql values("sp_helpdb",2,"Reports information about a database or about all databases.")
insert into helpsql values("sp_helpdb",3,"")
insert into helpsql values("sp_helpdb",4,"   sp_helpdb [<dbname>]")
insert into helpsql values("sp_helpdb",5,"")
insert into helpsql values("sp_helpdevice",1,"sp_helpdevice")
insert into helpsql values("sp_helpdevice",2,"Reports information about SQL Server's database devices and dump")
insert into helpsql values("sp_helpdevice",3,"devices.")
insert into helpsql values("sp_helpdevice",4,"")
insert into helpsql values("sp_helpdevice",5,"   sp_helpdevice [<logical_name>]")
insert into helpsql values("sp_helpdevice",6,"")
insert into helpsql values("sp_helpgroup",1,"sp_helpgroup")
insert into helpsql values("sp_helpgroup",2,"Reports information about a group or about all groups in the current")
insert into helpsql values("sp_helpgroup",3,"database.")
insert into helpsql values("sp_helpgroup",4,"")
insert into helpsql values("sp_helpgroup",5,"   sp_helpgroup [<grpname>]")
insert into helpsql values("sp_helpgroup",6,"")
insert into helpsql values("sp_helpindex",1,"sp_helpindex")
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>")
insert into helpsql values("sp_helpindex",5,"")
insert into helpsql values("sp_helpjoins",1,"sp_helpjoins")
insert into helpsql values("sp_helpjoins",2,"Lists the columns in two tables or views that are likely to be joined.")
insert into helpsql values("sp_helpjoins",3,"")
insert into helpsql values("sp_helpjoins",4,"   sp_helpjoins <lafttab>, <righttab>")
insert into helpsql values("sp_helpjoins",5,"")
insert into helpsql values("sp_helpkey",1,"sp_helpkey")
insert into helpsql values("sp_helpkey",2,"Reports information about primary, foreign, and common keys.")
insert into helpsql values("sp_helpkey",3,"")
insert into helpsql values("sp_helpkey",4,"   sp_helpkey [<objname>]")
insert into helpsql values("sp_helpkey",5,"")
insert into helpsql values("sp_helplanguage",1,"sp_helplanguage")
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_helplanguage",6,"")
insert into helpsql values("sp_helplog",1,"sp_helplog")
go
dump transaction master with truncate_only
go
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,"")
insert into helpsql values("sp_helplog",4,"   sp_helplog")
insert into helpsql values("sp_helplog",5,"")
insert into helpsql values("sp_helpremotelogin",1,"sp_helpremotelogin")
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_helpremotelogin",6,"")
insert into helpsql values("sp_helprotect",1,"sp_helprotect")
insert into helpsql values("sp_helprotect",2,"Reports permissions by database object and optionally by user for that")
insert into helpsql values("sp_helprotect",3,"object.")
insert into helpsql values("sp_helprotect",4,"")
insert into helpsql values("sp_helprotect",5,"   sp_helprotect <name> [, <username>]")
insert into helpsql values("sp_helprotect",6,"")
insert into helpsql values("sp_helpsegment",1,"sp_helpsegment")
insert into helpsql values("sp_helpsegment",2,"Reports information about a particular segment or about all of the")
insert into helpsql values("sp_helpsegment",3,"segments in 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_helpsegment",6,"")
insert into helpsql values("sp_helpserver",1,"sp_helpserver")
insert into helpsql values("sp_helpserver",2,"Reports information about a particular remote server or about all remote")
insert into helpsql values("sp_helpserver",3,"servers.")
insert into helpsql values("sp_helpserver",4,"")
insert into helpsql values("sp_helpserver",5,"   sp_helpserver [<server_name>]")
insert into helpsql values("sp_helpserver",6,"")
insert into helpsql values("sp_helpsort",1,"sp_helpsort")
insert into helpsql values("sp_helpsort",2,"Displays SQL Server's 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_helpsort",5,"")
insert into helpsql values("sp_helpsql",1,"sp_helpsql")
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_helptext",1,"sp_helptext")
insert into helpsql values("sp_helptext",2,"Prints the text of a stored procedure, trigger, view, default, or")
insert into helpsql values("sp_helptext",3,"rule.")
insert into helpsql values("sp_helptext",4,"")
insert into helpsql values("sp_helptext",5,"   sp_helptext <objname>")
insert into helpsql values("sp_helptext",6,"")
insert into helpsql values("sp_helpuser",1,"sp_helpuser")
insert into helpsql values("sp_helpuser",2,"Reports information about 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_helpuser",5,"")
insert into helpsql values("sp_lock",1,"sp_lock")
insert into helpsql values("sp_lock",2,"Reports information about locks.")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_lock",3,"")
insert into helpsql values("sp_lock",4,"   sp_lock [<spid1> [, <spid2>]]")
insert into helpsql values("sp_lock",5,"")
insert into helpsql values("sp_logdevice",1,"sp_logdevice")
insert into helpsql values("sp_logdevice",2,"Puts the transaction log on a separate database device.")
insert into helpsql values("sp_logdevice",3,"")
insert into helpsql values("sp_logdevice",4,"   sp_logdevice <dbname>, <database_device>")
insert into helpsql values("sp_logdevice",5,"")
insert into helpsql values("sp_monitor",1,"sp_monitor")
insert into helpsql values("sp_monitor",2,"Displays statistics about the SQL Server.")
insert into helpsql values("sp_monitor",3,"")
insert into helpsql values("sp_monitor",4,"   sp_monitor")
insert into helpsql values("sp_monitor",5,"")
insert into helpsql values("sp_password",1,"sp_password")
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>]")
insert into helpsql values("sp_password",5,"")
insert into helpsql values("sp_placeobject",1,"sp_placeobject")
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_placeobject",6,"")
insert into helpsql values("sp_primarykey",1,"sp_primarykey")
insert into helpsql values("sp_primarykey",2,"Defines a primary key for a table or view.")
insert into helpsql values("sp_primarykey",3,"")
insert into helpsql values("sp_primarykey",4,"   sp_primarykey <tabname>, <col1> [, <col2>, <col3>, ..., <col8>]")
insert into helpsql values("sp_primarykey",5,"")
insert into helpsql values("sp_recompile",1,"sp_recompile")
insert into helpsql values("sp_recompile",2,"Causes each stored procedure and trigger that uses the named table to be")
insert into helpsql values("sp_recompile",3,"recompiled the next time it runs.")
insert into helpsql values("sp_recompile",4,"")
insert into helpsql values("sp_recompile",5,"   sp_recompile [<tabname>]")
insert into helpsql values("sp_recompile",6,"")
insert into helpsql values("sp_remoteoption",1,"sp_remoteoption")
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>, <optname>,")
insert into helpsql values("sp_remoteoption",5,"     {TRUE | FALSE}")
insert into helpsql values("sp_remoteoption",6,"")
insert into helpsql values("sp_rename",1,"sp_rename")
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,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_rename",4,"   sp_rename <oldname>, <newname>")
insert into helpsql values("sp_rename",5,"")
insert into helpsql values("sp_renamedb",1,"sp_renamedb")
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>")
insert into helpsql values("sp_renamedb",5,"")
insert into helpsql values("sp_serveroption",1,"sp_serveroption")
insert into helpsql values("sp_serveroption",2,"Displays or changes 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_serveroption",5,"")
insert into helpsql values("sp_setlangalias",1,"sp_setlangalias")
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_setlangalias",5,"")
insert into helpsql values("sp_spaceused",1,"sp_spaceused")
insert into helpsql values("sp_spaceused",2,"Displays the number of rows, the disk space reserved, and the disk")
insert into helpsql values("sp_spaceused",3,"space used by database objects.")
insert into helpsql values("sp_spaceused",4,"")
insert into helpsql values("sp_spaceused",5,"   sp_spaceused [<objname>]")
insert into helpsql values("sp_spaceused",6,"")
insert into helpsql values("sp_unbindefault",1,"sp_unbindefault")
insert into helpsql values("sp_unbindefault",2,"Unbinds a default value from a column or from a user-defined datatype.")
insert into helpsql values("sp_unbindefault",3,"")
insert into helpsql values("sp_unbindefault",4,"   sp_unbindefault <objname> [, FUTUREONLY]")
insert into helpsql values("sp_unbindefault",5,"")
insert into helpsql values("sp_unbindrule",1,"sp_unbindrule")
insert into helpsql values("sp_unbindrule",2,"Unbinds a rule from a column or user-defined datatype.")
insert into helpsql values("sp_unbindrule",3,"")
insert into helpsql values("sp_unbindrule",4,"   sp_unbindrule <objname> [, FUTUREONLY]")
insert into helpsql values("sp_unbindrule",5,"")
insert into helpsql values("sp_who",1,"sp_who")
insert into helpsql values("sp_who",2,"Reports information about current SQL Server users and processes.")
insert into helpsql values("sp_who",3,"")
insert into helpsql values("sp_who",4,"   sp_who [<login_id> | <'spid'>]")
insert into helpsql values("sp_column_privileges",1,"sp_column_privileges")
insert into helpsql values("sp_column_privileges",2,"Returns column privilege information for a single table in the current")
insert into helpsql values("sp_column_privileges",3,"DBMS environment.")
insert into helpsql values("sp_column_privileges",4,"")
insert into helpsql values("sp_column_privileges",5,"   sp_column_privileges <table_name> [, <table_owner>]")
insert into helpsql values("sp_column_privileges",6,"     [, <table_qualifier>] [, <column_name>]")
insert into helpsql values("sp_column_privileges",7,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_columns",1,"sp_columns")
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 DBMS environment. The returned columns belong either")
insert into helpsql values("sp_columns",4,"to a table or view.")
insert into helpsql values("sp_columns",5,"")
insert into helpsql values("sp_columns",6,"   sp_columns <table_name> [, <table_owner>] [, <table_qualifier>]")
insert into helpsql values("sp_columns",7,"     [, <column_name>]")
insert into helpsql values("sp_columns",8,"")
insert into helpsql values("sp_databases",1,"sp_databases")
insert into helpsql values("sp_databases",2,"Lists databases present in the SQL Server installation or accessible")
insert into helpsql values("sp_databases",3,"through a database gateway.")
insert into helpsql values("sp_databases",4,"")
insert into helpsql values("sp_databases",5,"   sp_databases")
insert into helpsql values("sp_databases",6,"")
insert into helpsql values("sp_datatype_info",1,"sp_datatype_info")
insert into helpsql values("sp_datatype_info",2,"Returns information about the datatypes supported by the DBMS.")
insert into helpsql values("sp_datatype_info",3,"")
insert into helpsql values("sp_datatype_info",4,"   sp_datatype_info <data_type>")
insert into helpsql values("sp_datatype_info",5,"")
insert into helpsql values("sp_fkeys",1,"sp_fkeys")
insert into helpsql values("sp_fkeys",2,"Returns logical foreign key information for the current DBMS environment.")
insert into helpsql values("sp_fkeys",3,"")
insert into helpsql values("sp_fkeys",4,"   sp_fkeys <pktable_name> [, <pktable_owner>] [, <pktable_qualifier>]")
insert into helpsql values("sp_fkeys",5,"   [, <fktable_name>] [, <fktable_owner>] [, <fktable_qualifier>]")
insert into helpsql values("sp_fkeys",6,"")
insert into helpsql values("sp_pkeys",1,"sp_pkeys")
insert into helpsql values("sp_pkeys",2,"Returns primary key information for a single table in the current DBMS")
insert into helpsql values("sp_pkeys",3,"environment.")
insert into helpsql values("sp_pkeys",4,"")
insert into helpsql values("sp_pkeys",5,"   sp_pkeys <table_name> [, <table_owner>] [, <table_qualifier>]")
insert into helpsql values("sp_pkeys",6,"")
insert into helpsql values("sp_server_info",1,"sp_server_info")
insert into helpsql values("sp_server_info",2,"Returns a list of attribute names and matching values for SQL Server or")
insert into helpsql values("sp_server_info",3,"database gateway and/or the underlying data source.")
insert into helpsql values("sp_server_info",4,"")
insert into helpsql values("sp_server_info",5,"   sp_server_info [<attribute_id>]")
insert into helpsql values("sp_server_info",6,"")
insert into helpsql values("sp_special_columns",1,"sp_special_columns")
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")
insert into helpsql values("sp_special_columns",4,"the row is updated by a transaction.")
insert into helpsql values("sp_special_columns",5,"")
insert into helpsql values("sp_special_columns",6,"   sp_special_columns <table_name> [, <table_owner>]")
insert into helpsql values("sp_special_columns",7,"     [, <table_qualifier>] [, <column_type>]")
insert into helpsql values("sp_special_columns",8,"")
insert into helpsql values("sp_sproc_columns",1,"sp_sproc_columns")
insert into helpsql values("sp_sproc_columns",2,"Returns column information for a single stored procedure in the current")
insert into helpsql values("sp_sproc_columns",3,"DBMS environment.")
insert into helpsql values("sp_sproc_columns",4,"")
insert into helpsql values("sp_sproc_columns",5,"   sp_sproc_columns <sp_name> [, <sp_owner>] [, <sp_qualifier>]")
insert into helpsql values("sp_sproc_columns",6,"     [, <column_name>]")
insert into helpsql values("sp_sproc_columns",7,"")
go
dump transaction master with truncate_only
go
insert into helpsql values("sp_statistics",1,"sp_statistics")
insert into helpsql values("sp_statistics",2,"Returns a list of all indexes in a single table, determined by")
insert into helpsql values("sp_statistics",3,"<table_qualifier>, <table_owner>, and <table_name> parameters.")
insert into helpsql values("sp_statistics",4,"")
insert into helpsql values("sp_statistics",5,"   sp_statistics <table_name> [, <table_owner>] [, <table_qualifier>]")
insert into helpsql values("sp_statistics",6,"")
insert into helpsql values("sp_stored_procedures",1,"sp_stored_procedures")
insert into helpsql values("sp_stored_procedures",2,"Returns a list of stored procedures in the current DBMS environment.")
insert into helpsql values("sp_stored_procedures",3,"")
insert into helpsql values("sp_stored_procedures",4,"   sp_stored_procedures [<sp_name>] [, <sp_owner>] [, <sp_qualifier>]")
insert into helpsql values("sp_stored_procedures",5,"")
insert into helpsql values("sp_table_privileges",1,"sp_table_privileges")
insert into helpsql values("sp_table_privileges",2,"Returns table privilege information for a single table in the current")
insert into helpsql values("sp_table_privileges",3,"DBMS environment.")
insert into helpsql values("sp_table_privileges",4,"")
insert into helpsql values("sp_table_privileges",5,"   sp_table_privileges <table_name> [, <table_owner>]")
insert into helpsql values("sp_table_privileges",6,"     [, <table_qualifier>]")
insert into helpsql values("sp_table_privileges",7,"")
insert into helpsql values("sp_tables",1,"sp_tables")
insert into helpsql values("sp_tables",2,"Returns a list of objects that can be queried in the current DBMS")
insert into helpsql values("sp_tables",3,"environment.")
insert into helpsql values("sp_tables",4,"")
insert into helpsql values("sp_tables",5,"   sp_tables [<table_name>] [, <table_owner>] [, <table_qualifier>]")
insert into helpsql values("sp_tables",6,"     [, <table_type>]")
insert into helpsql values("sp_tables",7,"")
go
grant execute on sp_helpsql to public
grant select on  helpsql to public
go
dump transaction master with truncate_only
go
checkpoint
go