need a stored procedure...............

Question

Post reply

need a stored procedure...............

espanolanthony

SSCarpal Tunnel

Points: 4204
More actions
October 28, 2009 at 8:00 am

#139708

Hello friends can someone get me a stored procedure to delete some data from a table if we give a particular date in the parameter. anything is ok.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Animal Magic SSChampion Points: 13964 More actions · Answer 1

umm thats fairly generic...

create procedure USP_DeleteMyData

@date datetime

as

Delete from MyTable where MyDate = @date

go

espanolanthony SSCarpal Tunnel Points: 4204 More actions · Answer 2

espanolanthony

SSCarpal Tunnel

Points: 4204

October 28, 2009 at 8:13 am

#1071755

no that does not work

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 3

Take this and move it to a procedure:

DECLARE

@table VARCHAR(100)

,@date VARCHAR(30)

,@sql VARCHAR(1000);

SELECT

@table = 'mytable'

,@date = '1901-01-01';

SELECT

@sql = 'DELETE FROM ' + @table + ' WHERE AnyColumn < ''' + @date + '''';

PRINT (@sql);

-- EXECUTE (@sql);

Greets

Flo

espanolanthony SSCarpal Tunnel Points: 4204 More actions · Answer 4

so where should be the create procedure statement be. sorry for that but i i totally blank.

Animal Magic SSChampion Points: 13964 More actions · Answer 5

espanolanthony (10/28/2009)
no that does not work

what do you mean it doesnt work??

i assume you replaced the MyTable with your tablename?

homebrew01 SSC Guru Points: 55548 More actions · Answer 6

espanolanthony (10/28/2009)
so where should be the create procedure statement be. sorry for that but i i totally blank.

Look at CREATE PROCEDURE in Books On Line (BOL)

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 7

Hi

I really don't think it makes sense that you just get any statements from here you don't understand. Please have a look to CREATE PROCEDURE. You really should know what you are doing (especially if you want to manipulate data).

Greets

Flo