Is userID declared as a primary key?(In order for it to have an index)
R U using somekind of a stored procedure to get the values?

Hey noman,

You can do this real easy in MySQL. Use the LIMIT and OFFSET keyword. Thats it you are done.

But in MSSQL there is no LIMIT and OFFSET function. Unfortunately there is no other...

INSERT INTO test
(SELECT [Customer Id]
FROM [Customers])


Works fine.

I'm trying to populate a table from a sub-query.


CREATE TABLE test
(
ID int
)


INSERT INTO test

What type of front end application your using?

It really depends on the front end application your using.

1.Go to Enterprise Manager and right click the databases and create a new database

2.Right click the database which you created and select the ALL Tasks and then select IMPORT DATA

3.Now you...

Thanks Wchitamb.

I changed it. I went to enterprise Manager and went to design view of the table and changed the data type of the field.

Thanks anyway

Hello,
I want to change the datatype of a field from Varchar to integer in T-SQL.

I tried something like Modify like you use in Oracle.

ALTER TABLE tablename
MODIFY COLUMNNAME Datatype.
...

Do you mean,You want to create a copy of an existing database?

I dont know about enterprise manager...But you can use the query analyzer..

Check out these threads..
http://www.tek-tips.com/faqs.cfm?fid=2519
...