Transact-SQL Reference for SQL 2000

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




Comments ( )
<00>  <01>  <02>  <03>  <04>  <05>  <06>  <07>  <08>  <09>  <10>  <11>  <12>  <13>  <14>  <15>  <16>  <17>  <18>  <19
Link to this page: http://www.vb-net.com/Arenda-Support/index.htm
<SITEMAP>  <MVC>  <ASP>  <NET>  <DATA>  <KIOSK>  <FLEX>  <SQL>  <NOTES>  <LINUX>  <MONO>  <FREEWARE>  <DOCS>  <ENG>  <MAIL ME>  <ABOUT ME>  < THANKS ME>