Click here to Skip to main content
15,608,671 members
Home / Discussions / Database
   

Database

 
JokeRe: Find Last week dates? Pin
leoinfo14-Jul-08 18:27
leoinfo14-Jul-08 18:27 
GeneralRe: Find Last week dates? Pin
TheFM23415-Jul-08 3:24
TheFM23415-Jul-08 3:24 
GeneralRe: Find Last week dates? [modified] Pin
Member 387988114-Jul-08 18:47
Member 387988114-Jul-08 18:47 
QuestionHow to write query Pin
BalasubramanianK14-Jul-08 0:23
BalasubramanianK14-Jul-08 0:23 
AnswerRe: How to write query Pin
TheFM23414-Jul-08 6:53
TheFM23414-Jul-08 6:53 
GeneralRe: How to write query Pin
BalasubramanianK14-Jul-08 18:17
BalasubramanianK14-Jul-08 18:17 
QuestionDelete Query Pin
sjs4u14-Jul-08 0:10
sjs4u14-Jul-08 0:10 
AnswerRe: Delete Query Pin
subai14-Jul-08 0:29
subai14-Jul-08 0:29 
if you want to remove only from one table you can use this
DELETE FROM TABLE_1 WHERE ID IN (SELECT ID FROM TABLE_2)

or
DELETE FROM Table_1
FROM         Table_2 AS t2 INNER JOIN
                      Table_1 as t1 ON t1.ID = t2.ID

but i don't know if it's possible to remove records from 2 different tables by one single query

I Wish the Life Had CTRL-Z
Wizard's First Rule : People are fool,they believe what they want to believe or what they afraid to believe
www.subaitech.blogspot.com

AnswerRe: Delete Query Pin
Declan Bright14-Jul-08 1:19
Declan Bright14-Jul-08 1:19 
AnswerRe: Delete Query Pin
TheFM23414-Jul-08 7:20
TheFM23414-Jul-08 7:20 
QuestionAccessing multiple result sets from a stored procedure Pin
Rashmi Deshpande13-Jul-08 23:56
Rashmi Deshpande13-Jul-08 23:56 
AnswerRe: Accessing multiple result sets from a stored procedure Pin
Declan Bright14-Jul-08 1:26
Declan Bright14-Jul-08 1:26 
QuestionError message in Stored procedure Pin
IamAmit13-Jul-08 23:21
IamAmit13-Jul-08 23:21 
AnswerRe: Error message in Stored procedure Pin
leoinfo14-Jul-08 2:54
leoinfo14-Jul-08 2:54 
AnswerRe: Error message in Stored procedure Pin
TheFM23414-Jul-08 6:31
TheFM23414-Jul-08 6:31 
QuestionAutomate database backup ? Pin
rajg8213-Jul-08 22:03
rajg8213-Jul-08 22:03 
AnswerRe: Automate database backup ? Pin
Syed Mehroz Alam14-Jul-08 0:51
Syed Mehroz Alam14-Jul-08 0:51 
AnswerRe: Automate database backup ? Pin
leoinfo14-Jul-08 3:10
leoinfo14-Jul-08 3:10 
QuestionSQL SERVER DATABASE Pin
Anubhava Dimri13-Jul-08 21:54
Anubhava Dimri13-Jul-08 21:54 
AnswerRe: SQL SERVER DATABASE [modified] Pin
Syed Mehroz Alam14-Jul-08 0:42
Syed Mehroz Alam14-Jul-08 0:42 
Questiongeneralized statements for update delete insert Pin
santosh04213-Jul-08 21:37
santosh04213-Jul-08 21:37 
AnswerRe: generalized statements for update delete insert Pin
Ashfield14-Jul-08 1:14
Ashfield14-Jul-08 1:14 
GeneralRe: generalized statements for update delete insert Pin
santosh04214-Jul-08 4:11
santosh04214-Jul-08 4:11 
AnswerRe: generalized statements for update delete insert Pin
leoinfo14-Jul-08 4:27
leoinfo14-Jul-08 4:27 
Questionconnection string Pin
nelsonpaixao13-Jul-08 15:06
nelsonpaixao13-Jul-08 15:06 

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.