|
|
-
|
|
Let Us Learn Oracle - Part 16 of N [ Greatest and Least function in Oracle ]
Source table: tblStudents
Purpose: Finds the Greatest and the Least number from a range of numbers
Example of Greatest function
SQL> Select Greatest(10,20,4,56,234,999,12,56,-45,23,77,123) GreatestNumber From Dual;......
|
|
-
|
|
Let Us Learn Oracle - Part 12 of N [ NVL function in Oracle ]
Source table: tblPlayers
Purpose: It substitute a value when a null value is encountered.
Syntax: NVL( ColumnName, ReplaceValue )
Where,
ColumnName => It is the column that is use for null value test.
ReplaceValue => Value that w......
|
|
-
|
|
Select PlayerID,BelongsTO,Width_Bucket(Sum(FeePerMatch),100,5000,10) Bucket From tblplayers Group By PlayerID,BelongsTO Order By PlayerID;
PLAYERID BELONGSTO BUCKET
---------- ---------- ----------
1 India 4
2 India 2
3 India ......
|
|
-
|
|
Let Us Learn Oracle - Part 6 of N [ RPad and LPad function in Oracle ]
Source table: tblPlayers
RPad
Syntax: RPad(InputString,length,[,set])
Purpose: Pads the right side of the column with the given character. It fills the display to the given length. If InputString is longer than length, s......
|
|
-
|
|
Let Us Learn Oracle - Part 5 of N [ InStrb function in Oracle ]
Source table: tblPlayers
Syntax: InStrB(char1,char2 [,n[,m]])
Purpose: It searches the string argument char1, beginning with it's nth byte , for the mth occurance of string argument char2
Example 1:
SQL> select PlayerLastName,In......
|
|
-
|
|
An Introduction to SSIS Balanced Data Distributor Transformation Component
Table of Content
Introduction
How it Works
Adding Balanced Data Distributor(BDD) in the SSIS toolbox
Let us look an example
When to use the BDD
References
Conclusion
Introduction
Microsoft has released ......
|
|
-
|
|
Lag Function
Purpose: This function returns result set starting from the previous row in the table.
Syntax: Lag(expression [,offset [,default] ] ) over( [ Partition_By_clause] order by clause)
Where,
Expression => A table column or built-in function but not analytical functions
Offset => It i......
|
|
-
|
|
In Denali (SQL Server 2012) CTP 3, the Over clause has been enhanced a lot. Let us look into them as below
a.Rows and Range
These keywords specifies that the function will be applied for every row a window use for calculating the function result. The Rows specifies the window in physical units wh......
|
|
-
|
|
lstPlayers.Add(new Players
{
PlayerId = i
,
......
|
|
-
|
|
As the name suggests, it concatenates strings. In earlier versions of Sql Server we have the option of performing concatenation using the '+' symbol. But the overhead was that if the types that are participating in the concatenation are not of varchar type, then we had to do explicit conversion else......
|
|