var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: select * into table1 from table2 - Problem
i noticed something when i was doing
select * into table1 from table2 that
1 - All Columns Have to be the Same size = Understandable
2 - All Columns have to be in the same order in both tables (this makes no sense) im getting a "String or Binary Data Will Be Truncated"
"Both tables have the same columns just not in order"
To me it seems that it is matching up col1 with col1 and col2 with col2 as apposed to the column names
is there something i am missing??
any suggestions to get around this ???
need some solution or advice to create my own solution ASAP - found this error at work and shit needs to be done (a lot of u know how it is)
Re: select * into table1 from table2 - Problem
Canm you post some DDL, DML, and sample data?
I don't have that problem...
SELECT * INTO OrderDetails FROM [Order Details]
SELECT * FROM OrderDetails
SELECT * FROM [Order Details]
sp_Help [Order Details]
DROP TABLE OrderDetails
My Fault : wrong query i wrote (damn copy & paste)
insert into Table1 select * from table2
Format for Tables Displayed Below
<Column Name> <Size>
I did ti through VB but when i got the error i tried it threw queryanalyzer and got the sam
Order of feilds has to be the same. Type and length of field could be different - if server can convert by itself with out loosing data (truncate).
do you happen to know a reason why this happens all sql databases or is it another "Microsoft Special Feature"
any suggestiosn without me selcting teh order of columns to select fomr (50 columns and cna change any time)
one way i have - but rather not do - is alter table accordingly