F1-F12 key 1 - 12
Shift F1-F12 key 13 - 24
Ctrl F1-F12 key 25 - 36
Ctrl+shift F1-F12 key 37 - 48
Home key 49
Up arrow key 50
Page Up key 51
(keypad) - key 52
Left arrow key 53
(keypad) 5 key 54
Right arrow key 55
(keypad) + key 56
End key 57...
BHARATH RS
Last Activity: Jun 17 '07, 03:01 PM
Joined: May 3 '07
Location:
-
Before oracle 8i there was only DECODE function. The main problem with DECODE is that we can compare only discrete values and not ranged values. So they introduced the CASE statements from oracle 8i onwards. This CASE was able to handle ranged values by using >, <, BETWEEN.
Hence the difference between the DECODE and CASE is that DECODE cannot be used handle Ranged values, whereas CASE is capleable of that.
...Leave a comment:
-
I hope ur question is like this
You have 2 database DB1 and DB2. You want to select Tab2 in DB2 while you are executing the query in DB1.
The query would be like this
Select *
From DB2.dbo.Tab2
the general syntax would be
Select <column1>,<colu mn2>.......
from <database_name> .dbo.<table_nam e>Leave a comment:
-
Hey u have analysis services in sql server 2000 which helps u to build data cubes over the table(s). Please check that if u have analysis service installed in ur machine.Leave a comment:
-
Hi,
I think its not going into an endless loop. The thing is that, since no join condition is provided it will be a cartesian product and if there are lot of rows in each of the tables it will take a lot of time to execute the above query.
The solution to ur problem is that have join conditions so that you filter out unwanted rows.Leave a comment:
-
You can use them in ur stored procedures. It mainly depends on the requirements.
here is a sample procedure for ur question
CREATE PROCEDURE Top_Customer AS
begin
Declare
@l_top_customer varchar(100)
set @l_top_customer = (select top 1cust_name from Bharath_Practis e.dbo.Cust_Reco rd)
print @l_top_customer
END
...Leave a comment:
No activity results to display
Leave a comment: