Guest User

Untitled

a guest
Jan 20th, 2019
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. testRequest (wardNo nchar(5), BHTNo nchar(5), testID nchar(5), reqDateTime datetime);
  2.  
  3. ALTER TABLE dbo.testRequest
  4. ADD CONSTRAINT PK_TestRequest
  5. PRIMARY KEY (wardNo, BHTNo, TestID)
  6.  
  7. CREATE TABLE testRequest (
  8. wardNo nchar(5),
  9. BHTNo nchar(5),
  10. testID nchar(5),
  11. reqDateTime datetime,
  12. PRIMARY KEY (wardNo, BHTNo, testID)
  13. );
Add Comment
Please, Sign In to add comment