Answer Posted / yjreddy

select @@ROWCOUNT
it will give the no of rows affected by last sql statement
select @@ERROR
it will display the error number for last sql statement

Explain “row_number()” in sql server with an example?

1060

---

How do you manipulate data?

956

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2174

---

Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

195

---

How do you run a trace?

950

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1012

---

How will you add a dimension to cube? : sql server analysis services, ssas

1142

---

Find first and last day of current month in sql server

1086

---

How you can get the list of largest tables in a database?

1079

---

What is the difference between a unique key and primary key?

1012

---

What is the difference between nvl and nvl2?

1042

---

Give an example of why you would want to denormalize a database

1043

---

What are the different types of join?

1259

---

Can we delete data from a view?

986

---

Can we take the full database backup in log shipping?

1001

---