Answer / Sharad Pratap Singh

Custom fields in SQL Server Reporting Services allow users to create additional fields that do not exist in the underlying data source. These fields can be used to perform calculations, concatenate values, or manipulate data in various ways to better suit reporting needs.

What is the Disadvantage of indexed sequential file.

1 Answers   HCL,

---

What are various limitations of the views?

1 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

What is meant by indexing?

1 Answers  

---

How do you rename a table in sql server?

1 Answers  

---

What happens to a trigger with multiple affected rows?

1 Answers  

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?

1 Answers  

---

What is store procedure?

1 Answers  

---

Can we use pragma autonomous_transaction in trigger?

1 Answers  

---

What are the restraints imposed on the table design by a merge replication?

1 Answers  

---

How do indexes help, types?

1 Answers  

---