If you put jQuery in your CV, then beware, you should be able to answer following questions. Better you read on, and test yourself how much you can score. 1. What is jQuery & its significance? Why it is so popular? 2. What is jQuery UI? 3. What ...

Run the following code declare @t table(i int unique) insert into @t select 1 union all select null union all select null You will get the following error Msg 2627, Level 14, State 1, Line 3 Violation of UNIQUE KEY constraint 'UQ__#A9...

I am back from vacation, and have spent a couple of weeks catching up my workload. Now I am ready to finish the SQL Server BI Quiz “Mass Mailing Your Report”. Here is my original blog, SSRS #55 – SQL Server BI Quiz “Mass Mailing...

In this post Dynamic PIVOT in SQL Server 2005, I have shown a way to dynamically generate the column values with names. I used to get mails frequently from people on how to pass parameters when executing the procedure. The following will find total sal...

see below link for decrypt stored procedure. [http://optillect-sql-decryptor.software.informer.com/2.0/][1] [1]: http://optillect-sql-decryptor.software.informer.com/2.0/...

What is Refactoring? Refactoring of code helps to restructure the code to enhance performance, scalability, reusability and code readability. There could be chances that refactoring can result in breaking of application flow when you do refactoring of ...

What is Refactoring? Refactoring of code helps to restructure the code to enhance performance, scalability, reusability and code readability. There could be chances that refactoring can result in breaking of application flow when you do refactoring of ...

Hi, Someone asked me how to create facebook app day before yesterday and he wanted to integrate existing asp.net webpage in this facebook app. I was not much aware about facebook integration but got to know that facebook doesn’t h...

Hi, Someone asked me how to create facebook app day before yesterday and he wanted to integrate existing asp.net webpage in this facebook app. I was not much aware about facebook integration but got to know that facebook doesn’t h...

There is one interesting story about NASA floating around the internet for quite some time now. The story goes like this - NASA spent millions to develop a pen that could write in space under zero gravity while the Soviet cosmonauts just used a pencil. ...