Can we execute a sql query inside the Function in SQL?

See more:

SQL-Server

Hi....I am creating one function inside that function i am executing the sql query using EXECUTE @SQL command here @sql contain sql query to create a view.but
I am getting the following error while executing my function .

"Invalid use of a side-effecting operator 'EXECUTE STRING' within a function."


How can i execute my sql query inside function.