![LOCKING HOW IT HAPPENS IN REAL TIME.[SP_WHO2]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEigZxH9ibJGOfSRALh4SFPVfwXffG4aJXa8S48STCUmsDvr0Q0TmOkUFiTR8djrOLLvZBZ3PSvgQGXS8W7JOeOU__MDcEF_Hq8A0_Hb7It_aHBctJ5KHAZSjcdUCD9DUkwtJZPll0HyCnb2/s600/11.PNG "LOCKING HOW IT HAPPENS IN REAL TIME.[SP_WHO2]")
September 30, 2013
LOCKING HOW IT HAPPENS IN REAL TIME.[SP_WHO2]
Split the vertical tab.First the query window 52 followed by 53.
Execute in query window 52.
begin transaction
select
update
execute in...
Monday, 30 September 2013
September 30, 2013
ISNULL ,COALESCE AND NULLIF TO TACKLE NULL VALUES
ISNULL(ARGUMENT1,ARGUMENT2)
COALESCE(ARG1,ARG2,[ARG3,ARG4,])
--isnull
/*They are like inline if statement
if argument1 is null
return argument2
else
return...
Friday, 20 September 2013
![HOW TO FIND Nth HIGHEST NUMBER THE COMMON INTERVIEW QUESTION. [OFFSET/FETCH USE TO FIND THE SAME]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwH2YIGCemIzMO467RzSpbE8dL2J9lPMFMUrkD7E2rzkDkiIEXPOzF98lJA9pdR3uMydxI7EUgro7xEG5TfLwSO4BbGunLplVsrBrL7pUGOjkaJ2ZUybINsZQK9n3MYFYPIatxAMW8vaQN/s600/1.PNG "HOW TO FIND Nth HIGHEST NUMBER THE COMMON INTERVIEW QUESTION. [OFFSET/FETCH USE TO FIND THE SAME]")
September 20, 2013
HOW TO FIND Nth HIGHEST NUMBER THE COMMON INTERVIEW QUESTION. [OFFSET/FETCH USE TO FIND THE SAME]
>>>>>>HOW TO FIND Nth HIGHEST NUMBER<<<<<
--create a table
create table #temp1
(
id int
)
--insert all the...
Hello, my name is Jack Sparrow. I'm a 50 year old self-employed Pirate from the Caribbean.