Answer Posted / senthilsjc

Hai..

plz understand what they asked?
don't post answer what u studied in material..

if u know well with example post it..

plz don't waste ur time and others?

Why I am getting this error when renaming a database in ms sql server?

990

---

What is the difference between TRUNCATE and DROP?

1067

---

How can we remove orphan records from a table?

933

---

What is CTE in SQL

876

---

How to disable stored procedure sql server?

1532

---

What does man by sql wildcard characters in sql server?

997

---

How many types of built in functions are there in sql server 2012?

876

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1088

---

How to move database physical files in ms sql server?

961

---

Write a code to select distinct records without using the DISTINCT keyword.

1052

---

your distribution database is full what will u do

2129

---

What is compound operators?

978

---

explain extended properties

929

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

901

---

What is difference between global temporary tables and local temporary tables?

1178

---