Ritesh Kesharwani

Tuesday, June 18, 2013

Need Start Button on Window 8

If you are missing start button on Window 8, try http://www.startisback.com/

you can buy with very nominal charges. E N J O Y ......

Thursday, February 21, 2013

Error: Unable to Open Database Project in Visual Studio 2012:

Error: Unable to Open Database Project in Visual Studio 2012: This version of SQL Server Data Tools is not compatible with the database run time components installed on this.

To fix this problem you need to install SQL Server Data Tools – November 2012 update.

then try opening same project, you will get instruction saying (needs migration) with project file,
To migrate your project you need to Right Click on the Project name and select “Reload Project”.

All done here.

Friday, February 08, 2013

Error: "No column name was specified for column 1 of 'SOURCE'" in SQL Server Merge statement

when I was working with Merge statement with SQL Server 2008 then while writing this I got this error and after couple of min i got the issues

Declare

@Id Int = 10,

@Name Varchar(20) = 'Kesharwani',

@Salary Int = 30000

MERGE INTO [Temp] as TARGET

USING (SELECT @Id,@Name,@Salary) AS

SOURCE ON TARGET.empId = SOURCE.empId

WHEN MATCHED THEN

UPDATE SET Name=SOURCE.Name, Salary =SOURCE.Salary

WHEN NOT MATCHED THEN

INSERT (empId,Name,Salary)

VALUES (SOURCE.empId,SOURCE.Name,SOURCE.Salary);

While running above query sometime I got this error: No column name was specified for column 1 of 'SOURCE'.

The problem in the above query the alias name not there on the columns in Select statement, to resolve this error above query can be written in following way

Declare

@Id Int = 10,

@Name Varchar(20) = 'Kesharwani',

@Salary Int = 30000

MERGE INTO [Temp] as TARGET

USING (SELECT @Id AS empId,@Name AS Name,@Salary AS Salary) AS

SOURCE ON TARGET.empId = SOURCE.empId

WHEN MATCHED THEN

UPDATE SET Name=SOURCE.Name, Salary =SOURCE.Salary

WHEN NOT MATCHED THEN

INSERT (empId,Name,Salary)

VALUES (SOURCE.empId,SOURCE.Name,SOURCE.Salary);

Thursday, December 27, 2012

Try Operating System other than Windows

Try Operating System other than Windows

My window 7 OS got crash and finding difficulity to boot my laptop, I did not find any window OS for free than I found there are so many Unix based OS available for free. I tried Fidora, it's really good It's solve all my purpose, I am able to boot my laptop and it is working. I can browser internet, search my files , backup etc. almost all the thing I can do that is require at home.

There are so many free OS available, but I like Fidora, latest version is 18. Download ISO file and use USB creator softwware to craete bootable CD or USB and then start installation

Install Fidora 17:
http://fedoraproject.org/en/get-fedora

Download Lili USB Creator from ISO file
http://www.linuxliveusb.com/en/download

Fidora documentation available:
http://docs.fedoraproject.org/en-US/Fedora/18/html/Release_Notes/index.html

See the list of other OS available:
http://www.ixibo.com/list-of-free-operating-systems-download-now/

Wednesday, December 26, 2012

How to use MERGE, WHEN MATCH and WHEN NOT MATCH statement in SQL Server 2008

How to use MERGE, WHEN MATCH and WHEN NOT MATCH statement in SQL Server 2008

Normally we have common requirement for inserting data into the database table, we need to take care of duplicate data should not get inserted, for this we used to first check in the database table whether that data is present or not, If not then insert otherwise update.

Current Approcah

Declare

@Id Int = 10,

@Name Varchar(20) = 'Kesharwani',

@Salary Int = '30000'

-- Update the row if it exists.

UPDATE [Temp]

SET Name = @Name, Salary = @Salary

WHERE empId = @empId

-- Insert the row if the UPDATE statement failed.

IF (@@ROWCOUNT = 0 )

BEGIN

INSERT INTO [Temp] (Id, Name,Salary)

VALUES (@empId, @Name,@Salary)

END

New way to do the same operation

Let say you have one database table as below

Select * from Temp

Query -1

Declare

@Id Int = 10,

@Name Varchar(20) = 'Kesharwani',

@Salary Int = 30000

MERGE INTO [Temp] as TARGET

