Answer Posted / hairlin vasanth raj

ALTER procedure [dbo].[p1]
as
declare
@i int
set @i = 0
begin
set nocount on
while (@i < 6)
begin
SELECT DATEADD(DD,-@i,GETDATE()) as date
set @i=@i+1
end
end


exec p1

Do you have any idea about the tcl commands?

716

---

How to insert stored procedure result into temporary table?

771

---

What is acid mean in sql server?

739

---

What is rolap and its advantage? : sql server analysis services, ssas

937

---

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

1270

---

---

Can we insert data into a view?

828

---

How can I know what locks are running on which resource?

707

---

How to populate a table in sql server?

661

---

Give a example to search fr a string in all stored procedure in sql server.

702

---

Tell me in brief how sql server enhances scalability of the database system?

715

---

what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

686

---

How to create new databases with "create database" statements?

758

---

In what version of sql server were synonyms released?

695

---

List all types of constraints in sql server?

684

---

What are truncate options available in sql server? : sql server database administration

746

---