my reframce

use ReportServerTempDB
select *from dbo.ChunkData
INNER JOIN
[ChunkSegmentMapping] on ChunkSegmentMapping.ChunkId = ChunkData.ChunkID
INNER JOIN
[PersistedStream] on PersistedStream.SessionID = ChunkData.SnapshotDataID

use ReportServerTempDB
select *from dbo.Segment
select *from dbo.ChunkData
alter procedure selectsubquery
as
declare
@department varchar(50)
begin
--select *from dbo.Segment where SegmentId = (select *from  dbo.Segment where Content= @department)
select * from SegmentId where emp_add =(select *  from dbo.Segment where Content =@department)
end
exec selectsubquery "1"
create view selectall as
select *from Segment
select *from selectall
drop view selectall
drop procedure selectsubquery
create index test_index on ChunkData(SnapshotDataID)
drop index ChunkData.test_index
select *from dbo.Segment

create database testdbset
create table userse (userid int ,name varchar(50))
drop table users
select * from users
--insert into userse(name) values( 'kathir')
--insert into userse(name) values('test')
create database bookDb
create table bookdeatails(bookid int,bookname varchar(200),authorname varchar(100))
alter table bookdeatails modify bookid int  identity
create table emp(emp_id int identity primary key,emp_name varchar(200),emp_salary decimal(18,2))
insert into emp (emp_name,emp_salary) values ('kathir',100)
insert into emp (emp_name,emp_salary) values ('raj',2300)
insert into emp (emp_name,emp_salary) values ('ragu',190)
insert into emp (emp_name,emp_salary) values ('saran',300)
insert into emp (emp_name,emp_salary) values ('kumar',900)
select *from emp
SELECT MAX(emp_salary) AS 'emp_salary' FROM emp WHERE emp_salary < (SELECT MAX(emp_salary) FROM emp where emp_name='kathir')
--create procedure findmax_salary
--as
--begin
--end
use bookDb
create table product(pid int primary key identity, p_name varchar(200))
create table purchage(pid int primary key identity,p_quantity varchar(200))
create table sales(pid int primary key identity,p_amount decimal(18,2))
select *from product
create view joinsview as
select product.pid,product.p_name,sales.p_amount,purchage.p_quantity from  product
inner join purchage on product.pid = purchage.pid
inner join sales on product.pid = sales.pid
select *from joinsview
use bookDb
alter table purchage add
constraint purchase_fk foreign key(pid) REFERENCES product(pid);
alter table sales add
constraint sales_fk foreign key (pid) REFERENCES product(pid);

alter table bookdeatails(bookid int primary key identity)
insert into bookdeatails(bookid)
create table (emp_id int indentity primary key,emp_name varchar(200),emp_salary decimal(18,2))
insert into emp (emp_name,emp_salary) values ("kathir",100)
insert into emp (emp_name,emp_salary) values ("raj",2300)
insert into emp (emp_name,emp_salary) values ("ragu",190)
insert into emp (emp_name,emp_salary) values ("saran",300)
insert into emp (emp_name,emp_salary) values ("kumar",900)

use bookDb

alter table purchase add
constrain purchase_fk (pid) REFERENCES product(pid))
alter table sales add
constrain sales_fk (pid) REFERENCES product(pid))

create table product(
pid int identity,
p_name varchar(200),
CONSTRAINT product_pk PRIMARY KEY (pid)
   )
create table purchase(
pid int primary key identity,
p_quantity varchar(200),
CONSTRAINT purchase_pk PRIMARY KEY (pid)
    )
create table sales(
pid int primary key identity,
p_amount decimal(18,2),
CONSTRAINT sales_pk PRIMARY KEY (pid)
  )

select product.pid,product.p_name,sales.p_amount,purchase.p_quantity from  product
inner join purchase on product.pid = purchage.pid
inner join sales on product.pid = sales.pid

SELECT *
     FROM CUSTOMERS
     WHERE ID IN (SELECT ID
                  FROM CUSTOMERS
                  WHERE SALARY > 4500) ;

INSERT INTO CUSTOMERS_BKP
     SELECT * FROM CUSTOMERS
     WHERE ID IN (SELECT ID
                  FROM CUSTOMERS
UPDATE CUSTOMERS
     SET SALARY = SALARY * 0.25
     WHERE AGE IN (SELECT AGE FROM CUSTOMERS_BKP
                   WHERE AGE >= 27 );
DELETE FROM CUSTOMERS
     WHERE AGE IN (SELECT AGE FROM CUSTOMERS_BKP
                   WHERE AGE >= 27 );

CREATE TABLE Emails
(email_address VARCHAR(255) NOT NULL UNIQUE,
 email_type CHAR(1) NOT NULL,
 CONSTRAINT valid_email_type
  CHECK (email_type IN ('S', 'F')),
 PRIMARY KEY (email_address, email_type));



department to fielder the maximum salary
join three tables
inner join,left join,right join,full join
all differnce and out put
maximum salary based on sub query to do that
store procedure all statement
ado.net connectivity
data grid view
sql view,index
what is the self join

array maximum and minimum find out,add the array values,find the second maximum number
web services labires
boxing and unboxing

http://stag-homemanagementpros.azurewebsites.net/DashboardSection/DashboardSection/?identifyprovider=Email&name=some%20k&email=kathiravan.kkathiravan07@gmail.com&browser=chrome#

http://www.dotnettricks.com/learn/sqlserver/different-types-of-sql-joins