when doing this

create view viewname as select * from table1

no trouble but when doing this

if @temp 1 = 1 then
begin
create view viewname as select * from table1

suddenly sql server doesn't acknowledge the syntax in the create view
statement ? how come ?

michael v wrote:
parameters, @temp, 1 and another 1? If in SQL does not use then.

Crate view must be the first statement as well. Try this-

declare @temp int
set @temp = 1
if @temp = 1
begin
exec('create view viewname as select * from sysobjects')
end

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

thanx darren

I did declare it but didn't show it but i was missing the exec statement.

didn't know that this was needed

"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote