How to use OPENROWSET command in sql server

Dear all,

Sometimes we need to copy the data from access db to sql server. For transferring data we can use openrowset command.
For using openrowset you need the Ad Hoc Distributed Queries component turned on.
But, by default this component is being turned off for the security of server. But you can turn it on for using the openrowset command.

Accounting Knowledge for Software Engineers Part 3(Double Entry System)

Hi all,
Today we are going to learn about double entry system of accounting which means debit and credit.
This is the toughest part of accounting.
But, if you are confident about the earlier part of this series then this part is not so difficult.
Now, we all know about the accounting equation, that is..

↑ Asset = ↑ Equity + ↑ Liabilities
↑ Expenses                 ↑ Income

Accounting Knowledge for Software Engineers Part 2(Basic Accounting Transaction)

Hello all,

Thanks for waiting for the finest part of accounting. Today we will see how transactions are stored for basic accounting. In the first part of this series we know that accounting basically lays on equation..
↑ Asset = ↑ Equity + ↑ Liabilities
That means if equity and liabilities goes up then the asset must goes up.

A Transaction can be defined as an exchange of goods or services between two parties.
Now we show the step by step business accounting…

1. One man starts his business with 15,000$.
   So, the equation is..

   Asset(15,000$) =  Equity(15,000$) + Liabilities(0$)
   a. Bank(15,000$)

Accounting Knowledge for Software Engineers Part 1(Basic Accounting Concept)

Dear all,

Today we are going to discuss about a different subject that is accounting which is necessary to know for developing an Accounting software, Point of sale, ERP, Banking solution etc.
I divide this tutorial into some series for clearly understanding the accounting.

How to Write Stored Procedure

Hello all,
Today we are going to learn how to write a stored procedure in sql server. The following code is a sample one. If you like it you can use this format for all stored procedure…

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO 

Asp.net MVC3 : Formatting DateTime field in HtmlHelper Method

Reblogged from Bappi's Blog:

To format DateTime field in HtmlHelper method use following expression without using Lamda Expression:

@Html.TextBox(string name, object value)

Read more… 29 more words

Helpful information for asp.net mvc

Create transactional publication in sql server 2008

Hi all,
Today we are going to learn how to create a transactional publication in sql server 2008. You may create it by using gui of sql server management studio. But we learn using sql script. Just copy the following code and enjoy…

Debugging codeigniter with firephp

Hi all,
Today we will explore how to debug the codeigniter application with firephp a extension of firebug. For this you have to install the firebug with your firefox browser.

Than, you have to download the firephp library. You can download from here or here. After downloading the library you have to copy it to your application/libraries directory. And then load the library as..

$this->load->library("firephp");

And finally to debug your code just write the code as follow…

Removing Distribution From Sql Server

Hello all,
Today we learn how to remove distribution database from your sql server.
Dont try to delete the distribution server directly. If you delete the distribution database, its actually not deleted, then you have to reinstall the sql server. So, to avoid this mess up please copy the following script and run in your sql server…

Configure Distribution server for Replication in Sql server 2008

Hi all,

Today we are going to learn how to make a distribution server for replication in sql server 2008.
Many people configure the distribution server using gui(graphical user interface).
But, i am comfortable with the sql server script. So, we learn how to make a sql server applicable for distribution using sql script.

At, first connect to sql server 2008 instances and then create a new query and copy the following code…