Welcome to Sign in | Help
» Search

Search

You searched for the word(s):
Showing page 51 of 68 (674 total posts) < 1 second(s)
  • Re: Cum leg ""Miercuri" de un datetime?

    Iata si o metoda (independenta de ''datefirst'') descrisa de Itzik Ben - Gan in ''Inside Microsoft SQL Server 2005 T-SQL Programming'': SELECT RecordID FROM Table WHERE DATEDIFF(day, '19000101', RecordDate) % 7 = 0 Codul de mai sus ''intoarce'' toate inregistrarile create luni. Folosesti faptul ca 1 ianuarie 1900 a fost intr-o luni, iar ...
    Posted to T-SQL (Forum) by Diana on September 22, 2007
  • Re: Convert() !

    Daca datele provin dintr-un import, nu poti ''aranja'' sa importi campul respectiv intr-o coloana de tip numeric? Asa ai scapa de ''ocol''. &nbsp;
    Posted to Intrebari (Forum) by Diana on September 21, 2007
  • Re: Convert() !

    SELECT MIN(CAST(REPLACE(coloana, ',', '.') AS float)) FROM tabel functioneaza... Folosesc CAST pentru ca minimul sa fie ''ales'' dintre valori numerice. Altfel poti sa alegi un ''minim'' si dintre valori varchar, dar ele vor fi sortate alfabetic...
    Posted to Intrebari (Forum) by Diana on September 21, 2007
  • Re: Convert() !

    M-am referit la virgula din ''0,000199''. Incearca sa ''replace'' vrgula cu un punct, deci cam: SELECT MIN(CAST(x AS float)), unde x = REPLACE(coloana, ',', '.')&nbsp; * Nu-i grozav, este doar ''quick and dirty'' &nbsp;
    Posted to Intrebari (Forum) by Diana on September 21, 2007
  • Re: Convert() !

    Jourjaque:...iar in sql am gasit doar cast si convert dar exec. CONVERT ( coloana , float ) nu merge .... se aplica doar ptr 1 singura valoare ! &nbsp; ...nu prea inteleg ''se aplica ptr 1 singura valoare''... Incearca SELECT MIN(CAST(coloana AS float)) FROM Tabel * Vad ca in exemplul tau folosesti virgula, nu punct zecimal. Atentie si la ...
    Posted to Intrebari (Forum) by Diana on September 21, 2007
  • Re: import din firebird

    Incearca sa exporti din Firebird in text / csv si apoi sa folosesti ''flat file source'' in ''import export wizard''. La o ''survolare'' rapida a documentatiei de pe http://www.firebirdsql.org/pdfmanual/Firebird-2.0-QuickStart.pdf nu m-am lamurit daca Firebird ofera ''tools'' de import / export de date, dar am gasit pe Google utilitare ...
    Posted to Intrebari generale (Forum) by Diana on September 18, 2007
  • Re: DTS import.

    SQL 2000 sau SQL 2005?
    Posted to Intrebari (Forum) by Diana on September 17, 2007
  • Re: dts packages in sql 2000

    Pachetele SSIS au ''din fabricatie'' (---&gt; template-ul ''Integration services project'' din VS) format ''dtsx''. SSIS ofera suport pentru pachetele DTS - exista de exemplu task-ul ''Execute DTS 2000 package'' - pachetul DTS poate fi executat, insa nu poate fi modificat cu designerul din VS. Nu poti sa ''faci'' un pachet DTS 2000 folosind ...
    Posted to Business Intelligence - Extract,Transform,Load(ETL) (Forum) by Diana on September 11, 2007
  • Re: dts packages in sql 2000

    Gasesti informatie destul de multa si de amanuntita si in Books Online pentru SQL 2000.
    Posted to Business Intelligence - Extract,Transform,Load(ETL) (Forum) by Diana on September 11, 2007
  • Re: Only functions and extended stored procedures can be executed from within a function.

    Bogdan, am citat artocolul de pe MSDN pentru ca ''listeaza'' niste limitari ale functiilor, si anume: &nbsp;''# Functions can't execute stored procedures. A function can only execute functions and some xp's, but not sp's. This limitation immediately disqualifies function as a candidate for solving use cases 1 and 3. # Functions can't create ...
    Posted to Intrebari (Forum) by Diana on September 6, 2007
« First ... < Previous 49 50 51 52 53 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems