Guest

Can SQL Server views have primary and foreign keys

By: a guest on Feb 12th, 2012  |  syntax: None  |  size: 0.30 KB  |  hits: 36  |  expires: Never
download  |  raw  |  embed  |  report abuse
Copied
  1. SELECT MAX(...) ... GROUP BY ...
  2.        
  3. ALTER VIEW [dbo].[ViewName]
  4. AS
  5.  
  6. SELECT  
  7. ISNULL(CAST(
  8.         CASE ROW_NUMBER() OVER (ORDER BY columnNames)
  9.             WHEN ROW_NUMBER() OVER (ORDER BY columnNames) THEN ROW_NUMBER() OVER (ORDER BY columnNames)  
  10.             ELSE 0  
  11.         END AS int), 0) AS ID