Viewing 5 posts - 1 through 5 (of 5 total)
Good point about sorting when date is stored in character datatype. I used to get various date points (i.e. first day of month, last day, etc...) by stripping the Year(),...
October 27, 2005 at 6:26 am
Try something like:
Declare @FileFrom varchar(255),
@FileTo varchar(255),
@path varchar(255),
@OutputString varchar(500)
SELECT @path='C:\Program Files\Microsoft SQL Server\Backups\' --Or whatever your path is
SELECT @FileFrom =@path +'logname_2004-01-12. 300.trn'
SELECT @FileTo =@path +'logname3.trn'
select @OutputString= 'REN ' + '"'+...
February 11, 2005 at 12:18 pm
Excellent function!!
But as others have pointed out holidays will invariably need to be taken into account; we have a holiday table which (simplified version) is called HCD and has one...
January 10, 2005 at 9:39 am
Try This
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TempDBImpact]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[TempDBImpact]
GO
CREATE procedure dbo.TempDBImpact
@tab2bs varchar(100) = null ...
December 29, 2004 at 6:09 am
Check out 'sp_addlinkedserver' in SQL Books Online
December 23, 2004 at 5:57 am
Viewing 5 posts - 1 through 5 (of 5 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy