skip to main
|
skip to sidebar
Pages
Home
About Me
Technical Dreams...
Ads 468x60px
Social Icons
Thursday, 27 October 2011
Age Calculation
Hi,
In most of the project we need to calculate the age.
Consider below TSQL to calculate age, it should be used where age needs to be displayed.
SELECT
CAST
((
DATEDIFF
(
dd
,
<date_of_birth>
,
GETDATE
())/
365.25
)
AS
INT
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Social Icons
Powered by
Blogger
.
Popular Posts
Allow only numeric character in JavaScript
Hi, Here is the example code of Javascript which allows you to type only numeric value in a textbox. Here is the features of this code...
SSRS Interview Questions II
1. What does rdl stand for? RDL stand for Report Definition Language. RDL is the extension for reports file. 2. What is Report Manag...
Simple tricks in SQL-Server
Here I am going to explain some cool tricks in SQL-Server. Trick 1: Code Wrap Some times will see our code is going to beyond the...
Strikethrough selected text JavaScript
Here is code which shows how to strike though the selected text in textbox using JavaScript. < script type ="text/java...
Find Duplicate Entry
In this way we can find duplicate entry in the database -- create table for test data create table test_data ( id int, product char(1...
Retrieve the Image From the Database
If we want to retrive the image from the database then first we pick the image from the database and then convert it into the image : Here...
Ranking Function
We have four types of ranking function in sql server 1.) row_number 2.) rank 3.) dense_rank Row_Number() Function The ROW_NUMBER(...
Calendar In Sql Server Reporting Services.
In SSRS there is no any option by which we can create the calender in the reports but this thing can be done using SQL-Server here I am giv...
Manipulate Header and Footer values at each page
Generally in SSRS Header and Footer value is same for a report. Sometime we require to show different value in the footer or header on the ...
Split the comma separated value
Some times we have some values with the delimiter and we need to split that value with the that delimiter and need that value in the column...
Followers
Archive
►
2015
(5)
►
September
(1)
►
August
(1)
►
April
(1)
►
March
(2)
►
2014
(18)
►
December
(1)
►
November
(1)
►
September
(2)
►
July
(2)
►
May
(5)
►
March
(1)
►
February
(3)
►
January
(3)
►
2013
(15)
►
December
(1)
►
November
(1)
►
October
(1)
►
June
(1)
►
May
(1)
►
March
(1)
►
February
(2)
►
January
(7)
►
2012
(40)
►
December
(6)
►
November
(2)
►
October
(8)
►
September
(4)
►
May
(6)
►
April
(5)
►
March
(5)
►
February
(3)
►
January
(1)
▼
2011
(27)
►
December
(4)
►
November
(15)
▼
October
(8)
Age Calculation
Calendar In Sql Server Reporting Services.
Split the comma separated value
Comma separated Value In SQL-Server
JQuery Date Function
Case Statement in INNER JOIN
SSRS Column header is not repeating???
Unique constraint to allow multiple NULL's in Sql ...
Search
No comments:
Post a Comment