Answer Posted / prasad

select convert(varchar,columnname,101) from tablename

How to use transact-sql statements to access the database engine?

744

---

What is the difference between delete and truncate statements?

746

---

Where the sql logs gets stored? : sql server database administration

687

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

739

---

What happens when unicode strings concatenate with non-unicode strings?

733

---

---

How to create indexed view?

732

---

What is parameterized reports in ssrs ?

125

---

What is Transparent Data Encryption?

731

---

Define indexes?

795

---

What specific conditions database should meet, before you can bulk copy data into it using bcp?

735

---

Explain the collation?

824

---

What does it mean to invest in the index?

696

---

How do I find the default sql server instance?

695

---

what are database files and filegroups? : Sql server database administration

666

---

How many cores do I need for sql server 2016?

670

---