A Function That Creates A View (dynamic SQL)

I'm very new to SQL Server. Please help. I need to create a FUNCTION that creates a view. Then call this function in a SQL which is passed as a parameter to BCP. In Oracle, it would be something like:



create function CREATEVIEW

return number as

begin

create view SampleView as SELECT a,b,c from Mytable;

return 1;

when others then return 0; -- for exception handling

end:



create function DROPVIEW

return number as

begin

Drop view SampleView;

return 1;

when others then return 0; -- for exception handling

end:



Then my BCP will have something like:



BCP "select CREATEVIEW from dual"... QUERYOUT ..



then

BCP "select * from SampleView"... QUERYOUT ..



then drop the view again:

BCP "select DROPVIEW from dual"... QUERYOUT ..



I know there is no DUAL table in SQL SERVER. I just want to know how to code this in SQL Server.

The origin of my problem is that my SQL statement is too long to fit as BCP parameter, hence, am creating a view and reading there and dropping it again. If you can provide me with a better workaround, that would be great.
Thanks in advance.