Question
MERGE in sql server 2008
Answers
Merge statement allows a single statement for INSERT, DELETE and UPDATE a row that depends on a condition..........   Your Comment




  • Contributors: *,
More Software Questions..
What is the inputsplit in map reduce software?
What is software configuration management?
What Is Java Api For Xml-based Rpc (jax-rpc)?
How can you implement fine-grained auditing?
What is IBM’s simple explanation for Big Data’s four critical features?
What is static synchronized method in JDBC API? Give an example?
What does the NULLIF function do?
What happens if a start method is not invoked and the run method is directly invoked?
Should we override finalize method
what is the difference between mysql_fetch_array and mysql_fetch_object?
How will XML affect my document links?
Why to use Style Sheets?
What are Filters in MVC?
Can you explain Application layer in OSI model?
How to define new testplan attributes?
What are the minimum system requirements to run Photoshop? Is it possible to run Photoshop over linux?
Which oracle package is used to manage the oracle lock management services?
What is Latch Up? Explain Latch Up with cross section of a CMOS Inverter. How do you avoid Latch Up?
What is marker interface?
What types of partitioning are there for BW?


Search
Can you Answer!!
  • Q Are you a member of any clubs or charities?
  • Q "pp-pm integration" we have a requirement at our client place. At the time of production confirmation using transaction code c011, the system has to cumulate the confirmed production quantities. When it reaches a certain quantity (ex: 100 tons), the system should generate the maintenance order in plant maintenance. Is there any possibility for configuration in sap for the above mentioned query? what is the appropriate formula or configuration step? should we create the equipment as prt equipment (equipment category as prt)?
  • Q Why does each student need in-depth training on each piece of shop machinery?
  • Q What changes in the front end code is needed if mirroring is implemented for the high availability?
  • Q What is servlet tunnelling?
  • Q What is business objects?
  • Q Why you have to use backbone ? advantages?
  • Q Columbus's Nina and Pinta were both this type of popular Spanish ship:
  • Q Which trace file is used for performance tuning and why?
  • Q Identify the tree family which includes among its members the: new mexico, texas honey, thornless honey, water, black and honey. Name this tree family.
  • Q You are creating an ASP.NET Web Form that displays employee data from a DataSet object. You want to fill the DataSet object and then you want to retrieve a reference to the employee whose primary key has the value of 1. You write the following code. (Line numbers are included for reference only) 01 SqlConnection(ConnectionString); 02 conn.Open(); 03 SqlCommand cmd = new SqlCommand (SELECT * FROM Employees, conn); 04 SqlDataAdapter da = new SqlDataAdapter(cmd); 05 DataSet ds = new DataSet(); 06 07 da.Fill(ds, Employees); 08 09 DataRow dr; 10 dr = ds.Tables[Employees].Rows.Find(1); 11 nameLabel.Text = dr[Name].ToString(); When you run the code, you receive the following error message at line 10: Table doesnt have a primary key. You ensure that a primary key is defined on the Employees table in the database. You want to alleviate the error to allow the code to run correctly. You also want to catch the exception that would occur if the employee whose primary key has the value if 1 is deleted from the database. Which two actions should you take? (Each correct answer presents part of the solution. Choose two) A. Add the following code at line 06: da.MissingSchemaAction = MissingSchemaAction.AddWithKey; B. Add the following code at line 06: da.MissingSchemaAction = MissingSchemaAction.Add; C. Add the following code at line 06: da.MissingSchemaAction = MissingSchemaAction.Ignore; D. Add the following code at line 06: da.MissingSchemaAction = MissingSchemaAction.Error; E. Place line 07 in a structured exception handling block. F. Place lines 10 and 11 in a structured exception handling block.