USING (SELECT @Id AS empId,@Name AS Name,@Salary AS Salary) AS

SOURCE ON TARGET.empId = SOURCE.empId

WHEN MATCHED THEN

UPDATE SET Name=SOURCE.Name, Salary =SOURCE.Salary

WHEN NOT MATCHED THEN

INSERT (empId,Name,Salary)

VALUES (SOURCE.empId,SOURCE.Name,SOURCE.Salary);

Note: If you have multiple PK columns then in the USING statement you need to include all PK columns as same as below

USING (SELECT @Id,@Name,@Salary ) AS

SOURCE ON TARGET.empId = SOURCE.empId
AND TARGET.empId1 = SOURCE.empId1
AND TARGET.empId2 = SOURCE.empId2

Result from Query-1

Employee Id = 10 data was present that’s why that row is UPDATED

Select * from Temp

Query -2

Declare

@Id Int = 30,

@Name Varchar(20) = 'Master',

@Salary Int = 40000

MERGE INTO [Temp] as TARGET

USING (SELECT @Id AS empId,@Name AS Name,@Salary AS Salary) AS

SOURCE ON TARGET.empId = SOURCE.empId

WHEN MATCHED THEN

UPDATE SET Name=SOURCE.Name, Salary =SOURCE.Salary

WHEN NOT MATCHED THEN

INSERT (empId,Name,Salary)

VALUES (SOURCE.empId,SOURCE.Name,SOURCE.Salary);

Result from Query-2

Employee Id= 30 was NOT present that’s why new data got INSERTED

Select * from Temp

Multiple values as an input

Let’s say you are passing table type as input parameter because you want to pass multiple data together, assume you are passing TempTest table (having same structure as Temp table) as an input .

Select * from TempTest

Query -3

MERGE INTO [Temp] as TARGET

USING (SELECT empId,Name,Salary from TempTest) AS

SOURCE ON TARGET.empId = SOURCE.empId

WHEN MATCHED THEN

UPDATE SET Name=SOURCE.Name, Salary =SOURCE.Salary

WHEN NOT MATCHED THEN

INSERT (empId,Name,Salary)

VALUES (SOURCE.empId,SOURCE.Name,SOURCE.Salary);

Note: If you have multiple PK columns then in the USING statement you need to include all PK columns as same as below

USING (SELECT @Id,@Name,@Salary ) AS

SOURCE ON TARGET.empId = SOURCE.empId
AND TARGET.empId1 = SOURCE.empId1
AND TARGET.empId2 = SOURCE.empId2

Result from Query-3

From TempTest table employee Id =10 was present that’s why this data got UPDATED and employee Id =30 was NOT present then this data got INSERTED into the Temp table

Select * from Temp

You can perform all kinds of operation (INSERT, UPDATE, DELETE) using these statement , for more example see the link here http://technet.microsoft.com/en-us/library/bb510625.aspx

Sunday, December 16, 2012

Good reasons to work on Visual Studio 2012

Visual Studio 2012 is next generation platform (4.5 Framework) to develop .NET applications, this includes development of Window 8, Window phone, Gaming and 3D applications.
To know more about visual studio 2012, see below link

Features perspective
http://blogs.msdn.com/b/jasonz/archive/2012/08/15/visual-studio-2012-and-net-framework-4-5-released-to-the-web.aspx

Developer perspective
http://dotnet.dzone.com/articles/10-illustrated-examples-visual-0

Thursday, December 13, 2012

How to enable code analysis for Visual Studio 2010 projects (FxCop, StyleCop etc.)

Below I am giving steps to enable FxCop rule set. To enable FxCop Rule set into your projects, first you need the FxCop rule sets files (*.ruleset). By default you will get most of sets from Microsoft when you install Visual Studio 2010, you can customize those by selecting or unselecting rule sets. Or if you want to create your own custom rule set then below link will guide you for this

I am assuming that rule set are available with you and you want to enable FxCop/StyleCop/etc. for your project.

Right click on the project property and go to the “Code Analysis” tab
Select check box “Enable Code Analysis on build”
Select “ from “Run this rule set” dropdown and select your custom rule set you created or available with you.
Click “Open” to customize
Select/Unselect Rules using check box
Set the Action likes if rules violate by code then it should be warning, error or none
“Save” the rule set
“Save” the Project

