Re: needed: 1 + null = 1 (Correction)

On 31.05.2007 10:21, info@xxxxxxxxxxx wrote:
Robert, it does make sense and the schema is build dynamically.

If you say so... To me this rather sounds like a case for

CREATE TABLE PARAMETERS (
item INT NOT NULL,
parameter_name VARCHAR(20) NOT NULL,
parameter_value INT NOT NULL,
PRIMARY KEY (
item,
parameter_name
)
)

Of course I don't know all the details...

Kind regards

robert
.

Relevant Pages

  • Re: Storing Users/Groups
    ... websites can interface with this setup. ... > returns @outtable table (root_node int, group_key int, primary key ... > --40 members are members of 50 ... PRIMARY KEY, ...
    (microsoft.public.sqlserver.programming)
  • Re: Storing Users/Groups
    ... returns @outtable table (root_node int, group_key int, primary key ... --40 members are members of 50 ... PRIMARY KEY, FOREIGN KEY REFERENCES, ... Is it still possible to query all users of the websites with this additional functionality? ...
    (microsoft.public.sqlserver.programming)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I'm just trying to differentiate between two fundamentally different SQL objects. ... CREATE TABLE P(pk INT NOT NULL PRIMARY KEY, ... SELECT MAXFROM nestedview ...
    (comp.databases.ms-sqlserver)
  • Re: Adding new object to Typed Data Set and return the primary key
    ... CAST(TS AS INT) AS TS FROM AgencyNET.Office " + ... public TypedDataObjectProject newProject() { ... returning the new Primary Key value. ... on the singleton which then creates a new table adapter. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Database Design Question
    ... What you call a "single primary key" is known as a "surrogate key". ... > LanguageId int identitynot null, ... > HeadingId int identitynot null, ... > REFERENCES tbBrochure, ...
    (microsoft.public.sqlserver.server)