-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: harsh-fommy
Message 3 in Discussion
New Message on MumbaiUserGroup
Alter/add column before a column in sql server
Reply
Reply to Sender
Recommend
Message 1 in Discussion
From:
harsh-fommy
New Message on MumbaiUserGroup
Alter/add column before a column in sql server
Reply
Reply to Sender
Recommend
Message 2 in Discussion
From:
harsh-fommy
Hi,<o:p></o:p>
I have a table l(id, name,sal) column in
sql server.<o:p></o:p>
I want to add a column before name column as
Dept id in existing table.<o:p></o:p>
What the way to write in T-sql query to alter
the table for add the column .<o:p></o:p>
Again I want to alter the table to change
id column with identity true .<o:p></o:p>
<o:p> </o:p>
Best
Regards,
Harsh Kumar
Database administrator
MOFTWARE LLC<o:p></o:p>
[EMAIL PROTECTED] <o:p></o:p>
MOFTWARE, LLC <o:p></o:p>
CONFIDENTIAL & PROPRIETARY. Use pursuant
to Company instructions 2004.DISCLAIMER: This message contains privileged and
confidential information and is intended only for the individual named. If you
are not the intended recipient, you should not disseminate, distribute, store,
print, copy or deliver this message. If you have received this e-mail by
mistake, please notify the sender immediately by e-mail and delete this message
from your system. E-mail transmission cannot be guaranteed to be secured or
error-free, as information could be intercepted, corrupted, lost, destroyed,
arrive late or incomplete, or contain viruses. The sender therefore does not
accept liability for any errors or omissions in the contents of this message,
which arise as a result of e-mail transmission. If verification is required,
please request a hard-copy version.<o:p></o:p>
<o:p></o:p>
<o:p> </o:p>
View other groups in this category.
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
