Click here to Skip to main content
15,662,774 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to set the timer for SSIS package Pin
Marek Grzenkowicz19-Jul-08 9:50
Marek Grzenkowicz19-Jul-08 9:50 
Questionconvert datetime format Pin
tai-fun14-Jul-08 11:01
tai-fun14-Jul-08 11:01 
AnswerRe: convert datetime format Pin
Arindam Tewary14-Jul-08 22:09
professionalArindam Tewary14-Jul-08 22:09 
GeneralRe: convert datetime format Pin
tai-fun15-Jul-08 1:15
tai-fun15-Jul-08 1:15 
AnswerRe: convert datetime format Pin
leoinfo15-Jul-08 5:35
leoinfo15-Jul-08 5:35 
QuestionBULK INSERT and collation problem Pin
msx2314-Jul-08 10:56
msx2314-Jul-08 10:56 
AnswerRe: BULK INSERT and collation problem Pin
Syed Mehroz Alam15-Jul-08 1:08
Syed Mehroz Alam15-Jul-08 1:08 
QuestionWhere To Buy SQL 2000 Reporting Service? [modified] Pin
thundernow14-Jul-08 4:21
thundernow14-Jul-08 4:21 
AnswerRe: Where To Buy SQL 2000 Reporting Service? Pin
DerekFL14-Jul-08 7:51
DerekFL14-Jul-08 7:51 
QuestionFind Last week dates? Pin
Member 387988114-Jul-08 3:04
Member 387988114-Jul-08 3:04 
AnswerRe: Find Last week dates? Pin
subai14-Jul-08 3:21
subai14-Jul-08 3:21 
AnswerRe: Find Last week dates? Pin
leoinfo14-Jul-08 3:35
leoinfo14-Jul-08 3:35 
AnswerRe: Find Last week dates? Pin
TheFM23414-Jul-08 6:26
TheFM23414-Jul-08 6:26 
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 

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.