Select Command

1. select * from inventry
2. select iid,qty from inventry
3. select distinct supid,qty from inventry

Select using 'like'

1.select * from tblemp
where eadd like 'd_'

2.select * from tblemp
where eadd like '%d'

3.select * from tblemp
where eadd  like '%d%' and ename like 'u%'

Trigger

1.create trigger t_insert
on tblemp
for insert
as
print 'row inserted'

2.create trigger t_insert2
on tblemp
for insert
as
select eid from tblemp
where eid>5

3.create trigger t_insert1
on tblemp
for insert
as
select eid from tblemp

Programming in SQL

begin

declare @a int
declare @b int
declare @c int

set @a=67
set @b = 99
set @c=@a+@b

print @a
print @b
print@c


end

Cursor

states of cursor
1.declare cursor_emp cursor
for
select eid, ename from emp

2.open cursor_emp

3.fetch cursor_emp

4.close cursor_emp

5.deallocate cursor_emp

CREATE TABLE

1.create table emp
(eid int,ename varchar(20),emgr int, esalry int)

2.create table dept(eid int primary key)

3.CREATE TABLE INVENTRY( IID INT PRIMARY KEY,PRODID INT,SUPID INT,QTY INT )

 CREATE DATABASE

CREATE DATABASE ERP
 ON PRIMARY
(NAME=ERP,FILENAME='C:\JOG\ERP.MDF', SIZE=10 MB,MAXSIZE =200 MB, FILEGROWTH =10 %)
 LOG ON
 (NAME=LERP,FILENAME='C:\JOG\LERP.LDF',SIZE=5 MB, MAXSIZE=100 MB,FILEGROWTH =5%)