Re: New to SQL server


aaron.kempf@xxxxxxxxx wrote:
CREATE TABLE OrgChart (
employeeID INTEGER NOT NULL UNIQUE,
manager_employeeID INTEGER
REFERENCES OrgChart (employeeID)
ON DELETE SET NULL
ON UPDATE CASCADE);

wouldn't work in SQL Server since I don't have a table named OrgChart

Try reading that again (hint: CREATE TABLE OrgChart...?)

how about this.. Right-Click CREATE SCRIPT for all your MDB tables and
queries LoL

Have you seen the code it writes: proprietary syntax, weird casing,
peppered with parens and brackets, ...yuk! I have my own tool that
works on both Jet and SQL Server, SQL-92 standard syntax where
possible, SQL keywords in uppercase, etc. Lovely.

dude what about when you need to split your backend into multiple files
because you get a single table that is approaching 1gb?

I can assure you, sir, my backend does not require splitting. ROFL.

Jamie.

--

.

Relevant Pages

  • Re: New to SQL server
    ... employeeID INTEGER NOT NULL UNIQUE, ... REFERENCES OrgChart (employeeID) ... wouldn't work in SQL Server since I don't have a table named OrgChart ...
    (microsoft.public.access.adp.sqlserver)
  • Re: New to SQL server
    ... yeah with MDB you have to 'write your own EVERYTHING' ... with SQL Server you dont need to do this; there aren't work arounds for ... wouldn't work in SQL Server since I don't have a table named OrgChart ...
    (microsoft.public.access.adp.sqlserver)