Ask a Question related to ASP Database, Design and Development.
-
Michael Posthoff #1
rename columns in sql server
hi group,
am i stupid or what. I try to rename a column name via asp and getting
errors all the time. what would be the right syntax:
alter table [name] rename column [old] [new] wvarchar(255)
produces error Microsoft OLE DB Provider for SQL Server error '80040e14'
Please help,
Michael
Michael Posthoff Guest
-
Rename CF Windows Server
How will CF MX 6.1 deal with a Windows 2000 Server (IIS 5.0) being renamed? We'd like to change some server names to more conventional names. Thanks -
Datagrid columns and ntext (via sql server)
Hi I've have some text inside a "ntext" data field from SQL server. I am displaying this text as a column in a datagrid using ASP.NET 1.1 and... -
MS-SQL Server - obtain pk from columns?
Hi all, I have cfmx7 along with ms-sql2000. Given column names and table name which I obtain dynamically, how can I find out which column(s)... -
Can't get value from datagrid when generating columns on the server side
Hi I have a problem with a datagrid, I need to get a value from one of the columns from when I hit a hyperlink column. The hyperlink column is... -
Pad strings/concatenate columns to simulate data columns in ASP select box with SQL Server 2K
Dale, Cast all the data to fixed character data type in your select statement. For example: select cast(au_id as char(12)) +... -
Aaron Bertrand - MVP #2 Re: rename columns in sql server
Maybe you should look up syntax in Books Online, instead of making up your
own!
EXEC sp_rename 'table_name.old_column_name', 'new_column_name', 'COLUMN'
"Michael Posthoff" <posthoff@e-confirm.de> wrote in message
news:bf11d7$qqg$1@news1.transmedia.de...> hi group,
> am i stupid or what. I try to rename a column name via asp and getting
> errors all the time. what would be the right syntax:
>
> alter table [name] rename column [old] [new] wvarchar(255)
>
> produces error Microsoft OLE DB Provider for SQL Server error '80040e14'
>
> Please help,
>
> Michael
>
>
Aaron Bertrand - MVP Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
