BISQL # 99 – ‘A to Z’ SQL Command # 1 – List of Command which are present in SQL Server 2008 R2 AND SQL Server 2012
Hi Folks,
I found that some of command are extinct as an SQL server found alternative and not in use as of now.
In ‘A to Z’ SQL Command series we are going to cover all command exist in SQL as follows
ABORT, ALTER DATABASE, ALTER GROUP, ALTER TABLE, ALTER TRIGGER, ALTER USER,ANALYZE, BEGIN, CHECKPOINT, CLOSE, CLUSTER, COMMENT, COMMIT, COPY, CREATE AGGREGATE, CREATE CAST, CREATE CONSTRAINT TRIGGER, CREATE CONVERSION, CREATE DATABASE, CREATE DOMAIN, CREATE FUNCTION, CREATE GROUP, CREATE INDEX, CREATE LANGUAGE, CREATE OPERATOR, CREATE OPERATOR CLASS, CREATE RULE, CREATE SCHEMA, CREATE SEQUENCE, CREATE TABLE, CREATE TABLE AS, CREATE TRIGGER, CREATE TYPE, CREATE USER, CREATE VIEW, DEALLOCATE, DECLARE, DELETE, DROP AGGREGATE, DROP CAST, DROP CONVERSION, DROP DATABASE, DROP DOMAIN, DROP FUNCTION, DROP GROUP, DROP INDEX, DROP LANGUAGE, DROP OPERATOR, DROP OPERATOR CLASS, DROP RULE, DROP SCHEMA, DROP SEQUENCE, DROP TABLE, DROP TRIGGER, DROP TYPE, DROP USER, DROP VIEW, END, EXECUTE, EXPLAIN, FETCH, GRANT, INSERT, LISTEN, LOAD, LOCK, MOVE, NOTIFY, PREPARE, REINDEX, RESET, REVOKE, ROLLBACK, SELECT, SELECT INTO, SET, SET CONSTRAINTS, SET SESSION AUTHORIZATION, SET TRANSACTION, SHOW, START TRANSACTION, TRUNCATE, UNLISTEN, UPDATE, VACUUM
Today morning only when i started querying about ABORT command listed in above ‘A to Z’ SQL Command series i found that it is not in SQL Server 2008 R2. 
When i tried fire query for same it have shown me following message
So i just pasted this entire list on SQL Server Query plane i found there are some other command also which are now not part of SQL Server 2008 R2
So command which are in BLACK are not part SQL Server 2008 R2
So listing down same separately , Query / Command are not present now as follows:
ABORT,ANALYZE, CLUSTER, COMMENT, COPY, EXPLAIN, LISTEN, LOCK, NOTIFY, PREPARE, REINDEX, SHOW, UNLISTEN, VACUUM
I found similar in SQL Server 2012
I will update and comment on every command in future as when we are going to explain each command in Details.
So i will be deleting above unlisted query / command from my list going to continue further with this series .
Hope this helps !!
Those who have not ye subscribe my Blog yet they can subscribe it !So that I can post you @ real time and all sort of knowledge in your mail without Zero spamming !!
Happy Learning and Sharing !!
If you want daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog :
For More information related to BI World visit my Mentalist Blog
Link Resource Blog >> Daily Interesting links
SQL Server Mentalist >> SQL Learning Blog
Business Intelligence Mentalist >> BI World
Connect With me on
| Facebook |Twitter | LinkedIn| Google+ | Word Press | RSS |
-
July 3, 2012 at 8:16 amBISQL # 101 : ‘A to Z’ SQL Command with Syntax, Description, Usage and Example # 1 : ALTER DATABASE « SQL Server Mentalist
-
July 23, 2012 at 6:16 amBISQL # 105 : SQL Server 2012 : Resource Governor : Introduction, Syntax, Example, Resources and Explanation with SQL Server 2012 Enhancement « SQL Server Mentalist
SQL Server Mentalist 