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

How do you migrate data from mssql server to azure?

167

---

Explain boyce and codd normal form(bcnf)?

1015

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

---

how to invoke a trigger on demand? : Sql server database administration

1152

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

2115

---

How to delete database objects with "drop" statements in ms sql server?

1152

---

Tell me the difference between clustered and non-clustered index?

991

---

Describe and explain about SQL native client?

1158

---

How can sql injection be stopped? : sql server security

1104

---

How to call stored procedure using http soap?

1130

---

Does sql server use t sql?

1071

---

Does windows server 2016 come with sql server?

986

---

Do you know how to make remote connection in database?

1008

---

What is SQL Azure Fabric?

112

---

How will you optimize a stored procedure optimization?

1116

---