how to add a column in certain positon in table?
Hi Expert,
How I can add a cloumn to a exist table in certain position for instance,
Table 1
FirstName varchar(20), Lastname varchar(20).
I want add a column MiddleName varchar(20) in second column and all data can not be lost.
Thanks in advance.
How I can add a cloumn to a exist table in certain position for instance,
Table 1
FirstName varchar(20), Lastname varchar(20).
I want add a column MiddleName varchar(20) in second column and all data can not be lost.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You gonna need to post the table structure first.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I Agree.
>>Could some one write sql statement? How to recreate?<<
If you persist and in case you missed the point, here it goes again:
Use SSMS to make the change but do not save instead copy the script generated and use that in your code.
If you persist and in case you missed the point, here it goes again:
Use SSMS to make the change but do not save instead copy the script generated and use that in your code.
ASKER
thanks,