Home » RDBMS Server » Server Administration » SET with SQL 6.5
SET with SQL 6.5 [message #374328] Tue, 05 June 2001 21:53
astroalien
Messages: 1
Registered: June 2001
Junior Member
Hi there,

I am having trouble with the 3 set statements below when I try to run the script the SET lines are giving me problem.

DECLARE @dateString VARCHAR(10), @dateVal datetime, @purge_date VARCHAR(8)
SET @dateVal = GETDATE() - @numDays
SET @dateString = CONVERT (varchar(10),@dateVal,121)
SET @purge_date = Replace(@dateString,"-","")

Report message to a moderator

Previous Topic: Re: How to insert single quote (') in the row of table
Next Topic: need help with query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 12:31:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.