Keep it Simple and Smart
VLOOKUP function is very useful function if you are dealing with large excel sheet. With the help of this function one can search/find the data value from one or more columns. The V in VLOOKUP stands for vertical. Syntax: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup) Let‘s take a simple example to
» Read moreSometime we need to compare the data of two different columns in excel. Here is very simple solution with the help of IF Function. Syntax: IF (logical_condition, value_if_true, value_if_false) Example: Say we have two columns as Now we can use the IF function as IF (A1=B1, TRUE, FALSE) According to
» Read moreFacebook have 901 million monthly active users at the end of March 2012. The social networking site Facebook released a list of the most social cities or most popular landmarks in the world from where the maximum number of users Facebook check-ins (since August 2010) Facebook says that check-ins data
» Read moreIf you wanted to find/know the webhosting company of any website then you can use the WhoIsHostingThis.com. WhoIsHostingThis.com is webmaster tool that will help you to find the webhosting company of any website. You just need to submit the website URL. It will return following information: Webhosting Company Name IP
» Read moreLets see how to copy an existing table to new table in SQL Server. There are two options. Copy the table with Data. Copy the table without data (i.e.Table Structure Only) — Create Table CREATE TABLE EMPLOYEE ( ID INT NOT NULL, FIRST_NAME VARCHAR(10), LAST_NAME VARCHAR(10) ); — INSERT
» Read moreAt the moment I saw this picture, I decided to share this, I like it 😉 If you are Developer, You have either heard or said the following words: “That’s not a bug, that’s a feature” Or “It’s not a bug – It’s an undocumented feature”
» Read moreNEWID () NEWID () creates a unique value of type uniqueidentifier. NEWID () can be referenced in the queries. Example: NEWSEQUENTIALID () NEWSEQUENTIALID () creates a GUID that is greater than any GUID previously generated by this function on a specified computer since Windows was started. After restarting Windows, the
» Read moreFilm directors are managers and artists at the same time. They have to know everything that goes on in a film set at the same time they exercise their creativity through the input they put into making the film a masterpiece. From the pre-production to the filming, editing and the
» Read moreMicrosoft releases the free eBooks in the various formats as ePub, Mobi and PDF. Anyway one can download that eBooks free… List of Books Deploying an ASP.NET Web Application to a Hosting Provider using Visual Studio Getting Started with ASP.NET 4.5 Web Forms (Beta) Intro to ASP.NET MVC 4 with
» Read moreI had requirement to move the data from source table with his identity column to destination table that have also identity column. Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. Identity column does not allow any
» Read moreVarinder Sandhu is using WP-Gravatar