Trace Mobile number location

Trace Mobile number location and Mobile number operator in India

You often get a missed call and wonder who's calling !!
Well, we can't tell you "who" but can help by telling "where" the call is from.
Just enter the ten digit mobile number and submit, you will get the
Telecom Circle (State / Metro) and the Operator of the calling number. Rest you can guess, Who??

Mobile Number Details
Enter Mobile Number:

Note:
1. No directory of mobile numbers is published in India because of the privacy concern so you can't get the name and address of the caller.
2.*The Operator shown here is the original / first operator for this number. With mobile number portability in place, the number could have moved to some other operator.

How to import data from Excel to SQL Server

How to import data from Excel to SQL Server

Introduction

In this article you will see how to use the SQL Server import an MS Excel file on your computer to a database on your SQL Server.


Open The Sql Query window select the database and Type

create database samp

go

sp_configure 'show advanced options',1 

reconfigure with override 

go 

sp_configure 'Ad Hoc Distributed Queries',1 

reconfigure with override 

go

SELECT * into temptable

FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

                'Excel 8.0;DATABASE=C:\Users\RAJU\Desktop\pincodes.xls;IMEX=1',

                'SELECT * FROM [Sheet1$]')

select * from temptable