We can't Have 2 Primary Keys in Sql Server, but if we want two unique keys there is a option to have 2 uniques columns 1 is primary key and second is Unique key.Create table with Primary Key:CREATE TABLE Authors (AuthorID INT NOT NULL PRIMARY KEY,Name VARCHAR(100) NOT NULL)GOAlter table with … [Read more...]

Definition: A stored procedure, by definition, is a segment of declarative SQL code which is stored in the database catalog and can be invoked later by a program, a trigger or even another stored procedure. A stored procedure, which calls itself, is recursive stored procedure. Most DMBSs support … [Read more...]

SQL Select StatementsSELECT * FROM tbl Select all rows and columns from table tblSELECT c1,c2 FROM tblSelect column c1, c2 and all rows from table tblSELECT c1,c2 FROM tblWHERE conditionsORDER BY c1 ASC, c2 DESCSelect columns c1, c2 with where conditionsand from table tbl order result by column … [Read more...]