Answer Posted / rajkumar v

select convert(varchar,getdate(),105)

How to write a query with an inner join in ms sql server?

1043

---

What does it mean to manipulate data?

987

---

How to test a dml trigger in ms sql server?

1037

---

Define tempdb database?

990

---

How would you choose between a clustered and a non-clustered index?

965

---

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2477

---

What is the order by used for?

1017

---

How to use column default values in insert statements in ms sql server?

1025

---

How fixed length strings are truncated and padded?

974

---

What is enhanced database mirroring in sql server 2008?

967

---

How to list all tables in the database using odbc_tables()?

1043

---

Why Master database is required?

1127

---

What command must you use to include the not null constraint after a table has already been created?

1141

---

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

1079

---

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1025

---