Can I Alter any of the table through stored procedure. I tried but it didn't
work, if any one guide then I would really appreciated.
Thanks
Thanks Hari, can you try this one. It wont work from my side.
create table xx( i int)
go
create proc xproc
as
Begin
alter table xx add j int
End
select * from xx where j is null
go
exec xproc
go
select * from xx
"Hari Prasad" <HariPrasad@.discussions.microsoft.com> wrote in message
news:54156A3D-DD59-4466-9BFC-BD94ADA4142C@.microsoft.com...[vbcol=seagreen]
> It works good for me in SQL 2000 and SQL 2005. See the sample below.
> create table xx( i int)
> go
> create proc xproc
> as
> Begin
> alter table xx add j int
> End
> go
> exec xproc
> go
> select * from xx
> Thanks
> Hari
> "Rogers" wrote:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment