Results 1 to 22 of 22
Thread: 2 - .
Hybrid View
-
8th October 2009 19:51 #1
2 - .
1 :
SQL SERVER , :
char,varchar text.ext .
.
2. :
:
-.
-().
-.
, .
, , .
-
8th October 2009 20:09 #2Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
1. . . ntext unicode, varchar(max) ...
2. . double - . DATEDIFF(...) datetime int, decimal, float. ... double integer - - , " " . : http://msdn.microsoft.com/en-us/libr...7(SQL.80).aspx
: . .prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
8th October 2009 20:38 #3
.
1. , ( , 99.99% , ) , , , , .
2. , , .
, .: . .
-
8th October 2009 23:20 #4Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
1. : http://msdn.microsoft.com/en-us/library/ms187993.aspx . , . . MSSQL , MSSQL 2008 ( MSSQL 2000, 2 - ).
2. datetime - : http://msdn.microsoft.com/en-us/library/ms187752.aspx
3. , . :
...... ,
, , ............
Last edited by DiadoMraz; 8th October 2009 at 23:26.
prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
8th October 2009 23:33 #5
-
14th October 2009 18:01 #6Registered User
Join Date: Jul:2005
Location: Sofiq
Posts: 2,798
unix timestamp. , ( ). range, / 2 DATETIME .
-
14th October 2009 18:34 #7Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
.
-
14th October 2009 19:14 #8Registered User
Join Date: Aug:2006
Location:
Posts: 4,052
, *nix
-
14th October 2009 20:31 #9
-
14th October 2009 22:56 #10
-
14th October 2009 20:30 #11
, datetime .
, , .
datetime -> ..
... , - foreign keys, .
, ...
, , int(11) 0/1 ...
Hey, mother, I come bearing a gift. I'll give you a hint. It's in my diaper and it's not a toaster.
.
-
14th October 2009 22:16 #12
19 2038 DB , - - DB backend-. - - , time_t 4 expansion...
, ( : 4 ), . .
"640K ught to be enough for anybody" - Bill Gates, 1981
::Machine specs::Fract::AGG::::Baileys::blog::YouTube channel
-
15th October 2009 01:40 #13
-
15th October 2009 04:19 #14Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
- - . datetime . .net-a DateTime TimeSpan . int - , . , .. -
. , - - .
int, double *char , . XML .. -
prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
15th October 2009 04:31 #15
, - - .
- , , record ,
, . .
"640K ught to be enough for anybody" - Bill Gates, 1981
::Machine specs::Fract::AGG::::Baileys::blog::YouTube channel
-
15th October 2009 08:43 #16Registered User
Join Date: Aug:2006
Location:
Posts: 4,052
-
17th October 2009 19:40 #17Registered User
Join Date: Jul:2005
Location: Sofiq
Posts: 2,798
MySQL, DATEDIFF TIMEDIFF , 400 /, . , , int. : " 1 , 10 , 1 2 ..." / , : TIMEDIFF .
Edit: DATEDIFF , TIMEDIFF e 838:59:59. , 2 , , () .
int :
2 : dt: DATETIME, dt_unix INT.
2 , 2 000 000Code:EXPLAIN SELECT * FROM `test_table` FORCE INDEX ( dt_unix ) WHERE UNIX_TIMESTAMP( ) -172800000 > dt_unix SIMPLE test_table range dt_unix dt_unix 4 NULL 1 Using where EXPLAIN SELECT * FROM `test_table` FORCE INDEX ( dt ) WHERE DATEDIFF( NOW( ) , dt ) >2000 SIMPLE test_table ALL NULL NULL NULL NULL 2 Using where EXPLAIN SELECT * FROM `test_table` FORCE INDEX ( dt ) WHERE DATE_SUB( NOW( ) , INTERVAL 2000 DAY ) > dt SIMPLE test_table range dt dt 8 NULL 1 Using where
200 000 . , e MySQL-a. " > ", (range). DATETIME , .
Last edited by _ShadoW_; 17th October 2009 at 21:11.
-
18th October 2009 06:48 #18Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
-
15th October 2009 06:22 #19Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
.
prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
15th October 2009 14:04 #20Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
XML-a ? XML . .
prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?
-
15th October 2009 14:49 #21Registered User
Join Date: Aug:2006
Location:
Posts: 4,052
exist-db

/ . , full-text indexing .
-
15th October 2009 18:52 #22Registered User
Join Date: Oct:2006
Location: Plovdiv
Posts: 305
... full-text XML , ( ) XML . !
- datetime full-text indexing XML :
select invoice_date, sum(invoice_total)
from invoices
where invoice_date >= '2009-01-01' and invoice_date < '2009-06-01'
group by invoice_date
?
200,000 ( ) .Last edited by DiadoMraz; 17th October 2009 at 03:10.
prepBut nI vrbLike adjHungarian! qWhat's artThe adjBig nProblem?




Reply With Quote
? ...
.


Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in