Sql Server Problem Windows Installer Needed

Today i was facing a problem while installing Sql Server in my Computer .

 It says " Windows Installer Needed "

So i figure out and find some downloads from Microsoft website that is windows installer for the windows xp to overcome some problem causing installation and interrupt me to install Sql Server.

 Note: If anything says windows installer needed then you can download this installer and all problem will solve.

Click Download this Installer to install SQL server 

which need Windows Installer.

More Over Extra Error:

This will solve your problem but if the problem persist may be you don't have .net framework then

Download .net Framework Here for Windows XP

If you have Windows 7 then Download this.

Download .net Framework Here for Windows 7 (x64)

Read More

How to Write Sql in Phpmyadmin also Make Tables in MYSQL

How to Write SQL query in  Phpmyadmin:

One of my friend ask on how to write sql query in phpmyadmin so i decided to write a small tutorial with screen shots so you can work your own self.

Step 1: If you don't have phpmyadmin then go to this website and download XAMPP

Step 2: Install Xampp Click to see how to install.

Step 3: Go to Start >> Programs >> Xampp >> Xampp Control Panel and Start it.

Step 4: Now Start two services (Apache and Mysql) see in screen shot.

How to start Xampp

Step 5: Go to your Web Browser and write http://localhost/phpmyadmin

Step 6: you will see a windows Click on Database. See in screen shot.

how to create database

Step 7: Write your desired database name and then click create like screen shot below.

How to Create database in phpmyadmin

Step 8: Now on the left side pan there is your database pateltutes select it.

Step 9: Click on SQL and then write your sql query and click GO. see in screen shot.

How to and where to Write SQL query

Sql Query Example

Step 10: We do and example above which shows how to write example query you can design table in xampp

How to Design Table Using Phpmyadmin

Click the Structure button at the left of SQL and write your table name and designed it.

Design of Table using Xampp

Read More