Transact-SQL Reference for SQL 2000

	New and Enhanced Features in Transact-SQL
1	APP_NAME
2	ABS
3	ALL
4	AND
5	ANY
6	AVG
7	ALTER VIEW
8	ALTER TABLE
9	ALTER DATABASE
10	ACOS
11	ASIN
12	ATAN
13	ATN2
14	ASCII
15	ALTER PROCEDURE
16	ALTER TRIGGER
17	ALTER FUNCTION
18	BREAK
19	BINARY_CHECKSUM
20	bit
21	BACKUP
22	BULK INSERT
23	binary and varbinary
24	BETWEEN
25	BEGIN TRANSACTION
26	BEGIN DISTRIBUTED TRANSACTION
27	BEGIN...END
28	CONTINUE
29	COLUMNPROPERTY
30	Control-of-Flow Language
31	COUNT_BIG
32	Constants
33	CHECKPOINT
34	COL_LENGTH
35	Windows Collation Name
36	CAST and CONVERT
37	COS
38	COT
39	CONTAINS
40	CHARINDEX
41	CONTAINSTABLE
42	CHECKSUM_AGG
43	COMMIT WORK
44	COUNT
45	SQL Collation Name
46	CASE
47	COLLATIONPROPERTY
48	COLLATE
49	CLOSE
50	CHAR
51	CEILING
52	COL_NAME
53	char and varchar
54	COMMIT TRANSACTION
55	COALESCE
56	CHECKSUM
57	CURSOR_STATUS
58	cursor
59	CURRENT_USER
60	CURRENT_TIMESTAMP
61	Cursors
62	CREATE DATABASE
63	CREATE DEFAULT
64	CREATE PROCEDURE
65	CREATE INDEX
66	CREATE FUNCTION
67	CREATE STATISTICS
68	CREATE RULE
69	CREATE VIEW
70	CREATE TRIGGER
71	CREATE TABLE
72	CREATE SCHEMA
73	DATABASEPROPERTYEX
74	DATENAME
75	Data Type Precedence
76	DATEPART
77	DAY
78	DATEADD
79	DATALENGTH
80	DATEDIFF
81	DB_NAME
82	Data Types
83	Collation Precedence
84	Data Type Synonyms
85	Precision, Scale, and Length
86	DATABASEPROPERTY
87	DB_ID
88	datetime and smalldatetime
89	DBCC CHECKDB
90	DBCC CONCURRENCYVIOLATION
91	DBCC NEWALLOC
92	DBCC
93	DBCC CHECKCONSTRAINTS
94	DBCC UPDATEUSAGE
95	DBCC PINTABLE
96	DBCC dllname (FREE)
97	DBCC INDEXDEFRAG
98	DBCC SHRINKDATABASE
99	DBCC TRACEOFF
100	DBCC CHECKTABLE
101	DBCC TRACESTATUS
102	DBCC SHOWCONTIG
103	DBCC CLEANTABLE
104	DBCC CHECKALLOC
105	DBCC OUTPUTBUFFER
106	DBCC USEROPTIONS
107	DBCC ROWLOCK
108	DBCC CHECKCATALOG
109	DBCC DROPCLEANBUFFERS
110	DBCC OPENTRAN
111	DBCC UNPINTABLE
112	DBCC CHECKIDENT
113	DBCC CHECKFILEGROUP
114	DBCC SQLPERF
115	DBCC PROCCACHE
116	DBCC SHOW_STATISTICS
117	DBCC FREEPROCCACHE
118	DBCC TRACEON
119	DBCC SHRINKFILE
120	DBCC HELP
121	DBCC INPUTBUFFER
122	DBCC DBREPAIR
123	DBCC DBREINDEX
124	DENY
125	DROP PROCEDURE
126	DECLARE CURSOR
127	decimal and numeric
128	DROP RULE
129	DUMP
130	DROP VIEW
131	DROP DEFAULT
132	DROP INDEX
133	DROP FUNCTION
134	DECLARE @local_variable
135	DROP STATISTICS
136	DROP TABLE
137	DEALLOCATE
138	DROP DATABASE
139	DIFFERENCE
140	DEGREES
141	DROP TRIGGER
142	DELETE
143	EXECUTE
144	EXISTS
145	ELSE (IF...ELSE)
146	EXP
147	Expressions
148	END (BEGIN...END)
149	fn_trace_getinfo
150	Text and Image Functions
151	fn_trace_gettable
152	fn_helpcollations
153	FORMATMESSAGE
154	FILEGROUP_NAME
155	Cursor Functions
156	FREETEXTTABLE
157	Mathematical Functions
158	Date and Time Functions
159	FREETEXT
160	FILE_ID
161	FILEGROUP_ID
162	FULLTEXTSERVICEPROPERTY
163	FROM
164	Configuration Functions
165	fn_virtualfilestats
166	Rowset Functions
167	fn_trace_geteventinfo
168	fn_servershareddrives
169	FLOOR
170	float and real
171	FILE_NAME
172	fn_trace_getfilterinfo
173	System Functions
174	fn_listextendedproperty
175	String Functions
176	fn_virtualservernodes
177	FULLTEXTCATALOGPROPERTY
178	FILEPROPERTY
179	System Statistical Functions
180	FETCH
181	Meta Data Functions
182	FILEGROUPPROPERTY
183	Functions
184	Security Functions
185	Aggregate Functions
186	GROUPING
187	GETANSINULL
188	GETUTCDATE
189	GETDATE
190	GROUP BY
191	GOTO
192	GO
193	GRANT
194	@@CONNECTIONS
195	@@REMSERVER
196	@@TIMETICKS
197	@@FETCH_STATUS
198	@@PROCID
199	@@SPID
200	@@ROWCOUNT
201	@@PACK_SENT
202	@@TEXTSIZE
203	@@TOTAL_WRITE
204	@@CURSOR_ROWS
205	@@NESTLEVEL
206	@@DATEFIRST
207	@@TOTAL_READ
208	@@IDLE
209	@@IDENTITY
210	@@OPTIONS
211	@@SERVICENAME
212	@@PACK_RECEIVED
213	@@VERSION
214	@@SERVERNAME
215	@@DBTS
216	@@CPU_BUSY
217	@@MAX_PRECISION
218	@@LANGID
219	@@TOTAL_ERRORS
220	@@TRANCOUNT
221	@@LANGUAGE
222	@@PACKET_ERRORS
223	@@ERROR
224	@@LOCK_TIMEOUT
225	@@MAX_CONNECTIONS
226	@@IO_BUSY
227	HOST_NAME
228	HOST_ID
229	HAVING
230	HAS_DBACCESS
231	COLUMN_DOMAIN_USAGE
232	TABLE_PRIVILEGES
233	DOMAINS
234	TABLE_CONSTRAINTS
235	CONSTRAINT_TABLE_USAGE
236	VIEW_TABLE_USAGE
237	INDEXPROPERTY
238	IDENTITY (Property)
239	ROUTINES
240	int, bigint, smallint, and tinyint
241	INDEX_COL
242	IS_SRVROLEMEMBER
243	VIEWS
244	CONSTRAINT_COLUMN_USAGE
245	IDENT_INCR
246	Information Schema Views
247	TABLES
248	INSERT
249	SCHEMATA
250	IDENTITY (Function)
251	REFERENTIAL_CONSTRAINTS
252	ISNULL
253	KEY_COLUMN_USAGE
254	CHECK_CONSTRAINTS
255	ISNUMERIC
256	IF...ELSE
257	DOMAIN_CONSTRAINTS
258	PARAMETERS
259	IDENT_CURRENT
260	COLUMNS
261	INDEXKEY_PROPERTY
262	IN
263	ROUTINE_COLUMNS
264	ISDATE
265	COLUMN_PRIVILEGES
266	IS_MEMBER
267	IS [NOT] NULL
268	VIEW_COLUMN_USAGE
269	IDENT_SEED
270	KILL
271	LOG10
272	LIKE
273	LOWER
274	LEN
275	LOG
276	LOAD
277	LTRIM
278	LEFT
279	MONTH
280	MAX
281	MIN
282	money and smallmoney
283	MSmerge_history
284	MSlogreader_agents
285	MSmerge_genhistory
286	MSmerge_delete_conflicts
287	MSdynamicsnapshotjobs
288	MSdistribution_agents
289	MSrepl_backup_lsns
290	MSreplication_options
291	MSdistributiondbs
292	MSlogreader_history
293	MSsubscriptions
294	MSsnapshot_history
295	MSsubscription_articles
296	MSsubscriber_info
297	MSdistributor
298	restorefilegroup
299	MSmerge_errorlineage
300	MSdistpublishers
301	MSrepl_version
302	MSsubscriber_schedule
303	MSagent_parameters
304	MSreplication_objects
305	MSreplication_subscriptions
306	MSdynamicsnapshotviews
307	MSqreader_history
308	MSrepl_errors
309	MSmerge_altsyncpartners
310	MSpublication_access
311	MSpub_identity_range
312	MSsubscription_properties
313	MSmerge_agents
314	MSsnapshot_agents
315	restorefile
316	MSmerge_replinfo
317	MSrepl_commands
318	MSrepl_originators
319	MSrepl_transactions
320	restorehistory
321	MSpublisher_databases
322	MSsync_states
323	MSmerge_subscriptions
324	MSrepl_identity_range
325	MSarticles
326	MSdistribution_history
327	MSmerge_tombstone
328	MSmerge_contents
329	MSqreader_agents
330	MSreplication_queue
331	Mssub_identity_range
332	MSsubscription_agents
333	MSpublications
334	MSagent_profiles
335	NCHAR
336	NEWID
337	nchar and nvarchar
338	Products
339	Northwind Sample Database
340	Suppliers
341	Order Details
342	Orders
343	Territories
344	CustomerDemographics
345	Shippers
346	Categories
347	Employees
348	EmployeeTerritories
349	Region
350	CustomerCustomerDemo
351	Customers
352	ntext, text, and image
353	NOT
354	NULLIF
355	OPEN
356	OBJECT_ID
357	OBJECT_NAME
358	OPENDATASOURCE
359	Operators
360	OPENXML
361	OPENQUERY
362	OBJECTPROPERTY
363	OPENROWSET
364	ORDER BY
365	OR
366	- (Negative)
367	=(Equals)
368	+ (Positive)
369	> (Greater Than)
370	<=(Less Than or Equal To)
371	* (Multiply)
372	+ (Add)
373	| (Bitwise OR)
374	[ ] (Wildcard - Character(s) to Match)
375	+ (String Concatenation)
376	>=(Greater Than or Equal To)
377	!=(Not Equal To)
378	< (Less Than)
379	% (Modulo)
380	!> (Not Greater Than)
381	!< (Not Less Than)
382	^ (Bitwise Exclusive OR)
383	~ (Bitwise NOT)
384	- (Subtract)
385	-- (Comment)
386	& (Bitwise AND)
387	/ (Divide)
388	/*...*/ (Comment)
389	_ (Wildcard - Match One Character)
390	<> (Not Equal To)
391	% (Wildcard - Character(s) to Match)
392	[^] (Wildcard - Character(s) Not to Match)
393	POWER
394	PATINDEX
395	PRINT
396	PERMISSIONS
397	PI
398	PARSENAME
399	Predicate
400	pub_info
401	authors
402	titles
403	pubs Sample Database
404	jobs
405	titleauthor
406	sales
407	roysched
408	discounts
409	publishers
410	employee
411	stores
412	QUOTENAME
413	RETURN
414	ROWCOUNT_BIG
415	RAND
416	ROLLBACK WORK
417	RESTORE
418	RESTORE VERIFYONLY
419	REVOKE
420	RESTORE FILELISTONLY
421	RIGHT
422	ROLLBACK TRANSACTION
423	RECONFIGURE
424	RAISERROR
425	RESTORE HEADERONLY
426	RESTORE LABELONLY
427	REVERSE
428	RTRIM
429	REPLACE
430	REPLICATE
431	ROUND
432	RADIANS
433	Reserved Keywords
434	READTEXT
435	ORDER BY Clause
436	Search Condition
437	SELECT Examples
438	SAVE TRANSACTION
439	SESSION_USER
440	OPTION Clause
441	SELECT Clause
442	SELECT Clause
443	SERVERPROPERTY
444	HAVING Clause
445	FROM Clause
446	FOR Clause
447	UNION Operator
448	SESSIONPROPERTY
449	COMPUTE Clause
450	SCOPE_IDENTITY
451	WHERE Clause
452	WHERE Clause
453	SELECT @local_variable
454	SELECT
455	SET DATEFORMAT
456	SET ROWCOUNT
457	SET TEXTSIZE
458	SET STATISTICS IO
459	SET XACT_ABORT
460	SET @local_variable
461	SET STATISTICS TIME
462	SET QUERY_GOVERNOR_COST_LIMIT
463	SET ANSI_DEFAULTS
464	SET LOCK_TIMEOUT
465	SET REMOTE_PROC_TRANSACTIONS
466	SET CONTEXT_INFO
467	SET FMTONLY
468	SET ANSI_PADDING
469	SET CONCAT_NULL_YIELDS_NULL
470	SET SHOWPLAN_ALL
471	SET NOCOUNT
472	SET
473	SET OFFSETS
474	SET STATISTICS PROFILE
475	SET PARSEONLY
476	SET CURSOR_CLOSE_ON_COMMIT
477	SET DATEFIRST
478	SET NOEXEC
479	SET ARITHABORT
480	SET ANSI_WARNINGS
481	SET ANSI_NULL_DFLT_OFF
482	SET LANGUAGE
483	SET TRANSACTION ISOLATION LEVEL
484	SET ANSI_NULL_DFLT_ON
485	SET DISABLE_DEF_CNST_CHK
486	SET ARITHIGNORE
487	SET IMPLICIT_TRANSACTIONS
488	SET IDENTITY_INSERT
489	SET FIPS_FLAGGER
490	SET FORCEPLAN
491	SET DEADLOCK_PRIORITY
492	SET SHOWPLAN_TEXT
493	SET NUMERIC_ROUNDABORT
494	SET QUOTED_IDENTIFIER
495	SET ANSI_NULLS
496	SUSER_ID
497	SOME | ANY
498	SUSER_SID
499	SPACE
500	SOUNDEX
501	SIN
502	STR
503	SUM
504	STATS_DATE
505	SETUSER
506	sql_variant
507	SQL_VARIANT_PROPERTY
508	SQUARE
509	STDEV
510	SUBSTRING
511	STUFF
512	SIGN
513	SQRT
514	SUSER_SNAME
515	SUSER_NAME
516	STDEVP
517	SHUTDOWN
518	Object Hierarchy Syntax
519	System Stored Procedures
520	sp_addgroup
521	sp_add_log_shipping_secondary
522	sp_addlogin
523	sp_add_log_shipping_plan_database
524	sp_add_notification
525	sp_add_maintenance_plan
526	sp_add_operator
527	sp_addextendedproperty
528	sp_add_data_file_recover_suspect_db
529	sp_add_log_shipping_primary
530	sp_add_job
531	sp_add_maintenance_plan_db
532	sp_add_category
533	sp_addlinkedsrvlogin
534	sp_add_jobschedule
535	sp_addextendedproc
536	sp_addapprole
537	sp_add_log_shipping_database
538	sp_add_alert
539	sp_add_log_shipping_plan
540	sp_addlinkedserver
541	sp_addalias
542	sp_addmessage
543	sp_add_maintenance_plan_job
544	sp_add_log_file_recover_suspect_db
545	sp_add_jobstep
546	sp_add_jobserver
547	sp_adduser
548	sp_addsrvrolemember
549	sp_addremotelogin
550	sp_addserver
551	sp_addrole
552	sp_addtask
553	sp_add_targetsvrgrp_member
554	sp_addumpdevice
555	sp_add_targetservergroup
556	sp_addrolemember
557	sp_addtype
558	sp_apply_job_to_targets
559	sp_autostats
560	sp_approlepassword
561	sp_attach_single_file_db
562	sp_attach_db
563	sp_altermessage
564	sp_bindrule
565	sp_bindefault
566	sp_bindsession
567	sp_configure
568	sp_change_primary_role
569	sp_changeobjectowner
570	sp_create_removable
571	sp_change_secondary_role
572	sp_catalogs
573	sp_changedbowner
574	sp_column_privileges_ex
575	sp_changegroup
576	sp_create_log_shipping_monitor_account
577	sp_columns
578	sp_createstats
579	sp_cycle_errorlog
580	sp_change_monitor_role
581	sp_can_tlog_be_applied
582	sp_cursor_list
583	sp_column_privileges
584	sp_change_users_login
585	sp_columns_ex
586	sp_certify_removable
587	sp_databases
588	sp_delete_log_shipping_primary
589	sp_delete_log_shipping_database
590	sp_delete_backuphistory
591	sp_describe_cursor_tables
592	sp_describe_cursor_columns
593	sp_defaultlanguage
594	sp_describe_cursor
595	sp_delete_targetserver
596	sp_delete_log_shipping_plan_database
597	sp_delete_job
598	sp_define_log_shipping_monitor
599	sp_delete_jobschedule
600	sp_dbcmptlevel
601	sp_delete_maintenance_plan_db
602	sp_delete_maintenance_plan_job
603	sp_datatype_info
604	sp_delete_jobserver
605	sp_delete_log_shipping_monitor_info
606	sp_dbremove
607	sp_delete_operator
608	sp_delete_maintenance_plan
609	sp_delete_log_shipping_secondary
610	sp_delete_log_shipping_plan
611	sp_detach_db
612	sp_dboption
613	sp_delete_alert
614	sp_delete_targetsvrgrp_member
615	sp_defaultdb
616	sp_delete_notification
617	sp_denylogin
618	sp_dbfixedrolepermission
619	sp_depends
620	sp_delete_jobstep
621	sp_delete_targetservergroup
622	sp_delete_category
623	sp_dropextendedproperty
624	sp_dropdevice
625	sp_dropalias
626	sp_dropremotelogin
627	sp_dropgroup
628	sp_droplogin
629	sp_droprolemember
630	sp_dropuser
631	sp_droplinkedsrvlogin
632	sp_dropsrvrolemember
633	sp_dropextendedproc
634	sp_dropapprole
635	sp_droprole
636	sp_droptask
637	sp_dropmessage
638	sp_dropserver
639	sp_droptype
640	sp_dropwebtask
641	sp_enumcodepages
642	sp_executesql
643	sp_fulltext_catalog
644	sp_fulltext_database
645	sp_fkeys
646	sp_fulltext_service
647	sp_foreignkeys
648	sp_fulltext_column
649	sp_fulltext_table
650	sp_grantdbaccess
651	sp_getbindtoken
652	sp_get_log_shipping_monitor_info
653	sp_getapplock
654	sp_grantlogin
655	sp_helpsrvrolemember
656	sp_helpserver
657	sp_helpsrvrole
658	sp_help_fulltext_tables_cursor
659	sp_helpdevice
660	sp_help_downloadlist
661	sp_helpremotelogin
662	sp_help_fulltext_catalogs
663	sp_helprotect
664	sp_help_jobschedule
665	sp_help_fulltext_tables
666	sp_helpextendedproc
667	sp_help_jobhistory
668	sp_helplanguage
669	sp_helpsort
670	sp_help_maintenance_plan
671	sp_helpindex
672	sp_help
673	sp_help_category
674	sp_helpdb
675	sp_help_targetserver
676	sp_help_jobserver
677	sp_helpuser
678	sp_helpfilegroup
679	sp_help_fulltext_catalogs_cursor
680	sp_helplogins
681	sp_helptrigger
682	sp_helpntgroup
683	sp_helpdbfixedrole
684	sp_help_targetservergroup
685	sp_helpstats
686	sp_help_alert
687	sp_help_fulltext_columns
688	sp_helphistory
689	sp_helprole
690	sp_helptask
691	sp_helpgroup
692	sp_helptext
693	sp_help_notification
694	sp_help_jobstep
695	sp_help_fulltext_columns_cursor
696	sp_helprolemember
697	sp_helplinkedsrvlogin
698	sp_helpfile
699	sp_helpconstraint
700	sp_help_job
701	sp_help_operator
702	sp_invalidate_textptr
703	sp_indexoption
704	sp_indexes
705	sp_linkedservers
706	sp_lock
707	sp_MShasdbaccess
708	sp_makewebtask
709	sp_manage_jobs_by_login
710	sp_msx_defect
711	sp_monitor
712	sp_msx_enlist
713	sp_OASetProperty
714	sp_OAGetProperty
715	sp_OAStop
716	sp_OAGetErrorInfo
717	sp_OADestroy
718	sp_OACreate
719	sp_OAMethod
720	sp_post_msx_operation
721	sp_purgehistory
722	sp_processmail
723	sp_pkeys
724	sp_purge_jobhistory
725	sp_password
726	sp_primarykeys
727	sp_procoption
728	sp_remove_log_shipping_monitor
729	sp_reassigntask
730	sp_revokelogin
731	sp_revokedbaccess
732	sp_resolve_logins
733	sp_rename
734	sp_renamedb
735	sp_runwebtask
736	sp_remove_job_from_targets
737	sp_recompile
738	sp_resync_targetserver
739	sp_remoteoption
740	sp_refreshview
741	sp_resetstatus
742	sp_releaseapplock
743	sp_attachsubscription
744	sp_addtabletocontents
745	sp_add_agent_parameter
746	sp_addmergepublication
747	sp_addmergearticle
748	sp_articlesynctranprocs
749	sp_changesubscriptiondtsinfo
750	sp_change_subscription_properties
751	sp_changedistributor_property
752	sp_changepublication
753	sp_browsesnapshotfolder
754	sp_addarticle
755	sp_adddistpublisher
756	sp_addmergepullsubscription
757	sp_addpublisher70
758	sp_addpullsubscription_agent
759	sp_addmergefilter
760	sp_addmergesubscription
761	sp_addmergepullsubscription_agent
762	sp_changemergepullsubscription
763	sp_adjustpublisheridentityrange
764	sp_changemergesubscription
765	sp_adddistributiondb
766	sp_addsubscriber_schedule
767	sp_addsubscription
768	sp_articlecolumn
769	sp_adddistributor
770	sp_changesubscriber
771	sp_addpublication
772	sp_changearticle
773	sp_articleview
774	sp_changedistributor_password
775	sp_addsynctriggers
776	sp_changedistpublisher
777	sp_change_agent_profile
778	sp_addsubscriber
779	sp_addmergealternatepublisher
780	sp_addscriptexec
781	sp_add_agent_profile
782	sp_changemergearticle
783	sp_changedistributiondb
784	sp_browsereplcmds
785	sp_addpublication_snapshot
786	sp_changesubscriber_schedule
787	sp_browsemergesnapshotfolder
788	sp_article_validation
789	sp_articlefilter
790	sp_change_agent_parameter
791	sp_changemergefilter
792	sp_changesubstatus
793	sp_changemergepublication
794	sp_addpullsubscription
795	Replication Stored Procedures
796	sp_grant_publication_access
797	sp_check_for_sync_trigger
798	sp_help_agent_default
799	sp_enumfullsubscribers
800	sp_helparticle
801	sp_dropmergearticle
802	sp_helparticlecolumns
803	sp_help_publication_access
804	sp_droparticle
805	sp_helpdistpublisher
806	sp_helpmergefilter
807	sp_helpmergeconflictrows
808	sp_copymergesnapshot
809	sp_getqueuedrows
810	sp_dropmergefilter
811	sp_dropmergesubscription
812	sp_disableagentoffload
813	sp_helpmergepullsubscription
814	sp_helpdistributiondb
815	sp_getmergedeletetype
816	sp_dropmergepullsubscription
817	sp_dumpparamcmd
818	sp_copysubscription
819	sp_dropsubscription
820	sp_get_distributor
821	sp_helpmergealternatepublisher
822	sp_deletemergeconflictrow
823	sp_enumdsn
824	sp_helpdistributor
825	sp_getagentoffloadinfo
826	sp_help_agent_parameter
827	sp_helppublication
828	sp_helparticledts
829	sp_helpmergedeleteconflictrows
830	sp_helpmergearticleconflicts
831	sp_helpmergepublication
832	sp_drop_agent_profile
833	sp_dropdistributor
834	sp_droppublication
835	sp_dropmergealternatepublisher
836	sp_helpmergearticle
837	sp_getsubscriptiondtspackagename
838	sp_generatefilters
839	sp_drop_agent_parameter
840	sp_enableagentoffload
841	sp_helpmergesubscription
842	sp_dropsubscriber
843	sp_dropmergepublication
844	sp_helpmergearticlecolumn
845	sp_dropdistpublisher
846	sp_dropanonymouseagent
847	sp_expired_subscription_cleanup
848	sp_help_agent_profile
849	sp_copysnapshot
850	sp_dsninfo
851	sp_droppullsubscription
852	sp_dropdistributiondb
853	sp_enumcustomresolvers
854	sp_helpreplicationdboption
855	sp_repladdcolumn
856	sp_replication_agent_checkup
857	sp_reinitpullsubscription
858	sp_repltrans
859	sp_removedbreplication
860	sp_helpsubscription_properties
861	sp_replcmds
862	sp_helpsubscriberinfo
863	sp_helpreplicationoption
864	sp_refreshsubscriptions
865	sp_repldropcolumn
866	sp_publication_validation
867	sp_helppullsubscription
868	sp_replcounters
869	sp_vupgrade_replication
870	sp_revoke_publication_access
871	sp_validatemergesubscription
872	sp_replflush
873	sp_ivindexhasnullcols
874	sp_link_publication
875	sp_mergearticlecolumn
876	sp_update_agent_profile
877	sp_validatemergepublication
878	sp_replqueuemonitor
879	sp_reinitmergepullsubscription
880	sp_reinitmergesubscription
881	sp_restoredbreplication
882	sp_replshowcmds
883	sp_marksubscriptionvalidation
884	sp_script_synctran_commands
885	sp_helpreplfailovermode
886	sp_setreplfailovermode
887	sp_table_validation
888	sp_resyncmergesubscription
889	sp_subscription_cleanup
890	sp_mergecleanupmetadata
891	sp_mergedummyupdate
892	sp_repldone
893	sp_replsetoriginator
894	sp_reinitsubscription
895	sp_helpsubscription
896	sp_mergesubscription_cleanup
897	sp_replicationdboption
898	sp_spaceused
899	sp_start_job
900	sp_special_columns
901	sp_stored_procedures
902	sp_server_info
903	sp_statistics
904	sp_serveroption
905	sp_scriptsubconflicttable
906	sp_srvrolepermission
907	sp_setnetname
908	sp_settriggerorder
909	sp_setapprole
910	sp_stop_job
911	sp_sproc_columns
912	sp_trace_setstatus
913	sp_trace_generateevent
914	sp_trace_setevent
915	sp_tableoption
916	sp_table_privileges
917	sp_tables
918	sp_table_privileges_ex
919	sp_trace_setfilter
920	sp_trace_create
921	sp_tables_ex
922	sp_update_alert
923	sp_updatestats
924	sp_update_log_shipping_plan
925	sp_unbindefault
926	sp_unbindrule
927	sp_validname
928	sp_update_operator
929	sp_validatelogins
930	sp_updatetask
931	sp_update_log_shipping_monitor_info
932	sp_update_jobstep
933	sp_update_notification
934	sp_update_log_shipping_plan_database
935	sp_update_job
936	sp_update_category
937	sp_update_targetservergroup
938	sp_updateextendedproperty
939	sp_update_jobschedule
940	sp_who
941	sp_xml_preparedocument
942	sp_xml_removedocument
943	Transact-SQL Syntax Conventions
944	backupmediaset
945	backupset
946	System Tables
947	backupmediafamily
948	logmarkhistory
949	backupfile
950	sysarticleupdates
951	sysalerts
952	sysarticles
953	sysaltfiles
954	syscategories
955	syscomments
956	syscacheobjects
957	sysconfigures
958	syscurconfigs
959	syscharsets
960	syscolumns
961	sysconstraints
962	sysdevices
963	sysdownloadlist
964	sysdepends
965	sysdbmaintplan_jobs
966	sysdbmaintplans
967	sysdbmaintplan_history
968	sysdatabases
969	sysdbmaintplan_databases
970	sysfilegroups
971	sysforeignkeys
972	sysfulltextcatalogs
973	sysfiles
974	sysindexkeys
975	sysindexes
976	sysjobsteps
977	sysjobs
978	sysjobhistory
979	sysjobservers
980	sysjobschedules
981	syslockinfo
982	syslogins
983	syslanguages
984	sysmergesubsetfilters
985	sysmessages
986	sysmergepublications
987	sysmergesubscriptions
988	sysmergeschemaarticles
989	sysmembers
990	sysmergearticles
991	sysmergeschemachange
992	sysnotifications
993	sysopentapes
994	sysoperators
995	sysobjects
996	sysoledbusers
997	sysprotects
998	sysperfinfo
999	sysprocesses
1000	syspermissions
1001	syspublications
1002	sysremotelogins
1003	sysreferences
1004	sysreplicationalerts
1005	sysschemaarticles
1006	sysschemaarticles
1007	syssubscriptions
1008	systargetservergroupmembers
1009	systypes
1010	systargetservergroups
1011	systargetservers
1012	systaskids
1013	sysusers
1014	SYSTEM_USER
1015	TRIGGER_NESTLEVEL
1016	TRUNCATE TABLE
1017	Transactions
1018	TYPEPROPERTY
1019	TEXTPTR
1020	TAN
1021	TEXTVALID
1022	Trace Flags
1023	timestamp
1024	table
1025	Transact-SQL Overview
1026	UPDATE STATISTICS
1027	USER_NAME
1028	USER_ID
1029	UPPER
1030	UNION
1031	USE
1032	uniqueidentifier
1033	UPDATETEXT
1034	UNICODE
1035	UPDATE
1036	USER
1037	VARP
1038	VAR
1039	WRITETEXT
1040	WHERE
1041	WHILE
1042	WAITFOR
1043	xp_sqlmaint
1044	xp_msver
1045	xp_enumgroups
1046	xp_readmail
1047	xp_cmdshell
1048	xp_findnextmsg
1049	xp_grantlogin
1050	xp_logevent
1051	xp_sendmail
1052	xp_loginconfig
1053	xp_startmail
1054	xp_stopmail
1055	xp_deletemail
1056	xp_revokelogin
1057	xp_sprintf
1058	xp_sscanf
1059	xp_logininfo
1060	YEAR

< THANKS ME>