Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here's a collection of such nuggets for developing SQL ...
CREATE TABLE SequentialIdTable (A int identity, B uniqueidentifier DEFAULT NEWSEQUENTIALID()); CREATE TABLE IdTable (A int identity, B uniqueidentifier DEFAULT NEWID()); CREATE TABLE RowVersionTable ...
[7831 - Severity LOW - Make sure that you install the uuid-ossp extension to use the newid() function. Revise your database settings and try again.] SET scope_id = var_myParentScope, left_id = ...