I need to delete a post - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Script Library

I need to delete a post

Author

Topic

logisticblazer
Starting Member

4 Posts

Posted - 2007-02-05 : 04:18:51

I need to delete a post by particular date and time, what is the syntax for that. anybody help

Articles on various categories

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-05 : 04:28:11

what post ? or do you mean a thread in this forum ?

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-05 : 04:31:34

"what is the syntax for that"

Delete P
From Posts p join Users u
on p.posterid = u.userid
where u.user_name = 'logisticblazer'
and p.posted_date = '20070502'

!!

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-05 : 04:35:30

Harsh, you forgot the time


Delete P
From Posts p join Users u
on p.posterid = u.userid
where u.user_name = 'logisticblazer'
and p.posted_date = '20070502 04:18:51'

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-02-05 : 04:40:38

Yeah..That too! Thanks khtan.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-05 : 05:31:07

Seriously if you want to delete a thread in this forumn, just open the thread and then click on the DELETE icon

Kristen
Test

22859 Posts

Posted - 2007-02-05 : 05:33:19

Can't do that if anyone has replied though, can you?

Kristen

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-02-05 : 05:39:00

Oh yeah. True true.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources