Tuesday, April 29, 2008

Copy Data from One Data Source to Another with SQL Query

U can simply move data from one data source to another by using the simple query,but be careful column name in both source and destination must be same in number and type.
And secondly if you execute the query again then it will append the same record again so please set the query to drop and create table.
Third one is the source and destination should be resides on same SQL server.
INSERT INTO Destination.dbo.Tb_Countries(Country_Name)
(SELECT Country_Name FROM Source.dbo.Tb_Countries)


It will copy all the data from source to destination.

Wednesday, April 9, 2008

Display special character on label in asp.net desktop application

If you want to insert some special character on the label as text like &,* ,$ then you have to set its one property false that property is UseMnemonic. Actually ByDefault it is set to true.

Tuesday, April 8, 2008

How to configure SQL Server 2005 to allow remote connections

These links may help out you..
http://support.microsoft.com/kb/914277
http://www.linglom.com/2007/08/31/enable-remote-connection-to-sql-server-2005-express/