Neeraj
Sunday, 4 September 2011
Replace Command in SQl
REPLACE FUNCTION
TAKES THREE ARGUMENT
REPLACE('STRING',REPLACE FROM,REPLACE WITH)
select Replace('123000/250000/14/10/23568','/,'-') as t
output:-
123000-250000-14-10-23568
HAVE A GOOD DAY...
Sunday, 28 August 2011
Difference between Count_Big and Count in ms-sql
Difference between Count_Big and Count in ms-sql
select count_big(*) from User
after execution query return Bigint
where as
select count(*) from User
after execution query return int.
Thats all.
Have a nice day...
Newer Posts
Home
Subscribe to:
Comments (Atom)