SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 Script Library
 I need to delete a post		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

logisticblazer
Starting Member

USA
4 Posts
Posted - 02/05/2007 :  04:18:51  Show Profile  Reply with Quote
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)

Singapore
16746 Posts
Posted - 02/05/2007 :  04:28:11  Show Profile  Reply with Quote
what post ? or do you mean a thread in this forum ?

KH
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts
Posted - 02/05/2007 :  04:31:34  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
"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"
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts
Posted - 02/05/2007 :  04:35:30  Show Profile  Reply with Quote
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'


KH
Go to Top of Page

harsh_athalye
Flowing Fount of Yak Knowledge

India
5509 Posts
Posted - 02/05/2007 :  04:40:38  Show Profile  Visit harsh_athalye's Homepage  Click to see harsh_athalye's MSN Messenger address  Send harsh_athalye a Yahoo! Message  Reply with Quote
Yeah..That too! Thanks khtan.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts
Posted - 02/05/2007 :  05:31:07  Show Profile  Reply with Quote
Seriously if you want to delete a thread in this forumn, just open the thread and then click on the DELETE icon

KH
Go to Top of Page

Kristen
Test

United Kingdom
22191 Posts
Posted - 02/05/2007 :  05:33:19  Show Profile  Reply with Quote
Can't do that if anyone has replied though, can you?

Kristen
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts
Posted - 02/05/2007 :  05:39:00  Show Profile  Reply with Quote
Oh yeah. True true.

KH
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000