Recent content by Kolt

u can't but why do u need arrays? u can create temporary tables - it's much more convenient.. create table #t1 ( f1 int, ..... )

if all other languages are Latin based then you can during installation of sql server set Server Collation - Cyrillic_General

because your field has type CHAR(12) you shoulD use type VARCHAR(12)

what do you mean 'handle cyrillic font in a table' ? more details please

use DISTINCT to elaminate duplicates: select distinct date from table order by date

Anyone knows a function which chooses the records with the maximum date; ie: most recent out of duplicate records? - ....where date = ( select max(date) from table )

it depends on Windows settings : Control Panel->Date/Time->Time Zone->automaticly ajust...

DECLARE @FilePath varchar(250) DECLARE @FileName varchar(250) DECLARE @Year varchar(4) DECLARE @FileDate varchar(10) SET @FilePath = 'c:\FilePath\' SET @FileName = 'FileName.Ext' SET @Cmd = 'dir ' + @FilePath + @FileName INSERT INTO #FileDate EXEC master.dbo.xp_cmdshell @Cmd SELECT...

you can do it in DTS-wizard when you create package

so what's the problem with DATEDIFF? use 'Convert' to get datetime value of 26/08/2003 13:55, 18/08/2003 14:00 and then DATEDIFF ( datepart , startdate , enddate )

create table #myTables ( TableID int primary key identity (1,1) ,TableName varchar(200) ) insert into #myTables ( TableName ) select Name from sysobjects where Type = 'U' declare @iter int, @max int, @name varchar(200) select @max = max(TableID) from #myTables select @iter = 1 while @iter...

ALTER TABLE Estimate_Site_AssetsAddList DROP constraint DF__Estimate_Site__D__2C8964E2 go ALTER TABLE Estimate_Site_AssetsAddList DROP column D go

and if the folder is locally on the server does it work? if does then it's probably security politics problem

guys! could any of you send me black book please? syd@ufpb.ru thanx

** Is there a time-out value that I can increase so the Agent can start without first giving this message? yesy there is. open EM -> SQL Server Group -> YourServer -> Management -> right click SQL Server Agent -> properties-> Connection -> Login timeout ** what could be causing the...