Answer Posted / madhesan

create database mani

use mani

create table emp
(
empno int,
empname varchar(20),
salary int
)

select * from emp

insert into emp values(2,'hari',10000)

create procedure selectproc
as select * from emp

exec selectproc

create procedure insertproc
@no int,
@name varchar(20),
@salary int
as
insert into emp values(@no,@name,@salary)

exec insertproc1 2,'pavan',15000

create procedure insertproc1
@no int,
@name varchar(20),
@salary int
as
if @no=1
print 1
else
insert into emp values(@no,@name,@salary)
print "successfully inserted!!!"

select * from syscolumns

sp_helpdb mani

sp_help selectproc
sp_helptext selectproc

set isolation level serializable

What is data mart? : sql server analysis services, ssas

1056

---

What is the difference between for trigger and after trigger?

1107

---

What is 2nf normalization?

1029

---

What are different types of statement?

1018

---

How to fetch the next row from a cursor with a "fetch" statement?

1073

---

Where do you find the default Index fill factor and how to change it?

1063

---

How does clustered and non clustered index work?

925

---

What does asynchronous call backs means?

1159

---

How to change parameter value inside the report?

164

---

What are commit and rollback in sql?

1130

---

What is difference between rownum and row_number?

969

---

What causes index fragmentation?

997

---

What are drilldown reports?

155

---

Explain transaction server isolation?

1045

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

1594

---