Congratulations to both

As stated previously

Let...

Using Query Analyzer

ALTER TABLE testing1 DROP COLUMN Cid

GO

ALTER TABLE testing1 ADD Cid INT IDENTITY (1,3) NOT NULL

GO

Jeff as usual you are CORRECT ... I must have gotten carried away reading all these posts ... tell me one thing what the heck is RTFS and if...

In the master database. Look at sp_msforeachtable

for an explanation of what and how it works try

http://www.databasejournal.com/features/mssql/article.php/3441031

What error?

Please read the article whose...

Suggest you read "Trouble Shooting Metadata Visibility"

http://msdn2.microsoft.com/en-us/library/ms190785.aspx

scroll to the bottom of the page and review:

"Metadata Visibility Configuration"

http://msdn.microsoft.com/en-us/library/ms187113.aspx

Plus search this site for many, many articles discussing injection attacks, and how to...

per rbarryyoung:

Except that that is NOT what was wanted. What was wanted was:

Eliminate One row from each distinct Group.

With the Following restrictions:

...

You could using SSMS

a). In design mode drop the column cID

b). Save the table

c). Go back into design mode insert a new column named cID

d). Set...

May I suggest using BOL subject "Using Pivot and Unpivot" or url:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/24ba54fc-98f7-4d35-8881-b5158aac1d66.htm

If I understand you correctly the following T-SQL should do what you want:

Insert INTO tbl_trans(code,no,name,amount)

SELECT code, no, name, amount FROM tbl_application ORDER BY no

From Jeff Moden's post:

you're going to spend that much time on it... write it as an article and submit it, instead.

...

People really get ticked at me when I say...

Strictly an assumption on my part but...

Although this sounds like a home work question. Start here:

1. Open your .net interface

2. Click on Help

3. Enter ADO in help search window

4. Read the...

The lack of information provided makes it highly unlikely you will get help for your question. Please follow the link in my signature and re-post

Insufficient information -- Do you mean convert a possible 3 characters (clnt_access varchar(3) NOT NULL) to binary, since a bit can only be a 1 or 0, or to binary?

(BOL...