sql server 2005 - deleting rows from multiple tables at a time with a single query in sqlserver2005? -

-

i wanna delete 2 rows 2 tables foreign key related how can delete 2 rows 2 tables @ time using single delete statement. can body me posting example?

look: deleting records multiple tables @ time single query in sqlserver2005


Comments

Post a Comment

Popular posts from this blog

Python __call__ special method practical example -

-
i know __call__ method in class triggered when instance of class called. however, have no idea when can use special method, because 1 can create new method , perform same operation done in __call__ method , instead of calling instance, can call method. i appreciate if gives me practical usage of special method. django forms module uses __call__ method nicely implement consistent api form validation. can write own validator form in django function. def custom_validator(value): #your validation logic django has default built-in validators such email validators, url validators etc., broadly fall under umbrella of regex validators. implement these cleanly, django resorts callable classes (instead of functions). implements default regex validation logic in regexvalidator , extends these classes other validations. class regexvalidator(object): def __call__(self, value): # validation logic class urlvalidator(regexvalidator): def __call__(self, valu...
Read more

Java - Combining two arrays? -

-
what i'm trying ask user list of items, , create 2 arrays - 1 itemname , 1 itemprice. program right deals itemprice , there's no indication of how can combine 2 arrays in 1 output list of both arrays combined, this: bread - 1.20 milk - 2.00 here have far, 2 arrays, name array isn't included in anything. thanks! public class taxclass { private input newlist; /** * constructor objects of class tax * enter number of items */ public taxclass(int anyamount) { newlist = new input(anyamount); } /** * mutator method add items , cost * enter sales tax percentage */ public void additems(double anytax){ double salestax = anytax; newlist.setarray(salestax); } } public class input { private scanner keybd; private string[] costarray; private string[] itemarray; /** * constructor objects of class scanner */ public input(int anyamountofitems) { keybd = new scanner(system.in); costarray = new string[anyamountofitems]; itemarray = new string[an...
Read more