• Home
  • About Author

SQL Server Inside

SQL Server Database Forum

  • Home
  • MSBI
    • SSIS
    • SSRS
    • SSAS
  • Interview Questions
    • SQL Server
    • T-SQL
    • SSIS
    • SSRS
    • SSAS
  • SQL Server
  • T-SQL
  • Facebook
  • Twitter
Home / Archive for January 2015
Difference between Primary Key and Unique Key in SQL Server

Difference between Primary Key and Unique Key in SQL Server

8:11 PM Rohit Kumar Barik 0
Both the Primary Key(PK) and Unique Key(UK) are meant to provide Uniqueness to the Column on which they are defined. Here is the major dif...
READ MORE +
Subscribe to: Posts ( Atom )
  • Popular Post
  • Blog Archieve
  • SQL Category

Popular Posts

  • Transactions and Isolation Levels in SSIS
    Transaction options in SSIS Package: NotSupported  - Specifies that no transaction will be started for this container, and consequently, ...
  • Unable to open Step output file. The step failed
    When you try to execute the job, The job will fail with error "Unable to open Step output file. The step failed" In this case th...
  • SQL Server Interview Questions and Answers (Part 1)
    1. Difference between TRUNCATE and DELETE                 - Truncate is DDL command so can't be rolled back while Delete is a DML co...
  • Date Function: DATEFROMPARTS() and TIMEFROMPARTS()
    DATEFROMPARTS() It returns the date value on specified year, month and day value. It available in SQL Server 2012. Syntax: D...

Blog Archive

  • ▼  2015 (15)
    • ►  October (8)
    • ►  August (3)
    • ►  April (1)
    • ►  March (2)
    • ▼  January (1)
      • Difference between Primary Key and Unique Key in S...
  • ►  2014 (6)
    • ►  December (1)
    • ►  September (4)
    • ►  January (1)
  • ►  2013 (4)
    • ►  August (4)

Labels

  • Interview Q&A - SQL Server
  • Interview Q&A - SSIS
  • Interview Q&A - T-SQL
  • SQL Server
  • SSIS
  • T-SQL
2013-14. Powered by Blogger.

Facebook: SQL Server Forum

Translate

Popular Posts

  • Unable to open Step output file. The step failed
    Unable to open Step output file. The step failed
    When you try to execute the job, The job will fail with error "Unable to open Step output file. The step failed" In this case th...
  • Transactions and Isolation Levels in SSIS
    Transaction options in SSIS Package: NotSupported  - Specifies that no transaction will be started for this container, and consequently, ...
  • Date Function: DateDiff()
    This is used to find the difference between two dates based on DatePart type The DATEDIFF() function returns the time between two dates....

Follow by Email

PageViews

Created By Sora Templates & Blogger Templates
  • Home
  • About