I just asked if anyone has any idea of those terms

Anyways thanks

This is my task given by my boss

thank you

So i have to alter table first

like ALTER TABLE table_name ADD column_name datatype

Later should i drop the view and create a new view to add that additional column?

Thanks for the reply.

But is there a command like ALTER VIEW view_name ADD column_name datatype

thats fine

Thank you very much

Even though there is char(10)+char(13) in select statement, i am getting output i one line

May i know the reason

GilaMonster (12/2/2009)

---

rahulsony111 (12/2/2009)

---

if i pass a table name like tablenew1 to the @tablename like 'EXECUTE usp_covertdatatype tablenew1'

will the select statement selects the tablenew1?

like 'select altertable tablenew1 alter column column'

And will...

In the code you gave above, in the select statement

select @sql = @sql + char(10) + char(13) + 'alter table ' + sysusers.name + '.' +...

Thanks for all the suggestions and code

I appreciate your help very much

Seth if it is possible can you explain me in detail what is the code doing. Is that taking...

Hi seth, how are you man?

Yes i am sure this time

i have to write a stored procedure so that it can change column datatypes which is char to nchar and...

GilaMonster (12/1/2009)

---

Few things. You're going to get a syntax error from that saying that the name column is ambiguous. You need to specify the table and column name in the...

Should the code look like this if i write in a stored procedure

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE sp_covertdatatype

@tablename

AS

BEGIN

select 'alter table ' + sysusers.name + '.' + tables.name

+...

The code is working. You are awesome

But i need a stored procedure for this.

I think the code you gave is a one-time process

The problem is that i have do...

GSquared (12/1/2009)

---

Instead of doing it with a parameter for the table name, if you really need to do a whole database all at once, try this:

declare Cmd cursor local fast_forward...