How to create composite primary key in SQL Server 2008

by 
create table my_table (
     column_a integer not null,
     column_b integer not null,
     column_c varchar(50),
     primary key (column_a, column_b)
);

More Related Contents:

  1. Efficiently convert rows to columns in sql server
  2. T-SQL split string
  3. How can I get column names from a table in SQL Server?
  4. Conditional WHERE clause in SQL Server
  5. How can I select the first day of a month in SQL?
  6. GROUP BY to combine/concat a column [duplicate]
  7. Select statement to find duplicates on certain fields
  8. How to turn IDENTITY_INSERT on and off using SQL Server 2008?
  9. Copy data into another table
  10. Parse comma-separated string to make IN List of strings in the Where clause
  11. sql runs fast in ssms slow in asp.net
  12. How do I see active SQL Server connections?
  13. EXISTS vs JOIN and use of EXISTS clause
  14. UPDATE if exists else INSERT in SQL Server 2008 [duplicate]
  15. SQL Server 2008 – IF NOT EXISTS INSERT ELSE UPDATE
  16. Why is a UDF so much slower than a subquery?
  17. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  18. Query runs slow with date expression, but fast with string literal
  19. Alternate of lead lag function in SQL Server 2008
  20. UNIX_TIMESTAMP in SQL Server
  21. How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
  22. Generate all combinations in SQL
  23. Generate random int value from 3 to 6
  24. The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range?
  25. Add emoji / emoticon to SQL Server table
  26. Cumulative Total in MS Sql server [duplicate]
  27. How to write a WHERE Clause to find all records in a specific month?
  28. How to make a view column NOT NULL
  29. Flattening of a 1 row table into a key-value pair table
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment