Answer / indraneelandhavarapu

You can use File system task of SSIS to rename file and
folders dynamically.

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

What the difference between UNION and UNIONALL?

0 Answers   HCL,

---

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

---

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  

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration

0 Answers  

---

Explain different backup plans?

0 Answers  

---

what are the joins,primary key,foriegn key, candidate key, super key and expain them?

6 Answers   Polaris,

---

How to get the count of distinct records. Please give me the query?

8 Answers   Value Labs,

---

i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.

0 Answers  

---

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---