Linked Servers + Distributed Queries Linking to External Data Sources Following stored procedure will allow you to create a link to another SQL Server. Link server name would be “SECOND†EXEC sp_addlinkedserver @server=‘myservername’,–name you will be using to refer link server @srvproduct = ‘Excel’, –Product name i.e excel @provider = ‘Microsoft.Jet.OLEDB.4.0′, –Jet engine @datasrc = [...]
I created a user control for Countries using Microsoft Visual sutdio. I populated a dropdownlist ( Server Side ) using database and then I called this countrol in one of my web form. I wanted to validate this User control but it was not validating when I used ”MyControl1.ClientID” instead of this when i Use Asp.Net generated ID it [...]
Note : T=Table, C=Column, C2 for T1 and T2 got same values.  I want to update T1.C1 values from T2.C1. What would be the SQL Query. update T1 set T1.C1=T2.C1 from T2inner join T1 on T2.C2=T1.C2 Above sql query will update all values from table 2 column 1 to table 1 column1 where table1 and table2 [...]
if you are using windows then Resotore your system to a previous date Click on start > program files> Accessories> system tools> system resotre You will see the following screen. > click on next and you will see the following picutre > choose your date. Bold dates are keeping system restore points. Choose date which you [...]
Getting cheap web hosting is not a problem now. For some technologies you can get even free web hosting [terms and Conditions] apply. Hosting for PHP is cheap while ASP.Net hosting is expensive. Many web hosting companies are offering many kinds of packages. You need to choose the package which suites to your needs. You [...]
E-commerce is a re-known term now a day. Organisation are using e-commerce to earn more profit. Use of e-commerce is increased now a day in all kinds of business. Specailly airlines, warehousing and reatail businesses. Can I use E-commerce? If you want to run a business, a shop online then E-commerce is for you. What [...]
Database is a set of rows and columns. We use database to store information in it and we can retrieve that information on demand. To manipulate database we use SQL (Structured Query Language.) There are many database or DBMS (Database Management System) are available few re-known are Oracle, SQL Server, MySql, Sybase etc. Which database [...]
