Answer Posted / jyothi

user defines sp...
say i want to select some values based on parameter


create PROCEDURE GetEmployeeDetails
-- Add the parameters for the stored procedure here
@sno int,



-- Insert statements for procedure here


select *from emp where sno=@sno


END
GO

What is filter index?

933

---

System requirements for sql server 2005 express edition?

994

---

What is b tree index?

899

---

What are null values in ms sql server?

1058

---

Why use sub query in sql server and list out types of sub queries?

975

---

How to check status of stored procedure in sql server?

957

---

What is factless fact table? : sql server analysis services, ssas

1006

---

What is the difference between cartesian product and cross join?

844

---

Explain Normalization and DE normalization

1093

---

Can you name some of the dml commands in sql?

1007

---

How to use values from other tables in update statements in ms sql server?

1092

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

951

---

How many types of built in functions are there in sql server 2012?

907

---

How would you use user_constraints table in DB?

984

---

How to add a new dsn with the odbc driver for sql server?

1040

---