Answer / gautam k panjikar

getdate()

Answer / rajkumar v

select convert(varchar,getdate(),105)

Answer / anto

select getdate()

Answer / mt

select getdate();

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---

Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?

3 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?

3 Answers  

---

How to generate create procedure script on an existing stored procedure?

0 Answers  

---

What do you mean by subquery?

0 Answers  

---

Explain insert into select statement?

0 Answers  

---

If we shrink the Databse and Files, how much size is decreased?

1 Answers   TCS,

---

How do I find the sql server database version?

0 Answers  

---

How can we solve concurrency problems?

0 Answers  

---

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

---

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

---