can u create two Primary key for a table?
--Sivaa

Answer Posted / purushotham

S we can create its called composite key

ALTER TABLE TableName
ADD CONSTRAINT CONSTRAINT _Name
PRIMARY KEY (attribute1,attribute2)

Is This Answer Correct ?    12 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the syntax for datagrid and specifying columns?

2303


What is the difference between GridView and Repeater controls in ASP.NET?

812


What is datagrid asp.net?

737


What is globalization and localization in asp net?

719


How you will improve web application performance?

755


What does a switch do?

743


What do you mean by serialize and marshalbyref?

777


How ASP.NET page works?

868


Hi this is the coding for adding data in to an xml table i want the coding for update and delete Try Dim emp_xml_doc As New XmlDocument If System.IO.File.Exists(Server.MapPath("emp.xml")) Then emp_xml_doc.Load(Server.MapPath("emp.xml")) Dim myrow_element As XmlElement myrow_element = emp_xml_doc.CreateElement("EmpDetails") Dim str As String str = "" & TxtEmpId.Text & "" & _ "" & TxtName.Text & "" & _ "" & TxtSalary.Text & "" myrow_element.InnerXml = str emp_xml_doc.DocumentElement.AppendChild(myrow_element) emp_xml_doc.Save(Server.MapPath("emp.xml")) Response.Write("Record Saved") Dim ds As New DataSet ds.ReadXml(Server.MapPath("emp.xml")) GridView1.DataSource = ds GridView1.DataBind() Else Response.Write("File does not exist.") End If Catch ex As Exception Response.Write(ex.ToString) End Try *********************** this is the xml file 100 xxx 2000 yyy dddd 77777 rrrr rrrr 6666 qaqa sini 50000 errrrrrrrr rrrrrrrrr 677777 rrr rrr 33

1945


What is gridview in asp.net?

685


If there are multiple update panels on the page say upd1 and upd2. There is a button placed in upd1. How can you stop upd2 to update when button placed in upd1 is clicked?

785


When you are running a component within ASP.NET, what process is it running within on Windows XP? Windows 2000? Windows 2003?

804


What is new asp.net core?

791


Explain security types in asp.net?

805


What is the difference between the asp and asp.net?

712