Home > A to Z SQL Command, Link, SQL > BISQL # 99 – ‘A to Z’ SQL Command # 1 – List of Command which are present in SQL Server 2008 R2 AND SQL Server 2012

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. Smile

When i tried fire query for same it have shown me following message

image 

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

image

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

image 

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 :

Link Resource Website

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 |

About these ads
Categories: A to Z SQL Command, Link, SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 1,120 other followers

%d bloggers like this: