Answer Posted / test

select datename(month,getdate())

Explain the dbcc pintable command when would you use it?

920

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

950

---

How to apply cascading referential integrity in place of triggers?

1034

---

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

991

---

What is the stored procedure?

1009

---

What is difference between temp table and cte?

1019

---

What is a group function explain with an example?

989

---

How to find out what is the default collation in a database?

1123

---

What is thr feature of change data capture?

980

---

What types of replication are supported in sql server?

1063

---

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1396

---

What are the types of resultset?

967

---

How do I open port 1433?

931

---

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

1013

---

What do you understand by mirroring?

997

---