Answer Posted / rajkumar v

select convert( varchar(20), getdate(), 103)

Write an sql query to find first weekday of the month?

908

---

What is the use of keyword with encryption.

1024

---

What are the types of dml?

976

---

How to read data in a table with "select" statements?

959

---

What are the differences between decimal and float in ms sql server?

1227

---

How to display a past time in days, hours and minutes?

1010

---

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

903

---

Can we use pragma autonomous_transaction in trigger?

951

---

How to use user defined functions in expressions?

1077

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

938

---

Where are sql server user names and passwords stored in sql server?

1072

---

Explain identity in sql server?

997

---

How to check parameter value in stored procedure sql server?

962

---

What is the importance of concurrency control?

1218

---

what is a schema in sql server 2005? : Sql server database administration

1016

---