Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Kolt
  • Order by date
  1. Kolt

    It's possible to use an array variable in a stored procedure

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

    need help with data in cyrillic font

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

    Why blank spaces are entered into DB

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

    need help with data in cyrillic font

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

    How to Format DATE

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

    How to Format 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 )
  7. Kolt

    summertime/wintertime change

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

    obtaining tme a file was created

    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...
  9. Kolt

    Help

    you can do it in DTS-wizard when you create package
  10. Kolt

    Format DATEDIFF output

    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 )
  11. Kolt

    Easiest Clear All

    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...
  12. Kolt

    DROP COLUMN fails with constraint error

    ALTER TABLE Estimate_Site_AssetsAddList DROP constraint DF__Estimate_Site__D__2C8964E2 go ALTER TABLE Estimate_Site_AssetsAddList DROP column D go
  13. Kolt

    Win2k3 and DTS Folder access

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

    Absolute Beginner

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

    SQLServerAgent service hung on starting

    ** 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...
  16. Kolt

    problems with SQL server installation

    WinXP OS is not good for sql server, it's good for games etc. you should use win2000Server or NT4.0Server if u have ms sql 7.0
  17. Kolt

    Multiple deletes in one query

    impossible, in one delete stastment u can delete rows only from single table
  18. Kolt

    offtopic: is it possible to edit my posts in this forum

    2 SQLBill: that's too bad :( thanx for reply 2 administration: it should be fixed :)
  19. Kolt

    offtopic: is it possible to edit my posts in this forum

    maybe i've searched bad but i did't find this possibility
  20. Kolt

    Dts Between dbf and sql server problem

    >...and than tried to copy this column into another one (a >datetime column). please post how did u exactly tried it. if you used DTS then you should try it manually (make script), using Convert function to convert char values to data. probably some of data values was incorrect, for example...

Part and Inventory Search

Back
Top