Can someone tell me the difference between making a column primary key column vs. making it identity column
thanks
Primary key and identity
Hot Topic
- Pie Chart Legend Values
- Management Studio and Mangement Studio Express on the same machine
- Answer: Shared Datasource
- Some problem with Istallation of SQL Server 2000 Reporting Services
- MySql SSIS Hangs with ODBC Drivers
- Reference to preceeding component from custom dataflow transformation component
- Schedule Stored Procedures
- SQL 2005 .NET Stored Procedure - Returning more than 8000 chars i a variable
- T-SQL Select Statement executed inside the Visual Studio 2005 Environment returns -1 for the "True" Values of the bit fields
- group rpt hdgs not appearing on all pgs
SQL Server
- Is there a way to tell what column I'm in?
- Data types in SQL Server
- List of Approved Assemblies
- Database Mirroring is not working at all in RTM
- SQL 2000 stops to increment @cpu_busy value, sp_monitor does not work anymore
- Stored Proc Input Parameter Limited?
- Embedding an object into report
- Check if database exists?
- Returns Nothing, But Executes Fine
- Help! - Error in moving data from AS400
Primary key and identity
Inquisitve2
Identity just auto increments the value in that column (like autonumber in Access). A primary key uniquely identifies a specific row. Obviously you can have only one primary key per table (you can make a combination of columns the primary key - but I do not recommend this).