when i try the syntax exec sp_rename 'table.columnnameold', 'columnnamenew' it executes in ssms

but in tfs it throws an error: VwA has no reference object or have an ambigous reference

Working for me as well.

Thanks

Tried it as well.

CREATE TABLE T1

(

CreateDate DateTime2 not null

)

GO

INSERT INTO T1 (createdate)

VALUES ('2012-03-09 12:34:45:567')

GO

throws an error: cannot convert datetime to string

ok got it thanks

Thanks,

Its working perfect. But i could see that if we add unique to the column in the table itself, then only the script is working fine.. Otherwise it throws error....

Forgot to mention EDId is the primary key in dbo.ED table

Thanks guys,

Worked perfectly.

k Thanks will try using function

Awesome thats perfect. Thankyou very much foryour help.

SELECT table1.column4,

table2.column5

FROM table1

...

ok.

thanks for your replies and will try again

Thanks for the reply,

But actually i tried this way also and its not working.

The thing is table2.column3=02 is the condition applied after performing join where as table2.column3(+)=02 is the condition...