|
 |
asp_databases thread: Query problem in MS- SQL Server
Message #1 by "Yadi Mulyadi" <BJS52@t...> on Fri, 1 Jan 1999 00:41:53 +0700
|
|
i got a problem when am using this query in MS-SQL Server and MS-Access
*****
Create Table a(
a1 integer NOT Null,
a2 char(50),
PRIMARY KEY (a1));
Create Table b(
b1 integer NOT Null,
a1 integer,
b2 char(50),
PRIMARY KEY (b1),
FOREIGN KEY (a1) REFERENCES a
ON DELETE CASCADE ON UPDATE CASCADE); // <- the MS-SQL server not
recognize this statement
*****
anyone know to replace "ON DELETE CASCADE ON UPDATE CASCADE" statement in
MS-SQL server or MS-Access ?
Thank in advance
M. YADI M.
bjs52@t...
----------------
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 21 Dec 2001 14:29:48 +1100
|
|
What version of SQL Server are you using?
Cascaded updates and deletes are not supported in SQL Server prior to SQL
Server 2000
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Yadi Mulyadi" <BJS52@t...>
Subject: [asp_databases] Query problem in MS- SQL Server
:
: i got a problem when am using this query in MS-SQL Server and MS-Access
:
: *****
:
: Create Table a(
: a1 integer NOT Null,
: a2 char(50),
: PRIMARY KEY (a1));
:
: Create Table b(
: b1 integer NOT Null,
: a1 integer,
: b2 char(50),
: PRIMARY KEY (b1),
: FOREIGN KEY (a1) REFERENCES a
: ON DELETE CASCADE ON UPDATE CASCADE); // <- the MS-SQL server not
: recognize this statement
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "Yadi Mulyadi" <BJS52@t...> on Fri, 1 Jan 1999 02:02:39 +0700
|
|
oh, am using SQL Server 7
Thanks
-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 21 Desember 2001 10:30
To: ASP Databases
Subject: [asp_databases] Re: Query problem in MS- SQL Server
What version of SQL Server are you using?
Cascaded updates and deletes are not supported in SQL Server prior to SQL
Server 2000
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Yadi Mulyadi" <BJS52@t...>
Subject: [asp_databases] Query problem in MS- SQL Server
:
: i got a problem when am using this query in MS-SQL Server and MS-Access
:
: *****
:
: Create Table a(
: a1 integer NOT Null,
: a2 char(50),
: PRIMARY KEY (a1));
:
: Create Table b(
: b1 integer NOT Null,
: a1 integer,
: b2 char(50),
: PRIMARY KEY (b1),
: FOREIGN KEY (a1) REFERENCES a
: ON DELETE CASCADE ON UPDATE CASCADE); // <- the MS-SQL server not
: recognize this statement
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
$subst('Email.Unsub').
|
|
|
View Cart
