This article should have most of the info that will help you accomplish what you asked.

http://www.sqlservercentral.com/articles/Stairway+Series/76390/

This appears to be a duplicate of http://www.sqlservercentral.com/Forums/Topic1532410-364-1.aspx

gopisridhar,

Can you provide the sample tables/data? I'm not sure I understand your question completely when you say next column.

Are you are trying to update the the existing rows and insert...

I would want to check first before possibly truncating data:

select max(len(code)) from stkitem

or

select *

from stkitem

where len(code) > 20

If you do try:

update stkitem

SET Csimplecode=left(Code,20)

Here is the link for MS:...

Your screenshot is a bit blurry. Are you sure the current file path selected for the MDF is valid and the file is in that directory?

Mike

I tried to replicate the issue as you described and did not have the problem using 2012. Keep identity should be unchecked and is by default.

Is a...

Have you tried creating a format file for the bulk insert?

http://technet.microsoft.com/en-us/library/ms188365.aspx

Are there any foreign keys in the tables? Are there more columns by chance?

If you wanted a cartesian product then you have it based on the results listed (select...

Any chance there are more files than just the primary data and log file?

Try: RESTORE FILELISTONLY FROM DISK = 'C:\Test\backuptest.bak'

As long as both databases are on the same instance, you can....

1. USE <db>

SELECT * FROM dbo.DimCustomer

2. SELECT * FROM <db>.dbo.DimCustomer

3. Choose the db from the db drop...

I don't know for the 463 as I haven't taken it yet but I did for the 461. They are ok, I don't think they are necessary with Bol...

I passed the 461 and am working on preparing for the 462. I guess it depends on what you have done for the past three years. I studied for a...

Look at http://msdn.microsoft.com/en-us/library/ms162773.aspx or they could start it via SSMS to get an idea. This subject or a variation of it has been posted before so there are lots...

Sorry, I am somewhat tired and not near a pc.

Try:

'BULK INSERT newtable

FROM ''C:\inetpub\wwwroot\'+ @importedfile +

''' WITH ( FIRSTROW = 4,

FIELDTERMINATOR = '','',

ROWTERMINATOR = '''')'

Also, might want to review http://msdn.microsoft.com/en-us/library/ms188365(v=sql.105).aspx...

Try something like:

'BULK INSERT newtable

FROM ''C:\inetpub\wwwroot\'''+ @importedfile +

'WITH ( FIRSTROW = 4,

FIELDTERMINATOR = '','',

ROWTERMINATOR = '''')'