Click here to Skip to main content
16,020,567 members
Home / Discussions / Database
   

Database

 
AnswerRe: stored procedure syntax error Pin
_AK_2-Nov-06 1:10
_AK_2-Nov-06 1:10 
QuestionRange of serial numbers Pin
Imtiaz Murtaza1-Nov-06 20:25
Imtiaz Murtaza1-Nov-06 20:25 
AnswerRe: Range of serial numbers Pin
Paddy Boyd2-Nov-06 3:01
Paddy Boyd2-Nov-06 3:01 
AnswerRe: Range of serial numbers Pin
Eric Dahlvang2-Nov-06 3:58
Eric Dahlvang2-Nov-06 3:58 
Questionms sql 2005 and ms sql 2000 Pin
uglyeyes1-Nov-06 17:29
uglyeyes1-Nov-06 17:29 
QuestionUniversal Table Editor by Wellige Pin
Greg2781-Nov-06 14:14
Greg2781-Nov-06 14:14 
QuestionConversion of SQL DB 2005 to 2000 Pin
kaliem1-Nov-06 11:20
kaliem1-Nov-06 11:20 
Questioncascading deletes Pin
neilsolent1-Nov-06 9:52
neilsolent1-Nov-06 9:52 
Hi I run what I thought was the most basic example of a table that allows a cascading delete:

CREATE TABLE TEST
(
ID tinyint NOT NULL,
PARENT_ID tinyint NULL,
CONSTRAINT PK PRIMARY KEY (ID),
CONSTRAINT FK FOREIGN KEY (PARENT_ID) REFERENCES TEST(ID) ON DELETE CASCADE
)
go

I get the error:

Introducing FOREIGN KEY constraint 'FK' on table 'TEST' may cause
cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO
ACTION, or modify other FOREIGN KEY constraints.
Msg 1750, Level 16, State 0, Server PEER170, Line 5

What am I doing wrong???


cheers,
Neil

AnswerRe: cascading deletes Pin
Rob Graham1-Nov-06 10:41
Rob Graham1-Nov-06 10:41 
GeneralRe: cascading deletes Pin
neilsolent2-Nov-06 21:39
neilsolent2-Nov-06 21:39 
QuestionUsing DTSWizard.exe to copy multiple tables Pin
Alice@mywonderland1-Nov-06 9:31
Alice@mywonderland1-Nov-06 9:31 
QuestionDate Format as dd/mm/yyyy Pin
fahiemulleh1-Nov-06 9:14
fahiemulleh1-Nov-06 9:14 
AnswerRe: Date Format as dd/mm/yyyy Pin
Rob Graham1-Nov-06 9:42
Rob Graham1-Nov-06 9:42 
AnswerRe: Date Format as dd/mm/yyyy Pin
Eric Dahlvang1-Nov-06 12:20
Eric Dahlvang1-Nov-06 12:20 
AnswerRe: Date Format as dd/mm/yyyy Pin
Colin Angus Mackay3-Nov-06 0:05
Colin Angus Mackay3-Nov-06 0:05 
QuestionReporting Services Pin
SJR_11-Nov-06 8:17
SJR_11-Nov-06 8:17 
QuestionSQL Server 2000 to 2005 Pin
Michael P Butler1-Nov-06 7:22
Michael P Butler1-Nov-06 7:22 
AnswerRe: SQL Server 2000 to 2005 Pin
Rob Graham1-Nov-06 9:46
Rob Graham1-Nov-06 9:46 
GeneralRe: SQL Server 2000 to 2005 Pin
kaliem1-Nov-06 10:29
kaliem1-Nov-06 10:29 
GeneralRe: SQL Server 2000 to 2005 Pin
Rob Graham1-Nov-06 12:31
Rob Graham1-Nov-06 12:31 
QuestionRight Outer Joins : Please help Pin
shivarishxxxx1-Nov-06 7:05
shivarishxxxx1-Nov-06 7:05 
QuestionBackup database to CSV files Pin
hasanali001-Nov-06 0:43
hasanali001-Nov-06 0:43 
Questioncopy dataset to dataset Pin
K edar V1-Nov-06 0:31
K edar V1-Nov-06 0:31 
QuestionCombining Columns In A ResultSet Pin
Samuel G31-Oct-06 22:14
Samuel G31-Oct-06 22:14 
AnswerRe: Combining Columns In A ResultSet Pin
Private_Void1-Nov-06 5:20
Private_Void1-Nov-06 5:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.