Insert Update Delete and Other Important SQL Commands in MS SQl SERVER


For Fresher it’s important to know few important commands before starting coding
You should remember all the commands how and why use.

Firstly you should know that commands are not case sensitive, and after ending your any query it’s important to put semicolon (;). It separates the every sql commands.

Here is the important Sql Commands in sql.

SELECT:
Select Command use to take out all data from you database.

UPDATE:
Update data of database.

DELETE: 
To delete data from table.

INSERT INTO:
Inserts new data and new rows into a database

CREATE DATABASE:
It use to create a new database.

ALTER DATABASE:
Modifies a database

CREATE TABLE:
To creates a new table

ALTER TABLE:
It use to modify and delete in table

DROP TABLE:
Use to delete a table from database

CREATE INDEX:
Use to create index in table it retrieves data very fast from database. Index use to speedup searches.


DROP INDEX:
Use to delete index

Comments

Post a Comment

Popular posts from this blog

Disable right click, Inspect Element and page source using JavaScript in Html and asp.net

This is a code to hide right click on any web page and to hide inspect element and page source of page.  I have used JavaScript to hide a source code below is the code. It blocks Ctrl + U , Right click , F12 , and Ctrl+ Shift + J Step One :  copy JavaScript and paste under head tag. <script> document.onkeydown = function(e) { if(event.keyCode == 123) { return false; } if(e.ctrlKey && e.shiftKey && e.keyCode == 'I'.charCodeAt(0)){ return false; } if(e.ctrlKey && e.shiftKey && e.keyCode == 'J'.charCodeAt(0)){ return false; } if(e.ctrlKey && e.keyCode == 'U'.charCodeAt(0)){ return false; } } </script> Step Two :  Put this code  in the body tag. <body oncontextmenu="return false;"> Now you can run your page and check using all the short controls and right click all are disabled now… Happy Coding Day
Read more

Select distinct value from data table in SQL

SELECT DISTINCT query is used to return different values from data table. In database there are so many duplicate values and if you want to select only different data and row from table use distinct statement. SELECT DISTINCT QUERY SELECT   DISTINCT   Emp_name ,  Emp_City, FROM  your_ table_name ; Now will show you the difference between SELECT and SELECT DISTINCT  SELECT Example Following Sql Query select all duplicate rows from column Emp_name from table SELECT   Emp_name FROM  Employee_table; SELECT DISTINCT Example Following Sql query select only distinct value from column Emp_name From Employee_table SELECT DITINCT   Emp_name FROM  Employee_table; Example Following SQL query selects and counts the different rows SELECT   COUNT ( DISTINCT   Emp_name )  FROM  Employee_table;
Read more