How will you hide an attribute? : sql server analysis services, ssas

0 Answers  

---

How we Resize table,temp table, database and log file size in SQL Server 2005

1 Answers   ABC,

---

You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  

---

How can u get the number of pupils connecting the database?

1 Answers   Cap Gemini,

---

Can a table be created inside a trigger?

0 Answers  

---

What is a materialized view?

3 Answers  

---

Define model database?

0 Answers  

---

What is the name of the system variable that returns the number of rows affected by a SQL statement?

0 Answers   HCL,

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers  

---

What is the difference between local and global temporary tables?

0 Answers  

---

Can you please explain the difference between primary keys and foreign keys?

0 Answers  

---

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 Answers  

---