create multiple primary key in a single table

CREATE TABLE CUSTOMERS(
   ID   INT              NOT NULL,
   NAME VARCHAR (20)     NOT NULL,
   AGE  INT              NOT NULL,
   ADDRESS  CHAR (25) ,
   SALARY   DECIMAL (18, 2),       
   PRIMARY KEY (ID, NAME)

);

Comments

Post a Comment

Popular posts from this blog

FAQ BIND

public void FaqBind()     {         try         {             var content = GetContactUslist().ToList();             var result = (from a in content                           where a.IsActive == true && a.ContactUs_Comments != null && a.ContactUs_Answer != null                           select new                           {                              a.ContactUs_ID,                             a.ContactUs_Comments,                             ...
Read more

Create Schema Using C# Asp .Net Dynamically.

In WebConfig First Set The Connection String. ====================================== <?xml version="1.0"?> <!--   For more information on how to configure your ASP.NET application, please visit   http://go.microsoft.com/fwlink/?LinkId=169433   --> <configuration>   <connectionStrings>     <add name="InterviewConnectionString" connectionString="Data Source=SATYABRATA;Initial Catalog=Interview;Persist Security Info=True;User ID=satya;Password=satya@215;MultipleActiveResultSets=True;Application Name=EntityFramework"           providerName="System.Data.SqlClient" />   </connectionStrings>   <system.web>     <compilation debug="true" targetFramework="4.5" />     <httpRuntime targetFramework="4.5" />   </system.web> </configuration> ====================================== Design Page in Source FIle ====================================== ...
Read more

resgination mail

Dear Sir,          Kindly informed that I am submitting this letter for the purpose of resigning from the post of Software Engineer from SWASH Convergence Technologies Limited effective from today. Therefore, the last day of work for me here will be Today. The purpose of this resignation letter is to inform you that I will be leaving my position with Swash Company, effective long Period from now on August 11. my family is currently in the process of relocation that I will be relocating to the Hyderabad City metropolitan area in the near future. From the time I joined SWASH Convergence Technologies Limited as Software Engineer One year’s one Month ago, I have enjoyed immense professional growth and forged unbreakable bonds of friendship. I have received an abundance of support, advice, and encouragement from my superiors, and for that I shall be always grateful. I would like to special thanks our CEO , Dr. Pritam Pal for his coo...
Read more