CREATE DATABASE Nto10
USE NTo10

SELECT * FROM sys.databases
  ORDER BY create_date DESC

DROP DATABASE Nto10


CREATE TABLE Tab
(
ID INT,
Name VARCHAR(500),
Age int
)

SELECT * FROM dbo.Tab
SELECT * FROM sys.tables

INSERT INTO tab(ID,Name,age) VALUES(1,'Amit',23)
INSERT INTO tab(ID,age) VALUES(2,24)

SELECT * FROM dbo.Tab
UPDATE tab SET
   Name='Mayank'
     WHERE Name IS NULL

DELETE FROM dbo.Tab WHERE id=2

DROP TABLE dbo.Tab
------------------------------------------------------------------------------
CREATE DATABASE anil
USE anil
SELECT * FROM sys.databases
 ORDER BY create_date DESC
 DROP DATABASE anil

    CREATE TABLE info
    (
    id INT,
    name VARCHAR(10),
    age INT,

    )
    SELECT * FROM dbo.info
    SELECT * FROM sys.tables
    INSERT INTO info(id,name,age) values(1,'amit',23)
    INSERT INTO info(id,name,age) values(2,'anil',23)
    INSERT INTO info(id,name,age) values(3,'amil',26)
    INSERT INTO info(id,name,age) values(4,'amit',27)
    SELECT * FROM dbo.info WHERE name='amit' AND age=23
    SELECT * FROM dbo.info WHERE name='amit' OR age=23
   TRUNCATE TABLE dbo.
   SELECT * FROM dbo.info
  ALTER TABLE dbo.info
  ADD Email VARCHAR(50)

INSERT INTO Info VALUES(1,'Amit',23,'A@gmail.com')
INSERT INTO Info VALUES(2,'Sachin',23,'S@gmail.com')
INSERT INTO Info VALUES(3,'Mayank',23,'M@gmail.com')
INSERT INTO Info VALUES(4,'Manish',28,'Mn@gmail.com')
INSERT INTO Info VALUES(5,'Sanket',45,'SN@gmail.com')
 SELECT * FROM dbo.info WHERE Name='Amit'
 SELECT * FROM dbo.info WHERE Age=23
 SELECT * FROM dbo.info WHERE Name='Amit' ANd Age=23
 SELECT * FROM dbo.info WHERE Name!='Amit'
 SELECT * FROM dbo.info WHERE Age<>23