Total number of rows or records. e.g. We have a set with 10 elements. We need to find the Percentile_Disc of the 7th row.Let us first find the Cumulative_distribution as So, Cumulative_Distribution = (7)/(10) = 0.7 So, Percentile_Disc = Cumulative_...

Oracle Nested Table Collection Type We can make composite datatypes in oracle that will hold multiple values of the same type. These composite types are known as collections.There are basically 3 types of collections in oracle VArray Nested Table...

Comapare string using CheckSum and binary_CheckSum method....

Reset Identity Column use CHECKIDENT Command...

Change Table Name Using sp_Rename Procedure...

This is third blog on security concept in WCF. You can read previous posts: Something about Security in WCF- I Implement windows authentication and security in WCF Service Today I’ll describe how we can implement role ...

This is in continuation to my series on the Underappreciated features of Microsoft SQL Server. The series has been inspired from Andy Warren’s editorial on SQLServerCentral.com of the same name. After a number of posts on my visit to Tech-Ed 2011 (Indi...

This is a setting that DBA are advised to place at the start of the stored procedure. What this setting does? Let us run an sample code for this. USE AdventureWorks GO SELECT * FROM Person.Address SET NOCOUNT ON SELECT * FROM Person.Addre...

Before we directly jump to the topic, I would like to give a basic introduction of SELECT..INTO statement. As, we know that, select into statement can be used to create new table with same table structure and to insert a base table rows in new table. W...

We can use SPACE function to replicate spaces for a string. Consider the following statement select 'A'+space(10)+'B' The result is ------------ A B As you see space function adds 10 spaces between the string A and B. Note that the s...