Answer Posted / vaishali

create procedure proc_name
{
@para1 varchar(20),
@para2 varchar(20),
}
AS
Declare @sql varchar(8000)
Set @sql="update table1 set col1='value' where
col2='"+@para1+"'\n"
Set @sql=@sql+ "update table2 set col1='value' where
col2='"+@para2+"'\n"

Exec(@sql)

How to generate create view script on an existing view?

740

---

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1267

---

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

843

---

what happens on checkpoint? : Sql server database administration

696

---

What is encryption key?

98

---

---

Explain the database you used in your final year project?

712

---

What is a mixed extent?

756

---

Does a specific recovery model need to be used for a replicated database? : sql server replication

709

---

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

795

---

What Is Rdbms?

840

---

What different steps will a sql server developer take to secure sql server?

722

---

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

766

---

What is difference between oltp and olap?

779

---

What are trace flags and mention a few common trace flags used with sql server?

746

---

Explain the purpose of indexes?

721

---