Results 1 to 9 of 9
Thread: MSSQL
Hybrid View
-
29th January 2007 16:33 #1
MSSQL
, MSSQL SQL , . , .
:
, , ( , ).Code:SELECT *, data AS Expr1 FROM PROVERKA WHERE (data = 'Jun 9 2006')
Excel, ? *, , .... , ,
, ... ?
-
29th January 2007 17:19 #2
SELECT *, data AS Expr1
FROM PROVERKA
WHERE data between '2006-01-01' and '2007-01-01'
, .Ar4i
-
30th January 2007 18:50 #3
-
23rd October 2008 15:34 #4
. :
, Table2 , .Code:SELECT *, Table1.[] AS Expr1 FROM Table1, Table2 WHERE Table1.[] <> Table2.[] AND Table1.[] = Table2.[]
, , 1 -1 , 1 1 -2 . , .
.: , (<>) .... , ,
, ... ?
-
29th January 2007 21:59 #5Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
SQL MS SQL ,
SELECT * FROM <table> WHERE time > '13:00:00' ( ).
, WHERE data > '06-09-2006' - .
-
23rd October 2008 16:14 #6Registered User
Join Date: Oct:2003
Location:
Posts: 4,317
, , ?
-
24th October 2008 09:19 #7
-
23rd October 2008 17:35 #8Mire-x
Join Date: Apr:2005
Location: Sofia
Posts: 763
select *, table1.[] as expr1
from table1, table2
where abs(table1.[]) <> abs(table2.[])
and abs(table1.[]) = abs(table1.[])
abs(expr) ... ? , abs(-1) abs(1) 1.
(10b) || !(10b)
-
24th October 2008 09:52 #9Mire-x
Join Date: Apr:2005
Location: Sofia
Posts: 763
, , , .
-, abs().
(10b) || !(10b)




Reply With Quote

07.05.23 ., 16:02 in PC