FxCop rule set is now enable for this project, when you build your project each time all rules run and give you errors/warning if code violate the rules.

Sunday, December 09, 2012

How to use XQuery to retrieve data from XML

How to use XQuery to retrieve data from XML

XQuery is an Language that used to retrieve data from XML in required format, XQuery uses FLWOR expressions (For, Let, Where, Order By, Return), I am giving to some examples below to understand XQuery. By looking below example you should be able to retrieve data from XML using XQuery.

Create One XML file and save as “Employee.xml”

xml version="1.0" encoding="utf-8" ?>

<Name>Ritesh</Name>

</Employee>

<Name>Kumar</Name>

</Employee>

</Employees>

Example-1: To Find the Department Id of the employee name 'Ritesh'

for $emp in doc (Employee.xml)/Employees/Employee

where $emp/Name =”Ritesh”

return $emp/DeptId

Return Answer

If you want to return only data then use below return statement

return data($emp/DeptId)

Return Answer

If you want to return Data in different Structure then use below return statement

return

<Id>{data($emp/DeptId)}</Id>

Return Answer

Example-2: To Find the Employee whose salary is > 1000 and return name with type

for $emp in doc("Employee.xml")/Employees/Employee

where $emp/Salary > 1000

order by $emp/Name

return
<Department>

if ($emp/@type=”Admin”)

then

else

</Department>

Return Answer
<Department>

<Admin>Kumar</Admin>

<Supervisor>Ritesh</Supervisor>
</Department>

You can find more examples http://www.w3schools.com/xquery/default.asp

Saturday, December 01, 2012

Error: Resource cannot be found in MVC 3.0 application

I observed this error when I was working in one of MVC (Razor View) application, I got confused when all my page is available in correct View folder then why this error thrown. Finally I found there was no mistake from my implementation or page name etc.

Error:

Cause:

The problem was if you are running MVC application by Visual Studio and any of view ( .cshtml or .aspx) file open (in Active tab) in Visual Studio and you are the running the application by clicking (F5 or Ctrl+F5) than you will get this error. Visual Studio not goes to start up page it is considering open page (in Active tab) as start up page.

Solution:

Close all view files (.cshtml or .aspx) and then run application by F5 or Ctrl+F5 or open .cs files in Active tab in Visual Studio. It ok to open .cs files.

Friday, November 30, 2012

Hyperlink clicks doing page refresh in JQuery

Hyperlink clicks doing page refresh in JQuery

Normally if you have multiple Ajax calls and Hyperlink action on the same page then you will face multiple call issues, when you clicks on hyperlink same time another Ajax call action trigger and create the issues, you have to prevent those call using ‘stopPropogation’ and ‘preventDefault’, see below example

Following code will refresh page when you click on “Click Here”

$("CallFunctionToOpenWindow(event)’>" Click Here "");

Try following way to write same code, this will prevent server call which will not refresh the page

var anchor = $("CallFunctionToOpenWindow(event)’>" Click Here "");

anchor.click(function (event) {
    CallFunctionToOpenWindow (event);
    event.stopPropagation();
    event.preventDefault();
});

CallFunctionToOpenWindow(): you can write simple custom function to do the action on hyperlink click.

Image Background Position not working in Firefox, CSS Style Sheet

Image Background Position not working in Firefox, CSS Style Sheet

If you are facing issues to set Image background position with following style sheet class

display: inline-block;

border: none;

background-image: url(/images/MockIcon.png);

background-repeat: no-repeat;

background-position-x: 50px;

background-position-y: 5px;

vertical-align: middle;

Try following style sheet class which will work in all the Browsers (Chrome, IE and Firefox)

display: inline-block;

border: none;

background-image: url(/images/MockIcon.png);

background-repeat: no-repeat;

background-position: left 50px top 5px;

vertical-align: middle;

Sunday, September 09, 2012

Do your unit testing with Rhino Mocks

Mock object can be used with .NET framework and utilize in all kinds of .net unit testing, Normally real object call is slow because of lots other dependency like libraries, db etc.
also if real object is not 100% ready. In all that scenario Rhino Mocks framework can be used.

For functional testing you have to have real object ready and for unit testing Rhino Mock is the best and quick solution.

Using rhino mock you can simply create mock object and from the caller method you can call mock object instead of calling real object.

to know more about Rhino Mock you can refer following links