home *** CD-ROM | disk | FTP | other *** search
/ Microsoft Internet Business Development Kit / PRODUCT_CD.iso / sqlsvr / ppc / helpsql.sql < prev    next >
Encoding:
Text File  |  1995-11-16  |  166.3 KB  |  2,287 lines
  1.  
  2. /*  HelpSQL.SQL  1995/06/14
  3. *******************************************************************
  4. **  sp_helpsql for Microsoft SQL Server 6.0                      **
  5. *******************************************************************
  6. */
  7.  
  8. go
  9. USE master
  10. set nocount on
  11. go
  12.  
  13. raiserror('Dumping tran master no_log ...',1,1)
  14. go
  15.  
  16. DUMP TRANSACTION master WITH NO_LOG
  17. go
  18.  
  19. IF (EXISTS (SELECT * FROM sysobjects WHERE name = 'sp_helpsql'))
  20.     DROP PROC sp_helpsql
  21. go
  22.  
  23. IF (EXISTS (SELECT * FROM sysobjects WHERE name = 'helpsql'))
  24.     DROP TABLE helpsql
  25. go
  26.  
  27. DUMP TRANSACTION master WITH NO_LOG
  28. go
  29.  
  30. raiserror('Creating table helpsql ...',1,1)
  31. go
  32.  
  33. CREATE TABLE helpsql (command varchar(30), ordering tinyint, helptext varchar(80))
  34. go
  35.  
  36. CREATE INDEX helpsql_index ON helpsql(command)
  37. go
  38.  
  39. raiserror('Creating procedure sp_helpsql ...',1,1)
  40. go
  41.  
  42. CREATE PROC sp_helpsql
  43. @in_command varchar(30) = NULL
  44. AS
  45. DECLARE @num_commands tinyint
  46. DECLARE @original_command varchar(30)
  47. /*******************************************************************/
  48. /*  sp_helpsql gives help on SQL commands supported by SQL Server  */
  49. /*      4 situations are covered:                                  */
  50. /*          1. No additional parameters                            */
  51. /*             Returns: Help on how to use sp_helpsql              */
  52. /*          2. Partial parameter input by the user                 */
  53. /*             Returns: The name of all commands that begin with   */
  54. /*                      the string input by the user.  The user    */
  55. /*                      can resubmit the request for help with     */
  56. /*                      the correct command name.                  */
  57. /*          3. A unique parameter passed from the user             */
  58. /*             Returns: A brief definition and syntax on command.  */
  59. /*          4. A parameter which does not match any help commands. */
  60. /*             return:  No help available for command: parameter   */
  61. /*******************************************************************/
  62.  
  63. /* first deal with no parameter passed, which means to simply give */
  64. /* usage syntax and help                                           */
  65. IF @in_command IS NULL
  66.     BEGIN
  67.     PRINT ' '
  68.      PRINT 'sp_helpsql supplies help on Transact-SQL statements, server-supplied stored '
  69.         PRINT '    procedures, and the following special topics: '
  70.     PRINT ' '
  71.     PRINT '         Comments              Expression            Variables'
  72.     PRINT '         Control of Flow       Functions             Wildcards'
  73.     PRINT '         Cursors               Operators'
  74.     PRINT '         Datatypes             Transactions'
  75.     PRINT ' '
  76.     PRINT "Syntax:  sp_helpsql ['topic']"
  77.     PRINT ' '
  78.     PRINT ' '
  79.     PRINT "For parameter options and syntax restrictions, see the Books On-line."
  80.     PRINT ' '
  81.     /* all done, so leave now */
  82.     RETURN
  83.     END
  84. ELSE
  85.     BEGIN
  86.     SELECT @original_command = @in_command
  87.     SELECT @in_command = UPPER(@in_command)
  88.     /* see if we got a unique hit on command */
  89.     SELECT @num_commands = COUNT(DISTINCT command) FROM master..helpsql WHERE
  90.         UPPER(command) LIKE @in_command
  91.     IF @num_commands = 1
  92.         BEGIN
  93.         SELECT 'Transact-SQL Syntax Help' = ('  ' + helptext)
  94.             FROM master..helpsql
  95.                 WHERE UPPER(command) LIKE @in_command
  96.             ORDER BY ordering
  97.         RETURN
  98.         END
  99.     ELSE
  100.     /* what was input did not get a direct hit, so now look for a part */
  101.     /* of a command as input */
  102.     SELECT @in_command = @in_command + '%'
  103.     SELECT @num_commands = COUNT(DISTINCT command) FROM master..helpsql WHERE
  104.         UPPER(command) LIKE @in_command
  105.     /* if num_command > 1 then more than 1 command has been found*/
  106.     IF @num_commands > 1
  107.         BEGIN
  108.         PRINT ' '
  109.         PRINT 'You have entered a non-unique topic.  More information can be obtained'
  110.         PRINT 'for the following topics:'
  111.         PRINT ' '
  112.         SELECT DISTINCT 'Transact-SQL command' = command FROM master..helpsql WHERE
  113.             UPPER(command) LIKE @in_command
  114.         RETURN
  115.         END
  116.     ELSE
  117.     /* if num_command = 1 then give help for that 1 command */
  118.     IF @num_commands = 1
  119.         BEGIN
  120.         SELECT 'Transact-SQL Syntax Help' = ('  ' + helptext)
  121.             FROM master..helpsql
  122.                 WHERE UPPER(command) LIKE @in_command
  123.             ORDER BY ordering
  124.         RETURN
  125.         END
  126.     ELSE
  127.     /* if we got here we have no help on the command requested by the */
  128.     /* user                                                           */
  129.         BEGIN
  130.         DECLARE @nohelp varchar(72)
  131.         SELECT @nohelp = 'No help available for ' + @original_command
  132.         PRINT @nohelp
  133.         RETURN
  134.         END
  135.     END
  136. go
  137. DUMP TRANSACTION master WITH NO_LOG
  138. go
  139.  
  140. raiserror('Next are numerous inserts to helpsql ...',1,1)
  141. go
  142.  
  143. go
  144. INSERT INTO helpsql VALUES("ALTER DATABASE",1,"ALTER DATABASE Statement")
  145. INSERT INTO helpsql VALUES("ALTER DATABASE",2,"Increases the amount of disk space allocated to a database.")
  146. INSERT INTO helpsql VALUES("ALTER DATABASE",3," ")
  147. INSERT INTO helpsql VALUES("ALTER DATABASE",4,"ALTER DATABASE <database_name>")
  148. INSERT INTO helpsql VALUES("ALTER DATABASE",5,"     [ON {DEFAULT | <database_device>} [= <size>] ")
  149. INSERT INTO helpsql VALUES("ALTER DATABASE",6,"          [, <database_device> [= <size>]]...]")
  150. INSERT INTO helpsql VALUES("ALTER DATABASE",7,"[FOR LOAD]")
  151. go
  152. DUMP TRANSACTION master WITH NO_LOG
  153. go
  154. INSERT INTO helpsql VALUES("ALTER TABLE",1,"ALTER TABLE Statement")
  155. INSERT INTO helpsql VALUES("ALTER TABLE",2,"Adds new columns or constraints to an existing table.")
  156. INSERT INTO helpsql VALUES("ALTER TABLE",3," ")
  157. INSERT INTO helpsql VALUES("ALTER TABLE",4,"ALTER TABLE [<database>.[<owner>].]<table_name> ")
  158. INSERT INTO helpsql VALUES("ALTER TABLE",5,"[WITH NOCHECK]")
  159. INSERT INTO helpsql VALUES("ALTER TABLE",6,"[ADD")
  160. INSERT INTO helpsql VALUES("ALTER TABLE",7,"     {<col_name> <column_properties> [<column_constraints>]")
  161. INSERT INTO helpsql VALUES("ALTER TABLE",8,"     | [[,] <table_constraint>]}")
  162. INSERT INTO helpsql VALUES("ALTER TABLE",9,"          [, {<next_col_name> | <next_table_constraint>}]...]")
  163. INSERT INTO helpsql VALUES("ALTER TABLE",10,"|")
  164. INSERT INTO helpsql VALUES("ALTER TABLE",11,"[DROP [CONSTRAINT] ")
  165. INSERT INTO helpsql VALUES("ALTER TABLE",12,"     <constraint_name> [, <constraint_name2>]...]")
  166. INSERT INTO helpsql VALUES("ALTER TABLE",13," ")
  167. INSERT INTO helpsql VALUES("ALTER TABLE",14,"<column_properties> =")
  168. INSERT INTO helpsql VALUES("ALTER TABLE",15,"     <datatype> [NULL | IDENTITY[(<seed>, <increment>)]]")
  169. INSERT INTO helpsql VALUES("ALTER TABLE",16," ")
  170. INSERT INTO helpsql VALUES("ALTER TABLE",17,"<column_constraints> =")
  171. INSERT INTO helpsql VALUES("ALTER TABLE",18,"  For a column-level UNIQUE constraint:")
  172. INSERT INTO helpsql VALUES("ALTER TABLE",19,"     [CONSTRAINT <constraint_name> ]")
  173. INSERT INTO helpsql VALUES("ALTER TABLE",20,"          UNIQUE [CLUSTERED | NONCLUSTERED] [(<col_name>)]")
  174. INSERT INTO helpsql VALUES("ALTER TABLE",21,"               [WITH FILLFACTOR = <fillfactor> ]")
  175. INSERT INTO helpsql VALUES("ALTER TABLE",22,"               [ON <segment_name>] ")
  176. INSERT INTO helpsql VALUES("ALTER TABLE",23,"  For a column-level FOREIGN KEY constraint:")
  177. INSERT INTO helpsql VALUES("ALTER TABLE",24,"     [CONSTRAINT <constraint_name>]")
  178. INSERT INTO helpsql VALUES("ALTER TABLE",25,"          [FOREIGN KEY [(<col_name>)]] ")
  179. INSERT INTO helpsql VALUES("ALTER TABLE",26,"               REFERENCES [<owner>.]<ref_table> [(<ref_col>)]")
  180. INSERT INTO helpsql VALUES("ALTER TABLE",27,"  For a column-level DEFAULT constraint:")
  181. INSERT INTO helpsql VALUES("ALTER TABLE",28,"     [CONSTRAINT <constraint_name>]")
  182. INSERT INTO helpsql VALUES("ALTER TABLE",29,"          DEFAULT {<constant_expression> | <niladic-function> | NULL}")
  183. INSERT INTO helpsql VALUES("ALTER TABLE",30,"  For a column-level CHECK constraint:")
  184. INSERT INTO helpsql VALUES("ALTER TABLE",31,"     [CONSTRAINT <constraint_name>]")
  185. INSERT INTO helpsql VALUES("ALTER TABLE",32,"          CHECK [NOT FOR REPLICATION] (<expression>) ")
  186. INSERT INTO helpsql VALUES("ALTER TABLE",33,"<table_constraint> = ")
  187. INSERT INTO helpsql VALUES("ALTER TABLE",34,"  For a table-level PRIMARY KEY constraint:")
  188. INSERT INTO helpsql VALUES("ALTER TABLE",35,"     [CONSTRAINT <constraint_name> ]")
  189. INSERT INTO helpsql VALUES("ALTER TABLE",36,"          PRIMARY KEY [CLUSTERED | NONCLUSTERED]")
  190. INSERT INTO helpsql VALUES("ALTER TABLE",37,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
  191. INSERT INTO helpsql VALUES("ALTER TABLE",38,"               [WITH FILLFACTOR = <fillfactor>]")
  192. INSERT INTO helpsql VALUES("ALTER TABLE",39,"               [ON <segment_name>] ")
  193. INSERT INTO helpsql VALUES("ALTER TABLE",40,"  For a table-level UNIQUE constraint:")
  194. INSERT INTO helpsql VALUES("ALTER TABLE",41,"     [CONSTRAINT <constraint_name>]")
  195. INSERT INTO helpsql VALUES("ALTER TABLE",42,"          UNIQUE [CLUSTERED | NONCLUSTERED]")
  196. INSERT INTO helpsql VALUES("ALTER TABLE",43,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
  197. INSERT INTO helpsql VALUES("ALTER TABLE",44,"               [WITH FILLFACTOR = <fillfactor>]")
  198. INSERT INTO helpsql VALUES("ALTER TABLE",45,"               [ON <segment_name>] ")
  199. INSERT INTO helpsql VALUES("ALTER TABLE",46,"  For a table-level FOREIGN KEY constraint:")
  200. INSERT INTO helpsql VALUES("ALTER TABLE",47,"     [CONSTRAINT <constraint_name>]")
  201. INSERT INTO helpsql VALUES("ALTER TABLE",48,"          FOREIGN KEY (<col_name> [, <col_name2> [..., <col_name16>]])")
  202. INSERT INTO helpsql VALUES("ALTER TABLE",49,"               REFERENCES [<owner>.]<ref_table> [(<ref_col> ")
  203. INSERT INTO helpsql VALUES("ALTER TABLE",50,"                    [, <ref_col2> [..., <ref_col16>]])]")
  204. INSERT INTO helpsql VALUES("ALTER TABLE",51,"  For a table-level DEFAULT constraint:")
  205. INSERT INTO helpsql VALUES("ALTER TABLE",52,"     [CONSTRAINT <constraint_name>]")
  206. INSERT INTO helpsql VALUES("ALTER TABLE",53,"          DEFAULT {<constant_expression> | <niladic-function> | NULL}")
  207. INSERT INTO helpsql VALUES("ALTER TABLE",54,"               FOR <col_name>")
  208. INSERT INTO helpsql VALUES("ALTER TABLE",55,"  For a table-level CHECK constraint:")
  209. INSERT INTO helpsql VALUES("ALTER TABLE",56,"     [CONSTRAINT <constraint_name>]")
  210. INSERT INTO helpsql VALUES("ALTER TABLE",57,"          CHECK [NOT FOR REPLICATION] (<expression>) ")
  211. go
  212. DUMP TRANSACTION master WITH NO_LOG
  213. go
  214. INSERT INTO helpsql VALUES("CASE",1,"CASE Expression")
  215. INSERT INTO helpsql VALUES("CASE",2,"The CASE expression allows SQL expressions to be simplified for ")
  216. INSERT INTO helpsql VALUES("CASE",3,"conditional values. The CASE expression in SQL Server 6.0 is ANSI ")
  217. INSERT INTO helpsql VALUES("CASE",4,"SQL-92-compliant and allowed anywhere an expression is used.")
  218. INSERT INTO helpsql VALUES("CASE",5," ")
  219. INSERT INTO helpsql VALUES("CASE",6,"Simple CASE expression:")
  220. INSERT INTO helpsql VALUES("CASE",7,"     CASE <expression>")
  221. INSERT INTO helpsql VALUES("CASE",8,"          WHEN <expression1> THEN <expression1>")
  222. INSERT INTO helpsql VALUES("CASE",9,"          [[WHEN <expression2> THEN <expression2>] [...]]")
  223. INSERT INTO helpsql VALUES("CASE",10,"          [ELSE <expressionN>]")
  224. INSERT INTO helpsql VALUES("CASE",11,"     END")
  225. INSERT INTO helpsql VALUES("CASE",12," ")
  226. INSERT INTO helpsql VALUES("CASE",13,"Searched CASE expression:")
  227. INSERT INTO helpsql VALUES("CASE",14,"     CASE")
  228. INSERT INTO helpsql VALUES("CASE",15,"          WHEN <Boolean_expression1> THEN <expression1>")
  229. INSERT INTO helpsql VALUES("CASE",16,"          [[WHEN <Boolean_expression2> THEN <expression2> ] [...]]")
  230. INSERT INTO helpsql VALUES("CASE",17,"          [ELSE <expressionN>]")
  231. INSERT INTO helpsql VALUES("CASE",18,"     END")
  232. INSERT INTO helpsql VALUES("CASE",19," ")
  233. INSERT INTO helpsql VALUES("CASE",20,"CASE-related functions:")
  234. INSERT INTO helpsql VALUES("CASE",21,"     COALESCE (<expression1>, <expression2>)")
  235. INSERT INTO helpsql VALUES("CASE",22,"     COALESCE (<expression1>, <expression2>, ... <expressionN>)")
  236. INSERT INTO helpsql VALUES("CASE",23,"     NULLIF (<expression1>, <expression2>)")
  237. go
  238. DUMP TRANSACTION master WITH NO_LOG
  239. go
  240. INSERT INTO helpsql VALUES("CHECKPOINT",1,"CHECKPOINT Statement")
  241. INSERT INTO helpsql VALUES("CHECKPOINT",2,"Forces all dirty pages (those that have been updated since the ")
  242. INSERT INTO helpsql VALUES("CHECKPOINT",3,"last checkpoint) in the current database to be written to disk. ")
  243. INSERT INTO helpsql VALUES("CHECKPOINT",4," ")
  244. INSERT INTO helpsql VALUES("CHECKPOINT",5,"CHECKPOINT")
  245. INSERT INTO helpsql VALUES("COMMENTS",1,"Comments")
  246. INSERT INTO helpsql VALUES("COMMENTS",2,"Provide user-documented information about SQL statements, statement ")
  247. INSERT INTO helpsql VALUES("COMMENTS",3,"blocks, and stored procedures.")
  248. INSERT INTO helpsql VALUES("COMMENTS",4,"/* <text of comment> */")
  249. INSERT INTO helpsql VALUES("COMMENTS",5,"Or")
  250. INSERT INTO helpsql VALUES("COMMENTS",6,"-- <text of comment>")
  251. go
  252. DUMP TRANSACTION master WITH NO_LOG
  253. go
  254. INSERT INTO helpsql VALUES("CONTROL OF FLOW",1,"Control-of-Flow Language")
  255. INSERT INTO helpsql VALUES("CONTROL OF FLOW",2,"Controls the flow of execution of SQL statements, statement blocks, and ")
  256. INSERT INTO helpsql VALUES("CONTROL OF FLOW",3,"stored procedures. These keywords can be used in ad hoc SQL ")
  257. INSERT INTO helpsql VALUES("CONTROL OF FLOW",4,"statements, in batches, and in stored procedures.")
  258. INSERT INTO helpsql VALUES("CONTROL OF FLOW",5," ")
  259. INSERT INTO helpsql VALUES("CONTROL OF FLOW",6,"These are the control-of-flow keywords:")
  260. INSERT INTO helpsql VALUES("CONTROL OF FLOW",7,"BEGIN...END      Defines a statement block.")
  261. INSERT INTO helpsql VALUES("CONTROL OF FLOW",8,"GOTO <label>     Continues processing at the statement following the ")
  262. INSERT INTO helpsql VALUES("CONTROL OF FLOW",9,"                 label as defined by <label>. ")
  263. INSERT INTO helpsql VALUES("CONTROL OF FLOW",10,"IF...ELSE        Defines conditional and, optionally, alternate ")
  264. INSERT INTO helpsql VALUES("CONTROL OF FLOW",11,"                 execution when a condition is false. ")
  265. INSERT INTO helpsql VALUES("CONTROL OF FLOW",12,"RETURN           Exits unconditionally.")
  266. INSERT INTO helpsql VALUES("CONTROL OF FLOW",13,"WAITFOR          Sets a delay for statement execution.")
  267. INSERT INTO helpsql VALUES("CONTROL OF FLOW",14,"WHILE            Repeats statements while a specific condition is true.")
  268. INSERT INTO helpsql VALUES("CONTROL OF FLOW",15,"...BREAK         Exits the innermost WHILE loop.")
  269. INSERT INTO helpsql VALUES("CONTROL OF FLOW",16,"...CONTINUE      Restarts a WHILE loop.")
  270. go
  271. DUMP TRANSACTION master WITH NO_LOG
  272. go
  273. INSERT INTO helpsql VALUES("BEGIN...END",1,"BEGIN...END Block")
  274. INSERT INTO helpsql VALUES("BEGIN...END",2,"Encloses a series of SQL statements so that control-of-flow language, ")
  275. INSERT INTO helpsql VALUES("BEGIN...END",3,"such as IF...ELSE, affects the performance of a group of statements ")
  276. INSERT INTO helpsql VALUES("BEGIN...END",4,"instead of only the statement that immediately follows. ")
  277. INSERT INTO helpsql VALUES("BEGIN...END",5," ")
  278. INSERT INTO helpsql VALUES("BEGIN...END",6,"BEGIN...END blocks can be nested.")
  279. INSERT INTO helpsql VALUES("BEGIN...END",7,"BEGIN")
  280. INSERT INTO helpsql VALUES("BEGIN...END",8,"     {sql_statement | <statement_block>}")
  281. INSERT INTO helpsql VALUES("BEGIN...END",9,"END")
  282. INSERT INTO helpsql VALUES("GOTO...LABEL",1,"GOTO...LABEL Block")
  283. INSERT INTO helpsql VALUES("GOTO...LABEL",2,"Alters the flow of execution to a label. The SQL statement(s) following ")
  284. INSERT INTO helpsql VALUES("GOTO...LABEL",3,"GOTO are skipped and processing continues at the label. GOTO statements ")
  285. INSERT INTO helpsql VALUES("GOTO...LABEL",4,"and labels can be used anywhere within a procedure, batch, or ")
  286. INSERT INTO helpsql VALUES("GOTO...LABEL",5,"statement block, and they can be nested.")
  287. INSERT INTO helpsql VALUES("GOTO...LABEL",6," ")
  288. INSERT INTO helpsql VALUES("GOTO...LABEL",7,"Define the label:")
  289. INSERT INTO helpsql VALUES("GOTO...LABEL",8,"     <label>:")
  290. INSERT INTO helpsql VALUES("GOTO...LABEL",9,"Alter the execution:")
  291. INSERT INTO helpsql VALUES("GOTO...LABEL",10,"     GOTO <label>")
  292. go
  293. DUMP TRANSACTION master WITH NO_LOG
  294. go
  295. INSERT INTO helpsql VALUES("IF...ELSE",1,"IF...ELSE Block")
  296. INSERT INTO helpsql VALUES("IF...ELSE",2,"Imposes conditions on the execution of a SQL statement. The SQL ")
  297. INSERT INTO helpsql VALUES("IF...ELSE",3,"statement following an IF keyword and its condition is executed if the ")
  298. INSERT INTO helpsql VALUES("IF...ELSE",4,"condition is satisfied (when the Boolean expression returns true). The ")
  299. INSERT INTO helpsql VALUES("IF...ELSE",5,"optional ELSE keyword introduces an alternate SQL statement that is ")
  300. INSERT INTO helpsql VALUES("IF...ELSE",6,"executed when the IF condition is not satisfied (when the Boolean ")
  301. INSERT INTO helpsql VALUES("IF...ELSE",7,"expression returns false). ")
  302. INSERT INTO helpsql VALUES("IF...ELSE",8," ")
  303. INSERT INTO helpsql VALUES("IF...ELSE",9,"IF <Boolean_expression>")
  304. INSERT INTO helpsql VALUES("IF...ELSE",10,"     {<sql_statement> | <statement_block>}")
  305. INSERT INTO helpsql VALUES("IF...ELSE",11,"[ELSE [<Boolean_expression>]")
  306. INSERT INTO helpsql VALUES("IF...ELSE",12,"     {<sql_statement> | <statement_block>}]")
  307. INSERT INTO helpsql VALUES("RETURN",1,"RETURN Statement")
  308. INSERT INTO helpsql VALUES("RETURN",2,"Exits unconditionally from a query or procedure. RETURN is immediate and ")
  309. INSERT INTO helpsql VALUES("RETURN",3,"complete; statements following RETURN are not executed. ")
  310. INSERT INTO helpsql VALUES("RETURN",4," ")
  311. INSERT INTO helpsql VALUES("RETURN",5,"RETURN ([<integer_expression>])")
  312. go
  313. DUMP TRANSACTION master WITH NO_LOG
  314. go
  315. INSERT INTO helpsql VALUES("WAITFOR",1,"WAITFOR Statement")
  316. INSERT INTO helpsql VALUES("WAITFOR",2,"Specifies a time, time interval, or event that triggers execution of a ")
  317. INSERT INTO helpsql VALUES("WAITFOR",3,"statement block, stored procedure, or transaction.")
  318. INSERT INTO helpsql VALUES("WAITFOR",4," ")
  319. INSERT INTO helpsql VALUES("WAITFOR",5,"WAITFOR {DELAY '<time>' | TIME '<time>'}")
  320. INSERT INTO helpsql VALUES("WHILE",1,"WHILE Construct")
  321. INSERT INTO helpsql VALUES("WHILE",2,"Sets a condition for the repeated execution of an <sql_statement> or ")
  322. INSERT INTO helpsql VALUES("WHILE",3,"statement block. The statements are executed repeatedly as long as the ")
  323. INSERT INTO helpsql VALUES("WHILE",4,"specified condition is true. The execution of statements in the WHILE ")
  324. INSERT INTO helpsql VALUES("WHILE",5,"loop can be controlled from inside the loop with the BREAK and CONTINUE ")
  325. INSERT INTO helpsql VALUES("WHILE",6,"keywords.")
  326. INSERT INTO helpsql VALUES("WHILE",7," ")
  327. INSERT INTO helpsql VALUES("WHILE",8,"WHILE <Boolean_expression> ")
  328. INSERT INTO helpsql VALUES("WHILE",9,"       {<sql_statement> | <statement_block>}")
  329. INSERT INTO helpsql VALUES("WHILE",10,"     [BREAK]")
  330. INSERT INTO helpsql VALUES("WHILE",11,"       {<sql_statement> | <statement_block>}")
  331. INSERT INTO helpsql VALUES("WHILE",12,"     [CONTINUE]")
  332. go
  333. DUMP TRANSACTION master WITH NO_LOG
  334. go
  335. INSERT INTO helpsql VALUES("CREATE DATABASE",1,"CREATE DATABASE Statement")
  336. INSERT INTO helpsql VALUES("CREATE DATABASE",2,"Creates a new database. You must be in the master database to create a ")
  337. INSERT INTO helpsql VALUES("CREATE DATABASE",3,"new database.")
  338. INSERT INTO helpsql VALUES("CREATE DATABASE",4," ")
  339. INSERT INTO helpsql VALUES("CREATE DATABASE",5,"CREATE DATABASE <database_name>")
  340. INSERT INTO helpsql VALUES("CREATE DATABASE",6,"[ON {DEFAULT | <database_device>} [= <size>]")
  341. INSERT INTO helpsql VALUES("CREATE DATABASE",7,"     [, <database_device> [= <size>]]...]")
  342. INSERT INTO helpsql VALUES("CREATE DATABASE",8,"[LOG ON <database_device> [= <size>]")
  343. INSERT INTO helpsql VALUES("CREATE DATABASE",9,"     [, <database_device> [= <size>]]...]")
  344. INSERT INTO helpsql VALUES("CREATE DATABASE",10,"[FOR LOAD]")
  345. INSERT INTO helpsql VALUES("CREATE DEFAULT",1,"CREATE DEFAULT Statement")
  346. INSERT INTO helpsql VALUES("CREATE DEFAULT",2,"Creates an object that, when bound to a column or a user-defined ")
  347. INSERT INTO helpsql VALUES("CREATE DEFAULT",3,"datatype, specifies a value to be inserted into the column to which it's ")
  348. INSERT INTO helpsql VALUES("CREATE DEFAULT",4,"bound (or into all columns in the case of a user-defined datatype) when ")
  349. INSERT INTO helpsql VALUES("CREATE DEFAULT",5,"no value is explicitly supplied during an insert.")
  350. INSERT INTO helpsql VALUES("CREATE DEFAULT",6," ")
  351. INSERT INTO helpsql VALUES("CREATE DEFAULT",7,"CREATE DEFAULT [<owner>.]<<default_name>>")
  352. INSERT INTO helpsql VALUES("CREATE DEFAULT",8,"AS <constant_expression>")
  353. go
  354. DUMP TRANSACTION master WITH NO_LOG
  355. go
  356. INSERT INTO helpsql VALUES("CREATE INDEX",1,"CREATE INDEX Statement")
  357. INSERT INTO helpsql VALUES("CREATE INDEX",2,"Creates an index on a given table that either changes the physical ")
  358. INSERT INTO helpsql VALUES("CREATE INDEX",3,"ordering of the table or provides the optimizer with a logical ordering ")
  359. INSERT INTO helpsql VALUES("CREATE INDEX",4,"of the table to increase efficiency for queries. ")
  360. INSERT INTO helpsql VALUES("CREATE INDEX",5," ")
  361. INSERT INTO helpsql VALUES("CREATE INDEX",6,"CREATE [UNIQUE] [CLUSTERED | NONCLUSTERED] INDEX <index_name>")
  362. INSERT INTO helpsql VALUES("CREATE INDEX",7,"     ON [[<database>.]<owner>.]<table_name> (<column_name> ")
  363. INSERT INTO helpsql VALUES("CREATE INDEX",8,"          [, <column_name>]...)")
  364. INSERT INTO helpsql VALUES("CREATE INDEX",9,"[WITH ")
  365. INSERT INTO helpsql VALUES("CREATE INDEX",10,"     [FILLFACTOR = <x>] ")
  366. INSERT INTO helpsql VALUES("CREATE INDEX",11,"     [[,] IGNORE_DUP_KEY]")
  367. INSERT INTO helpsql VALUES("CREATE INDEX",12,"     [[,] {SORTED_DATA | SORTED_DATA_REORG}] ")
  368. INSERT INTO helpsql VALUES("CREATE INDEX",13,"     [[,] {IGNORE_DUP_ROW | ALLOW_DUP_ROW}]]")
  369. INSERT INTO helpsql VALUES("CREATE INDEX",14,"[ON <segment_name>]")
  370. INSERT INTO helpsql VALUES("CREATE PROCEDURE",1,"CREATE PROCEDURE Statement")
  371. INSERT INTO helpsql VALUES("CREATE PROCEDURE",2,"Creates a stored procedure (a precompiled collection of SQL statements")
  372. INSERT INTO helpsql VALUES("CREATE PROCEDURE",3,"that can take and/or return ")
  373. INSERT INTO helpsql VALUES("CREATE PROCEDURE",4,"user-supplied parameters.")
  374. INSERT INTO helpsql VALUES("CREATE PROCEDURE",5," ")
  375. INSERT INTO helpsql VALUES("CREATE PROCEDURE",6,"CREATE PROCedure [<owner>.] procedure_name [;<number>]")
  376. INSERT INTO helpsql VALUES("CREATE PROCEDURE",7,"     [(<parameter1> [, <parameter2>]...[<parameter255>])]")
  377. INSERT INTO helpsql VALUES("CREATE PROCEDURE",8,"[{FOR REPLICATION} | {WITH RECOMPILE}")
  378. INSERT INTO helpsql VALUES("CREATE PROCEDURE",9,"     [{[WITH] | [,]} ENCRYPTION]]")
  379. INSERT INTO helpsql VALUES("CREATE PROCEDURE",10,"AS <sql_statements>")
  380. go
  381. DUMP TRANSACTION master WITH NO_LOG
  382. go
  383. INSERT INTO helpsql VALUES("CREATE RULE",1,"CREATE RULE Statement")
  384. INSERT INTO helpsql VALUES("CREATE RULE",2,"Creates an object called a rule, which, when bound to a column or a ")
  385. INSERT INTO helpsql VALUES("CREATE RULE",3,"user-defined datatype, specifies the acceptable values that can be inserted ")
  386. INSERT INTO helpsql VALUES("CREATE RULE",4,"into that column.")
  387. INSERT INTO helpsql VALUES("CREATE RULE",5," ")
  388. INSERT INTO helpsql VALUES("CREATE RULE",6,"CREATE RULE [<owner>.]<<rule_name>>")
  389. INSERT INTO helpsql VALUES("CREATE RULE",7,"AS <condition_expression>")
  390. INSERT INTO helpsql VALUES("CREATE TABLE",1,"CREATE TABLE Statement")
  391. INSERT INTO helpsql VALUES("CREATE TABLE",2,"Creates a new table.")
  392. INSERT INTO helpsql VALUES("CREATE TABLE",3," ")
  393. INSERT INTO helpsql VALUES("CREATE TABLE",4,"CREATE TABLE [<database>.[<owner>].]<table_name> ")
  394. INSERT INTO helpsql VALUES("CREATE TABLE",5,"(")
  395. INSERT INTO helpsql VALUES("CREATE TABLE",6,"     {<col_name> <column_properties> [<constraint> [<constraint> ")
  396. INSERT INTO helpsql VALUES("CREATE TABLE",7,"          [... <constraint>]]]")
  397. INSERT INTO helpsql VALUES("CREATE TABLE",8,"     | [[,] <constraint>]}")
  398. INSERT INTO helpsql VALUES("CREATE TABLE",9,"          [[,] {<next_col_name> | <next_constraint>}...]")
  399. INSERT INTO helpsql VALUES("CREATE TABLE",10,")")
  400. INSERT INTO helpsql VALUES("CREATE TABLE",11,"[ON <segment_name>]")
  401. INSERT INTO helpsql VALUES("CREATE TABLE",12," ")
  402. INSERT INTO helpsql VALUES("CREATE TABLE",13,"<column_properties> =")
  403. INSERT INTO helpsql VALUES("CREATE TABLE",14,"     <datatype> [NULL | NOT NULL | IDENTITY[(<seed>, <increment>)]]")
  404. INSERT INTO helpsql VALUES("CREATE TABLE",15,"<constraint> =")
  405. INSERT INTO helpsql VALUES("CREATE TABLE",16,"  For a PRIMARY KEY constraint:")
  406. INSERT INTO helpsql VALUES("CREATE TABLE",17,"     [CONSTRAINT <constraint_name>]")
  407. INSERT INTO helpsql VALUES("CREATE TABLE",18,"          PRIMARY KEY [CLUSTERED | NONCLUSTERED]")
  408. INSERT INTO helpsql VALUES("CREATE TABLE",19,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
  409. INSERT INTO helpsql VALUES("CREATE TABLE",20,"               [ON <segment_name>] ")
  410. INSERT INTO helpsql VALUES("CREATE TABLE",21,"  For a UNIQUE constraint:")
  411. INSERT INTO helpsql VALUES("CREATE TABLE",22,"     [CONSTRAINT <constraint_name>]")
  412. INSERT INTO helpsql VALUES("CREATE TABLE",23,"          UNIQUE [CLUSTERED | NONCLUSTERED]")
  413. INSERT INTO helpsql VALUES("CREATE TABLE",24,"               (<col_name> [, <col_name2> [..., <col_name16>]])")
  414. INSERT INTO helpsql VALUES("CREATE TABLE",25,"               [ON <segment_name>] ")
  415. INSERT INTO helpsql VALUES("CREATE TABLE",26,"  For a FOREIGN KEY constraint:")
  416. INSERT INTO helpsql VALUES("CREATE TABLE",27,"     [CONSTRAINT <constraint_name>]")
  417. INSERT INTO helpsql VALUES("CREATE TABLE",28,"          [FOREIGN KEY (<col_name> [, <col_name2> ")
  418. INSERT INTO helpsql VALUES("CREATE TABLE",29,"               [..., <col_name16> ]])]")
  419. INSERT INTO helpsql VALUES("CREATE TABLE",30,"               REFERENCES [<owner>.]<ref_table> [(<ref_col> ")
  420. INSERT INTO helpsql VALUES("CREATE TABLE",31,"               [, <ref_col2> [..., <ref_col16>]])]")
  421. INSERT INTO helpsql VALUES("CREATE TABLE",32,"  For a DEFAULT constraint:")
  422. INSERT INTO helpsql VALUES("CREATE TABLE",33,"     [CONSTRAINT <constraint_name>]")
  423. INSERT INTO helpsql VALUES("CREATE TABLE",34,"          DEFAULT {<constant_expression> | <niladic-function> | NULL}")
  424. INSERT INTO helpsql VALUES("CREATE TABLE",35,"               [FOR <col_name>]")
  425. INSERT INTO helpsql VALUES("CREATE TABLE",36,"  For a CHECK constraint(s):")
  426. INSERT INTO helpsql VALUES("CREATE TABLE",37,"     [CONSTRAINT <constraint_name>]")
  427. INSERT INTO helpsql VALUES("CREATE TABLE",38,"          CHECK [NOT FOR REPLICATION] (<expression>) ")
  428. go
  429. DUMP TRANSACTION master WITH NO_LOG
  430. go
  431. INSERT INTO helpsql VALUES("CREATE TRIGGER",1,"CREATE TRIGGER Statement")
  432. INSERT INTO helpsql VALUES("CREATE TRIGGER",2,"Creates a trigger, a special kind of stored procedure that is executed ")
  433. INSERT INTO helpsql VALUES("CREATE TRIGGER",3,"automatically when a user attempts the specified data-modification ")
  434. INSERT INTO helpsql VALUES("CREATE TRIGGER",4,"statement on the specified table.")
  435. INSERT INTO helpsql VALUES("CREATE TRIGGER",5," ")
  436. INSERT INTO helpsql VALUES("CREATE TRIGGER",6,"CREATE TRIGGER [<owner>.]<<trigger_name>>")
  437. INSERT INTO helpsql VALUES("CREATE TRIGGER",7,"ON [<owner>.]<table_name>")
  438. INSERT INTO helpsql VALUES("CREATE TRIGGER",8,"FOR {INSERT, UPDATE, DELETE}")
  439. INSERT INTO helpsql VALUES("CREATE TRIGGER",9,"[WITH ENCRYPTION]")
  440. INSERT INTO helpsql VALUES("CREATE TRIGGER",10,"AS <sql_statements> ")
  441. INSERT INTO helpsql VALUES("CREATE TRIGGER",11," ")
  442. INSERT INTO helpsql VALUES("CREATE TRIGGER",12,"Or, using the IF UPDATE clause:")
  443. INSERT INTO helpsql VALUES("CREATE TRIGGER",13,"CREATE TRIGGER [<owner>.]<<trigger_name>>")
  444. INSERT INTO helpsql VALUES("CREATE TRIGGER",14,"ON [<owner>.]<table_name>")
  445. INSERT INTO helpsql VALUES("CREATE TRIGGER",15,"FOR {INSERT, UPDATE}")
  446. INSERT INTO helpsql VALUES("CREATE TRIGGER",16,"[WITH ENCRYPTION]")
  447. INSERT INTO helpsql VALUES("CREATE TRIGGER",17,"AS")
  448. INSERT INTO helpsql VALUES("CREATE TRIGGER",18,"IF UPDATE (<column_name>)")
  449. INSERT INTO helpsql VALUES("CREATE TRIGGER",19,"[{AND | OR} UPDATE (<column_name>)...] <sql_statements>")
  450. INSERT INTO helpsql VALUES("CREATE VIEW",1,"CREATE VIEW Statement")
  451. INSERT INTO helpsql VALUES("CREATE VIEW",2,"Creates a virtual table that represents an alternative way of looking at ")
  452. INSERT INTO helpsql VALUES("CREATE VIEW",3,"the data in one or more tables. You can use views as security mechanisms ")
  453. INSERT INTO helpsql VALUES("CREATE VIEW",4,"by granting permission on a view but not on underlying tables.")
  454. INSERT INTO helpsql VALUES("CREATE VIEW",5," ")
  455. INSERT INTO helpsql VALUES("CREATE VIEW",6,"CREATE VIEW [<owner>.]<view_name>")
  456. INSERT INTO helpsql VALUES("CREATE VIEW",7,"[(<column_name> [, <column_name>]...)]")
  457. INSERT INTO helpsql VALUES("CREATE VIEW",8,"[WITH ENCRYPTION]")
  458. INSERT INTO helpsql VALUES("CREATE VIEW",9,"AS <select_statement> [WITH CHECK OPTION]")
  459. go
  460. DUMP TRANSACTION master WITH NO_LOG
  461. go
  462. INSERT INTO helpsql VALUES("CURSORS",1,"Cursors")
  463. INSERT INTO helpsql VALUES("CURSORS",2,"Server cursors allow individual row operations to be performed on a ")
  464. INSERT INTO helpsql VALUES("CURSORS",3,"given results set or on the entire set. In SQL Server 6.0, ANSI SQL ")
  465. INSERT INTO helpsql VALUES("CURSORS",4,"cursors are server-based.")
  466. INSERT INTO helpsql VALUES("CURSORS",5," ")
  467. INSERT INTO helpsql VALUES("CURSORS",6,"DECLARE Statement     Defines a cursor.")
  468. INSERT INTO helpsql VALUES("CURSORS",7,"OPEN Statement               Opens a declared cursor.")
  469. INSERT INTO helpsql VALUES("CURSORS",8,"FETCH Statement              Retrieves a specific row from the cursor.")
  470. INSERT INTO helpsql VALUES("CURSORS",9,"CLOSE Statement              Closes an open cursor.")
  471. INSERT INTO helpsql VALUES("CURSORS",10,"DEALLOCATE Statement         Removes the cursor data structures.")
  472. INSERT INTO helpsql VALUES("DECLARE CURSOR",1,"DECLARE Statement")
  473. INSERT INTO helpsql VALUES("DECLARE CURSOR",2,"Defines a cursor. Once declared, row sets for cursors are assigned by ")
  474. INSERT INTO helpsql VALUES("DECLARE CURSOR",3,"using the OPEN statement. (The DECLARE statement can also be used to ")
  475. INSERT INTO helpsql VALUES("DECLARE CURSOR",4,"define the name and type of local variables for a batch or procedure.) ")
  476. INSERT INTO helpsql VALUES("DECLARE CURSOR",5," ")
  477. INSERT INTO helpsql VALUES("DECLARE CURSOR",6,"DECLARE <cursor_name> [INSENSITIVE] [SCROLL] CURSOR ")
  478. INSERT INTO helpsql VALUES("DECLARE CURSOR",7,"FOR <select_statement> ")
  479. INSERT INTO helpsql VALUES("DECLARE CURSOR",8,"[FOR {READ ONLY | UPDATE [OF <column_list>]}]")
  480. go
  481. DUMP TRANSACTION master WITH NO_LOG
  482. go
  483. INSERT INTO helpsql VALUES("OPEN",1,"OPEN Statement")
  484. INSERT INTO helpsql VALUES("OPEN",2,"Opens a cursor.")
  485. INSERT INTO helpsql VALUES("OPEN",3," ")
  486. INSERT INTO helpsql VALUES("OPEN",4,"OPEN <cursor_name>")
  487. INSERT INTO helpsql VALUES("FETCH",1,"FETCH Statement")
  488. INSERT INTO helpsql VALUES("FETCH",2,"Retrieves a specific row from the cursor.")
  489. INSERT INTO helpsql VALUES("FETCH",3," ")
  490. INSERT INTO helpsql VALUES("FETCH",4,"FETCH [[NEXT | PRIOR | FIRST | LAST | ")
  491. INSERT INTO helpsql VALUES("FETCH",5,"     ABSOLUTE <n> | RELATIVE <n>] FROM] <cursor_name> ")
  492. INSERT INTO helpsql VALUES("FETCH",6,"[INTO @<variable_name1>, @<variable_name2>, ...]")
  493. INSERT INTO helpsql VALUES("CLOSE",1,"CLOSE Statement")
  494. INSERT INTO helpsql VALUES("CLOSE",2,"Closes an open cursor. CLOSE leaves the data structures accessible for ")
  495. INSERT INTO helpsql VALUES("CLOSE",3,"reopening; however, modifications or fetches are not allowed until the ")
  496. INSERT INTO helpsql VALUES("CLOSE",4,"cursor is reopened.")
  497. INSERT INTO helpsql VALUES("CLOSE",5," ")
  498. INSERT INTO helpsql VALUES("CLOSE",6,"CLOSE <cursor_name>")
  499. INSERT INTO helpsql VALUES("DEALLOCATE",1,"DEALLOCATE Statement")
  500. INSERT INTO helpsql VALUES("DEALLOCATE",2,"Removes the cursor data structures. DEALLOCATE is different from CLOSE ")
  501. INSERT INTO helpsql VALUES("DEALLOCATE",3,"in that a closed cursor can be re-opened. DEALLOCATE releases all data ")
  502. INSERT INTO helpsql VALUES("DEALLOCATE",4,"structures associated with the cursor and removes the definition of the ")
  503. INSERT INTO helpsql VALUES("DEALLOCATE",5,"cursor. ")
  504. INSERT INTO helpsql VALUES("DEALLOCATE",6," ")
  505. INSERT INTO helpsql VALUES("DEALLOCATE",7,"DEALLOCATE <cursor_name>")
  506. go
  507. DUMP TRANSACTION master WITH NO_LOG
  508. go
  509. INSERT INTO helpsql VALUES("DATATYPES",1,"Datatypes")
  510. INSERT INTO helpsql VALUES("DATATYPES",2,"Datatypes specify the data characteristics of columns, stored-procedure ")
  511. INSERT INTO helpsql VALUES("DATATYPES",3,"parameters, and local variables. ")
  512. INSERT INTO helpsql VALUES("DATATYPES",4," ")
  513. INSERT INTO helpsql VALUES("DATATYPES",5,"Binary                  binary[(<n>)]")
  514. INSERT INTO helpsql VALUES("DATATYPES",6,"                        varbinary[(<n>)]")
  515. INSERT INTO helpsql VALUES("DATATYPES",7,"Character               char[(<n>)]")
  516. INSERT INTO helpsql VALUES("DATATYPES",8,"                        varchar[(<n>)]")
  517. INSERT INTO helpsql VALUES("DATATYPES",9,"Date and time           datetime")
  518. INSERT INTO helpsql VALUES("DATATYPES",10,"                        smalldatetime")
  519. INSERT INTO helpsql VALUES("DATATYPES",11,"Exact numeric           decimal[(<p>[, <s>])]")
  520. INSERT INTO helpsql VALUES("DATATYPES",12,"                        numeric[(<p>[, <s>])]")
  521. INSERT INTO helpsql VALUES("DATATYPES",13,"Approximate numeric     float[(<n>)]")
  522. INSERT INTO helpsql VALUES("DATATYPES",14,"                        real")
  523. INSERT INTO helpsql VALUES("DATATYPES",15,"Integer                 int")
  524. INSERT INTO helpsql VALUES("DATATYPES",16,"                        smallint")
  525. INSERT INTO helpsql VALUES("DATATYPES",17,"                        tinyint")
  526. INSERT INTO helpsql VALUES("DATATYPES",18,"Monetary                money")
  527. INSERT INTO helpsql VALUES("DATATYPES",19,"                        smallmoney")
  528. INSERT INTO helpsql VALUES("DATATYPES",20,"Special                 bit")
  529. INSERT INTO helpsql VALUES("DATATYPES",21,"                        timestamp")
  530. INSERT INTO helpsql VALUES("DATATYPES",22,"                        user-defined datatypes")
  531. INSERT INTO helpsql VALUES("DATATYPES",23,"Text and image          text")
  532. INSERT INTO helpsql VALUES("DATATYPES",24,"                        image")
  533. INSERT INTO helpsql VALUES("DATATYPES",25,"Synonyms                binary varying for varbinary")
  534. INSERT INTO helpsql VALUES("DATATYPES",26,"                        char varying for varchar")
  535. INSERT INTO helpsql VALUES("DATATYPES",27,"                        character for char")
  536. INSERT INTO helpsql VALUES("DATATYPES",28,"                        character for char(1)")
  537. INSERT INTO helpsql VALUES("DATATYPES",29,"                        character(<n>) for char(<n>)")
  538. INSERT INTO helpsql VALUES("DATATYPES",30,"                        character varying(<n>) for varchar(<n>)")
  539. INSERT INTO helpsql VALUES("DATATYPES",31,"                        dec for decimal")
  540. INSERT INTO helpsql VALUES("DATATYPES",32,"                        double precision for float")
  541. INSERT INTO helpsql VALUES("DATATYPES",33,"                        float[(<n>)] for n = 1-7 for real")
  542. INSERT INTO helpsql VALUES("DATATYPES",34,"                        float[(<n>)] for n = 8-15 for float")
  543. INSERT INTO helpsql VALUES("DATATYPES",35,"                        integer for int")
  544. go
  545. DUMP TRANSACTION master WITH NO_LOG
  546. go
  547. INSERT INTO helpsql VALUES("DBCC",1,"DBCC Statement")
  548. INSERT INTO helpsql VALUES("DBCC",2,"Used to check the logical and physical consistency of a database, check ")
  549. INSERT INTO helpsql VALUES("DBCC",3,"memory usage, decrease the size of a database, check performance ")
  550. INSERT INTO helpsql VALUES("DBCC",4,"statistics, and so on. DBCC is the SQL Server Database Consistency ")
  551. INSERT INTO helpsql VALUES("DBCC",5,"Checker.")
  552. INSERT INTO helpsql VALUES("DBCC",6," ")
  553. INSERT INTO helpsql VALUES("DBCC",7,"DBCC {")
  554. INSERT INTO helpsql VALUES("DBCC",8,"     CHECKALLOC [(<database_name> [, NOINDEX])] | ")
  555. INSERT INTO helpsql VALUES("DBCC",9,"     CHECKCATALOG [(<database_name>)] | ")
  556. INSERT INTO helpsql VALUES("DBCC",10,"     CHECKTABLE (<table_name> [, NOINDEX | <index_id>]) | ")
  557. INSERT INTO helpsql VALUES("DBCC",11,"     CHECKDB [(<database_name> [, NOINDEX])] | ")
  558. INSERT INTO helpsql VALUES("DBCC",12,"     DBREPAIR (<database_name>, DROPDB) | ")
  559. INSERT INTO helpsql VALUES("DBCC",13,"     <dllname> (FREE) | ")
  560. INSERT INTO helpsql VALUES("DBCC",14,"     INPUTBUFFER (<spid>) | ")
  561. INSERT INTO helpsql VALUES("DBCC",15,"     MEMUSAGE | ")
  562. INSERT INTO helpsql VALUES("DBCC",16,"     NEWALLOC [(<database_name> [, NOINDEX])] | ")
  563. INSERT INTO helpsql VALUES("DBCC",17,"     OPENTRAN ({<database_name>} | {<database_id>}) ")
  564. INSERT INTO helpsql VALUES("DBCC",18,"          [WITH TABLERESULTS] | ")
  565. INSERT INTO helpsql VALUES("DBCC",19,"     OUTPUTBUFFER (<spid>) | ")
  566. INSERT INTO helpsql VALUES("DBCC",20,"     PERFMON | ")
  567. INSERT INTO helpsql VALUES("DBCC",21,"     PINTABLE (<database_id>, <table_id>) | ")
  568. INSERT INTO helpsql VALUES("DBCC",22,"     SHOW_STATISTICS (<table_name>, <index_name>) | ")
  569. INSERT INTO helpsql VALUES("DBCC",23,"     SHOWCONTIG (<table_id>, [<index_id>]) | ")
  570. INSERT INTO helpsql VALUES("DBCC",24,"     SHRINKDB (<database_name> [, <new_size> [, 'MASTEROVERRIDE']]) | ")
  571. INSERT INTO helpsql VALUES("DBCC",25,"     SQLPERF ({IOSTATS | LRUSTATS | NETSTATS [, CLEAR]} |")
  572. INSERT INTO helpsql VALUES("DBCC",26,"          {THREADS} | {LOGSPACE}) | ")
  573. INSERT INTO helpsql VALUES("DBCC",27,"     TEXTALL [({<database_name> | <database_id>}[, FULL | FAST])] | ")
  574. INSERT INTO helpsql VALUES("DBCC",28,"     TEXTALLOC [({<table_name> | <table_id>}[, FULL | FAST])] | ")
  575. INSERT INTO helpsql VALUES("DBCC",29,"     TRACEOFF (<trace#>) | ")
  576. INSERT INTO helpsql VALUES("DBCC",30,"     TRACEON (<trace#>) |")
  577. INSERT INTO helpsql VALUES("DBCC",31,"     TRACESTATUS (<trace#> [, <trace#>...]) | ")
  578. INSERT INTO helpsql VALUES("DBCC",32,"     UNPINTABLE (<database_id>, <table_id>) | ")
  579. INSERT INTO helpsql VALUES("DBCC",33,"     UPDATEUSAGE ({0 | <database_name>} [, <table_name> ")
  580. INSERT INTO helpsql VALUES("DBCC",34,"          [, <index_id>]]) |")
  581. INSERT INTO helpsql VALUES("DBCC",35,"     USEROPTIONS } ")
  582. INSERT INTO helpsql VALUES("DBCC",36,"[WITH NO_INFOMSGS]")
  583. go
  584. DUMP TRANSACTION master WITH NO_LOG
  585. go
  586. INSERT INTO helpsql VALUES("DECLARE",1,"DECLARE Statement")
  587. INSERT INTO helpsql VALUES("DECLARE",2,"Used to define the name and type of local variables for a batch or ")
  588. INSERT INTO helpsql VALUES("DECLARE",3,"procedure, and to define cursors.")
  589. INSERT INTO helpsql VALUES("DECLARE",4," ")
  590. INSERT INTO helpsql VALUES("DECLARE",5,"DECLARE @<variable_name> <datatype> ")
  591. INSERT INTO helpsql VALUES("DECLARE",6,"     [, @<variable_name> <datatype>...]")
  592. INSERT INTO helpsql VALUES("DELETE",1,"DELETE Statement")
  593. INSERT INTO helpsql VALUES("DELETE",2,"Removes rows from a table.")
  594. INSERT INTO helpsql VALUES("DELETE",3," ")
  595. INSERT INTO helpsql VALUES("DELETE",4,"DELETE [FROM] {<table_name> | <view_name>}")
  596. INSERT INTO helpsql VALUES("DELETE",5,"     [WHERE clause]")
  597. INSERT INTO helpsql VALUES("DELETE",6," ")
  598. INSERT INTO helpsql VALUES("DELETE",7,"Transact-SQL extension Syntax:")
  599. INSERT INTO helpsql VALUES("DELETE",8,"DELETE [FROM] {<table_name> | <view_name>}")
  600. INSERT INTO helpsql VALUES("DELETE",9,"     [FROM {<table_name> | <view_name>}")
  601. INSERT INTO helpsql VALUES("DELETE",10,"          [, {<table_name> | <view_name>}]...]")
  602. INSERT INTO helpsql VALUES("DELETE",11,"               [..., {<table_name16> | <view_name16>}]] ")
  603. INSERT INTO helpsql VALUES("DELETE",12,"[WHERE clause]")
  604. go
  605. DUMP TRANSACTION master WITH NO_LOG
  606. go
  607. INSERT INTO helpsql VALUES("DISK INIT",1,"DISK INIT Statement")
  608. INSERT INTO helpsql VALUES("DISK INIT",2,"Creates a device on which a database or multiple databases can be ")
  609. INSERT INTO helpsql VALUES("DISK INIT",3,"placed. A device is an operating-system file that SQL Server pre-")
  610. INSERT INTO helpsql VALUES("DISK INIT",4,"allocates for database use.")
  611. INSERT INTO helpsql VALUES("DISK INIT",5," ")
  612. INSERT INTO helpsql VALUES("DISK INIT",6,"DISK INIT ")
  613. INSERT INTO helpsql VALUES("DISK INIT",7,"     NAME = '<logical_name>',")
  614. INSERT INTO helpsql VALUES("DISK INIT",8,"     PHYSNAME = '<physical_name>',")
  615. INSERT INTO helpsql VALUES("DISK INIT",9,"     VDEVNO = <virtual_device_number>,")
  616. INSERT INTO helpsql VALUES("DISK INIT",10,"     SIZE = <number_of_2K_blocks>")
  617. INSERT INTO helpsql VALUES("DISK INIT",11,"[, VSTART = <virtual_address>]")
  618. INSERT INTO helpsql VALUES("DISK MIRROR",1,"DISK MIRROR Statement")
  619. INSERT INTO helpsql VALUES("DISK MIRROR",2,"Creates a software image of the SQL Server device.")
  620. INSERT INTO helpsql VALUES("DISK MIRROR",3," ")
  621. INSERT INTO helpsql VALUES("DISK MIRROR",4,"DISK MIRROR")
  622. INSERT INTO helpsql VALUES("DISK MIRROR",5,"     NAME = '<logical_name>',")
  623. INSERT INTO helpsql VALUES("DISK MIRROR",6,"     MIRROR = '<physical_name>'")
  624. INSERT INTO helpsql VALUES("DISK MIRROR",7,"     [, WRITES = {SERIAL | NOSERIAL}]")
  625. INSERT INTO helpsql VALUES("DISK UNMIRROR",1,"DISK UNMIRROR Statement")
  626. INSERT INTO helpsql VALUES("DISK UNMIRROR",2,"Temporarily pauses software mirroring for the SQL Server device. Often ")
  627. INSERT INTO helpsql VALUES("DISK UNMIRROR",3,"this is useful when large non-logged operations are occurring against ")
  628. INSERT INTO helpsql VALUES("DISK UNMIRROR",4,"the database and when a database backup (using the DUMP statement) will ")
  629. INSERT INTO helpsql VALUES("DISK UNMIRROR",5,"be performed after the non-logged operations finish.")
  630. INSERT INTO helpsql VALUES("DISK UNMIRROR",6," ")
  631. INSERT INTO helpsql VALUES("DISK UNMIRROR",7,"DISK UNMIRROR")
  632. INSERT INTO helpsql VALUES("DISK UNMIRROR",8,"     NAME = '<logical_name>'")
  633. INSERT INTO helpsql VALUES("DISK UNMIRROR",9,"     [, SIDE = {PRIMARY | SECONDARY}]")
  634. INSERT INTO helpsql VALUES("DISK UNMIRROR",10,"     [, MODE = {RETAIN | REMOVE}]")
  635. INSERT INTO helpsql VALUES("DISK REMIRROR",1,"DISK REMIRROR Statement")
  636. INSERT INTO helpsql VALUES("DISK REMIRROR",2,"Resumes software mirroring for the SQL Server device.")
  637. INSERT INTO helpsql VALUES("DISK REMIRROR",3," ")
  638. INSERT INTO helpsql VALUES("DISK REMIRROR",4,"DISK REMIRROR")
  639. INSERT INTO helpsql VALUES("DISK REMIRROR",5,"     NAME = '<logical_name>'")
  640. go
  641. DUMP TRANSACTION master WITH NO_LOG
  642. go
  643. INSERT INTO helpsql VALUES("DISK REFIT",1,"DISK REFIT Statement")
  644. INSERT INTO helpsql VALUES("DISK REFIT",2,"Restores usage information from the system tables when a device exists ")
  645. INSERT INTO helpsql VALUES("DISK REFIT",3,"(the file is present) but the entries in the sysusages table no longer ")
  646. INSERT INTO helpsql VALUES("DISK REFIT",4,"exist. This occurs after a damaged master database is restored and the ")
  647. INSERT INTO helpsql VALUES("DISK REFIT",5,"master database is incomplete (databases and devices were added or ")
  648. INSERT INTO helpsql VALUES("DISK REFIT",6,"altered since the last backup of master). ")
  649. INSERT INTO helpsql VALUES("DISK REFIT",7," ")
  650. INSERT INTO helpsql VALUES("DISK REFIT",8,"DISK REFIT")
  651. INSERT INTO helpsql VALUES("DISK REINIT",1,"DISK REINIT Statement")
  652. INSERT INTO helpsql VALUES("DISK REINIT",2,"Restores the device entries to the system tables when a device exists ")
  653. INSERT INTO helpsql VALUES("DISK REINIT",3,"(the file is present) and the entry in the sysdevices table no longer ")
  654. INSERT INTO helpsql VALUES("DISK REINIT",4,"exists. This occurs after a damaged master database is restored and the ")
  655. INSERT INTO helpsql VALUES("DISK REINIT",5,"master database is incomplete (databases and devices were added or ")
  656. INSERT INTO helpsql VALUES("DISK REINIT",6,"altered since the last backup of master). This is the first step for ")
  657. INSERT INTO helpsql VALUES("DISK REINIT",7,"restoring access to user databases. The DISK REFIT statement completes ")
  658. INSERT INTO helpsql VALUES("DISK REINIT",8,"the recovery.")
  659. INSERT INTO helpsql VALUES("DISK REINIT",9," ")
  660. INSERT INTO helpsql VALUES("DISK REINIT",10,"DISK REINIT")
  661. INSERT INTO helpsql VALUES("DISK REINIT",11,"     NAME = '<logical_name>',")
  662. INSERT INTO helpsql VALUES("DISK REINIT",12,"     PHYSNAME = '<physical_name>',")
  663. INSERT INTO helpsql VALUES("DISK REINIT",13,"     VDEVNO = <virtual_device_number>,")
  664. INSERT INTO helpsql VALUES("DISK REINIT",14,"     SIZE = <number_of_2K_blocks>")
  665. INSERT INTO helpsql VALUES("DISK REINIT",15,"     [, VSTART = <virtual_address>]")
  666. INSERT INTO helpsql VALUES("DISK RESIZE",1,"DISK RESIZE Statement")
  667. INSERT INTO helpsql VALUES("DISK RESIZE",2,"Allows you to expand a device. You can use DISK RESIZE on any database ")
  668. INSERT INTO helpsql VALUES("DISK RESIZE",3,"device, including the MASTER device.")
  669. INSERT INTO helpsql VALUES("DISK RESIZE",4," ")
  670. INSERT INTO helpsql VALUES("DISK RESIZE",5,"DISK RESIZE ")
  671. INSERT INTO helpsql VALUES("DISK RESIZE",6,"     NAME = <logical_device_name>, ")
  672. INSERT INTO helpsql VALUES("DISK RESIZE",7,"     SIZE = <final_size> ")
  673. go
  674. DUMP TRANSACTION master WITH NO_LOG
  675. go
  676. INSERT INTO helpsql VALUES("DROP DATABASE",1,"DROP DATABASE Statement")
  677. INSERT INTO helpsql VALUES("DROP DATABASE",2,"Removes one or more databases from SQL Server.")
  678. INSERT INTO helpsql VALUES("DROP DATABASE",3," ")
  679. INSERT INTO helpsql VALUES("DROP DATABASE",4,"DROP DATABASE <database_name> [, <database_name>...]")
  680. INSERT INTO helpsql VALUES("DROP DEFAULT",1,"DROP DEFAULT Statement")
  681. INSERT INTO helpsql VALUES("DROP DEFAULT",2,"Removes a user-defined default from a database. ")
  682. INSERT INTO helpsql VALUES("DROP DEFAULT",3," ")
  683. INSERT INTO helpsql VALUES("DROP DEFAULT",4,"DROP DEFAULT [<owner>.]<default_name> [, [<owner>.]<default_name>...]")
  684. INSERT INTO helpsql VALUES("DROP INDEX",1,"DROP INDEX Statement")
  685. INSERT INTO helpsql VALUES("DROP INDEX",2,"Removes an index from a database. ")
  686. INSERT INTO helpsql VALUES("DROP INDEX",3," ")
  687. INSERT INTO helpsql VALUES("DROP INDEX",4,"DROP INDEX [owner.]<table_name>.<index_name> ")
  688. INSERT INTO helpsql VALUES("DROP INDEX",5,"              [, [owner.]<table_name>.<index_name>...]")
  689. INSERT INTO helpsql VALUES("DROP PROCEDURE",1,"DROP PROCEDURE Statement")
  690. INSERT INTO helpsql VALUES("DROP PROCEDURE",2,"Removes user-created stored procedures from the current database.")
  691. INSERT INTO helpsql VALUES("DROP PROCEDURE",3," ")
  692. INSERT INTO helpsql VALUES("DROP PROCEDURE",4,"DROP PROCedure [<owner>.]<procedure_name> ")
  693. INSERT INTO helpsql VALUES("DROP PROCEDURE",5,"                   [, [<owner>.]<procedure_name>...]")
  694. INSERT INTO helpsql VALUES("DROP RULE",1,"DROP RULE Statement")
  695. INSERT INTO helpsql VALUES("DROP RULE",2,"Removes a user-specified rule from a database. ")
  696. INSERT INTO helpsql VALUES("DROP RULE",3," ")
  697. INSERT INTO helpsql VALUES("DROP RULE",4,"DROP RULE [<owner>.]<rule_name> ")
  698. INSERT INTO helpsql VALUES("DROP RULE",5,"              [, [<owner>.]<rule_name>...]")
  699. INSERT INTO helpsql VALUES("DROP TABLE",1,"DROP TABLE Statement")
  700. INSERT INTO helpsql VALUES("DROP TABLE",2,"Removes a table definition and all data, indexes, triggers, constraints, and ")
  701. INSERT INTO helpsql VALUES("DROP TABLE",3,"permission specifications for that table from the database.")
  702. INSERT INTO helpsql VALUES("DROP TABLE",4," ")
  703. INSERT INTO helpsql VALUES("DROP TABLE",5,"DROP TABLE [[<database>.]<owner>.]<table_name>")
  704. INSERT INTO helpsql VALUES("DROP TABLE",6,"               [, [[<database>.]<owner>.]<table_name>...]")
  705. INSERT INTO helpsql VALUES("DROP TRIGGER",1,"DROP TRIGGER Statement")
  706. INSERT INTO helpsql VALUES("DROP TRIGGER",2,"Removes a trigger from a database. ")
  707. INSERT INTO helpsql VALUES("DROP TRIGGER",3," ")
  708. INSERT INTO helpsql VALUES("DROP TRIGGER",4,"DROP TRIGGER [<owner>.]<trigger_name> ")
  709. INSERT INTO helpsql VALUES("DROP TRIGGER",5,"                 [, [<owner>.]<trigger_name>...]")
  710. go
  711. DUMP TRANSACTION master WITH NO_LOG
  712. go
  713. INSERT INTO helpsql VALUES("DROP VIEW",1,"DROP VIEW Statement")
  714. INSERT INTO helpsql VALUES("DROP VIEW",2,"Removes a view from a database.")
  715. INSERT INTO helpsql VALUES("DROP VIEW",3," ")
  716. INSERT INTO helpsql VALUES("DROP VIEW",4,"DROP VIEW [<owner>.]<view_name> ")
  717. INSERT INTO helpsql VALUES("DROP VIEW",5,"              [, [<owner>.]<view_name>...]")
  718. INSERT INTO helpsql VALUES("DUMP",1,"DUMP Statement ")
  719. INSERT INTO helpsql VALUES("DUMP",2,"Makes a backup copy of a database and its transaction log (DUMP ")
  720. INSERT INTO helpsql VALUES("DUMP",3,"DATABASE) or only the transaction log (DUMP TRANSACTION) ")
  721. INSERT INTO helpsql VALUES("DUMP",4,"in a form that can be read into SQL Server using the LOAD statement. ")
  722. INSERT INTO helpsql VALUES("DUMP",5," ")
  723. INSERT INTO helpsql VALUES("DUMP",6,"Dumping a database:")
  724. INSERT INTO helpsql VALUES("DUMP",7,"     DUMP DATABASE {<dbname> | @<dbname_var>}")
  725. INSERT INTO helpsql VALUES("DUMP",8,"          TO <dump_device> [, <dump_device2> [..., <dump_device32>]]")
  726. INSERT INTO helpsql VALUES("DUMP",9,"     [WITH <options> ")
  727. INSERT INTO helpsql VALUES("DUMP",10,"          [[,] STATS [ = <percentage>]]]")
  728. INSERT INTO helpsql VALUES("DUMP",11," ")
  729. INSERT INTO helpsql VALUES("DUMP",12,"Dumping a transaction log:")
  730. INSERT INTO helpsql VALUES("DUMP",13,"     DUMP TRANSACTION {<dbname> | @<dbname_var>} ")
  731. INSERT INTO helpsql VALUES("DUMP",14,"          [TO <dump_device> [, <dump_device2> [..., <dump_device32>]]]")
  732. INSERT INTO helpsql VALUES("DUMP",15,"     [WITH {TRUNCATE_ONLY | NO_LOG | NO_TRUNCATE}")
  733. INSERT INTO helpsql VALUES("DUMP",16,"          {<options>}]")
  734. INSERT INTO helpsql VALUES("DUMP",17," ")
  735. INSERT INTO helpsql VALUES("DUMP",18,"where")
  736. INSERT INTO helpsql VALUES("DUMP",19,"<")
  737. INSERT INTO helpsql VALUES("DUMP",20,"<dump_device> =")
  738. INSERT INTO helpsql VALUES("DUMP",21,"     { <dump_device_name> | @<dump_device_namevar>} ")
  739. INSERT INTO helpsql VALUES("DUMP",22,"     | {DISK | TAPE | FLOPPY | PIPE} = ")
  740. INSERT INTO helpsql VALUES("DUMP",23,"          {'<temp_dump_device>' | @<temp_dump_device_var>}} ")
  741. INSERT INTO helpsql VALUES("DUMP",24,"     [VOLUME = {<volid> | @<volid_var>}]")
  742. INSERT INTO helpsql VALUES("DUMP",25," ")
  743. INSERT INTO helpsql VALUES("DUMP",26,"<options> =")
  744. INSERT INTO helpsql VALUES("DUMP",27,"     [[,] {UNLOAD | NOUNLOAD}]")
  745. INSERT INTO helpsql VALUES("DUMP",28,"     [[,] {INIT | NOINIT}]")
  746. INSERT INTO helpsql VALUES("DUMP",29,"     [[,] {SKIP | NOSKIP}]")
  747. INSERT INTO helpsql VALUES("DUMP",30,"     [[,] {{EXPIREDATE = {<date> | @<date_var>}} ")
  748. INSERT INTO helpsql VALUES("DUMP",31,"          | {RETAINDAYS = {<days> | @<days_var>}}]")
  749. go
  750. DUMP TRANSACTION master WITH NO_LOG
  751. go
  752. INSERT INTO helpsql VALUES("EXECUTE",1,"EXECUTE Statement")
  753. INSERT INTO helpsql VALUES("EXECUTE",2,"Executes a system procedure, a user-defined stored procedure, or an ")
  754. INSERT INTO helpsql VALUES("EXECUTE",3,"extended stored procedure. Also supports the execution of a character ")
  755. INSERT INTO helpsql VALUES("EXECUTE",4,"string within a Transact-SQL batch. ")
  756. INSERT INTO helpsql VALUES("EXECUTE",5," ")
  757. INSERT INTO helpsql VALUES("EXECUTE",6,"To execute a stored procedure:")
  758. INSERT INTO helpsql VALUES("EXECUTE",7,"  [[EXECute] ")
  759. INSERT INTO helpsql VALUES("EXECUTE",8,"  {[@<return_status> =]")
  760. INSERT INTO helpsql VALUES("EXECUTE",9,"     {[[[<server>.]<database>.]<owner>.]<procedure_name>[;<number>] | ")
  761. INSERT INTO helpsql VALUES("EXECUTE",10,"          @<procedure_name_var>} ")
  762. INSERT INTO helpsql VALUES("EXECUTE",11,"     [[@<parameter_name> =] {<value> | @<variable> [OUTPUT] ")
  763. INSERT INTO helpsql VALUES("EXECUTE",12,"          [, [@<parameter_name> =] {<value> | @<variable> [OUTPUT]}]...] ")
  764. INSERT INTO helpsql VALUES("EXECUTE",13,"     [WITH RECOMPILE] ")
  765. INSERT INTO helpsql VALUES("EXECUTE",14," ")
  766. INSERT INTO helpsql VALUES("EXECUTE",15,"To execute a character string:")
  767. INSERT INTO helpsql VALUES("EXECUTE",16,"  EXECute ({@<str_var> | '<tsql_string>'} [+{@<str_var> | ")
  768. INSERT INTO helpsql VALUES("EXECUTE",17,"     '<tsql_string>'}...])}")
  769. INSERT INTO helpsql VALUES("EXPRESSION",1,"Expressions")
  770. INSERT INTO helpsql VALUES("EXPRESSION",2,"Used as variables, constants, and column names in many SQL statements, ")
  771. INSERT INTO helpsql VALUES("EXPRESSION",3,"functions and expressions. An expression returns values and can be ")
  772. INSERT INTO helpsql VALUES("EXPRESSION",4,"nested.")
  773. INSERT INTO helpsql VALUES("EXPRESSION",5," ")
  774. INSERT INTO helpsql VALUES("EXPRESSION",6,"{<constant> | <column_name> | <function> | (<subquery>)}")
  775. INSERT INTO helpsql VALUES("EXPRESSION",7,"[{operator | AND | OR | NOT}")
  776. INSERT INTO helpsql VALUES("EXPRESSION",8,"{<constant> | <column_name> | <function> | (<subquery>)}...]")
  777. go
  778. DUMP TRANSACTION master WITH NO_LOG
  779. go
  780. INSERT INTO helpsql VALUES("FUNCTIONS",1,"Functions")
  781. INSERT INTO helpsql VALUES("FUNCTIONS",2,"Functions return special information from the system about users, ")
  782. INSERT INTO helpsql VALUES("FUNCTIONS",3,"expressions, a database or database objects, and so on. ")
  783. INSERT INTO helpsql VALUES("FUNCTIONS",4," ")
  784. INSERT INTO helpsql VALUES("FUNCTIONS",5,"+ (<expression> + <expression>)")
  785. INSERT INTO helpsql VALUES("FUNCTIONS",6,"ABS (<numeric_expr>)")
  786. INSERT INTO helpsql VALUES("FUNCTIONS",7,"ACOS (<float_expr>)")
  787. INSERT INTO helpsql VALUES("FUNCTIONS",8,"ASCII (<char_expr>)")
  788. INSERT INTO helpsql VALUES("FUNCTIONS",9,"ASIN (<float_expr>)")
  789. INSERT INTO helpsql VALUES("FUNCTIONS",10,"ATAN (<float_expr>)")
  790. INSERT INTO helpsql VALUES("FUNCTIONS",11,"ATN2 (<float_expr1>1, <float_expr2>)")
  791. INSERT INTO helpsql VALUES("FUNCTIONS",12,"AVG([ALL | DISTINCT] <expression>)")
  792. INSERT INTO helpsql VALUES("FUNCTIONS",13,"CEILING (<numeric_expr>)")
  793. INSERT INTO helpsql VALUES("FUNCTIONS",14,"CHAR (<integer_expr>)")
  794. INSERT INTO helpsql VALUES("FUNCTIONS",15,"CHARINDEX ('<pattern>', <expression>)")
  795. INSERT INTO helpsql VALUES("FUNCTIONS",16,"COALESCE (<expression1>, <expression2>, ... <expressionN>)")
  796. INSERT INTO helpsql VALUES("FUNCTIONS",17,"COL_LENGTH ('<table_name>',  '<column_name>')")
  797. INSERT INTO helpsql VALUES("FUNCTIONS",18,"COL_NAME (<table_id>,  <column_id>)")
  798. INSERT INTO helpsql VALUES("FUNCTIONS",19,"CONVERT (<datatype>[(<length>)], <expression> [, <style>])")
  799. INSERT INTO helpsql VALUES("FUNCTIONS",20,"COS (<float_expr>)")
  800. INSERT INTO helpsql VALUES("FUNCTIONS",21,"COT (<float_expr>)")
  801. INSERT INTO helpsql VALUES("FUNCTIONS",22,"COUNT(*)")
  802. INSERT INTO helpsql VALUES("FUNCTIONS",23,"COUNT([ALL | DISTINCT] <expression>)")
  803. INSERT INTO helpsql VALUES("FUNCTIONS",24,"CURRENT_TIMESTAMP (Used with DEFAULT constraints ONLY)")
  804. INSERT INTO helpsql VALUES("FUNCTIONS",25,"CURRENT_USER (Used with DEFAULT constraints ONLY)")
  805. INSERT INTO helpsql VALUES("FUNCTIONS",26,"DATALENGTH ('<expression>')")
  806. INSERT INTO helpsql VALUES("FUNCTIONS",27,"DATALENGTH (<expression>)")
  807. INSERT INTO helpsql VALUES("FUNCTIONS",28,"DATEADD(<datepart>, <number>, <date>)")
  808. INSERT INTO helpsql VALUES("FUNCTIONS",29,"DATEDIFF(<datepart>, <date1>, <date2>)")
  809. INSERT INTO helpsql VALUES("FUNCTIONS",30,"DATENAME(<datepart>, <date>)")
  810. INSERT INTO helpsql VALUES("FUNCTIONS",31,"DATEPART(<datepart>, <date>)")
  811. INSERT INTO helpsql VALUES("FUNCTIONS",32,"DB_ID (['<database_name>'])")
  812. INSERT INTO helpsql VALUES("FUNCTIONS",33,"DB_NAME ([<database_id>])")
  813. INSERT INTO helpsql VALUES("FUNCTIONS",34,"DEGREES (<numeric_expr>)")
  814. INSERT INTO helpsql VALUES("FUNCTIONS",35,"DIFFERENCE (<char_expr1>, <char_expr2>)")
  815. INSERT INTO helpsql VALUES("FUNCTIONS",36,"EXP (<float_expr>)")
  816. INSERT INTO helpsql VALUES("FUNCTIONS",37,"FLOOR (<numeric_expr>)")
  817. INSERT INTO helpsql VALUES("FUNCTIONS",38,"GETDATE()")
  818. INSERT INTO helpsql VALUES("FUNCTIONS",39,"GETANSINULL (['<database_name>']")
  819. INSERT INTO helpsql VALUES("FUNCTIONS",40,"HOST_ID ( )")
  820. INSERT INTO helpsql VALUES("FUNCTIONS",41,"HOST_NAME ( )")
  821. INSERT INTO helpsql VALUES("FUNCTIONS",42,"IDENT_INCR ('<table_name>')")
  822. INSERT INTO helpsql VALUES("FUNCTIONS",43,"IDENT_SEED ('<table_name>')")
  823. INSERT INTO helpsql VALUES("FUNCTIONS",44,"INDEX_COL ('<table_name>', <index_id>, key_id)")
  824. INSERT INTO helpsql VALUES("FUNCTIONS",45,"ISNULL (<expression>, <value>)")
  825. INSERT INTO helpsql VALUES("FUNCTIONS",46,"LOG (<float_expr>)")
  826. INSERT INTO helpsql VALUES("FUNCTIONS",47,"LOG10 (<float_expr>)")
  827. INSERT INTO helpsql VALUES("FUNCTIONS",48,"LOWER (<char_expr>)")
  828. INSERT INTO helpsql VALUES("FUNCTIONS",49,"LTRIM (<char_expr>)")
  829. INSERT INTO helpsql VALUES("FUNCTIONS",50,"MAX([ALL | DISTINCT] <expression>)")
  830. INSERT INTO helpsql VALUES("FUNCTIONS",51,"MIN([ALL | DISTINCT] <expression>)")
  831. INSERT INTO helpsql VALUES("FUNCTIONS",52,"NULLIF (<expression1>, <expression2>)")
  832. INSERT INTO helpsql VALUES("FUNCTIONS",53,"OBJECT_ID ('<object_name>')")
  833. INSERT INTO helpsql VALUES("FUNCTIONS",54,"OBJECT_NAME (object_id)")
  834. INSERT INTO helpsql VALUES("FUNCTIONS",55,"PATINDEX ('%<pattern>%', <expression>)")
  835. INSERT INTO helpsql VALUES("FUNCTIONS",56,"PI ( )")
  836. INSERT INTO helpsql VALUES("FUNCTIONS",57,"POWER (<numeric_expr1>, <numeric_expr2>)")
  837. INSERT INTO helpsql VALUES("FUNCTIONS",58,"RADIANS (<numeric_expr>)")
  838. INSERT INTO helpsql VALUES("FUNCTIONS",59,"RAND ([<seed>])")
  839. INSERT INTO helpsql VALUES("FUNCTIONS",60,"REPLICATE (<char_expr>, <integer_expr>)")
  840. INSERT INTO helpsql VALUES("FUNCTIONS",61,"REVERSE (<char_expr>)")
  841. INSERT INTO helpsql VALUES("FUNCTIONS",62,"RIGHT (<char_expr>, <integer_expr>)")
  842. INSERT INTO helpsql VALUES("FUNCTIONS",63,"ROUND (<numeric_expr>, <length>)")
  843. INSERT INTO helpsql VALUES("FUNCTIONS",64,"RTRIM (<char_expr>)")
  844. INSERT INTO helpsql VALUES("FUNCTIONS",65,"SESSION_USER (Used with DEFAULT constraints ONLY)")
  845. INSERT INTO helpsql VALUES("FUNCTIONS",66,"SIGN (<numeric_expr>)")
  846. INSERT INTO helpsql VALUES("FUNCTIONS",67,"SIN (<float_expr>)")
  847. INSERT INTO helpsql VALUES("FUNCTIONS",68,"SOUNDEX (<char_expr>)")
  848. INSERT INTO helpsql VALUES("FUNCTIONS",69,"SPACE (<integer_expr>)")
  849. INSERT INTO helpsql VALUES("FUNCTIONS",70,"SQRT (<float_expr>)")
  850. INSERT INTO helpsql VALUES("FUNCTIONS",71,"STATS_DATE (<table_id>, <index_id>)")
  851. INSERT INTO helpsql VALUES("FUNCTIONS",72,"STR (<float_expr> [, <length> [, <decimal>]]) ")
  852. INSERT INTO helpsql VALUES("FUNCTIONS",73,"STUFF (<char_expr1>, <start>, <length>, <char_expr2>)")
  853. INSERT INTO helpsql VALUES("FUNCTIONS",74,"SUBSTRING (<expression>, <start>, <length>)")
  854. INSERT INTO helpsql VALUES("FUNCTIONS",75,"SUM([ALL | DISTINCT] <expression>)")
  855. INSERT INTO helpsql VALUES("FUNCTIONS",76,"SUSER_ID (['<login_name>'])")
  856. INSERT INTO helpsql VALUES("FUNCTIONS",77,"SUSER_NAME ([<server_user_id>])")
  857. INSERT INTO helpsql VALUES("FUNCTIONS",78,"SYSTEM_USER (Used with DEFAULT constraints ONLY)")
  858. INSERT INTO helpsql VALUES("FUNCTIONS",79,"TAN (<float_expr>)")
  859. INSERT INTO helpsql VALUES("FUNCTIONS",80,"TEXTPTR (<column_name>)")
  860. INSERT INTO helpsql VALUES("FUNCTIONS",81,"TEXTVALID ('<table_name>.<column_name>', <text_ ptr>) ")
  861. INSERT INTO helpsql VALUES("FUNCTIONS",82,"UPPER (<char_expr>)")
  862. INSERT INTO helpsql VALUES("FUNCTIONS",83,"USER (Used with DEFAULT constraints ONLY)")
  863. INSERT INTO helpsql VALUES("FUNCTIONS",84,"USER_ID (['<user_name>'])")
  864. INSERT INTO helpsql VALUES("FUNCTIONS",85,"USER_NAME ([<user_id>])")
  865. go
  866. DUMP TRANSACTION master WITH NO_LOG
  867. go
  868. INSERT INTO helpsql VALUES("GRANT",1,"GRANT Statement")
  869. INSERT INTO helpsql VALUES("GRANT",2,"Assigns permissions to users.")
  870. INSERT INTO helpsql VALUES("GRANT",3," ")
  871. INSERT INTO helpsql VALUES("GRANT",4,"Statement permissions:")
  872. INSERT INTO helpsql VALUES("GRANT",5,"     GRANT {ALL | <statement_list>} ")
  873. INSERT INTO helpsql VALUES("GRANT",6,"     TO {PUBLIC | <name_list>}")
  874. INSERT INTO helpsql VALUES("GRANT",7," ")
  875. INSERT INTO helpsql VALUES("GRANT",8,"Object permissions:")
  876. INSERT INTO helpsql VALUES("GRANT",9,"     GRANT {ALL | <permission_list>}")
  877. INSERT INTO helpsql VALUES("GRANT",10,"     ON {<table_name> [(<column_list>)] | ")
  878. INSERT INTO helpsql VALUES("GRANT",11,"         <view_name> [(<column_list>)] | ")
  879. INSERT INTO helpsql VALUES("GRANT",12,"         <stored_procedure_name> | ")
  880. INSERT INTO helpsql VALUES("GRANT",13,"         <extended_stored_procedure_name>}")
  881. INSERT INTO helpsql VALUES("GRANT",14,"     TO {PUBLIC | <name_list>}")
  882. INSERT INTO helpsql VALUES("INSERT",1,"INSERT Statement")
  883. INSERT INTO helpsql VALUES("INSERT",2,"Adds a new row to a table or a view.")
  884. INSERT INTO helpsql VALUES("INSERT",3," ")
  885. INSERT INTO helpsql VALUES("INSERT",4,"INSERT [INTO]")
  886. INSERT INTO helpsql VALUES("INSERT",5,"     {<table_name> | <view_name>} [(<column_list>)]")
  887. INSERT INTO helpsql VALUES("INSERT",6,"{DEFAULT VALUES | <values_list> | <select_statement>}")
  888. go
  889. DUMP TRANSACTION master WITH NO_LOG
  890. go
  891. INSERT INTO helpsql VALUES("KILL",1,"KILL Statement")
  892. INSERT INTO helpsql VALUES("KILL",2,"Terminates a user's process based on the system process ID.")
  893. INSERT INTO helpsql VALUES("KILL",3," ")
  894. INSERT INTO helpsql VALUES("KILL",4,"KILL <spid>")
  895. INSERT INTO helpsql VALUES("LOAD",1,"LOAD Statement")
  896. INSERT INTO helpsql VALUES("LOAD",2,"Restores a backup copy of a user database and its transaction log (LOAD ")
  897. INSERT INTO helpsql VALUES("LOAD",3,"DATABASE) or only the transaction log (LOAD TRANSACTION) from a dump ")
  898. INSERT INTO helpsql VALUES("LOAD",4,"that was created using the DUMP statement. The LOAD statement can also ")
  899. INSERT INTO helpsql VALUES("LOAD",5,"be used to retrieve header informantion from a database dump (LOAD ")
  900. INSERT INTO helpsql VALUES("LOAD",6,"HEADERONLY).")
  901. INSERT INTO helpsql VALUES("LOAD",7," ")
  902. INSERT INTO helpsql VALUES("LOAD",8,"Loading a database:")
  903. INSERT INTO helpsql VALUES("LOAD",9,"     LOAD DATABASE {<dbname> | @<dbname_var>}")
  904. INSERT INTO helpsql VALUES("LOAD",10,"          FROM <dump_device> [, <dump_device2> [..., <dump_device32>]]")
  905. INSERT INTO helpsql VALUES("LOAD",11,"     [WITH <options> ")
  906. INSERT INTO helpsql VALUES("LOAD",12,"          [[,] STATS [ = <percentage>]]]")
  907. INSERT INTO helpsql VALUES("LOAD",13," ")
  908. INSERT INTO helpsql VALUES("LOAD",14,"Loading a transaction log:")
  909. INSERT INTO helpsql VALUES("LOAD",15,"     LOAD TRANSACTION {<dbname> | @<dbname_var>} ")
  910. INSERT INTO helpsql VALUES("LOAD",16,"          FROM <dump_device> [, <dump_device2> [..., <dump_device32>]]")
  911. INSERT INTO helpsql VALUES("LOAD",17,"     [WITH <options>]")
  912. INSERT INTO helpsql VALUES("LOAD",18," ")
  913. INSERT INTO helpsql VALUES("LOAD",25,"Loading header information:")
  914. INSERT INTO helpsql VALUES("LOAD",26,"     LOAD HEADERONLY")
  915. INSERT INTO helpsql VALUES("LOAD",27,"          FROM <dump_device>")
  916. INSERT INTO helpsql VALUES("LOAD",28," ")
  917. INSERT INTO helpsql VALUES("LOAD",29,"where")
  918. INSERT INTO helpsql VALUES("LOAD",30," ")
  919. INSERT INTO helpsql VALUES("LOAD",31,"<dump_device> =")
  920. INSERT INTO helpsql VALUES("LOAD",32,"     { <dump_device_name> | @<dump_device_namevar>} ")
  921. INSERT INTO helpsql VALUES("LOAD",33,"          | {DISK | TAPE | FLOPPY | PIPE} = ")
  922. INSERT INTO helpsql VALUES("LOAD",34,"          {'<temp_dump_device>' | @<temp_dump_device_var>}} ")
  923. INSERT INTO helpsql VALUES("LOAD",35,"     [VOLUME = {<volid> | @<volid_var>}]")
  924. INSERT INTO helpsql VALUES("LOAD",36," ")
  925. INSERT INTO helpsql VALUES("LOAD",37,"<options> =")
  926. INSERT INTO helpsql VALUES("LOAD",38,"     [[,] {UNLOAD | NOUNLOAD}]")
  927. INSERT INTO helpsql VALUES("LOAD",39,"     [[,] {SKIP | NOSKIP}]")
  928. INSERT INTO helpsql VALUES("LOAD",40,"     [[,] {FILE = <fileno>}]")
  929. go
  930. DUMP TRANSACTION master WITH NO_LOG
  931. go
  932. INSERT INTO helpsql VALUES("OPERATORS",1,"Operators")
  933. INSERT INTO helpsql VALUES("OPERATORS",2,"Operators are symbols used to perform mathematical computations and/or ")
  934. INSERT INTO helpsql VALUES("OPERATORS",3,"comparisons between columns or variables. Comparisons can be made ")
  935. INSERT INTO helpsql VALUES("OPERATORS",4,"between like datatypes without any conversion, implicit conversion, or ")
  936. INSERT INTO helpsql VALUES("OPERATORS",5,"if necessary, explicit conversion. When comparisons are made between ")
  937. INSERT INTO helpsql VALUES("OPERATORS",6,"implicitly converted datatypes, the result will have the greater ")
  938. INSERT INTO helpsql VALUES("OPERATORS",7,"precision, the larger scale, and/or the larger/longer datatype. ")
  939. INSERT INTO helpsql VALUES("OPERATORS",8," ")
  940. INSERT INTO helpsql VALUES("OPERATORS",9,"-      Subtraction")
  941. INSERT INTO helpsql VALUES("OPERATORS",10,"%      Modulo")
  942. INSERT INTO helpsql VALUES("OPERATORS",11,"&      Bitwise AND (two operands)")
  943. INSERT INTO helpsql VALUES("OPERATORS",12,"*      Multiplication")
  944. INSERT INTO helpsql VALUES("OPERATORS",13,"*=     Outer Join ")
  945. INSERT INTO helpsql VALUES("OPERATORS",14,"+      Addition")
  946. INSERT INTO helpsql VALUES("OPERATORS",15,"/      Division")
  947. INSERT INTO helpsql VALUES("OPERATORS",16,"<      Less than")
  948. INSERT INTO helpsql VALUES("OPERATORS",17,"< >    Not equal to")
  949. INSERT INTO helpsql VALUES("OPERATORS",18,"<=     Less than or equal to")
  950. INSERT INTO helpsql VALUES("OPERATORS",19,"=      Equal to")
  951. INSERT INTO helpsql VALUES("OPERATORS",20,"=*     Outer Join")
  952. INSERT INTO helpsql VALUES("OPERATORS",21,">      Greater than")
  953. INSERT INTO helpsql VALUES("OPERATORS",22,">=     Greater than or equal to")
  954. INSERT INTO helpsql VALUES("OPERATORS",23,"^      Bitwise exclusive OR (two operands)")
  955. INSERT INTO helpsql VALUES("OPERATORS",24,"|      Bitwise OR (two operands)")
  956. INSERT INTO helpsql VALUES("OPERATORS",25,"~      Bitwise NOT (one operand)")
  957. go
  958. DUMP TRANSACTION master WITH NO_LOG
  959. go
  960. INSERT INTO helpsql VALUES("PRINT",1,"PRINT Statement")
  961. INSERT INTO helpsql VALUES("PRINT",2,"Returns a user-defined message to the client's message handler.")
  962. INSERT INTO helpsql VALUES("PRINT",3," ")
  963. INSERT INTO helpsql VALUES("PRINT",4,"PRINT {'<any ASCII text>' | @<local_variable> | @@<global_variable>}")
  964. INSERT INTO helpsql VALUES("RAISERROR",1,"RAISERROR Statement")
  965. INSERT INTO helpsql VALUES("RAISERROR",2,"Returns a user-defined error message and sets a system flag to record ")
  966. INSERT INTO helpsql VALUES("RAISERROR",3,"that an error has occurred. RAISERROR lets the client retrieve an entry ")
  967. INSERT INTO helpsql VALUES("RAISERROR",4,"from the sysmessages table or build a message dynamically with user-")
  968. INSERT INTO helpsql VALUES("RAISERROR",5,"specified severity and state information. Once defined, this message is ")
  969. INSERT INTO helpsql VALUES("RAISERROR",6,"sent back to the client as a server error message.")
  970. INSERT INTO helpsql VALUES("RAISERROR",7," ")
  971. INSERT INTO helpsql VALUES("RAISERROR",8,"RAISERROR ({<msg_id> | <msg_str>}, <severity>, <state>")
  972. INSERT INTO helpsql VALUES("RAISERROR",9,"          [, <argument1> [, <argument2>]] )")
  973. INSERT INTO helpsql VALUES("RAISERROR",10,"     [WITH LOG]")
  974. go
  975. DUMP TRANSACTION master WITH NO_LOG
  976. go
  977. INSERT INTO helpsql VALUES("RECONFIGURE",1,"RECONFIGURE Statement")
  978. INSERT INTO helpsql VALUES("RECONFIGURE",2,"Installs a changed configuration option used only with the sp_configure ")
  979. INSERT INTO helpsql VALUES("RECONFIGURE",3,"system stored procedure.")
  980. INSERT INTO helpsql VALUES("RECONFIGURE",4," ")
  981. INSERT INTO helpsql VALUES("RECONFIGURE",5,"RECONFIGURE [WITH OVERRIDE]")
  982. INSERT INTO helpsql VALUES("REVOKE",1,"REVOKE Statement")
  983. INSERT INTO helpsql VALUES("REVOKE",2,"Revokes object and statement permissions from users.")
  984. INSERT INTO helpsql VALUES("REVOKE",3," ")
  985. INSERT INTO helpsql VALUES("REVOKE",4,"Statement permissions:")
  986. INSERT INTO helpsql VALUES("REVOKE",5,"     REVOKE {ALL | <statement_list>} ")
  987. INSERT INTO helpsql VALUES("REVOKE",6,"     FROM {PUBLIC | <name_list>}")
  988. INSERT INTO helpsql VALUES("REVOKE",7," ")
  989. INSERT INTO helpsql VALUES("REVOKE",8,"Object permissions:")
  990. INSERT INTO helpsql VALUES("REVOKE",9,"     REVOKE {ALL | <permission_list>} ")
  991. INSERT INTO helpsql VALUES("REVOKE",10,"     ON {<table_name> [(<column_list>)] | ")
  992. INSERT INTO helpsql VALUES("REVOKE",11,"          <view_name> [(<column_list>)] | ")
  993. INSERT INTO helpsql VALUES("REVOKE",12,"          <stored_procedure_name> | ")
  994. INSERT INTO helpsql VALUES("REVOKE",13,"          <extended_stored_procedure_name>} ")
  995. INSERT INTO helpsql VALUES("REVOKE",14,"     FROM {PUBLIC | <name_list>}")
  996. go
  997. DUMP TRANSACTION master WITH NO_LOG
  998. go
  999. INSERT INTO helpsql VALUES("SELECT",1,"SELECT Statement")
  1000. INSERT INTO helpsql VALUES("SELECT",2,"Retrieves rows from the database.")
  1001. INSERT INTO helpsql VALUES("SELECT",3," ")
  1002. INSERT INTO helpsql VALUES("SELECT",4,"SELECT [ALL | DISTINCT] <select_list>")
  1003. INSERT INTO helpsql VALUES("SELECT",5,"     [INTO [<new_table_name>]] ")
  1004. INSERT INTO helpsql VALUES("SELECT",6,"[FROM {<table_name> | <view_name>}[(<optimizer_hints>)] ")
  1005. INSERT INTO helpsql VALUES("SELECT",7,"     [[, {<table_name2> | <view_name2>}[(<optimizer_hints>)] ")
  1006. INSERT INTO helpsql VALUES("SELECT",8,"     [..., {<table_name16> | <view_name16>}[(<optimizer_hints>)]]] ")
  1007. INSERT INTO helpsql VALUES("SELECT",9,"[WHERE clause] ")
  1008. INSERT INTO helpsql VALUES("SELECT",10,"[GROUP BY clause]")
  1009. INSERT INTO helpsql VALUES("SELECT",11,"[HAVING clause]")
  1010. INSERT INTO helpsql VALUES("SELECT",12,"[ORDER BY clause]")
  1011. INSERT INTO helpsql VALUES("SELECT",13,"[COMPUTE clause] ")
  1012. INSERT INTO helpsql VALUES("SELECT",14,"[FOR BROWSE]")
  1013. INSERT INTO helpsql VALUES("SELECT",15," ")
  1014. INSERT INTO helpsql VALUES("SELECT",16,"where")
  1015. INSERT INTO helpsql VALUES("SELECT",17," ")
  1016. INSERT INTO helpsql VALUES("SELECT",18,"<table_name> | <view_name> = ")
  1017. INSERT INTO helpsql VALUES("SELECT",19,"     [[<database>.]<owner>.]{<table_name>. | <view_name>.}")
  1018. INSERT INTO helpsql VALUES("SELECT",20," ")
  1019. INSERT INTO helpsql VALUES("SELECT",21,"<optimizer_hints> =")
  1020. INSERT INTO helpsql VALUES("SELECT",22,"     One or more of the following, separated with a space:")
  1021. INSERT INTO helpsql VALUES("SELECT",23,"          [INDEX = {<index_name> | <index_id>}]")
  1022. INSERT INTO helpsql VALUES("SELECT",24,"          [NOLOCK]")
  1023. INSERT INTO helpsql VALUES("SELECT",25,"          [HOLDLOCK]")
  1024. INSERT INTO helpsql VALUES("SELECT",26,"          [UPDLOCK]")
  1025. INSERT INTO helpsql VALUES("SELECT",27,"          [TABLOCK]")
  1026. INSERT INTO helpsql VALUES("SELECT",28,"          [PAGLOCK]")
  1027. INSERT INTO helpsql VALUES("SELECT",29,"          [TABLOCKX]")
  1028. INSERT INTO helpsql VALUES("SELECT",30,"          [FASTFIRSTROW]")
  1029. INSERT INTO helpsql VALUES("SELECT",31," ")
  1030. INSERT INTO helpsql VALUES("SELECT",32,"WHERE clause = ")
  1031. INSERT INTO helpsql VALUES("SELECT",33,"     WHERE <search_conditions>")
  1032. INSERT INTO helpsql VALUES("SELECT",34," ")
  1033. INSERT INTO helpsql VALUES("SELECT",35,"GROUP BY clause = ")
  1034. INSERT INTO helpsql VALUES("SELECT",36,"     GROUP BY [ALL] <aggregate_free_expression> ")
  1035. INSERT INTO helpsql VALUES("SELECT",37,"          [, <aggregate_free_expression>]...")
  1036. INSERT INTO helpsql VALUES("SELECT",38," ")
  1037. INSERT INTO helpsql VALUES("SELECT",39,"HAVING clause = ")
  1038. INSERT INTO helpsql VALUES("SELECT",40,"     HAVING <search_conditions>")
  1039. INSERT INTO helpsql VALUES("SELECT",41," ")
  1040. INSERT INTO helpsql VALUES("SELECT",42,"ORDER BY clause = ")
  1041. INSERT INTO helpsql VALUES("SELECT",43,"     ORDER BY {{<table_name>. | <view_name>.}<column_name> | ")
  1042. INSERT INTO helpsql VALUES("SELECT",44,"               <select_list_number> | <expression>} [ASC | DESC] ")
  1043. INSERT INTO helpsql VALUES("SELECT",45,"             [...{{<table_name16>. | <view_name16>.}<column_name> | ")
  1044. INSERT INTO helpsql VALUES("SELECT",46,"                      <select_list_number> | <expression>} [ASC | DESC]]")
  1045. INSERT INTO helpsql VALUES("SELECT",47," ")
  1046. INSERT INTO helpsql VALUES("SELECT",48,"COMPUTE clause = ")
  1047. INSERT INTO helpsql VALUES("SELECT",49,"     COMPUTE <row_aggregate>(<column_name>) ")
  1048. INSERT INTO helpsql VALUES("SELECT",50,"               [, <row_aggregate>(<column_name>)...]")
  1049. INSERT INTO helpsql VALUES("SELECT",51,"     [BY <column_name> [, <column_name>]...] ")
  1050. go
  1051. DUMP TRANSACTION master WITH NO_LOG
  1052. go
  1053. INSERT INTO helpsql VALUES("SET",1,"SET Statement")
  1054. INSERT INTO helpsql VALUES("SET",2,"Sets SQL Server query-processing options for the duration of the user's ")
  1055. INSERT INTO helpsql VALUES("SET",3,"work session, or for the duration of a running trigger or a stored ")
  1056. INSERT INTO helpsql VALUES("SET",4,"procedure.")
  1057. INSERT INTO helpsql VALUES("SET",5," ")
  1058. INSERT INTO helpsql VALUES("SET",6,"SET {")
  1059. INSERT INTO helpsql VALUES("SET",7,"{{{ANSI_NULL_DFLT_OFF | ANSI_NULL_DFLT_ON}")
  1060. INSERT INTO helpsql VALUES("SET",8,"| ARITHABORT ")
  1061. INSERT INTO helpsql VALUES("SET",9,"| ARITHIGNORE ")
  1062. INSERT INTO helpsql VALUES("SET",10,"| FMTONLY ")
  1063. INSERT INTO helpsql VALUES("SET",11,"| FORCEPLAN ")
  1064. INSERT INTO helpsql VALUES("SET",12,"| IDENTITY_INSERT [<database>.[<owner>.]]<tablename>")
  1065. INSERT INTO helpsql VALUES("SET",13,"| NOCOUNT ")
  1066. INSERT INTO helpsql VALUES("SET",14,"| NOEXEC ")
  1067. INSERT INTO helpsql VALUES("SET",15,"| OFFSETS {<keyword_list>} ")
  1068. INSERT INTO helpsql VALUES("SET",16,"| PARSEONLY ")
  1069. INSERT INTO helpsql VALUES("SET",17,"| PROCID ")
  1070. INSERT INTO helpsql VALUES("SET",18,"| QUOTED_IDENTIFIER")
  1071. INSERT INTO helpsql VALUES("SET",19,"| SHOWPLAN ")
  1072. INSERT INTO helpsql VALUES("SET",20,"| STATISTICS IO ")
  1073. INSERT INTO helpsql VALUES("SET",21,"| STATISTICS TIME} ")
  1074. INSERT INTO helpsql VALUES("SET",22,"     {ON | OFF}} ")
  1075. INSERT INTO helpsql VALUES("SET",23,"| DATEFIRST <number> ")
  1076. INSERT INTO helpsql VALUES("SET",24,"| DATEFORMAT <format> ")
  1077. INSERT INTO helpsql VALUES("SET",25,"| DEADLOCKPRIORITY {LOW | NORMAL}")
  1078. INSERT INTO helpsql VALUES("SET",26,"| LANGUAGE <language>")
  1079. INSERT INTO helpsql VALUES("SET",27,"| ROWCOUNT <number> ")
  1080. INSERT INTO helpsql VALUES("SET",28,"| TEXTSIZE <number>")
  1081. INSERT INTO helpsql VALUES("SET",29,"| TRANSACTION ISOLATION LEVEL {READ COMMITTED | READ ")
  1082. INSERT INTO helpsql VALUES("SET",30,"     UNCOMMITTED | REPEATABLE READ | SERIALIZABLE}}")
  1083. go
  1084. DUMP TRANSACTION master WITH NO_LOG
  1085. go
  1086. INSERT INTO helpsql VALUES("SETUSER",1,"SETUSER Statement")
  1087. INSERT INTO helpsql VALUES("SETUSER",2,"Allows a database owner to impersonate another user. The SETUSER ")
  1088. INSERT INTO helpsql VALUES("SETUSER",3,"statement is used by the system administrator or a database owner when ")
  1089. INSERT INTO helpsql VALUES("SETUSER",4,"he or she wants to adopt the identity of another user in order to use ")
  1090. INSERT INTO helpsql VALUES("SETUSER",5,"another user's database object, to grant permissions to that object, to ")
  1091. INSERT INTO helpsql VALUES("SETUSER",6,"create an object, and so on.")
  1092. INSERT INTO helpsql VALUES("SETUSER",7," ")
  1093. INSERT INTO helpsql VALUES("SETUSER",8,"SETUSER ['<username>' [WITH NORESET]]")
  1094. INSERT INTO helpsql VALUES("SHUTDOWN",1,"SHUTDOWN Statement")
  1095. INSERT INTO helpsql VALUES("SHUTDOWN",2,"Stops SQL Server. Only the system administrator can execute this statement.")
  1096. INSERT INTO helpsql VALUES("SHUTDOWN",3," ")
  1097. INSERT INTO helpsql VALUES("SHUTDOWN",4,"SHUTDOWN [WITH NOWAIT]")
  1098. go
  1099. DUMP TRANSACTION master WITH NO_LOG
  1100. go
  1101. INSERT INTO helpsql VALUES("sp_column_privileges",1,"sp_column_privileges Catalog Stored Procedure")
  1102. INSERT INTO helpsql VALUES("sp_column_privileges",2,"Returns column privilege information for a single table in the current ")
  1103. INSERT INTO helpsql VALUES("sp_column_privileges",3,"environment.")
  1104. INSERT INTO helpsql VALUES("sp_column_privileges",4," ")
  1105. INSERT INTO helpsql VALUES("sp_column_privileges",5,"sp_column_privileges <table_name> [, <table_owner>] ")
  1106. INSERT INTO helpsql VALUES("sp_column_privileges",6,"     [, <table_qualifier>] [, <column_name>]")
  1107. INSERT INTO helpsql VALUES("sp_columns",1,"sp_columns Catalog Stored Procedure")
  1108. INSERT INTO helpsql VALUES("sp_columns",2,"Returns column information for a single object that can be queried in ")
  1109. INSERT INTO helpsql VALUES("sp_columns",3,"the current environment. The returned columns belong to a table or a ")
  1110. INSERT INTO helpsql VALUES("sp_columns",4,"view.")
  1111. INSERT INTO helpsql VALUES("sp_columns",5," ")
  1112. INSERT INTO helpsql VALUES("sp_columns",6,"sp_columns <object_name> [, <object_owner>] [, <object_qualifier>] ")
  1113. INSERT INTO helpsql VALUES("sp_columns",7,"     [, <column_name>]")
  1114. INSERT INTO helpsql VALUES("sp_databases",1,"sp_databases Catalog Stored Procedure")
  1115. INSERT INTO helpsql VALUES("sp_databases",2,"Lists databases present in the SQL Server installation or accessible ")
  1116. INSERT INTO helpsql VALUES("sp_databases",3,"through a database gateway.")
  1117. INSERT INTO helpsql VALUES("sp_databases",4," ")
  1118. INSERT INTO helpsql VALUES("sp_databases",5,"sp_databases")
  1119. INSERT INTO helpsql VALUES("sp_datatype_info",1,"sp_datatype_info Catalog Stored Procedure")
  1120. INSERT INTO helpsql VALUES("sp_datatype_info",2,"Returns information about the datatypes supported by the current ")
  1121. INSERT INTO helpsql VALUES("sp_datatype_info",3,"environment.")
  1122. INSERT INTO helpsql VALUES("sp_datatype_info",4," ")
  1123. INSERT INTO helpsql VALUES("sp_datatype_info",5,"sp_datatype_info [<data_type>]")
  1124. INSERT INTO helpsql VALUES("sp_fkeys",1,"sp_fkeys Catalog Stored Procedure")
  1125. INSERT INTO helpsql VALUES("sp_fkeys",2,"Returns logical foreign key information for the current environment.")
  1126. INSERT INTO helpsql VALUES("sp_fkeys",3," ")
  1127. INSERT INTO helpsql VALUES("sp_fkeys",4,"sp_fkeys [<pktable_name>] [, <pktable_owner>] [, <pktable_qualifier>] ")
  1128. INSERT INTO helpsql VALUES("sp_fkeys",5,"     [, <fktable_name>] [, <fktable_owner>] [, <fktable_qualifier>]")
  1129. INSERT INTO helpsql VALUES("sp_pkeys",1,"sp_pkeys Catalog Stored Procedure")
  1130. INSERT INTO helpsql VALUES("sp_pkeys",2,"Returns primary key information for a single table in the current ")
  1131. INSERT INTO helpsql VALUES("sp_pkeys",3,"environment.")
  1132. INSERT INTO helpsql VALUES("sp_pkeys",4," ")
  1133. INSERT INTO helpsql VALUES("sp_pkeys",5,"sp_pkeys <table_name> [, <table_owner>] [, <table_qualifier>]")
  1134. INSERT INTO helpsql VALUES("sp_server_info",1,"sp_server_info Catalog Stored Procedure")
  1135. INSERT INTO helpsql VALUES("sp_server_info",2,"Returns a list of attribute names and matching values for SQL Server, ")
  1136. INSERT INTO helpsql VALUES("sp_server_info",3,"the database gateway, and/or the underlying data source.")
  1137. INSERT INTO helpsql VALUES("sp_server_info",4," ")
  1138. INSERT INTO helpsql VALUES("sp_server_info",5,"sp_server_info [[@attribute_id =] <attribute_id>]")
  1139. INSERT INTO helpsql VALUES("sp_special_columns",1,"sp_special_columns Catalog Stored Procedure")
  1140. INSERT INTO helpsql VALUES("sp_special_columns",2,"Returns the optimal set of columns that uniquely identify a row in the ")
  1141. INSERT INTO helpsql VALUES("sp_special_columns",3,"table and columns that are automatically updated when any value in the ")
  1142. INSERT INTO helpsql VALUES("sp_special_columns",4,"row is updated by a transaction.")
  1143. INSERT INTO helpsql VALUES("sp_special_columns",5," ")
  1144. INSERT INTO helpsql VALUES("sp_special_columns",6,"sp_special_columns <table_name> [, <table_owner>] [, <table_qualifier>] ")
  1145. INSERT INTO helpsql VALUES("sp_special_columns",7,"     [, <col_type>] [, scope] [, nullable]")
  1146. INSERT INTO helpsql VALUES("sp_sproc_columns",1,"sp_sproc_columns Catalog Stored Procedure")
  1147. INSERT INTO helpsql VALUES("sp_sproc_columns",2,"Returns column information for a single stored procedure in the current ")
  1148. INSERT INTO helpsql VALUES("sp_sproc_columns",3,"environment.")
  1149. INSERT INTO helpsql VALUES("sp_sproc_columns",4," ")
  1150. INSERT INTO helpsql VALUES("sp_sproc_columns",5,"sp_sproc_columns <procedure_name> [, <procedure_owner>] ")
  1151. INSERT INTO helpsql VALUES("sp_sproc_columns",6,"     [, <procedure_qualifier>] [, <column_name>]")
  1152. INSERT INTO helpsql VALUES("sp_statistics",1,"sp_statistics Catalog Stored Procedure")
  1153. INSERT INTO helpsql VALUES("sp_statistics",2,"Returns a list of all indexes on a specified table.")
  1154. INSERT INTO helpsql VALUES("sp_statistics",3," ")
  1155. INSERT INTO helpsql VALUES("sp_statistics",4,"sp_statistics <table_name> [, <table_owner>] [, <table_qualifier>] ")
  1156. INSERT INTO helpsql VALUES("sp_statistics",5,"     [, <index_name>] [, <is_unique>]")
  1157. INSERT INTO helpsql VALUES("sp_stored_procedures",1,"sp_stored_procedures Catalog Stored Procedure")
  1158. INSERT INTO helpsql VALUES("sp_stored_procedures",2,"Returns a list of stored procedures in the current environment.")
  1159. INSERT INTO helpsql VALUES("sp_stored_procedures",3," ")
  1160. INSERT INTO helpsql VALUES("sp_stored_procedures",4,"sp_stored_procedures [<procedure_name>] [, <procedure_owner>] ")
  1161. INSERT INTO helpsql VALUES("sp_stored_procedures",5,"     [, <procedure_qualifier>]")
  1162. INSERT INTO helpsql VALUES("sp_table_privileges",1,"sp_table_privileges Catalog Stored Procedure")
  1163. INSERT INTO helpsql VALUES("sp_table_privileges",2,"Returns privilege information for a single table in the current ")
  1164. INSERT INTO helpsql VALUES("sp_table_privileges",3,"environment.")
  1165. INSERT INTO helpsql VALUES("sp_table_privileges",4," ")
  1166. INSERT INTO helpsql VALUES("sp_table_privileges",5,"sp_table_privileges <table_name> [, <table_owner>] [, <table_qualifier>]")
  1167. INSERT INTO helpsql VALUES("sp_tables",1,"sp_tables Catalog Stored Procedure")
  1168. INSERT INTO helpsql VALUES("sp_tables",2,"Returns a list of objects that can be queried in the current environment ")
  1169. INSERT INTO helpsql VALUES("sp_tables",3,"(that is, any object that can appear in a FROM clause).")
  1170. INSERT INTO helpsql VALUES("sp_tables",4," ")
  1171. INSERT INTO helpsql VALUES("sp_tables",5,"sp_tables [<table_name>] [, <table_owner>] [, <table_qualifier>] ")
  1172. INSERT INTO helpsql VALUES("sp_tables",6,"     [, <table_type>]")
  1173. go
  1174. DUMP TRANSACTION master WITH NO_LOG
  1175. go
  1176. INSERT INTO helpsql VALUES("xp_cmdshell",1,"xp_cmdshell Extended Stored Procedure")
  1177. INSERT INTO helpsql VALUES("xp_cmdshell",2,"Executes a given command string as an operating-system command shell and ")
  1178. INSERT INTO helpsql VALUES("xp_cmdshell",3,"returns any output as rows of text.")
  1179. INSERT INTO helpsql VALUES("xp_cmdshell",4," ")
  1180. INSERT INTO helpsql VALUES("xp_cmdshell",5,"xp_cmdshell <command_string> [, no_output]")
  1181. INSERT INTO helpsql VALUES("xp_deletemail",1,"xp_deletemail Extended Stored Procedure")
  1182. INSERT INTO helpsql VALUES("xp_deletemail",2,"Deletes a message from the SQL Server inbox. This procedure is used by ")
  1183. INSERT INTO helpsql VALUES("xp_deletemail",3,"the sp_processmail system stored procedure to process mail in the SQL ")
  1184. INSERT INTO helpsql VALUES("xp_deletemail",4,"Server inbox.")
  1185. INSERT INTO helpsql VALUES("xp_deletemail",5," ")
  1186. INSERT INTO helpsql VALUES("xp_deletemail",6,"xp_deletemail [@msg_id = ] <msg_id>")
  1187. INSERT INTO helpsql VALUES("xp_dsninfo",1,"xp_dsninfo Extended Stored Procedure")
  1188. INSERT INTO helpsql VALUES("xp_dsninfo",2,"Returns the information values for a ODBC Data Source Name.")
  1189. INSERT INTO helpsql VALUES("xp_dsninfo",3," ")
  1190. INSERT INTO helpsql VALUES("xp_dsninfo",4,"xp_dsninfo dsn, [infotype]")
  1191. INSERT INTO helpsql VALUES("xp_enumdsn",1,"xp_enumdsn Extended Stored Procedure")
  1192. INSERT INTO helpsql VALUES("xp_enumdsn",2,"Provides a list of ODBC Data Source Names accessible to the publisher. ")
  1193. INSERT INTO helpsql VALUES("xp_enumdsn",3," ")
  1194. INSERT INTO helpsql VALUES("xp_enumdsn",4,"xp_enumdsn")
  1195. INSERT INTO helpsql VALUES("xp_enumgroups",1,"xp_enumgroups Extended Stored Procedure")
  1196. INSERT INTO helpsql VALUES("xp_enumgroups",2,"Provides a list of local Windows NT - based groups or a list of groups ")
  1197. INSERT INTO helpsql VALUES("xp_enumgroups",3,"defined in a specified Windows NT domain.")
  1198. INSERT INTO helpsql VALUES("xp_enumgroups",4," ")
  1199. INSERT INTO helpsql VALUES("xp_enumgroups",5,"xp_enumgroups [<domain_name>]")
  1200. INSERT INTO helpsql VALUES("xp_findnextmsg",1,"xp_findnextmsg Extended Stored Procedure")
  1201. INSERT INTO helpsql VALUES("xp_findnextmsg",2,"Accepts a message ID for input and returns the message ID for output. ")
  1202. INSERT INTO helpsql VALUES("xp_findnextmsg",3," ")
  1203. INSERT INTO helpsql VALUES("xp_findnextmsg",4,"xp_findnextmsg [@msg_id = <msg_id> [OUTPUT]] ")
  1204. INSERT INTO helpsql VALUES("xp_findnextmsg",5,"     [, @type = <type>] ")
  1205. INSERT INTO helpsql VALUES("xp_findnextmsg",6,"     [, @unread_only = {'TRUE' | 'FALSE'}])")
  1206. INSERT INTO helpsql VALUES("xp_grantlogin",1,"xp_grantlogin Extended Stored Procedure")
  1207. INSERT INTO helpsql VALUES("xp_grantlogin",2,"Grants SQL Server access to a Windows NT - based group or user.")
  1208. INSERT INTO helpsql VALUES("xp_grantlogin",3," ")
  1209. INSERT INTO helpsql VALUES("xp_grantlogin",4,"xp_grantlogin '<account_name>' [, {'admin' | 'repl' | 'user'}]")
  1210. INSERT INTO helpsql VALUES("xp_logevent",1,"xp_logevent Extended Stored Procedure")
  1211. INSERT INTO helpsql VALUES("xp_logevent",2,"Logs a user-defined message in the SQL Server log file and/or in the Windows ")
  1212. INSERT INTO helpsql VALUES("xp_logevent",3,"NT Event Viewer. When sending messages from Transact-SQL procedures, triggers, ")
  1213. INSERT INTO helpsql VALUES("xp_logevent",4,"batches, and so on, use the RAISERROR statement instead of xp_logevent.")
  1214. INSERT INTO helpsql VALUES("xp_logevent",5," ")
  1215. INSERT INTO helpsql VALUES("xp_logevent",6,"xp_logevent <error_number>, <message>, [<severity>]")
  1216. INSERT INTO helpsql VALUES("xp_loginconfig",1,"xp_loginconfig Extended Stored Procedure")
  1217. INSERT INTO helpsql VALUES("xp_loginconfig",2,"Reports the login security configuration of the server.")
  1218. INSERT INTO helpsql VALUES("xp_loginconfig",3," ")
  1219. INSERT INTO helpsql VALUES("xp_loginconfig",4,"xp_loginconfig ['<config_name>']")
  1220. go
  1221. DUMP TRANSACTION master WITH NO_LOG
  1222. go
  1223. INSERT INTO helpsql VALUES("xp_logininfo",1,"xp_logininfo Extended Stored Procedure")
  1224. INSERT INTO helpsql VALUES("xp_logininfo",2,"Reports the account, the type of account, the privilege level of the ")
  1225. INSERT INTO helpsql VALUES("xp_logininfo",3,"account, the map name of the account, and the permission path by which ")
  1226. INSERT INTO helpsql VALUES("xp_logininfo",4,"the account has access to SQL Server.")
  1227. INSERT INTO helpsql VALUES("xp_logininfo",5," ")
  1228. INSERT INTO helpsql VALUES("xp_logininfo",6,"xp_logininfo ['<account_name>' [, 'all' | 'members'] ")
  1229. INSERT INTO helpsql VALUES("xp_logininfo",7,"     [, [@privilege] = <variable_name> OUTPUT]]")
  1230. INSERT INTO helpsql VALUES("xp_msver",1,"xp_msver Extended Stored Procedure")
  1231. INSERT INTO helpsql VALUES("xp_msver",2,"Returns and allows to be queried all SQL Server version information.")
  1232. INSERT INTO helpsql VALUES("xp_msver",3," ")
  1233. INSERT INTO helpsql VALUES("xp_msver",4,"xp_msver [<optname>]")
  1234. INSERT INTO helpsql VALUES("xp_readmail",1,"xp_readmail Extended Stored Procedure")
  1235. INSERT INTO helpsql VALUES("xp_readmail",2,"Reads a mail message from the SQL Server mail inbox. This procedure is ")
  1236. INSERT INTO helpsql VALUES("xp_readmail",3,"used by the sp_processmail system stored procedure to process all mail ")
  1237. INSERT INTO helpsql VALUES("xp_readmail",4,"in the SQL Server inbox.")
  1238. INSERT INTO helpsql VALUES("xp_readmail",5," ")
  1239. INSERT INTO helpsql VALUES("xp_readmail",6,"xp_readmail ([@msg_id = <msg_id>] ")
  1240. INSERT INTO helpsql VALUES("xp_readmail",7,"     [, @type = <type> [OUTPUT]] ")
  1241. INSERT INTO helpsql VALUES("xp_readmail",8,"     [, @peek = {'TRUE' | 'FALSE'}] ")
  1242. INSERT INTO helpsql VALUES("xp_readmail",9,"     [, @suppress_attach = {'TRUE' | 'FALSE'}] ")
  1243. INSERT INTO helpsql VALUES("xp_readmail",10,"     [, @originator = @<sender> OUTPUT] ")
  1244. INSERT INTO helpsql VALUES("xp_readmail",11,"     [, @subject = @<subject> OUTPUT] ")
  1245. INSERT INTO helpsql VALUES("xp_readmail",12,"     [, @message = @<body_of_message> OUTPUT] ")
  1246. INSERT INTO helpsql VALUES("xp_readmail",13,"     [, @recipients = @<recipient_list> OUTPUT] ")
  1247. INSERT INTO helpsql VALUES("xp_readmail",14,"     [, @cc_list = @<cc_list> OUTPUT] ")
  1248. INSERT INTO helpsql VALUES("xp_readmail",15,"     [, @bcc_list = @<bcc_list> OUTPUT]")
  1249. INSERT INTO helpsql VALUES("xp_readmail",16,"     [, @date_received = @<date> OUTPUT] ")
  1250. INSERT INTO helpsql VALUES("xp_readmail",17,"     [, @unread = {'TRUE' | 'FALSE'}] ")
  1251. INSERT INTO helpsql VALUES("xp_readmail",18,"     [, @attachments = @<temp_file_paths> OUTPUT]) ")
  1252. INSERT INTO helpsql VALUES("xp_readmail",19,"     [, @skipbytes = @<bytes_to> <skip> OUTPUT]) ")
  1253. INSERT INTO helpsql VALUES("xp_readmail",20,"     [, @msg_length = @<length_in_bytes> OUTPUT]) ")
  1254. INSERT INTO helpsql VALUES("xp_revokelogin",1,"xp_revokelogin Extended Stored Procedure")
  1255. INSERT INTO helpsql VALUES("xp_revokelogin",2,"Revokes SQL Server access from a Windows NT - based group or user.")
  1256. INSERT INTO helpsql VALUES("xp_revokelogin",3," ")
  1257. INSERT INTO helpsql VALUES("xp_revokelogin",4,"xp_revokelogin '<account_name>'")
  1258. go
  1259. DUMP TRANSACTION master WITH NO_LOG
  1260. go
  1261. INSERT INTO helpsql VALUES("xp_sendmail",1,"xp_sendmail Extended Stored Procedure")
  1262. INSERT INTO helpsql VALUES("xp_sendmail",2,"Sends a message, and/or a query results set, and/or an attachment to the ")
  1263. INSERT INTO helpsql VALUES("xp_sendmail",3,"specified recipients.")
  1264. INSERT INTO helpsql VALUES("xp_sendmail",4," ")
  1265. INSERT INTO helpsql VALUES("xp_sendmail",5,"xp_sendmail @recipient = <recipient> [; <recipient2>; ")
  1266. INSERT INTO helpsql VALUES("xp_sendmail",6,"               [...; <recipientn>]]")
  1267. INSERT INTO helpsql VALUES("xp_sendmail",7,"     [, @message = <message>] ")
  1268. INSERT INTO helpsql VALUES("xp_sendmail",8,"     [, @query = <query>] ")
  1269. INSERT INTO helpsql VALUES("xp_sendmail",9,"     [, @attachments = <attachments>] ")
  1270. INSERT INTO helpsql VALUES("xp_sendmail",10,"     [, @copy_recipients = <recipient> [; <recipient2>; ")
  1271. INSERT INTO helpsql VALUES("xp_sendmail",11,"          [...; <recipientn>]]] ")
  1272. INSERT INTO helpsql VALUES("xp_sendmail",12,"     [, @blind_copy_recipients = <recipient> [; <recipient2>; ")
  1273. INSERT INTO helpsql VALUES("xp_sendmail",13,"          [...; <recipientn>]]]")
  1274. INSERT INTO helpsql VALUES("xp_sendmail",14,"     [, @subject = <subject>] ")
  1275. INSERT INTO helpsql VALUES("xp_sendmail",15,"     [, @type = <type>] ")
  1276. INSERT INTO helpsql VALUES("xp_sendmail",16,"     [, @attach_results = {'TRUE' | 'FALSE'}] ")
  1277. INSERT INTO helpsql VALUES("xp_sendmail",17,"     [, @no_output = {'TRUE' | 'FALSE'}] ")
  1278. INSERT INTO helpsql VALUES("xp_sendmail",18,"     [, @no_header = {'TRUE' | 'FALSE'}] ")
  1279. INSERT INTO helpsql VALUES("xp_sendmail",19,"     [, @width = <width>] ")
  1280. INSERT INTO helpsql VALUES("xp_sendmail",20,"     [, @separator = <separator>] ")
  1281. INSERT INTO helpsql VALUES("xp_sendmail",21,"     [, @echo_error = {'TRUE' | 'FALSE'}] ")
  1282. INSERT INTO helpsql VALUES("xp_sendmail",22,"     [, @set_user = <user>] ")
  1283. INSERT INTO helpsql VALUES("xp_sendmail",23,"     [, @dbuse = <dbname>]")
  1284. INSERT INTO helpsql VALUES("xp_sprintf",1,"xp_sprintf Extended Stored Procedure")
  1285. INSERT INTO helpsql VALUES("xp_sprintf",2,"Formats and stores a series of characters and values in the string ")
  1286. INSERT INTO helpsql VALUES("xp_sprintf",3,"output parameter. Each format argument is replaced with the ")
  1287. INSERT INTO helpsql VALUES("xp_sprintf",4,"corresponding argument.")
  1288. INSERT INTO helpsql VALUES("xp_sprintf",5," ")
  1289. INSERT INTO helpsql VALUES("xp_sprintf",6,"xp_sprintf @<string> OUTPUT, <format> [, <argument>]...")
  1290. go
  1291. DUMP TRANSACTION master WITH NO_LOG
  1292. go
  1293. INSERT INTO helpsql VALUES("xp_sscanf",1,"xp_sscanf Extended Stored Procedure")
  1294. INSERT INTO helpsql VALUES("xp_sscanf",2,"Reads data from the string into the argument locations given by each ")
  1295. INSERT INTO helpsql VALUES("xp_sscanf",3,"format argument.")
  1296. INSERT INTO helpsql VALUES("xp_sscanf",4," ")
  1297. INSERT INTO helpsql VALUES("xp_sscanf",5,"xp_sscanf <string, <format>, [, <argument>]...")
  1298. INSERT INTO helpsql VALUES("xp_startmail",1,"xp_startmail Extended Stored Procedure")
  1299. INSERT INTO helpsql VALUES("xp_startmail",2,"Starts a SQL Server mail client session.")
  1300. INSERT INTO helpsql VALUES("xp_startmail",3," ")
  1301. INSERT INTO helpsql VALUES("xp_startmail",4,"xp_startmail ['<user>'] [, '<password>'] ")
  1302. INSERT INTO helpsql VALUES("xp_stopmail",1,"xp_stopmail Extended Stored Procedure")
  1303. INSERT INTO helpsql VALUES("xp_stopmail",2,"Stops a SQL Server mail client session.")
  1304. INSERT INTO helpsql VALUES("xp_stopmail",3," ")
  1305. INSERT INTO helpsql VALUES("xp_stopmail",4,"xp_stopmail")
  1306. INSERT INTO helpsql VALUES("xp_unc_to_drive",1,"xp_unc_to_drive Extended Stored Procedure")
  1307. INSERT INTO helpsql VALUES("xp_unc_to_drive",2,"Converts a UNC path to a local drive.")
  1308. INSERT INTO helpsql VALUES("xp_unc_to_drive",3," ")
  1309. go
  1310. DUMP TRANSACTION master WITH NO_LOG
  1311. go
  1312. INSERT INTO helpsql VALUES("sp_addarticle",1,"sp_addarticle Replication Stored Procedure")
  1313. INSERT INTO helpsql VALUES("sp_addarticle",2,"Creates an article and adds it to a publication.")
  1314. INSERT INTO helpsql VALUES("sp_addarticle",3," ")
  1315. INSERT INTO helpsql VALUES("sp_addarticle",4,"sp_addarticle <publication>, <article>, <source_table> ")
  1316. INSERT INTO helpsql VALUES("sp_addarticle",5,"     [, <destination_table>] [, <vertical_partition>] [, <type>] ")
  1317. INSERT INTO helpsql VALUES("sp_addarticle",6,"     [, <filter>] [, <sync_object>] [, <ins_cmd>] [, <del_cmd>] ")
  1318. INSERT INTO helpsql VALUES("sp_addarticle",7,"     [, <upd_cmd>] [, <creation_script>] [, <description>] ")
  1319. INSERT INTO helpsql VALUES("sp_addarticle",8,"     [, <pre_creation_cmd>] [, <filter_clause>] ")
  1320. INSERT INTO helpsql VALUES("sp_addpublication",1,"sp_addpublication Replication Stored Procedure")
  1321. INSERT INTO helpsql VALUES("sp_addpublication",2,"Creates a publication.")
  1322. INSERT INTO helpsql VALUES("sp_addpublication",3," ")
  1323. INSERT INTO helpsql VALUES("sp_addpublication",4,"sp_addpublication <publication>, <taskid> ")
  1324. INSERT INTO helpsql VALUES("sp_addpublication",5,"     [, @restricted = {'TRUE' | 'FALSE'} ")
  1325. INSERT INTO helpsql VALUES("sp_addpublication",6,"     [, @sync_method = {'NATIVE' | 'CHARACTER'} ")
  1326. INSERT INTO helpsql VALUES("sp_addpublication",7,"     [, @repl_freq = {'CONTINUOUS' | 'SNAPSHOT'} ")
  1327. INSERT INTO helpsql VALUES("sp_addpublication",8,"     [, @description = 'string description' ")
  1328. INSERT INTO helpsql VALUES("sp_addpublication",9,"     [, @status = 'INACTIVE' | 'ACTIVE']]]]] ")
  1329. INSERT INTO helpsql VALUES("sp_addpublisher",1,"sp_addpublisher Replication Stored Procedure")
  1330. INSERT INTO helpsql VALUES("sp_addpublisher",2,"Adds a new publication server.")
  1331. INSERT INTO helpsql VALUES("sp_addpublisher",3," ")
  1332. INSERT INTO helpsql VALUES("sp_addpublisher",4,"sp_addpublisher <publisher> [, 'dist']")
  1333. INSERT INTO helpsql VALUES("sp_addsubscriber",1,"sp_addsubscriber Replication Stored Procedure")
  1334. INSERT INTO helpsql VALUES("sp_addsubscriber",2,"Adds a new subscription server and sets up a trusted remote login ")
  1335. INSERT INTO helpsql VALUES("sp_addsubscriber",3,"mapping from SA of the subscriber to the ")
  1336. INSERT INTO helpsql VALUES("sp_addsubscriber",4,"repl_subscriber login ID on the publisher (unless system administrator ")
  1337. INSERT INTO helpsql VALUES("sp_addsubscriber",5,"on the subscriber is already mapped to system administrator on the ")
  1338. INSERT INTO helpsql VALUES("sp_addsubscriber",6,"publisher).")
  1339. INSERT INTO helpsql VALUES("sp_addsubscriber",7," ")
  1340. INSERT INTO helpsql VALUES("sp_addsubscriber",8,"sp_addsubscriber <subscriber> [, <type>] [, <login>] [, <password>] ")
  1341. INSERT INTO helpsql VALUES("sp_addsubscriber",9,"      [, <commit_batch_size>] [, <status_batch_size>] [, <flush_frequency>] ")
  1342. INSERT INTO helpsql VALUES("sp_addsubscriber",10,"      [, <frequency_type>] [, <frequency_interval>] ")
  1343. INSERT INTO helpsql VALUES("sp_addsubscriber",11,"      [, <frequency_relative_interval>] [, <frequency_recurrence_factor>] ")
  1344. INSERT INTO helpsql VALUES("sp_addsubscriber",12,"      [, <frequency_subday>] [, <frequency_subday_interval>] ")
  1345. INSERT INTO helpsql VALUES("sp_addsubscriber",13,"      [, <active_start_time_of_day>] [, <active_end_time_of_day>] ")
  1346. INSERT INTO helpsql VALUES("sp_addsubscriber",14,"      [, <active_start_date>] [, <active_end_date>] ")
  1347. INSERT INTO helpsql VALUES("sp_addsubscription",1,"sp_addsubscription Replication Stored Procedure")
  1348. INSERT INTO helpsql VALUES("sp_addsubscription",2,"Adds a subscription to an article and sets the subscriber's status.")
  1349. INSERT INTO helpsql VALUES("sp_addsubscription",3," ")
  1350. INSERT INTO helpsql VALUES("sp_addsubscription",4,"sp_addsubscription <publication> [, '<article>'] , <subscriber> ")
  1351. INSERT INTO helpsql VALUES("sp_addsubscription",5,"     [, <destination_db>] ")
  1352. INSERT INTO helpsql VALUES("sp_addsubscription",6,"     [, @sync_type = {'AUTOMATIC' | 'MANUAL' | 'NONE' }] ")
  1353. INSERT INTO helpsql VALUES("sp_addsubscription",7,"     [, @status = {'INACTIVE' | 'ACTIVE' | 'SUBSCRIBED' }] ")
  1354. go
  1355. DUMP TRANSACTION master WITH NO_LOG
  1356. go
  1357. INSERT INTO helpsql VALUES("sp_articlecolumn",1,"sp_articlecolumn Replication Stored Procedure")
  1358. INSERT INTO helpsql VALUES("sp_articlecolumn",2,"Modifies columns for an article. Use sp_articlecolumn to create vertical ")
  1359. INSERT INTO helpsql VALUES("sp_articlecolumn",3,"partitions.")
  1360. INSERT INTO helpsql VALUES("sp_articlecolumn",4," ")
  1361. INSERT INTO helpsql VALUES("sp_articlecolumn",5,"sp_articlecolumn <publication>, <article> [, '<column>' ")
  1362. INSERT INTO helpsql VALUES("sp_articlecolumn",6,"     [, @operation = { 'ADD' | 'DROP' }] ")
  1363. INSERT INTO helpsql VALUES("sp_articlefilter",1,"sp_articlefilter Replication Stored Procedure")
  1364. INSERT INTO helpsql VALUES("sp_articlefilter",2,"Creates a filter stored procedure used to horizontally partition data ")
  1365. INSERT INTO helpsql VALUES("sp_articlefilter",3,"replicated from a published table.")
  1366. INSERT INTO helpsql VALUES("sp_articlefilter",4," ")
  1367. INSERT INTO helpsql VALUES("sp_articlefilter",5,"sp_articlefilter <publication>, <article> [, <filter_name>] ")
  1368. INSERT INTO helpsql VALUES("sp_articlefilter",6,"     [, <filter_clause>]")
  1369. INSERT INTO helpsql VALUES("sp_articletextcol",1,"sp_articletextcol Replication Stored Procedure")
  1370. INSERT INTO helpsql VALUES("sp_articletextcol",2,"Sets the replication column status of a Text\Image column")
  1371. INSERT INTO helpsql VALUES("sp_articletextcol",3," ")
  1372. INSERT INTO helpsql VALUES("sp_articletextcol",4,"sp_articletextcol <artid>, <colid>, ")
  1373. INSERT INTO helpsql VALUES("sp_articletextcol",5,"    <type> = {'PUBLISH' | 'NONSQLSUB'},  <operation> = { 'ADD' | 'DROP'}")
  1374. INSERT INTO helpsql VALUES("sp_articleview",1,"sp_articleview Replication Stored Procedure")
  1375. INSERT INTO helpsql VALUES("sp_articleview",2,"Creates the synchronization object for an article ")
  1376. INSERT INTO helpsql VALUES("sp_articleview",3,"when a table is filtered vertically and/or horizontally. ")
  1377. INSERT INTO helpsql VALUES("sp_articleview",4,"This synchronization object is a view that is used as the filtered ")
  1378. INSERT INTO helpsql VALUES("sp_articleview",5,"source of the schema and data for the destination tables. ")
  1379. INSERT INTO helpsql VALUES("sp_articleview",6," ")
  1380. INSERT INTO helpsql VALUES("sp_articleview",7,"sp_articleview <publication>, <article> [, <view_name>] ")
  1381. INSERT INTO helpsql VALUES("sp_articleview",8,"     [, <filter_clause>]")
  1382. INSERT INTO helpsql VALUES("sp_changearticle",1,"sp_changearticle Replication Stored Procedure")
  1383. INSERT INTO helpsql VALUES("sp_changearticle",2,"Changes an article's properties.")
  1384. INSERT INTO helpsql VALUES("sp_changearticle",3," ")
  1385. INSERT INTO helpsql VALUES("sp_changearticle",4,"sp_changearticle <publication>, <article> [, <property>, <value>]")
  1386. INSERT INTO helpsql VALUES("sp_changepublication",1,"sp_changepublication Replication Stored Procedure")
  1387. INSERT INTO helpsql VALUES("sp_changepublication",2,"Changes publication properties.")
  1388. INSERT INTO helpsql VALUES("sp_changepublication",3," ")
  1389. INSERT INTO helpsql VALUES("sp_changepublication",4,"sp_changepublication <publication> [, <property>, '<value>']")
  1390. INSERT INTO helpsql VALUES("sp_changesubscriber",1,"sp_changesubscriber Replication Stored Procedure")
  1391. INSERT INTO helpsql VALUES("sp_changesubscriber",2,"Changes the options for a subscription server. Any distribution task ")
  1392. INSERT INTO helpsql VALUES("sp_changesubscriber",3,"for the publisher's subscribers will be updated.")
  1393. INSERT INTO helpsql VALUES("sp_changesubscriber",4," ")
  1394. INSERT INTO helpsql VALUES("sp_changesubscriber",5,"sp_changesubscriber <subscriber> [, <type> ] [, <login> ] [, <password>] ")
  1395. INSERT INTO helpsql VALUES("sp_changesubscriber",6,"     [, <commit_batch_size> ] [, <status_batch_size> ] [, <flush_frequency>] ")
  1396. INSERT INTO helpsql VALUES("sp_changesubscriber",7,"     [, <frequency_type> ] [, <frequency_interval>] ")
  1397. INSERT INTO helpsql VALUES("sp_changesubscriber",8,"     [, <frequency_relative_interval> ] [, <frequency_recurrence_factor>] ")
  1398. INSERT INTO helpsql VALUES("sp_changesubscriber",9,"     [, <frequency_subday> ] [, <frequency_subday_interval>] ")
  1399. INSERT INTO helpsql VALUES("sp_changesubscriber",10,"     [, <active_start_time_of_day> ] [, <active_end_time_of_day>] ")
  1400. INSERT INTO helpsql VALUES("sp_changesubscriber",11,"     [, <active_start_date> ] [, <active_end_date>] ")
  1401. go
  1402. DUMP TRANSACTION master WITH NO_LOG
  1403. go
  1404. INSERT INTO helpsql VALUES("sp_changesubscription",1,"sp_changesubscription Replication Stored Procedure")
  1405. INSERT INTO helpsql VALUES("sp_changesubscription",2,"Is executed on a subscription server to change subscription properties ")
  1406. INSERT INTO helpsql VALUES("sp_changesubscription",3,"for an article or a publication.")
  1407. INSERT INTO helpsql VALUES("sp_changesubscription",4," ")
  1408. INSERT INTO helpsql VALUES("sp_changesubscription",5,"sp_changesubscription <publication>, <article>, <subscriber> ")
  1409. INSERT INTO helpsql VALUES("sp_changesubscription",6,"     [, '<property>', '<value>']")
  1410. INSERT INTO helpsql VALUES("sp_changesubstatus",1,"sp_changesubstatus Replication Stored Procedure")
  1411. INSERT INTO helpsql VALUES("sp_changesubstatus",2,"Changes the status of an existing subscriber.")
  1412. INSERT INTO helpsql VALUES("sp_changesubstatus",3," ")
  1413. INSERT INTO helpsql VALUES("sp_changesubstatus",4,"sp_changesubstatus [<publication> [, <article> [, <subscriber>[,]]]]")
  1414. INSERT INTO helpsql VALUES("sp_changesubstatus",5,"     <status> [, previous_status]")
  1415. INSERT INTO helpsql VALUES("sp_create_distribution_tables",1,"sp_create_distribution_tables Replication Stored Procedure")
  1416. INSERT INTO helpsql VALUES("sp_create_distribution_tables",2,"Creates the tables in the distribution database.")
  1417. INSERT INTO helpsql VALUES("sp_create_distribution_tables",3," ")
  1418. INSERT INTO helpsql VALUES("sp_create_distribution_tables",4,"sp_create_distribution_tables")
  1419. INSERT INTO helpsql VALUES("sp_distcounters",1,"sp_distcounters Replication Stored Procedure")
  1420. INSERT INTO helpsql VALUES("sp_distcounters",2,"Displays the latest information for all subscription servers. Used by ")
  1421. INSERT INTO helpsql VALUES("sp_distcounters",3,"SQL Performance Monitor.")
  1422. INSERT INTO helpsql VALUES("sp_distcounters",4," ")
  1423. INSERT INTO helpsql VALUES("sp_distcounters",5,"sp_distcounters")
  1424. INSERT INTO helpsql VALUES("sp_droparticle",1,"sp_droparticle Replication Stored Procedure")
  1425. INSERT INTO helpsql VALUES("sp_droparticle",2,"Drops an article.")
  1426. INSERT INTO helpsql VALUES("sp_droparticle",3," ")
  1427. INSERT INTO helpsql VALUES("sp_droparticle",4,"sp_droparticle <publication>, <article> ")
  1428. INSERT INTO helpsql VALUES("sp_droppublication",1,"sp_droppublication Replication Stored Procedure")
  1429. INSERT INTO helpsql VALUES("sp_droppublication",2,"Drops a publication and its associated articles.")
  1430. INSERT INTO helpsql VALUES("sp_droppublication",3," ")
  1431. INSERT INTO helpsql VALUES("sp_droppublication",4,"sp_droppublication <publication>")
  1432. INSERT INTO helpsql VALUES("sp_droppublisher",1,"sp_droppublisher Replication Stored Procedure")
  1433. INSERT INTO helpsql VALUES("sp_droppublisher",2,"Drops a publication server.")
  1434. INSERT INTO helpsql VALUES("sp_droppublisher",3," ")
  1435. INSERT INTO helpsql VALUES("sp_droppublisher",4,"sp_droppublisher <publisher> [, dist]")
  1436. INSERT INTO helpsql VALUES("sp_dropsubscriber",1,"sp_dropsubscriber Replication Stored Procedure")
  1437. INSERT INTO helpsql VALUES("sp_dropsubscriber",2,"Drops a subscription server.")
  1438. INSERT INTO helpsql VALUES("sp_dropsubscriber",3," ")
  1439. INSERT INTO helpsql VALUES("sp_dropsubscriber",4,"sp_dropsubscriber <subscriber>")
  1440. go
  1441. DUMP TRANSACTION master WITH NO_LOG
  1442. go
  1443. INSERT INTO helpsql VALUES("sp_dropsubscription",1,"sp_dropsubscription Replication Stored Procedure")
  1444. INSERT INTO helpsql VALUES("sp_dropsubscription",2,"On the publication server, drops subscriptions to a particular article, ")
  1445. INSERT INTO helpsql VALUES("sp_dropsubscription",3,"publication, or set of subscriptions.")
  1446. INSERT INTO helpsql VALUES("sp_dropsubscription",4," ")
  1447. INSERT INTO helpsql VALUES("sp_dropsubscription",5,"sp_dropsubscription '<publication>', '<article>', '<subscriber>'")
  1448. INSERT INTO helpsql VALUES("sp_dsninfo",1,"sp_dsninfo Replication Stored Procedure")
  1449. INSERT INTO helpsql VALUES("sp_dsninfo",2,"Returns the information value for a ODBC Data Source Name.")
  1450. INSERT INTO helpsql VALUES("sp_dsninfo",3," ")
  1451. INSERT INTO helpsql VALUES("sp_dsninfo",4,"sp_dsninfo dsn [, infotype] [, login] [, password]")
  1452. INSERT INTO helpsql VALUES("sp_enumfullsubscribers",1,"sp_enumfullsubscribers Replication Stored Procedure")
  1453. INSERT INTO helpsql VALUES("sp_enumfullsubscribers",2,"Returns a list of subscribers who have subscribed to all articles in a ")
  1454. INSERT INTO helpsql VALUES("sp_enumfullsubscribers",3,"specified publication.")
  1455. INSERT INTO helpsql VALUES("sp_enumfullsubscribers",4," ")
  1456. INSERT INTO helpsql VALUES("sp_enumfullsubscribers",5,"sp_enumfullsubscribers <publication>")
  1457. INSERT INTO helpsql VALUES("sp_enumdsn",1,"sp_enumdsn Replication Stored Procedure")
  1458. INSERT INTO helpsql VALUES("sp_enumdsn",2,"Provides a list of ODBC Data Source Names accessible to the publisher. ")
  1459. INSERT INTO helpsql VALUES("sp_enumdsn",3," ")
  1460. INSERT INTO helpsql VALUES("sp_enumdsn",4,"sp_enumdsn")
  1461. INSERT INTO helpsql VALUES("sp_helparticle",1,"sp_helparticle Replication Stored Procedure")
  1462. INSERT INTO helpsql VALUES("sp_helparticle",2,"Displays information about an article.")
  1463. INSERT INTO helpsql VALUES("sp_helparticle",3," ")
  1464. INSERT INTO helpsql VALUES("sp_helparticle",4,"sp_helparticle <publication>[, <article>] [, <returnfilter>]")
  1465. INSERT INTO helpsql VALUES("sp_helparticlecolumns",1,"sp_helparticlecolumns Replication Stored Procedure")
  1466. INSERT INTO helpsql VALUES("sp_helparticlecolumns",2,"Displays all columns in the underlying table. ")
  1467. INSERT INTO helpsql VALUES("sp_helparticlecolumns",3," ")
  1468. INSERT INTO helpsql VALUES("sp_helparticlecolumns",4,"sp_helparticlecolumns <publication>, <article>")
  1469. INSERT INTO helpsql VALUES("sp_helpdistributor",1,"sp_helpdistributor Replication Stored Procedure")
  1470. INSERT INTO helpsql VALUES("sp_helpdistributor",2,"Lists information about the distribution server, distribution database, ")
  1471. INSERT INTO helpsql VALUES("sp_helpdistributor",3,"working directory, and SQL Executive user account.")
  1472. INSERT INTO helpsql VALUES("sp_helpdistributor",4," ")
  1473. INSERT INTO helpsql VALUES("sp_helpdistributor",5,"sp_helpdistributor")
  1474. INSERT INTO helpsql VALUES("sp_helppublication",1,"sp_helppublication Replication Stored Procedure")
  1475. INSERT INTO helpsql VALUES("sp_helppublication",2,"Displays information about a publication.")
  1476. INSERT INTO helpsql VALUES("sp_helppublication",3," ")
  1477. INSERT INTO helpsql VALUES("sp_helppublication",4,"sp_helppublication [<publication>]")
  1478. INSERT INTO helpsql VALUES("sp_helppublicationsync",1,"sp_helppublicationsync Replication Stored Procedure")
  1479. INSERT INTO helpsql VALUES("sp_helppublicationsync",2,"Provides information about a scheduled synchronization task for a ")
  1480. INSERT INTO helpsql VALUES("sp_helppublicationsync",3,"publication.")
  1481. INSERT INTO helpsql VALUES("sp_helppublicationsync",4," ")
  1482. INSERT INTO helpsql VALUES("sp_helppublicationsync",5,"sp_helppublicationsync <publication>")
  1483. go
  1484. DUMP TRANSACTION master WITH NO_LOG
  1485. go
  1486. INSERT INTO helpsql VALUES("sp_helpreplicationdb",1,"sp_helpreplicationdb Replication Stored Procedure")
  1487. INSERT INTO helpsql VALUES("sp_helpreplicationdb",2,"Returns information about a specified database or a list of all ")
  1488. INSERT INTO helpsql VALUES("sp_helpreplicationdb",3,"publication databases on the server. ")
  1489. INSERT INTO helpsql VALUES("sp_helpreplicationdb",4," ")
  1490. INSERT INTO helpsql VALUES("sp_helpreplicationdb",5,"sp_helpreplicationdb [<databasename> [, {pub | sub}]]")
  1491. INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",1,"sp_helpsubscriberinfo Replication Stored Procedure")
  1492. INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",2,"Displays information about a subscription server.")
  1493. INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",3," ")
  1494. INSERT INTO helpsql VALUES("sp_helpsubscriberinfo",4,"sp_helpsubscriberinfo <subscriber>")
  1495. INSERT INTO helpsql VALUES("sp_helpsubscription",1,"sp_helpsubscription Replication Stored Procedure")
  1496. INSERT INTO helpsql VALUES("sp_helpsubscription",2,"Lists subscription information associated with a particular publication, ")
  1497. INSERT INTO helpsql VALUES("sp_helpsubscription",3,"article, subscriber, or set of subscriptions.")
  1498. INSERT INTO helpsql VALUES("sp_helpsubscription",4," ")
  1499. INSERT INTO helpsql VALUES("sp_helpsubscription",5,"sp_helpsubscription [<publication> [, <article> [, <subscriber> ]]] ")
  1500. INSERT INTO helpsql VALUES("sp_MSkill_job",1,"sp_MSkill_job Replication Stored Procedure")
  1501. INSERT INTO helpsql VALUES("sp_MSkill_job",2,"On the distribution server, removes a single job from the distribution ")
  1502. INSERT INTO helpsql VALUES("sp_MSkill_job",3,"database while continuing to send all other data to the subscriber.")
  1503. INSERT INTO helpsql VALUES("sp_MSkill_job",4," ")
  1504. INSERT INTO helpsql VALUES("sp_MSkill_job",5,"sp_MSkill_job <job_id>, <publisher>, <publisher_db> [, <subscriber> ")
  1505. INSERT INTO helpsql VALUES("sp_MSkill_job",6,"     [, <subscriber_db>]]")
  1506. INSERT INTO helpsql VALUES("sp_replcleanup",1,"sp_replcleanup Replication Stored Procedure")
  1507. INSERT INTO helpsql VALUES("sp_replcleanup",2,"Removes transactions from the distribution database tables after they ")
  1508. INSERT INTO helpsql VALUES("sp_replcleanup",3,"have been successfully distributed to the subscriber's database.")
  1509. INSERT INTO helpsql VALUES("sp_replcleanup",4," ")
  1510. INSERT INTO helpsql VALUES("sp_replcleanup",5,"sp_replcleanup <publisher>, <subscriber>, <retention>")
  1511. INSERT INTO helpsql VALUES("sp_replcmds",1,"sp_replcmds Replication Stored Procedure")
  1512. INSERT INTO helpsql VALUES("sp_replcmds",2,"Returns the commands for transactions marked for replication.")
  1513. INSERT INTO helpsql VALUES("sp_replcmds",3," ")
  1514. INSERT INTO helpsql VALUES("sp_replcmds",4,"sp_replcmds [<maxtrans>]")
  1515. INSERT INTO helpsql VALUES("sp_replcounters",1,"sp_replcounters Replication Stored Procedure")
  1516. INSERT INTO helpsql VALUES("sp_replcounters",2,"Returns replication statistics about latency, throughput, and ")
  1517. INSERT INTO helpsql VALUES("sp_replcounters",3,"transaction count for each published database. Used by SQL Performance ")
  1518. INSERT INTO helpsql VALUES("sp_replcounters",4,"Monitor.")
  1519. INSERT INTO helpsql VALUES("sp_replcounters",5," ")
  1520. INSERT INTO helpsql VALUES("sp_replcounters",6,"sp_replcounters")
  1521. go
  1522. DUMP TRANSACTION master WITH NO_LOG
  1523. go
  1524. INSERT INTO helpsql VALUES("sp_repldone",1,"sp_repldone Replication Stored Procedure")
  1525. INSERT INTO helpsql VALUES("sp_repldone",2,"Updates the record that identifies the server's last distributed ")
  1526. INSERT INTO helpsql VALUES("sp_repldone",3,"transaction.")
  1527. INSERT INTO helpsql VALUES("sp_repldone",4," ")
  1528. INSERT INTO helpsql VALUES("sp_repldone",5,"sp_repldone <page>, <row> [, <timestamp>] [, <numtrans>] [, <time>] [, <reset>] ")
  1529. INSERT INTO helpsql VALUES("sp_replflush",1,"sp_replflush Replication Stored Procedure")
  1530. INSERT INTO helpsql VALUES("sp_replflush",2,"Flushes the article cache.")
  1531. INSERT INTO helpsql VALUES("sp_replflush",3," ")
  1532. INSERT INTO helpsql VALUES("sp_replflush",4,"sp_replflush ")
  1533. INSERT INTO helpsql VALUES("sp_replica",1,"sp_replica Replication Stored Procedure")
  1534. INSERT INTO helpsql VALUES("sp_replica",2,"Remotely sets on a subscription server a sysobjects category bit that ")
  1535. INSERT INTO helpsql VALUES("sp_replica",3,"marks the table as a replica.")
  1536. INSERT INTO helpsql VALUES("sp_replica",4," ")
  1537. INSERT INTO helpsql VALUES("sp_replica",5,"sp_replica <tabname>, <replicated>")
  1538. INSERT INTO helpsql VALUES("sp_replstatus",1,"sp_replstatus Replication Stored Procedure")
  1539. INSERT INTO helpsql VALUES("sp_replstatus",2,"Used to update the internal table structure for replication (that ")
  1540. INSERT INTO helpsql VALUES("sp_replstatus",3,"indicates whether the table is being replicated).")
  1541. INSERT INTO helpsql VALUES("sp_replstatus",4," ")
  1542. INSERT INTO helpsql VALUES("sp_replstatus",5,"sp_replstatus <objectID>, <status>")
  1543. INSERT INTO helpsql VALUES("sp_replsync",1,"sp_replsync Replication Stored Procedure")
  1544. INSERT INTO helpsql VALUES("sp_replsync",2,"Used from a subscription server to acknowledge completion of a manual ")
  1545. INSERT INTO helpsql VALUES("sp_replsync",3,"synchronization.")
  1546. INSERT INTO helpsql VALUES("sp_replsync",4," ")
  1547. INSERT INTO helpsql VALUES("sp_replsync",5,"sp_replsync <publisher>, <publisher_db>, <publication> [, <article>]")
  1548. INSERT INTO helpsql VALUES("sp_repltrans",1,"sp_repltrans Replication Stored Procedure")
  1549. INSERT INTO helpsql VALUES("sp_repltrans",2,"Returns a result set of all the transactions in the publication database ")
  1550. INSERT INTO helpsql VALUES("sp_repltrans",3,"transaction log that are marked for replication but that have not been ")
  1551. INSERT INTO helpsql VALUES("sp_repltrans",4,"marked as distributed.")
  1552. INSERT INTO helpsql VALUES("sp_repltrans",5," ")
  1553. INSERT INTO helpsql VALUES("sp_repltrans",6,"sp_repltrans")
  1554. INSERT INTO helpsql VALUES("sp_textcolstatus",1,"sp_textcolstatus Replication Stored Procedure")
  1555. INSERT INTO helpsql VALUES("sp_textcolstatus",2,"Checks the replication column status of a Text\Image column")
  1556. INSERT INTO helpsql VALUES("sp_textcolstatus",3," ")
  1557. INSERT INTO helpsql VALUES("sp_textcolstatus",4,"sp_textcolstatus <artid>, <tabid>, <colid>,")
  1558. INSERT INTO helpsql VALUES("sp_textcolstatus",5,"    <type> = {'PUBLISH' | 'NONSQLSUB'},  <status> OUTPUT")
  1559. go
  1560. DUMP TRANSACTION master WITH NO_LOG
  1561. go
  1562. INSERT INTO helpsql VALUES("sp_subscribe",1,"sp_subscribe Replication Stored Procedure")
  1563. INSERT INTO helpsql VALUES("sp_subscribe",2,"Remotely adds a subscription to a particular article within a ")
  1564. INSERT INTO helpsql VALUES("sp_subscribe",3,"publication.")
  1565. INSERT INTO helpsql VALUES("sp_subscribe",4," ")
  1566. INSERT INTO helpsql VALUES("sp_subscribe",5,"sp_subscribe <publication>, [<article> [, <desitination_db> ")
  1567. INSERT INTO helpsql VALUES("sp_subscribe",6,"     [, @sync_type = {'AUTOMATIC' | 'MANUAL' | 'NONE'}]]] ")
  1568. INSERT INTO helpsql VALUES("sp_unsubscribe",1,"sp_unsubscribe Replication Stored Procedure")
  1569. INSERT INTO helpsql VALUES("sp_unsubscribe",2,"Remotely cancels a subscription to a particular article within a ")
  1570. INSERT INTO helpsql VALUES("sp_unsubscribe",3,"publication, to a whole publication, or to all publications. It also ")
  1571. INSERT INTO helpsql VALUES("sp_unsubscribe",4,"removes all pending jobs from the distribution database.")
  1572. INSERT INTO helpsql VALUES("sp_unsubscribe",5," ")
  1573. INSERT INTO helpsql VALUES("sp_unsubscribe",6,"sp_unsubscribe '<publication>', '<article>'")
  1574. INSERT INTO helpsql VALUES("sp_addalert",1,"sp_addalert SQL Executive Stored Procedure")
  1575. INSERT INTO helpsql VALUES("sp_addalert",2,"Creates an alert.")
  1576. INSERT INTO helpsql VALUES("sp_addalert",3," ")
  1577. INSERT INTO helpsql VALUES("sp_addalert",4,"sp_addalert <name>, <message_id>, <severity> [, <enabled>] ")
  1578. INSERT INTO helpsql VALUES("sp_addalert",5,"     [, <delay_between_responses>] [, <notification_message>] ")
  1579. INSERT INTO helpsql VALUES("sp_addalert",6,"     [, <include_event_description_in>] [, <database_name>] ")
  1580. INSERT INTO helpsql VALUES("sp_addalert",7,"     [, <event_description_keyword>] [, <task_name>]")
  1581. INSERT INTO helpsql VALUES("sp_addnotification",1,"sp_addnotification SQL Executive Stored Procedure")
  1582. INSERT INTO helpsql VALUES("sp_addnotification",2,"Sets up a notification for an alert.")
  1583. INSERT INTO helpsql VALUES("sp_addnotification",3," ")
  1584. INSERT INTO helpsql VALUES("sp_addnotification",4,"sp_addnotification <alert_name>, <operator_name>, <notification_method> ")
  1585. INSERT INTO helpsql VALUES("sp_addoperator",1,"sp_addoperator SQL Executive Stored Procedure")
  1586. INSERT INTO helpsql VALUES("sp_addoperator",2,"Sets up an operator (notification recipient) for use with alerts.")
  1587. INSERT INTO helpsql VALUES("sp_addoperator",3," ")
  1588. INSERT INTO helpsql VALUES("sp_addoperator",4,"sp_addoperator <name> [, <enabled>] [, <email_address>] ")
  1589. INSERT INTO helpsql VALUES("sp_addoperator",5,"     [, <pager_number>] [, <weekday_pager_start_time>] ")
  1590. INSERT INTO helpsql VALUES("sp_addoperator",6,"     [, <weekday_pager_end_time>] [, <saturday_pager_start_time>] ")
  1591. INSERT INTO helpsql VALUES("sp_addoperator",7,"     [, <saturday_pager_end_time>] [, <sunday_pager_start_time>] ")
  1592. INSERT INTO helpsql VALUES("sp_addoperator",8,"     [, <sunday_pager_end_time>] [, <pager_days>] ")
  1593. go
  1594. DUMP TRANSACTION master WITH NO_LOG
  1595. go
  1596. INSERT INTO helpsql VALUES("sp_addtask",1,"sp_addtask SQL Executive Stored Procedure")
  1597. INSERT INTO helpsql VALUES("sp_addtask",2,"Creates a scheduled task.")
  1598. INSERT INTO helpsql VALUES("sp_addtask",3," ")
  1599. INSERT INTO helpsql VALUES("sp_addtask",4,"sp_addtask <name> [, <subsystem>] [, <server>] [, <username>] ")
  1600. INSERT INTO helpsql VALUES("sp_addtask",5,"     [, <databasename>] [, <enabled>] [, <freqtype>] [, <freqinterval>] ")
  1601. INSERT INTO helpsql VALUES("sp_addtask",6,"     [, <freqsubtype>] [, <freqsubinterval>] [, <freqrelativeinterval>] ")
  1602. INSERT INTO helpsql VALUES("sp_addtask",7,"     [, <freqrecurrencefactor>] [, <activestartdate>] [, <activeenddate>] ")
  1603. INSERT INTO helpsql VALUES("sp_addtask",8,"     [, <activestarttimeofday>] [, <activeendtimeofday>] [, <nextrundate>] ")
  1604. INSERT INTO helpsql VALUES("sp_addtask",9,"     [, <nextruntime>] [, <runpriority>] [, <emailoperatorname>] ")
  1605. INSERT INTO helpsql VALUES("sp_addtask",10,"     [, <retryattempts>] [, <retrydelay>] [, <command>] ")
  1606. INSERT INTO helpsql VALUES("sp_addtask",11,"     [, <loghistcompletionlevel>] [, <emailcompletionlevel>] ")
  1607. INSERT INTO helpsql VALUES("sp_addtask",12,"     [, <description>] [, <tagadditionalinfo>] [, <tagobjectid>] ")
  1608. INSERT INTO helpsql VALUES("sp_addtask",13,"     [, <tagobjecttype>] [, @newid OUTPUT] ")
  1609. INSERT INTO helpsql VALUES("sp_dropalert",1,"sp_dropalert SQL Executive Stored Procedure")
  1610. INSERT INTO helpsql VALUES("sp_dropalert",2,"Drops an alert.")
  1611. INSERT INTO helpsql VALUES("sp_dropalert",3," ")
  1612. INSERT INTO helpsql VALUES("sp_dropalert",4,"sp_dropalert <name>")
  1613. INSERT INTO helpsql VALUES("sp_dropnotification",1,"sp_dropnotification SQL Executive Stored Procedure")
  1614. INSERT INTO helpsql VALUES("sp_dropnotification",2,"Drops a notification for an alert.")
  1615. INSERT INTO helpsql VALUES("sp_dropnotification",3," ")
  1616. INSERT INTO helpsql VALUES("sp_dropnotification",4,"sp_dropnotification <alert_name>, <operator_name>")
  1617. INSERT INTO helpsql VALUES("sp_dropoperator",1,"sp_dropoperator SQL Executive Stored Procedure")
  1618. INSERT INTO helpsql VALUES("sp_dropoperator",2,"Drops an operator.")
  1619. INSERT INTO helpsql VALUES("sp_dropoperator",3," ")
  1620. INSERT INTO helpsql VALUES("sp_dropoperator",4,"sp_dropoperator <name>")
  1621. INSERT INTO helpsql VALUES("sp_droptask",1,"sp_droptask SQL Executive Stored Procedure")
  1622. INSERT INTO helpsql VALUES("sp_droptask",2,"Removes a scheduled task.")
  1623. INSERT INTO helpsql VALUES("sp_droptask",3," ")
  1624. INSERT INTO helpsql VALUES("sp_droptask",4,"sp_droptask {<name> | <loginname> | <id>}")
  1625. INSERT INTO helpsql VALUES("sp_helpalert",1,"sp_helpalert SQL Executive Stored Procedure")
  1626. INSERT INTO helpsql VALUES("sp_helpalert",2,"Reports information about the alerts defined for the server.")
  1627. INSERT INTO helpsql VALUES("sp_helpalert",3," ")
  1628. INSERT INTO helpsql VALUES("sp_helpalert",4,"sp_helpalert [<having_name_like>]")
  1629. go
  1630. DUMP TRANSACTION master WITH NO_LOG
  1631. go
  1632. INSERT INTO helpsql VALUES("sp_helphistory",1,"sp_helphistory SQL Executive Stored Procedure")
  1633. INSERT INTO helpsql VALUES("sp_helphistory",2,"Reports the history of one or more scheduled events, alerts, or tasks. ")
  1634. INSERT INTO helpsql VALUES("sp_helphistory",3," ")
  1635. INSERT INTO helpsql VALUES("sp_helphistory",4,"sp_helphistory [, <taskname>] [, <taskid>] [, <eventid>] [, <messageid>] ")
  1636. INSERT INTO helpsql VALUES("sp_helphistory",5,"     [, <severity>] [, <source>] [, <category>] [, <startdate>] ")
  1637. INSERT INTO helpsql VALUES("sp_helphistory",6,"     [, <enddate>] [, <starttime>] [, <endtime>] [, <skipped>] ")
  1638. INSERT INTO helpsql VALUES("sp_helphistory",7,"     [, oldestfirst] [, <mode>] ")
  1639. INSERT INTO helpsql VALUES("sp_helpnotification",1,"sp_helpnotification SQL Executive Stored Procedure")
  1640. INSERT INTO helpsql VALUES("sp_helpnotification",2,"Reports a list of notifications.")
  1641. INSERT INTO helpsql VALUES("sp_helpnotification",3," ")
  1642. INSERT INTO helpsql VALUES("sp_helpnotification",4,"sp_helpnotification <object_type>, <name>, <enum_type>, ")
  1643. INSERT INTO helpsql VALUES("sp_helpnotification",5,"     <notification_method> [, <target_name>]")
  1644. INSERT INTO helpsql VALUES("sp_helpoperator",1,"sp_helpoperator SQL Executive Stored Procedure")
  1645. INSERT INTO helpsql VALUES("sp_helpoperator",2,"Reports information about the operators defined for the server.")
  1646. INSERT INTO helpsql VALUES("sp_helpoperator",3," ")
  1647. INSERT INTO helpsql VALUES("sp_helpoperator",4,"sp_helpoperator [<having_name_like>]")
  1648. INSERT INTO helpsql VALUES("sp_helptask",1,"sp_helptask SQL Executive Stored Procedure")
  1649. INSERT INTO helpsql VALUES("sp_helptask",2,"Provides information about one or more tasks.")
  1650. INSERT INTO helpsql VALUES("sp_helptask",3," ")
  1651. INSERT INTO helpsql VALUES("sp_helptask",4,"sp_helptask <taskname> [, <taskid>] [, <loginname>] [, <operatorname>] ")
  1652. INSERT INTO helpsql VALUES("sp_helptask",5,"     [, <subsystem>] [, <mode>]")
  1653. INSERT INTO helpsql VALUES("sp_purgehistory",1,"sp_purgehistory SQL Executive Stored Procedure")
  1654. INSERT INTO helpsql VALUES("sp_purgehistory",2,"Removes information from the history log.")
  1655. INSERT INTO helpsql VALUES("sp_purgehistory",3," ")
  1656. INSERT INTO helpsql VALUES("sp_purgehistory",4,"sp_purgehistory [<taskname>] [, <taskid>] [, <eventid>] [, <messageid>] ")
  1657. INSERT INTO helpsql VALUES("sp_purgehistory",5,"     [, <severity>] [, <source>] [, <category>] [, <startdate>] ")
  1658. INSERT INTO helpsql VALUES("sp_purgehistory",6,"     [, <enddate>] [, <starttime>] [, <endtime>] [, <skipped>] ")
  1659. go
  1660. DUMP TRANSACTION master WITH NO_LOG
  1661. go
  1662. INSERT INTO helpsql VALUES("sp_updatealert",1,"sp_updatealert SQL Executive Stored Procedure")
  1663. INSERT INTO helpsql VALUES("sp_updatealert",2,"Updates information for an existing alert.")
  1664. INSERT INTO helpsql VALUES("sp_updatealert",3," ")
  1665. INSERT INTO helpsql VALUES("sp_updatealert",4,"sp_updatealert <name> [, <new_name>] [, <enabled>] [, <message_id>] ")
  1666. INSERT INTO helpsql VALUES("sp_updatealert",5,"     [, <severity>] [, <delay_between_responses>] ")
  1667. INSERT INTO helpsql VALUES("sp_updatealert",6,"     [, <notification_message>] [, <include_event_description_in>] ")
  1668. INSERT INTO helpsql VALUES("sp_updatealert",7,"     [, <database_name>] [, <event_description_keyword>] ")
  1669. INSERT INTO helpsql VALUES("sp_updatealert",8,"     [, <task_name>] [, <occurrence_count>] [, <count_reset_date>] ")
  1670. INSERT INTO helpsql VALUES("sp_updatealert",9,"     [, <count_reset_time>] [, <last_occurrence_date>] ")
  1671. INSERT INTO helpsql VALUES("sp_updatealert",10,"     [, <last_occurrence_time>] [, <last_response_date>] ")
  1672. INSERT INTO helpsql VALUES("sp_updatealert",11,"     [, <last_response _time>]")
  1673. INSERT INTO helpsql VALUES("sp_updatenotification",1,"sp_updatenotification SQL Executive Stored Procedure")
  1674. INSERT INTO helpsql VALUES("sp_updatenotification",2,"Updates the notification method of an alert notification.")
  1675. INSERT INTO helpsql VALUES("sp_updatenotification",3," ")
  1676. INSERT INTO helpsql VALUES("sp_updatenotification",4,"sp_updatenotification <alert_name>, <operator_name>, ")
  1677. INSERT INTO helpsql VALUES("sp_updatenotification",5,"     <notification_method>")
  1678. INSERT INTO helpsql VALUES("sp_updateoperator",1,"sp_updateoperator SQL Executive Stored Procedure")
  1679. INSERT INTO helpsql VALUES("sp_updateoperator",2,"Updates information about an operator.")
  1680. INSERT INTO helpsql VALUES("sp_updateoperator",3," ")
  1681. INSERT INTO helpsql VALUES("sp_updateoperator",4,"sp_updateoperator <name> [, <new_name>] [, <enabled>] ")
  1682. INSERT INTO helpsql VALUES("sp_updateoperator",5,"     [, <email_address>] [, <pager_number>] ")
  1683. INSERT INTO helpsql VALUES("sp_updateoperator",6,"     [, <weekday_pager_start_time>] [, <weekday_pager_end_time>] ")
  1684. INSERT INTO helpsql VALUES("sp_updateoperator",7,"     [, <saturday_pager_start_time>] [, <saturday_pager_end_time>] ")
  1685. INSERT INTO helpsql VALUES("sp_updateoperator",8,"     [, <sunday_pager_start_time>] [, <sunday_pager_end_time>] ")
  1686. INSERT INTO helpsql VALUES("sp_updateoperator",9,"     [, <pager_days>] ")
  1687. go
  1688. DUMP TRANSACTION master WITH NO_LOG
  1689. go
  1690. INSERT INTO helpsql VALUES("sp_updatetask",1,"sp_updatetask SQL Executive Stored Procedure")
  1691. INSERT INTO helpsql VALUES("sp_updatetask",2,"Updates information about a task.")
  1692. INSERT INTO helpsql VALUES("sp_updatetask",3," ")
  1693. INSERT INTO helpsql VALUES("sp_updatetask",4,"sp_updatetask {<currentname> | <id>} [, <name>] [, <subsystem>] ")
  1694. INSERT INTO helpsql VALUES("sp_updatetask",5,"     [, <server>] [, <username>] [, <databasename>] [, <enabled>] ")
  1695. INSERT INTO helpsql VALUES("sp_updatetask",6,"     [, <freqtype>] [, <freqinterval>] [, <freqsubtype>] ")
  1696. INSERT INTO helpsql VALUES("sp_updatetask",7,"     [, <freqsubinterval>] [, <freqrelativeinterval>] ")
  1697. INSERT INTO helpsql VALUES("sp_updatetask",8,"     [, <freqrecurrencefactor>] [, <activestartdate>] ")
  1698. INSERT INTO helpsql VALUES("sp_updatetask",9,"     [, <activeenddate>] [, <activestarttimeofday>] ")
  1699. INSERT INTO helpsql VALUES("sp_updatetask",10,"     [, <activeendtimeofday>] [, <nextrundate>] [, <nextruntime>] ")
  1700. INSERT INTO helpsql VALUES("sp_updatetask",11,"     [, <runpriority>] [, <emailoperatorname>] [, <retryattempts>] ")
  1701. INSERT INTO helpsql VALUES("sp_updatetask",12,"     [, <retrydelay>] [, <command>] [, <loghistcompletionlevel>] ")
  1702. INSERT INTO helpsql VALUES("sp_updatetask",13,"     [, <emailcompletionlevel>] [, <description>] ")
  1703. INSERT INTO helpsql VALUES("sp_updatetask",14,"     [, <tagadditionalinfo>] [, <tagobjectid>] [, <tagobjecttype>] ")
  1704. INSERT INTO helpsql VALUES("sp_addalias",1,"sp_addalias System Stored Procedure")
  1705. INSERT INTO helpsql VALUES("sp_addalias",2,"Maps one user to another in a database.")
  1706. INSERT INTO helpsql VALUES("sp_addalias",3," ")
  1707. INSERT INTO helpsql VALUES("sp_addalias",4,"sp_addalias <login_ID>, <username>")
  1708. INSERT INTO helpsql VALUES("sp_addextendedproc",1,"sp_addextendedproc System Stored Procedure")
  1709. INSERT INTO helpsql VALUES("sp_addextendedproc",2,"Registers the name of a new extended stored procedure to SQL Server.")
  1710. INSERT INTO helpsql VALUES("sp_addextendedproc",3," ")
  1711. INSERT INTO helpsql VALUES("sp_addextendedproc",4,"sp_addextendedproc <function_name>, <dll_name>")
  1712. INSERT INTO helpsql VALUES("sp_addgroup",1,"sp_addgroup System Stored Procedure")
  1713. INSERT INTO helpsql VALUES("sp_addgroup",2,"Creates a group in the current database.")
  1714. INSERT INTO helpsql VALUES("sp_addgroup",3," ")
  1715. INSERT INTO helpsql VALUES("sp_addgroup",4,"sp_addgroup <grpname>")
  1716. INSERT INTO helpsql VALUES("sp_addlogin",1,"sp_addlogin System Stored Procedure")
  1717. INSERT INTO helpsql VALUES("sp_addlogin",2,"Creates a new SQL Server user by adding an entry to ")
  1718. INSERT INTO helpsql VALUES("sp_addlogin",3,"master.dbo.syslogins.")
  1719. INSERT INTO helpsql VALUES("sp_addlogin",4," ")
  1720. INSERT INTO helpsql VALUES("sp_addlogin",5,"sp_addlogin <login_ID> [, <passwd> [, <defdb> [, <deflanguage>]]]")
  1721. INSERT INTO helpsql VALUES("sp_addmessage",1,"sp_addmessage System Stored Procedure")
  1722. INSERT INTO helpsql VALUES("sp_addmessage",2,"Adds a new error message to the sysmessages table.")
  1723. INSERT INTO helpsql VALUES("sp_addmessage",3," ")
  1724. INSERT INTO helpsql VALUES("sp_addmessage",4,"sp_addmessage <msg_id>, <severity>, '<text of message>' ")
  1725. INSERT INTO helpsql VALUES("sp_addmessage",5,"          [, <language> [, TRUE | FALSE [, REPLACE]]]")
  1726. go
  1727. DUMP TRANSACTION master WITH NO_LOG
  1728. go
  1729. INSERT INTO helpsql VALUES("sp_addremotelogin",1,"sp_addremotelogin System Stored Procedure")
  1730. INSERT INTO helpsql VALUES("sp_addremotelogin",2,"Adds a new remote login ID to master.dbo.sysremotelogins. ")
  1731. INSERT INTO helpsql VALUES("sp_addremotelogin",3," ")
  1732. INSERT INTO helpsql VALUES("sp_addremotelogin",4,"sp_addremotelogin <remoteserver> [, <login_ID> [, <remotename>]]")
  1733. INSERT INTO helpsql VALUES("sp_addsegment",1,"sp_addsegment System Stored Procedure")
  1734. INSERT INTO helpsql VALUES("sp_addsegment",2,"Defines a segment on a database device in the current database.")
  1735. INSERT INTO helpsql VALUES("sp_addsegment",3," ")
  1736. INSERT INTO helpsql VALUES("sp_addsegment",4,"sp_addsegment <segname>, <logical_name>")
  1737. INSERT INTO helpsql VALUES("sp_addserver",1,"sp_addserver System Stored Procedure")
  1738. INSERT INTO helpsql VALUES("sp_addserver",2,"Defines a remote server or the name of the local server.")
  1739. INSERT INTO helpsql VALUES("sp_addserver",3," ")
  1740. INSERT INTO helpsql VALUES("sp_addserver",4,"sp_addserver <server_name> [, LOCAL]")
  1741. INSERT INTO helpsql VALUES("sp_addtype",1,"sp_addtype System Stored Procedure")
  1742. INSERT INTO helpsql VALUES("sp_addtype",2,"Creates a user-defined datatype.")
  1743. INSERT INTO helpsql VALUES("sp_addtype",3," ")
  1744. INSERT INTO helpsql VALUES("sp_addtype",4,"sp_addtype <typename>, <phystype> [, <nulltype>]")
  1745. INSERT INTO helpsql VALUES("sp_addumpdevice",1,"sp_addumpdevice System Stored Procedure")
  1746. INSERT INTO helpsql VALUES("sp_addumpdevice",2,"Adds a dump device to SQL Server.")
  1747. INSERT INTO helpsql VALUES("sp_addumpdevice",3," ")
  1748. INSERT INTO helpsql VALUES("sp_addumpdevice",4,"sp_addumpdevice {'disk' | 'diskette' | 'tape'}, '<logical_name>', ")
  1749. INSERT INTO helpsql VALUES("sp_addumpdevice",5,"     '<physical_name>' [, {{<cntrltype> [, noskip | skip ")
  1750. INSERT INTO helpsql VALUES("sp_addumpdevice",6,"     [, <media_capacity>]]} | ")
  1751. INSERT INTO helpsql VALUES("sp_addumpdevice",7,"     {@devstatus = {noskip | skip}}}]")
  1752. INSERT INTO helpsql VALUES("sp_adduser",1,"sp_adduser System Stored Procedure")
  1753. INSERT INTO helpsql VALUES("sp_adduser",2,"Adds a new user to the current database.")
  1754. INSERT INTO helpsql VALUES("sp_adduser",3," ")
  1755. INSERT INTO helpsql VALUES("sp_adduser",4,"sp_adduser <login_ID> [, <username> [, <grpname>]]")
  1756. INSERT INTO helpsql VALUES("sp_altermessage",1,"sp_altermessage System Stored Procedure")
  1757. INSERT INTO helpsql VALUES("sp_altermessage",2,"Alters the state of a sysmessages error.")
  1758. INSERT INTO helpsql VALUES("sp_altermessage",3," ")
  1759. INSERT INTO helpsql VALUES("sp_altermessage",4,"sp_altermessage <message_id>, WITH_LOG, {TRUE | FALSE}")
  1760. go
  1761. DUMP TRANSACTION master WITH NO_LOG
  1762. go
  1763. INSERT INTO helpsql VALUES("sp_bindefault",1,"sp_bindefault System Stored Procedure")
  1764. INSERT INTO helpsql VALUES("sp_bindefault",2,"Binds a default to a column or to a user-defined datatype.")
  1765. INSERT INTO helpsql VALUES("sp_bindefault",3," ")
  1766. INSERT INTO helpsql VALUES("sp_bindefault",4,"sp_bindefault <defname>, <objname> [, FUTUREONLY]")
  1767. INSERT INTO helpsql VALUES("sp_bindrule",1,"sp_bindrule System Stored Procedure")
  1768. INSERT INTO helpsql VALUES("sp_bindrule",2,"Binds a rule to a column or to a user-defined datatype.")
  1769. INSERT INTO helpsql VALUES("sp_bindrule",3," ")
  1770. INSERT INTO helpsql VALUES("sp_bindrule",4,"sp_bindrule <rulename>, <objname> [, FUTUREONLY]")
  1771. INSERT INTO helpsql VALUES("sp_certify_removable",1,"sp_certify_removable System Stored Procedure")
  1772. INSERT INTO helpsql VALUES("sp_certify_removable",2,"Verifies that a database is configured properly for distribution on ")
  1773. INSERT INTO helpsql VALUES("sp_certify_removable",3,"removable media.")
  1774. INSERT INTO helpsql VALUES("sp_certify_removable",4," ")
  1775. INSERT INTO helpsql VALUES("sp_certify_removable",5,"sp_certify_removable <dbname>[, AUTO]")
  1776. INSERT INTO helpsql VALUES("sp_changedbowner",1,"sp_changedbowner System Stored Procedure")
  1777. INSERT INTO helpsql VALUES("sp_changedbowner",2,"Changes the owner of a database.")
  1778. INSERT INTO helpsql VALUES("sp_changedbowner",3," ")
  1779. INSERT INTO helpsql VALUES("sp_changedbowner",4,"sp_changedbowner <login_ID> [, TRUE]")
  1780. INSERT INTO helpsql VALUES("sp_changegroup",1,"sp_changegroup System Stored Procedure")
  1781. INSERT INTO helpsql VALUES("sp_changegroup",2,"Changes a user's group.")
  1782. INSERT INTO helpsql VALUES("sp_changegroup",3," ")
  1783. INSERT INTO helpsql VALUES("sp_changegroup",4,"sp_changegroup <grpname>, <username>")
  1784. INSERT INTO helpsql VALUES("sp_configure",1,"sp_configure System Stored Procedure")
  1785. INSERT INTO helpsql VALUES("sp_configure",2,"Displays or changes configuration options.")
  1786. INSERT INTO helpsql VALUES("sp_configure",3," ")
  1787. INSERT INTO helpsql VALUES("sp_configure",4,"sp_configure [<config_name> [, <config_value>]]")
  1788. INSERT INTO helpsql VALUES("sp_create_removable",1,"sp_create_removable System Stored Procedure")
  1789. INSERT INTO helpsql VALUES("sp_create_removable",2,"Creates a removable media database. ")
  1790. INSERT INTO helpsql VALUES("sp_create_removable",3," ")
  1791. INSERT INTO helpsql VALUES("sp_create_removable",4,"sp_create_removable <dbname>, <syslogical>, '<sysphysical>', <syssize>, ")
  1792. INSERT INTO helpsql VALUES("sp_create_removable",5,"     <loglogical>, '<logphysical>', <logsize>, <datalogical1>, ")
  1793. INSERT INTO helpsql VALUES("sp_create_removable",6,"     '<dataphysical1>', <datasize1> [... , <datalogical16>, ")
  1794. INSERT INTO helpsql VALUES("sp_create_removable",7,"     '<dataphysical16>', <datasize16>]")
  1795. go
  1796. DUMP TRANSACTION master WITH NO_LOG
  1797. go
  1798. INSERT INTO helpsql VALUES("sp_dbinstall",1,"sp_dbinstall System Stored Procedure")
  1799. INSERT INTO helpsql VALUES("sp_dbinstall",2,"Installs a database and its devices.")
  1800. INSERT INTO helpsql VALUES("sp_dbinstall",3," ")
  1801. INSERT INTO helpsql VALUES("sp_dbinstall",4,"sp_dbinstall <database>, <logical_dev_name>, '<physical_dev_name>', ")
  1802. INSERT INTO helpsql VALUES("sp_dbinstall",5,"     <size>, '<devtype>' [,'<location>'] ")
  1803. INSERT INTO helpsql VALUES("sp_dboption",1,"sp_dboption System Stored Procedure")
  1804. INSERT INTO helpsql VALUES("sp_dboption",2,"Displays or changes database options.")
  1805. INSERT INTO helpsql VALUES("sp_dboption",3," ")
  1806. INSERT INTO helpsql VALUES("sp_dboption",4,"sp_dboption [<dbname>, <optname>, {TRUE | FALSE}]")
  1807. INSERT INTO helpsql VALUES("sp_dbremove",1,"sp_dbremove System Stored Procedure")
  1808. INSERT INTO helpsql VALUES("sp_dbremove",2,"Used to remove an installed database, and optionally, any devices to ")
  1809. INSERT INTO helpsql VALUES("sp_dbremove",3,"which it has exclusive use. ")
  1810. INSERT INTO helpsql VALUES("sp_dbremove",4," ")
  1811. INSERT INTO helpsql VALUES("sp_dbremove",5,"sp_dbremove <database>[, dropdev]")
  1812. INSERT INTO helpsql VALUES("sp_defaultdb",1,"sp_defaultdb System Stored Procedure")
  1813. INSERT INTO helpsql VALUES("sp_defaultdb",2,"Changes a user's default database.")
  1814. INSERT INTO helpsql VALUES("sp_defaultdb",3," ")
  1815. INSERT INTO helpsql VALUES("sp_defaultdb",4,"sp_defaultdb <login_ID>, <defdb>")
  1816. INSERT INTO helpsql VALUES("sp_defaultlanguage",1,"sp_defaultlanguage System Stored Procedure")
  1817. INSERT INTO helpsql VALUES("sp_defaultlanguage",2,"Changes a user's default language.")
  1818. INSERT INTO helpsql VALUES("sp_defaultlanguage",3," ")
  1819. INSERT INTO helpsql VALUES("sp_defaultlanguage",4,"sp_defaultlanguage <login_ID> [, <language>]")
  1820. INSERT INTO helpsql VALUES("sp_depends",1,"sp_depends System Stored Procedure")
  1821. INSERT INTO helpsql VALUES("sp_depends",2,"Displays information about database object dependencies - the views and ")
  1822. INSERT INTO helpsql VALUES("sp_depends",3,"procedures that depend on the specified table or view, and the tables ")
  1823. INSERT INTO helpsql VALUES("sp_depends",4,"and views that are depended on by the specified view or procedure.")
  1824. INSERT INTO helpsql VALUES("sp_depends",5," ")
  1825. INSERT INTO helpsql VALUES("sp_depends",6,"sp_depends <objname>")
  1826. INSERT INTO helpsql VALUES("sp_devoption",1,"sp_devoption System Stored Procedure")
  1827. INSERT INTO helpsql VALUES("sp_devoption",2,"Displays or sets device status. Although primarily used on removable ")
  1828. INSERT INTO helpsql VALUES("sp_devoption",3,"media devices, this procedure can be used for all devices. ")
  1829. INSERT INTO helpsql VALUES("sp_devoption",4," ")
  1830. INSERT INTO helpsql VALUES("sp_devoption",5,"sp_devoption [<devicename> [, <optname> {, TRUE | FALSE} [, OVERRIDE]]]")
  1831. go
  1832. DUMP TRANSACTION master WITH NO_LOG
  1833. go
  1834. INSERT INTO helpsql VALUES("sp_diskdefault",1,"sp_diskdefault System Stored Procedure")
  1835. INSERT INTO helpsql VALUES("sp_diskdefault",2,"Sets a database device's status to indicate whether the device can be ")
  1836. INSERT INTO helpsql VALUES("sp_diskdefault",3,"used for database storage when the user does not specify a database ")
  1837. INSERT INTO helpsql VALUES("sp_diskdefault",4,"device or specifies DEFAULT with the CREATE DATABASE or ALTER DATABASE ")
  1838. INSERT INTO helpsql VALUES("sp_diskdefault",5,"statements.")
  1839. INSERT INTO helpsql VALUES("sp_diskdefault",6," ")
  1840. INSERT INTO helpsql VALUES("sp_diskdefault",7,"sp_diskdefault <database_device>, {defaulton | defaultoff}")
  1841. INSERT INTO helpsql VALUES("sp_dropalias",1,"sp_dropalias System Stored Procedure")
  1842. INSERT INTO helpsql VALUES("sp_dropalias",2,"Removes the alias login ID identity that had been established by ")
  1843. INSERT INTO helpsql VALUES("sp_dropalias",3,"sp_addalias. ")
  1844. INSERT INTO helpsql VALUES("sp_dropalias",4," ")
  1845. INSERT INTO helpsql VALUES("sp_dropalias",5,"sp_dropalias <login_ID>")
  1846. INSERT INTO helpsql VALUES("sp_dropdevice",1,"sp_dropdevice System Stored Procedure")
  1847. INSERT INTO helpsql VALUES("sp_dropdevice",2,"Removes a SQL Server database device or dump device.")
  1848. INSERT INTO helpsql VALUES("sp_dropdevice",3," ")
  1849. INSERT INTO helpsql VALUES("sp_dropdevice",4,"sp_dropdevice <logical_name> [, DELFILE]")
  1850. INSERT INTO helpsql VALUES("sp_dropextendedproc",1,"sp_dropextendedproc System Stored Procedure")
  1851. INSERT INTO helpsql VALUES("sp_dropextendedproc",2,"Drops an extended stored procedure.")
  1852. INSERT INTO helpsql VALUES("sp_dropextendedproc",3," ")
  1853. INSERT INTO helpsql VALUES("sp_dropextendedproc",4,"sp_dropextendedproc <function_name>")
  1854. INSERT INTO helpsql VALUES("sp_dropgroup",1,"sp_dropgroup System Stored Procedure")
  1855. INSERT INTO helpsql VALUES("sp_dropgroup",2,"Removes a group from a database.")
  1856. INSERT INTO helpsql VALUES("sp_dropgroup",3," ")
  1857. INSERT INTO helpsql VALUES("sp_dropgroup",4,"sp_dropgroup <grpname>")
  1858. INSERT INTO helpsql VALUES("sp_droplanguage",1,"sp_droplanguage System Stored Procedure")
  1859. INSERT INTO helpsql VALUES("sp_droplanguage",2,"Drops an alternate language from the server and removes its row from ")
  1860. INSERT INTO helpsql VALUES("sp_droplanguage",3,"master.dbo.syslogins.")
  1861. INSERT INTO helpsql VALUES("sp_droplanguage",4," ")
  1862. INSERT INTO helpsql VALUES("sp_droplanguage",5,"sp_droplanguage <language> [, dropmessages]")
  1863. INSERT INTO helpsql VALUES("sp_droplogin",1,"sp_droplogin System Stored Procedure")
  1864. INSERT INTO helpsql VALUES("sp_droplogin",2,"Removes a SQL Server login ID by deleting the user's entry in ")
  1865. INSERT INTO helpsql VALUES("sp_droplogin",3,"master.dbo.syslogins.")
  1866. INSERT INTO helpsql VALUES("sp_droplogin",4," ")
  1867. INSERT INTO helpsql VALUES("sp_droplogin",5,"sp_droplogin <login_ID>")
  1868. go
  1869. DUMP TRANSACTION master WITH NO_LOG
  1870. go
  1871. INSERT INTO helpsql VALUES("sp_dropmessage",1,"sp_dropmessage System Stored Procedure")
  1872. INSERT INTO helpsql VALUES("sp_dropmessage",2,"Drops a specified error message from the sysmessages system table.")
  1873. INSERT INTO helpsql VALUES("sp_dropmessage",3," ")
  1874. INSERT INTO helpsql VALUES("sp_dropmessage",4,"sp_dropmessage <msg_id>, [<language> | 'ALL' ]")
  1875. INSERT INTO helpsql VALUES("sp_dropremotelogin",1,"sp_dropremotelogin System Stored Procedure")
  1876. INSERT INTO helpsql VALUES("sp_dropremotelogin",2,"Removes a remote user login.")
  1877. INSERT INTO helpsql VALUES("sp_dropremotelogin",3," ")
  1878. INSERT INTO helpsql VALUES("sp_dropremotelogin",4,"sp_dropremotelogin <remoteserver> [, <loginame> [, <remotename>]] ")
  1879. INSERT INTO helpsql VALUES("sp_dropsegment",1,"sp_dropsegment System Stored Procedure")
  1880. INSERT INTO helpsql VALUES("sp_dropsegment",2,"Drops a segment from a database or unmaps a segment from a database device.")
  1881. INSERT INTO helpsql VALUES("sp_dropsegment",3," ")
  1882. INSERT INTO helpsql VALUES("sp_dropsegment",4,"sp_dropsegment <segname> [, <logical_name>]")
  1883. INSERT INTO helpsql VALUES("sp_dropserver",1,"sp_dropserver System Stored Procedure")
  1884. INSERT INTO helpsql VALUES("sp_dropserver",2,"Drops a server from the list of known servers, deleting the entry from ")
  1885. INSERT INTO helpsql VALUES("sp_dropserver",3,"the master.dbo.sysservers table.")
  1886. INSERT INTO helpsql VALUES("sp_dropserver",4," ")
  1887. INSERT INTO helpsql VALUES("sp_dropserver",5,"sp_dropserver <server_name> [, droplogins]")
  1888. INSERT INTO helpsql VALUES("sp_droptype",1,"sp_droptype System Stored Procedure")
  1889. INSERT INTO helpsql VALUES("sp_droptype",2,"Deletes a user-defined datatype from systypes.")
  1890. INSERT INTO helpsql VALUES("sp_droptype",3," ")
  1891. INSERT INTO helpsql VALUES("sp_droptype",4,"sp_droptype <typename>")
  1892. INSERT INTO helpsql VALUES("sp_dropuser",1,"sp_dropuser System Stored Procedure")
  1893. INSERT INTO helpsql VALUES("sp_dropuser",2,"Removes a user from the current database by deleting the entry from the ")
  1894. INSERT INTO helpsql VALUES("sp_dropuser",3,"current database's sysusers table.")
  1895. INSERT INTO helpsql VALUES("sp_dropuser",4," ")
  1896. INSERT INTO helpsql VALUES("sp_dropuser",5,"sp_dropuser <username>")
  1897. INSERT INTO helpsql VALUES("sp_extendsegment",1,"sp_extendsegment System Stored Procedure")
  1898. INSERT INTO helpsql VALUES("sp_extendsegment",2,"Extends the range of a segment to another database device.")
  1899. INSERT INTO helpsql VALUES("sp_extendsegment",3," ")
  1900. INSERT INTO helpsql VALUES("sp_extendsegment",4,"sp_extendsegment <segname>, <logical_name>")
  1901. go
  1902. DUMP TRANSACTION master WITH NO_LOG
  1903. go
  1904. INSERT INTO helpsql VALUES("sp_help",1,"sp_help System Stored Procedure")
  1905. INSERT INTO helpsql VALUES("sp_help",2,"Reports information about a database object (any object listed in the ")
  1906. INSERT INTO helpsql VALUES("sp_help",3,"sysobjects table) or about a SQL Server - supplied or user-defined ")
  1907. INSERT INTO helpsql VALUES("sp_help",4,"datatype.")
  1908. INSERT INTO helpsql VALUES("sp_help",5," ")
  1909. INSERT INTO helpsql VALUES("sp_help",6,"sp_help [<objname>]")
  1910. INSERT INTO helpsql VALUES("sp_helpconstraint",1,"sp_helpconstraint System Stored Procedure")
  1911. INSERT INTO helpsql VALUES("sp_helpconstraint",2,"Returns a list of all constraint types, their user-defined or system- ")
  1912. INSERT INTO helpsql VALUES("sp_helpconstraint",3,"supplied name, and the columns on which they have been defined.")
  1913. INSERT INTO helpsql VALUES("sp_helpconstraint",4," ")
  1914. INSERT INTO helpsql VALUES("sp_helpconstraint",5,"sp_helpconstraint <table_name>")
  1915. INSERT INTO helpsql VALUES("sp_helpdb",1,"sp_helpdb System Stored Procedure")
  1916. INSERT INTO helpsql VALUES("sp_helpdb",2,"Reports information about a specified database or all databases.")
  1917. INSERT INTO helpsql VALUES("sp_helpdb",3," ")
  1918. INSERT INTO helpsql VALUES("sp_helpdb",4,"sp_helpdb [<dbname>]")
  1919. INSERT INTO helpsql VALUES("sp_helpdevice",1,"sp_helpdevice System Stored Procedure")
  1920. INSERT INTO helpsql VALUES("sp_helpdevice",2,"Reports information about SQL Server database devices and dump devices.")
  1921. INSERT INTO helpsql VALUES("sp_helpdevice",3," ")
  1922. INSERT INTO helpsql VALUES("sp_helpdevice",4,"sp_helpdevice [<logical_name>]")
  1923. INSERT INTO helpsql VALUES("sp_helpextendedproc",1,"sp_helpextendedproc System Stored Procedure")
  1924. INSERT INTO helpsql VALUES("sp_helpextendedproc",2,"Displays the currently defined extended stored procedures and the name ")
  1925. INSERT INTO helpsql VALUES("sp_helpextendedproc",3,"of the dynamic-link library to which the function belongs.")
  1926. INSERT INTO helpsql VALUES("sp_helpextendedproc",4," ")
  1927. INSERT INTO helpsql VALUES("sp_helpextendedproc",5,"sp_helpextendedproc [<function_name>]")
  1928. INSERT INTO helpsql VALUES("sp_helpgroup",1,"sp_helpgroup System Stored Procedure")
  1929. INSERT INTO helpsql VALUES("sp_helpgroup",2,"Reports information about a group or all groups in the current database.")
  1930. INSERT INTO helpsql VALUES("sp_helpgroup",3," ")
  1931. INSERT INTO helpsql VALUES("sp_helpgroup",4,"sp_helpgroup [<grpname>]")
  1932. INSERT INTO helpsql VALUES("sp_helpindex",1,"sp_helpindex System Stored Procedure")
  1933. INSERT INTO helpsql VALUES("sp_helpindex",2,"Reports information about the indexes on a table.")
  1934. INSERT INTO helpsql VALUES("sp_helpindex",3," ")
  1935. INSERT INTO helpsql VALUES("sp_helpindex",4,"sp_helpindex <tabname>")
  1936. go
  1937. DUMP TRANSACTION master WITH NO_LOG
  1938. go
  1939. INSERT INTO helpsql VALUES("sp_helplanguage",1,"sp_helplanguage System Stored Procedure")
  1940. INSERT INTO helpsql VALUES("sp_helplanguage",2,"Reports information about a particular alternate language or about all ")
  1941. INSERT INTO helpsql VALUES("sp_helplanguage",3,"languages.")
  1942. INSERT INTO helpsql VALUES("sp_helplanguage",4," ")
  1943. INSERT INTO helpsql VALUES("sp_helplanguage",5,"sp_helplanguage [<language>]")
  1944. INSERT INTO helpsql VALUES("sp_helplog",1,"sp_helplog System Stored Procedure")
  1945. INSERT INTO helpsql VALUES("sp_helplog",2,"Reports the name of the device that contains the first page of the log ")
  1946. INSERT INTO helpsql VALUES("sp_helplog",3,"in the current database.")
  1947. INSERT INTO helpsql VALUES("sp_helplog",4," ")
  1948. INSERT INTO helpsql VALUES("sp_helplog",5,"sp_helplog ")
  1949. INSERT INTO helpsql VALUES("sp_helpremotelogin",1,"sp_helpremotelogin System Stored Procedure")
  1950. INSERT INTO helpsql VALUES("sp_helpremotelogin",2,"Reports information about a particular remote server's logins or about ")
  1951. INSERT INTO helpsql VALUES("sp_helpremotelogin",3,"all remote servers' logins.")
  1952. INSERT INTO helpsql VALUES("sp_helpremotelogin",4," ")
  1953. INSERT INTO helpsql VALUES("sp_helpremotelogin",5,"sp_helpremotelogin [<remoteserver> [, <remotename>]]")
  1954. INSERT INTO helpsql VALUES("sp_helprotect",1,"sp_helprotect System Stored Procedure")
  1955. INSERT INTO helpsql VALUES("sp_helprotect",2,"Reports permissions by database object and, optionally, by user for that ")
  1956. INSERT INTO helpsql VALUES("sp_helprotect",3,"object.")
  1957. INSERT INTO helpsql VALUES("sp_helprotect",4," ")
  1958. INSERT INTO helpsql VALUES("sp_helprotect",5,"sp_helprotect <name> [, <username>]")
  1959. INSERT INTO helpsql VALUES("sp_helpsegment",1,"sp_helpsegment System Stored Procedure")
  1960. INSERT INTO helpsql VALUES("sp_helpsegment",2,"Reports information about a particular segment or about all segments in ")
  1961. INSERT INTO helpsql VALUES("sp_helpsegment",3,"the current database.")
  1962. INSERT INTO helpsql VALUES("sp_helpsegment",4," ")
  1963. INSERT INTO helpsql VALUES("sp_helpsegment",5,"sp_helpsegment [<segname>]")
  1964. INSERT INTO helpsql VALUES("sp_helpserver",1,"sp_helpserver System Stored Procedure")
  1965. INSERT INTO helpsql VALUES("sp_helpserver",2,"Reports information about a particular remote or replication server or ")
  1966. INSERT INTO helpsql VALUES("sp_helpserver",3,"about all servers of both types.")
  1967. INSERT INTO helpsql VALUES("sp_helpserver",4," ")
  1968. INSERT INTO helpsql VALUES("sp_helpserver",5,"sp_helpserver [<server_name>]")
  1969. INSERT INTO helpsql VALUES("sp_helpsort",1,"sp_helpsort System Stored Procedure")
  1970. INSERT INTO helpsql VALUES("sp_helpsort",2,"Displays the SQL Server default sort order and character set.")
  1971. INSERT INTO helpsql VALUES("sp_helpsort",3," ")
  1972. INSERT INTO helpsql VALUES("sp_helpsort",4,"sp_helpsort")
  1973. INSERT INTO helpsql VALUES("sp_helpsql",1,"sp_helpsql System Stored Procedure")
  1974. INSERT INTO helpsql VALUES("sp_helpsql",2,"Provides syntax for Transact-SQL statements, system procedures, ")
  1975. INSERT INTO helpsql VALUES("sp_helpsql",3,"and other special topics.")
  1976. INSERT INTO helpsql VALUES("sp_helpsql",4," ")
  1977. INSERT INTO helpsql VALUES("sp_helpsql",5,"sp_helpsql ['<topic>']")
  1978. go
  1979. DUMP TRANSACTION master WITH NO_LOG
  1980. go
  1981. INSERT INTO helpsql VALUES("sp_helpstartup",1,"sp_helpstartup System Stored Procedure")
  1982. INSERT INTO helpsql VALUES("sp_helpstartup",2,"Reports a listing of all auto-start stored procedures.")
  1983. INSERT INTO helpsql VALUES("sp_helpstartup",3," ")
  1984. INSERT INTO helpsql VALUES("sp_helpstartup",4,"sp_helpstartup")
  1985. INSERT INTO helpsql VALUES("sp_helptext",1,"sp_helptext System Stored Procedure")
  1986. INSERT INTO helpsql VALUES("sp_helptext",2,"Prints the text of a rule, a default, or an unencrypted stored ")
  1987. INSERT INTO helpsql VALUES("sp_helptext",3,"procedure, trigger, or view.")
  1988. INSERT INTO helpsql VALUES("sp_helptext",4," ")
  1989. INSERT INTO helpsql VALUES("sp_helptext",5,"sp_helptext <objname>")
  1990. INSERT INTO helpsql VALUES("sp_helpuser",1,"sp_helpuser System Stored Procedure")
  1991. INSERT INTO helpsql VALUES("sp_helpuser",2,"Reports information about the users of a database.")
  1992. INSERT INTO helpsql VALUES("sp_helpuser",3," ")
  1993. INSERT INTO helpsql VALUES("sp_helpuser",4,"sp_helpuser [<username>]")
  1994. INSERT INTO helpsql VALUES("sp_helplock",1,"sp_lock System Stored Procedure")
  1995. INSERT INTO helpsql VALUES("sp_helplock",2,"Reports information about locks.")
  1996. INSERT INTO helpsql VALUES("sp_helplock",3," ")
  1997. INSERT INTO helpsql VALUES("sp_helplock",4,"sp_lock [<spid1> [, <spid2>]]")
  1998. INSERT INTO helpsql VALUES("sp_logdevice",1,"sp_logdevice System Stored Procedure")
  1999. INSERT INTO helpsql VALUES("sp_logdevice",2,"Puts the syslogs system table, which contains the transaction log, on a ")
  2000. INSERT INTO helpsql VALUES("sp_logdevice",3,"separate database device.")
  2001. INSERT INTO helpsql VALUES("sp_logdevice",4," ")
  2002. INSERT INTO helpsql VALUES("sp_logdevice",5,"sp_logdevice <dbname>, <database_device>")
  2003. INSERT INTO helpsql VALUES("sp_makestartup",1,"sp_makestartup System Stored Procedure")
  2004. INSERT INTO helpsql VALUES("sp_makestartup",2,"Sets a stored procedure for auto execution. Auto execution stored ")
  2005. INSERT INTO helpsql VALUES("sp_makestartup",3,"procedures are executed every time the server is started.")
  2006. INSERT INTO helpsql VALUES("sp_makestartup",4," ")
  2007. INSERT INTO helpsql VALUES("sp_makestartup",5,"sp_makestartup <procedure_name>")
  2008. INSERT INTO helpsql VALUES("sp_monitor",1,"sp_monitor System Stored Procedure")
  2009. INSERT INTO helpsql VALUES("sp_monitor",2,"Displays statistics about SQL Server.")
  2010. INSERT INTO helpsql VALUES("sp_monitor",3," ")
  2011. INSERT INTO helpsql VALUES("sp_monitor",4,"sp_monitor")
  2012. INSERT INTO helpsql VALUES("sp_password",1,"sp_password System Stored Procedure")
  2013. INSERT INTO helpsql VALUES("sp_password",2,"Adds or changes a password for a SQL Server login ID.")
  2014. INSERT INTO helpsql VALUES("sp_password",3," ")
  2015. INSERT INTO helpsql VALUES("sp_password",4,"sp_password <old>, <new> [, <login_ID>]")
  2016. go
  2017. DUMP TRANSACTION master WITH NO_LOG
  2018. go
  2019. INSERT INTO helpsql VALUES("sp_placeobject",1,"sp_placeobject System Stored Procedure")
  2020. INSERT INTO helpsql VALUES("sp_placeobject",2,"Puts future space allocations for a table or index on a particular ")
  2021. INSERT INTO helpsql VALUES("sp_placeobject",3,"segment.")
  2022. INSERT INTO helpsql VALUES("sp_placeobject",4," ")
  2023. INSERT INTO helpsql VALUES("sp_placeobject",5,"sp_placeobject <segname>, <objname>")
  2024. INSERT INTO helpsql VALUES("sp_processmail",1,"sp_processmail System Stored Procedure")
  2025. INSERT INTO helpsql VALUES("sp_processmail",2,"Uses extended stored procedures (xp_findnextmsg, xp_readmail, and ")
  2026. INSERT INTO helpsql VALUES("sp_processmail",3,"xp_deletemail) to process incoming mail messages (expected to be only a ")
  2027. INSERT INTO helpsql VALUES("sp_processmail",4,"single query) from the inbox for SQL Server. It uses the xp_sendmail ")
  2028. INSERT INTO helpsql VALUES("sp_processmail",5,"extended stored procedure to return the results set back to the message ")
  2029. INSERT INTO helpsql VALUES("sp_processmail",6,"sender.")
  2030. INSERT INTO helpsql VALUES("sp_processmail",7," ")
  2031. INSERT INTO helpsql VALUES("sp_processmail",8,"sp_processmail [@subject = <subject>] [[,] @filetype = <filetype>] ")
  2032. INSERT INTO helpsql VALUES("sp_processmail",9,"     [[,] @separator = <separator>] [[,] @set_user = <user>] ")
  2033. INSERT INTO helpsql VALUES("sp_processmail",10,"     [[,] @dbuse = <dbname>]")
  2034. INSERT INTO helpsql VALUES("sp_recompile",1,"sp_recompile System Stored Procedure")
  2035. INSERT INTO helpsql VALUES("sp_recompile",2,"Causes each stored procedure and trigger that uses the specified table ")
  2036. INSERT INTO helpsql VALUES("sp_recompile",3,"to be recompiled the next time the stored procedure and triggers are ")
  2037. INSERT INTO helpsql VALUES("sp_recompile",4,"run.")
  2038. INSERT INTO helpsql VALUES("sp_recompile",5," ")
  2039. INSERT INTO helpsql VALUES("sp_recompile",6,"sp_recompile <tabname>")
  2040. INSERT INTO helpsql VALUES("sp_remoteoption",1,"sp_remoteoption System Stored Procedure")
  2041. INSERT INTO helpsql VALUES("sp_remoteoption",2,"Displays or changes remote login options.")
  2042. INSERT INTO helpsql VALUES("sp_remoteoption",3," ")
  2043. INSERT INTO helpsql VALUES("sp_remoteoption",4,"sp_remoteoption [<remoteserver>, <loginame>, <remotename>, ")
  2044. INSERT INTO helpsql VALUES("sp_remoteoption",5,"     <optname>, {TRUE | FALSE}]")
  2045. INSERT INTO helpsql VALUES("sp_rename",1,"sp_rename System Stored Procedure")
  2046. INSERT INTO helpsql VALUES("sp_rename",2,"Changes the name of a user-created object in the current database.")
  2047. INSERT INTO helpsql VALUES("sp_rename",3," ")
  2048. INSERT INTO helpsql VALUES("sp_rename",4,"sp_rename <objname>, <newname> [, COLUMN | INDEX ]")
  2049. INSERT INTO helpsql VALUES("sp_renamedb",1,"sp_renamedb System Stored Procedure")
  2050. INSERT INTO helpsql VALUES("sp_renamedb",2,"Changes the name of a database.")
  2051. INSERT INTO helpsql VALUES("sp_renamedb",3," ")
  2052. INSERT INTO helpsql VALUES("sp_renamedb",4,"sp_renamedb <oldname>, <newname>")
  2053. go
  2054. DUMP TRANSACTION master WITH NO_LOG
  2055. go
  2056. INSERT INTO helpsql VALUES("sp_serveroption",1,"sp_serveroption System Stored Procedure")
  2057. INSERT INTO helpsql VALUES("sp_serveroption",2,"Sets server options.")
  2058. INSERT INTO helpsql VALUES("sp_serveroption",3," ")
  2059. INSERT INTO helpsql VALUES("sp_serveroption",4,"sp_serveroption [<server_name>, <optname>, {TRUE | FALSE}]")
  2060. INSERT INTO helpsql VALUES("sp_setlangalias",1,"sp_setlangalias System Stored Procedure")
  2061. INSERT INTO helpsql VALUES("sp_setlangalias",2,"Assigns or changes the alias for an alternate language.")
  2062. INSERT INTO helpsql VALUES("sp_setlangalias",3," ")
  2063. INSERT INTO helpsql VALUES("sp_setlangalias",4,"sp_setlangalias <language>, <alias>")
  2064. INSERT INTO helpsql VALUES("sp_spaceused",1,"sp_spaceused System Stored Procedure")
  2065. INSERT INTO helpsql VALUES("sp_spaceused",2,"Displays the number of rows, the disk space reserved, and the disk space ")
  2066. INSERT INTO helpsql VALUES("sp_spaceused",3,"used by a table in a database, or displaces the disk space reserved and ")
  2067. INSERT INTO helpsql VALUES("sp_spaceused",4,"used by an entire database.")
  2068. INSERT INTO helpsql VALUES("sp_spaceused",5," ")
  2069. INSERT INTO helpsql VALUES("sp_spaceused",6,"sp_spaceused [<objname>] [[,] @updateusage = {TRUE | FALSE}]")
  2070. INSERT INTO helpsql VALUES("sp_unbindefault",1,"sp_unbindefault System Stored Procedure")
  2071. INSERT INTO helpsql VALUES("sp_unbindefault",2,"Unbinds (removes) a default from a column or from a user-defined ")
  2072. INSERT INTO helpsql VALUES("sp_unbindefault",3,"datatype in the current database.")
  2073. INSERT INTO helpsql VALUES("sp_unbindefault",4," ")
  2074. INSERT INTO helpsql VALUES("sp_unbindefault",5,"sp_unbindefault <objname> [, FUTUREONLY]")
  2075. INSERT INTO helpsql VALUES("sp_unbindrule",1,"sp_unbindrule System Stored Procedure")
  2076. INSERT INTO helpsql VALUES("sp_unbindrule",2,"Unbinds a rule from a column or a user-defined datatype in the current ")
  2077. INSERT INTO helpsql VALUES("sp_unbindrule",3,"database.")
  2078. INSERT INTO helpsql VALUES("sp_unbindrule",4," ")
  2079. INSERT INTO helpsql VALUES("sp_unbindrule",5,"sp_unbindrule <objname> [, FUTUREONLY]")
  2080. INSERT INTO helpsql VALUES("sp_unmakestartup",1,"sp_unmakestartup System Stored Procedure")
  2081. INSERT INTO helpsql VALUES("sp_unmakestartup",2,"Discontinues auto execution of the stored procedure.")
  2082. INSERT INTO helpsql VALUES("sp_unmakestartup",3," ")
  2083. INSERT INTO helpsql VALUES("sp_unmakestartup",4,"sp_unmakestartup <procedure_name>")
  2084. INSERT INTO helpsql VALUES("sp_who",1,"sp_who System Stored Procedure")
  2085. INSERT INTO helpsql VALUES("sp_who",2,"Reports information about current SQL Server users and processes.")
  2086. INSERT INTO helpsql VALUES("sp_who",3," ")
  2087. INSERT INTO helpsql VALUES("sp_who",4,"sp_who [<login_ID> | '<spid>']")
  2088. go
  2089. DUMP TRANSACTION master WITH NO_LOG
  2090. go
  2091. INSERT INTO helpsql VALUES("READTEXT",1,"READTEXT Statement")
  2092. INSERT INTO helpsql VALUES("READTEXT",2,"Reads text and image values, starting from a specified offset and ")
  2093. INSERT INTO helpsql VALUES("READTEXT",3,"reading a specified number of bytes.")
  2094. INSERT INTO helpsql VALUES("READTEXT",4," ")
  2095. INSERT INTO helpsql VALUES("READTEXT",5,"READTEXT [[<database>.]<owner>.]<table_name>.<column_name> ")
  2096. INSERT INTO helpsql VALUES("READTEXT",6,"     <text_ptr> <offset> <size> [HOLDLOCK]")
  2097. INSERT INTO helpsql VALUES("UPDATETEXT",1,"UPDATETEXT Statement")
  2098. INSERT INTO helpsql VALUES("UPDATETEXT",2,"Updates an existing text or image field.")
  2099. INSERT INTO helpsql VALUES("UPDATETEXT",3," ")
  2100. INSERT INTO helpsql VALUES("UPDATETEXT",4,"UPDATETEXT [[<database>.]<owner>.]<table_name>.<dest_column_name> ")
  2101. INSERT INTO helpsql VALUES("UPDATETEXT",5,"     <dest_text_ptr> {NULL | <insert_offset>} {NULL | <delete_length>}")
  2102. INSERT INTO helpsql VALUES("UPDATETEXT",6,"     [WITH LOG]")
  2103. INSERT INTO helpsql VALUES("UPDATETEXT",7,"     [<inserted_data> | ")
  2104. INSERT INTO helpsql VALUES("UPDATETEXT",8,"     [{[<database>.]<owner>.]<table_name>.<src_column_name> ")
  2105. INSERT INTO helpsql VALUES("UPDATETEXT",9,"          <src_text_ptr>}]")
  2106. INSERT INTO helpsql VALUES("WRITETEXT",1,"WRITETEXT Statement")
  2107. INSERT INTO helpsql VALUES("WRITETEXT",2,"Permits nonlogged, interactive updating of an existing text or image ")
  2108. INSERT INTO helpsql VALUES("WRITETEXT",3,"field. This statement completely overwrites any existing data in the ")
  2109. INSERT INTO helpsql VALUES("WRITETEXT",4,"column it affects.")
  2110. INSERT INTO helpsql VALUES("WRITETEXT",5," ")
  2111. INSERT INTO helpsql VALUES("WRITETEXT",6,"WRITETEXT [[<database>.]<owner>.]<table_name>.<column_name> ")
  2112. INSERT INTO helpsql VALUES("WRITETEXT",7,"     <text_ptr> [WITH LOG] <data>")
  2113. INSERT INTO helpsql VALUES("TRANSACTIONS",1,"Transactions")
  2114. INSERT INTO helpsql VALUES("TRANSACTIONS",2,"A transaction is a single unit of work. An explicit transaction is a ")
  2115. INSERT INTO helpsql VALUES("TRANSACTIONS",3,"grouping of SQL statements surrounded by the transaction delimiters: ")
  2116. INSERT INTO helpsql VALUES("TRANSACTIONS",4,"BEGIN TRANSACTION, COMMIT TRANSACTION, and optionally, one or more of ")
  2117. INSERT INTO helpsql VALUES("TRANSACTIONS",5,"the following statements:")
  2118. INSERT INTO helpsql VALUES("TRANSACTIONS",6," ")
  2119. INSERT INTO helpsql VALUES("TRANSACTIONS",7,"     BEGIN TRANSACTION ")
  2120. INSERT INTO helpsql VALUES("TRANSACTIONS",8,"     COMMIT TRANSACTION ")
  2121. INSERT INTO helpsql VALUES("TRANSACTIONS",9,"     ROLLBACK TRANSACTION ")
  2122. INSERT INTO helpsql VALUES("TRANSACTIONS",10,"     SAVE TRANSACTION ")
  2123. go
  2124. DUMP TRANSACTION master WITH NO_LOG
  2125. go
  2126. INSERT INTO helpsql VALUES("BEGIN TRANSACTION",1,"BEGIN TRANSACTION Statement")
  2127. INSERT INTO helpsql VALUES("BEGIN TRANSACTION",2,"Marks the starting point of a user-specified transaction.")
  2128. INSERT INTO helpsql VALUES("BEGIN TRANSACTION",3," ")
  2129. INSERT INTO helpsql VALUES("BEGIN TRANSACTION",4,"BEGIN TRANsaction [<transaction_name>]")
  2130. INSERT INTO helpsql VALUES("COMMIT TRANSACTION",1,"COMMIT TRANSACTION Statement")
  2131. INSERT INTO helpsql VALUES("COMMIT TRANSACTION",2,"Marks the end of a user-defined transaction.")
  2132. INSERT INTO helpsql VALUES("COMMIT TRANSACTION",3," ")
  2133. INSERT INTO helpsql VALUES("COMMIT TRANSACTION",4,"COMMIT TRANsaction [<transaction_name>]")
  2134. INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",1,"ROLLBACK TRANSACTION Statement")
  2135. INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",2,"Rolls back a user-specified transaction to the last savepoint inside a ")
  2136. INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",3,"transaction or to the beginning of a transaction.")
  2137. INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",4," ")
  2138. INSERT INTO helpsql VALUES("ROLLBACK TRANSACTION",5,"ROLLBACK TRANsaction [<transaction_name> | <savepoint_name>]")
  2139. INSERT INTO helpsql VALUES("SAVE TRANSACTION",1,"SAVE TRANSACTION Statement")
  2140. INSERT INTO helpsql VALUES("SAVE TRANSACTION",2,"Sets a savepoint within a transaction.")
  2141. INSERT INTO helpsql VALUES("SAVE TRANSACTION",3," ")
  2142. INSERT INTO helpsql VALUES("SAVE TRANSACTION",4,"SAVE TRANsaction <savepoint_name>")
  2143. INSERT INTO helpsql VALUES("TRUNCATE TABLE",1,"TRUNCATE TABLE Statement")
  2144. INSERT INTO helpsql VALUES("TRUNCATE TABLE",2,"Removes all rows from a table without logging the individual row ")
  2145. INSERT INTO helpsql VALUES("TRUNCATE TABLE",3,"deletes. This allows TRUNCATE TABLE to be efficient and quick, but ")
  2146. INSERT INTO helpsql VALUES("TRUNCATE TABLE",4,"unrecoverable.")
  2147. INSERT INTO helpsql VALUES("TRUNCATE TABLE",5," ")
  2148. INSERT INTO helpsql VALUES("TRUNCATE TABLE",6,"TRUNCATE TABLE [[<database>.]<owner>.]<table_name>")
  2149. INSERT INTO helpsql VALUES("UNION",1,"UNION Operator")
  2150. INSERT INTO helpsql VALUES("UNION",2,"Combines the results of two or more queries into a single results set ")
  2151. INSERT INTO helpsql VALUES("UNION",3,"consisting of all the rows belonging to any subset of the queries or to ")
  2152. INSERT INTO helpsql VALUES("UNION",4,"all queries in the union.")
  2153. INSERT INTO helpsql VALUES("UNION",5," ")
  2154. INSERT INTO helpsql VALUES("UNION",6,"SELECT <select_list> ")
  2155. INSERT INTO helpsql VALUES("UNION",7,"     [<INTO clause>] ")
  2156. INSERT INTO helpsql VALUES("UNION",8,"     [<FROM clause>] ")
  2157. INSERT INTO helpsql VALUES("UNION",9,"     [<WHERE clause>] ")
  2158. INSERT INTO helpsql VALUES("UNION",10,"     [<GROUP BY clause>] ")
  2159. INSERT INTO helpsql VALUES("UNION",11,"     [<HAVING clause>] ")
  2160. INSERT INTO helpsql VALUES("UNION",12,"[UNION [ALL] ")
  2161. INSERT INTO helpsql VALUES("UNION",13,"SELECT <select_list> ")
  2162. INSERT INTO helpsql VALUES("UNION",14,"     [<FROM clause>] ")
  2163. INSERT INTO helpsql VALUES("UNION",15,"     [<WHERE clause>] ")
  2164. INSERT INTO helpsql VALUES("UNION",16,"     [<GROUP BY clause>] ")
  2165. INSERT INTO helpsql VALUES("UNION",17,"     [<HAVING clause>]...] ")
  2166. INSERT INTO helpsql VALUES("UNION",18,"[<ORDER BY clause>] ")
  2167. INSERT INTO helpsql VALUES("UNION",19,"[<COMPUTE clause>]")
  2168. go
  2169. DUMP TRANSACTION master WITH NO_LOG
  2170. go
  2171. INSERT INTO helpsql VALUES("UPDATE",1,"UPDATE Statement")
  2172. INSERT INTO helpsql VALUES("UPDATE",2,"Changes data in existing rows, either by adding new data or by modifying ")
  2173. INSERT INTO helpsql VALUES("UPDATE",3,"existing data.")
  2174. INSERT INTO helpsql VALUES("UPDATE",4," ")
  2175. INSERT INTO helpsql VALUES("UPDATE",5,"UPDATE {<table_name> | <view_name>} ")
  2176. INSERT INTO helpsql VALUES("UPDATE",6,"SET [{<table_name> | <view_name>}] ")
  2177. INSERT INTO helpsql VALUES("UPDATE",7,"     {<column_list> ")
  2178. INSERT INTO helpsql VALUES("UPDATE",8,"     | <variable_list>")
  2179. INSERT INTO helpsql VALUES("UPDATE",9,"     | <variable_and_column_list>}")
  2180. INSERT INTO helpsql VALUES("UPDATE",10,"          [, {<column_list2> ")
  2181. INSERT INTO helpsql VALUES("UPDATE",11,"               | <variable_list2>")
  2182. INSERT INTO helpsql VALUES("UPDATE",12,"               | <variable_and_column_list2>}")
  2183. INSERT INTO helpsql VALUES("UPDATE",13,"               ...     [, {<column_listN> ")
  2184. INSERT INTO helpsql VALUES("UPDATE",14,"                         | <variable_listN>")
  2185. INSERT INTO helpsql VALUES("UPDATE",15,"                         | <variable_and_column_listN>}]]")
  2186. INSERT INTO helpsql VALUES("UPDATE",16,"[WHERE clause]")
  2187. INSERT INTO helpsql VALUES("UPDATE",17," ")
  2188. INSERT INTO helpsql VALUES("UPDATE",18,"Transact-SQL extension syntax:")
  2189. INSERT INTO helpsql VALUES("UPDATE",19,"UPDATE {<table_name> | <view_name>}")
  2190. INSERT INTO helpsql VALUES("UPDATE",20,"SET [{<table_name> | <view_name>}] ")
  2191. INSERT INTO helpsql VALUES("UPDATE",21,"     {<column_list> ")
  2192. INSERT INTO helpsql VALUES("UPDATE",22,"     | <variable_list>")
  2193. INSERT INTO helpsql VALUES("UPDATE",23,"     | <variable_and_column_list>}")
  2194. INSERT INTO helpsql VALUES("UPDATE",24,"          [, {<column_list2> ")
  2195. INSERT INTO helpsql VALUES("UPDATE",25,"               | <variable_list2>")
  2196. INSERT INTO helpsql VALUES("UPDATE",26,"               | <variable_and_column_list2>}")
  2197. INSERT INTO helpsql VALUES("UPDATE",27,"               ...     [, {<column_listN> ")
  2198. INSERT INTO helpsql VALUES("UPDATE",28,"                         | <variable_listN>")
  2199. INSERT INTO helpsql VALUES("UPDATE",29,"                         | <variable_and_column_listN>}]]")
  2200. INSERT INTO helpsql VALUES("UPDATE",30,"[FROM {<table_name> | <view_name>}")
  2201. INSERT INTO helpsql VALUES("UPDATE",31,"     [, {<table_name> | <view_name>}]...]")
  2202. INSERT INTO helpsql VALUES("UPDATE",32,"          [..., {<table_name16> | <view_name16>}]] ")
  2203. INSERT INTO helpsql VALUES("UPDATE",33,"[<WHERE clause>]")
  2204. INSERT INTO helpsql VALUES("UPDATE",34," ")
  2205. INSERT INTO helpsql VALUES("UPDATE",35,"where")
  2206. INSERT INTO helpsql VALUES("UPDATE",36," ")
  2207. INSERT INTO helpsql VALUES("UPDATE",37,"<table_name> | <view_name> = ")
  2208. INSERT INTO helpsql VALUES("UPDATE",38,"     [[<database_name>.]<owner>.]{<table_name> | <view_name>}")
  2209. INSERT INTO helpsql VALUES("UPDATE",39," ")
  2210. INSERT INTO helpsql VALUES("UPDATE",40,"<column_list> = ")
  2211. INSERT INTO helpsql VALUES("UPDATE",41,"     <column_name> = {<expression> | DEFAULT | NULL}")
  2212. INSERT INTO helpsql VALUES("UPDATE",42," ")
  2213. INSERT INTO helpsql VALUES("UPDATE",43,"<variable_list> = ")
  2214. INSERT INTO helpsql VALUES("UPDATE",44,"     <variable_name> = {<expression> | NULL}")
  2215. INSERT INTO helpsql VALUES("UPDATE",45," ")
  2216. INSERT INTO helpsql VALUES("UPDATE",46,"<variable_and_column_list> = ")
  2217. INSERT INTO helpsql VALUES("UPDATE",47,"     <variable_name> = <column_name> = {<expression> | NULL}")
  2218. INSERT INTO helpsql VALUES("UPDATE",48," ")
  2219. INSERT INTO helpsql VALUES("UPDATE",49,"WHERE clause = ")
  2220. INSERT INTO helpsql VALUES("UPDATE",50,"     WHERE {<search_conditions> | CURRENT OF <cursor_name>}")
  2221. INSERT INTO helpsql VALUES("UPDATE STATISTICS",1,"UPDATE STATISTICS Statement")
  2222. INSERT INTO helpsql VALUES("UPDATE STATISTICS",2,"Updates information about the distribution of key values in specified ")
  2223. INSERT INTO helpsql VALUES("UPDATE STATISTICS",3,"indexes.")
  2224. INSERT INTO helpsql VALUES("UPDATE STATISTICS",4," ")
  2225. INSERT INTO helpsql VALUES("UPDATE STATISTICS",5,"UPDATE STATISTICS [[<database>.]<owner>.]<table_name> [<index_name>]")
  2226. go
  2227. DUMP TRANSACTION master WITH NO_LOG
  2228. go
  2229. INSERT INTO helpsql VALUES("USE",1,"USE Statement")
  2230. INSERT INTO helpsql VALUES("USE",2,"Changes the database context.")
  2231. INSERT INTO helpsql VALUES("USE",3," ")
  2232. INSERT INTO helpsql VALUES("USE",4,"USE <database_name>")
  2233. INSERT INTO helpsql VALUES("VARIABLES",1,"Variables")
  2234. INSERT INTO helpsql VALUES("VARIABLES",2,"Local variables are declared in the body of a batch or procedure with ")
  2235. INSERT INTO helpsql VALUES("VARIABLES",3,"the DECLARE statement and given values with a SELECT statement. Local ")
  2236. INSERT INTO helpsql VALUES("VARIABLES",4,"variables are often used in a batch or procedure as counters for WHILE ")
  2237. INSERT INTO helpsql VALUES("VARIABLES",5,"loops or for IF...ELSE blocks.")
  2238. INSERT INTO helpsql VALUES("VARIABLES",6," ")
  2239. INSERT INTO helpsql VALUES("VARIABLES",7,"Variable declaration:")
  2240. INSERT INTO helpsql VALUES("VARIABLES",8,"     DECLARE @<variable_name> <datatype> ")
  2241. INSERT INTO helpsql VALUES("VARIABLES",9,"          [, @<variable_name> <datatype>...]")
  2242. INSERT INTO helpsql VALUES("VARIABLES",10,"Variable assignment:")
  2243. INSERT INTO helpsql VALUES("VARIABLES",11,"     SELECT @<variable> = {<expression> | <select_statement>} ")
  2244. INSERT INTO helpsql VALUES("VARIABLES",12,"          [, @<variable> = {<expression> | <select_statement>}...] ")
  2245. INSERT INTO helpsql VALUES("VARIABLES",13,"     [FROM <table_list>] ")
  2246. INSERT INTO helpsql VALUES("VARIABLES",14,"     [WHERE <search_conditions>]")
  2247. INSERT INTO helpsql VALUES("VARIABLES",15,"     [GROUP BY clause]")
  2248. INSERT INTO helpsql VALUES("VARIABLES",16,"     [HAVING clause]")
  2249. INSERT INTO helpsql VALUES("VARIABLES",17,"     [ORDER BY clause] ")
  2250. INSERT INTO helpsql VALUES("WILDCARDS",1,"Wildcard Characters")
  2251. INSERT INTO helpsql VALUES("WILDCARDS",2,"Wildcard characters are used with the LIKE keyword to represent any ")
  2252. INSERT INTO helpsql VALUES("WILDCARDS",3,"character in a string when searching for a char, varchar, or datetime ")
  2253. INSERT INTO helpsql VALUES("WILDCARDS",4,"value.")
  2254. INSERT INTO helpsql VALUES("WILDCARDS",5," ")
  2255. INSERT INTO helpsql VALUES("WILDCARDS",6,"<expression> [NOT] LIKE '<string>'")
  2256. INSERT INTO helpsql VALUES("WILDCARDS",7," ")
  2257. INSERT INTO helpsql VALUES("WILDCARDS",8,"The string can include these wildcard characters:")
  2258. INSERT INTO helpsql VALUES("WILDCARDS",9,"%                Any string of zero or more characters")
  2259. INSERT INTO helpsql VALUES("WILDCARDS",10,"_ (underscore)   Any single character")
  2260. INSERT INTO helpsql VALUES("WILDCARDS",11,"[ ]              Any single character within the specified range ")
  2261. INSERT INTO helpsql VALUES("WILDCARDS",12,"                  ([a-f]) or set ([abcdef])")
  2262. INSERT INTO helpsql VALUES("WILDCARDS",13,"[^]              Any single character not within the specified range ")
  2263. INSERT INTO helpsql VALUES("WILDCARDS",14,"                  ([^a-f]) or set ([^abcdef])")
  2264. go
  2265. DUMP TRANSACTION master WITH NO_LOG
  2266. go
  2267. GRANT EXECUTE ON sp_helpsql TO public
  2268. GRANT SELECT ON  helpsql TO public
  2269. go
  2270.  
  2271. /*
  2272. PRINT ''
  2273. PRINT 'Checking objects created by helpsql.sql.'
  2274.  
  2275. EXEC sp_check_objects 'help'            
  2276. */
  2277.  
  2278. PRINT ''
  2279. PRINT 'Running of helpsql.sql completed.'
  2280. go
  2281.  
  2282. DUMP TRANSACTION master WITH NO_LOG
  2283. go
  2284. CHECKPOINT
  2285. go
  2286. -- -
  2287.