code_junkie

Can you limit the number of rows in a (database) table?

Nov 13th, 2011
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. CREATE TABLE [dbo].[DatabaseVersion]
  2. (
  3. [MajorVersionNumber] [int] NOT NULL,
  4. [MinorVersionNumber] [int] NOT NULL,
  5. [RevisionNumber] [int] NOT NULL
  6. )
  7. GO
  8.  
  9. Insert DataBaseVersion (MajorVersionNumber, MinorVersionNumber, RevisionNumber) values (0, 0, 0)
  10. GO
  11.  
  12. CREATE TRIGGER DataBaseVersion_Prevent_Delete
  13. ON DataBaseVersion INSTEAD OF DELETE
  14. AS
  15. BEGIN
  16. RAISERROR ('DatabaseVersion must always have one Row. (source = INSTEAD OF DELETE)', 16, 1)
  17. END
  18. GO
  19.  
  20. CREATE TRIGGER DataBaseVersion_Prevent_Insert
  21. ON DataBaseVersion INSTEAD OF INSERT
  22. AS
  23. BEGIN
  24. RAISERROR ('DatabaseVersion must always have one Row. (source = INSTEAD OF INSERT)', 16, 1)
  25. END
  26. GO
  27.  
  28. CREATE TABLE Settings (Key nvarchar(max), Value nvarchar(max))
  29.  
  30. CREATE UNIQUE INDEX SettingsIDX ON Settings (Key)
  31.  
  32. INSERT INTO Settings (Key, Value) VALUES ('Version','1');
  33.  
  34. SELECT v.version FROM version v ORDER by v.date DESC LIMIT 1;
Add Comment
Please, Sign In to add comment