0

Can I write a select statement where the from clause has a scalar variable which contains table name ? Actually I want to write a store procedure that will take table name as input and display percentage of nulls in that table.

thanks

Improve this question

1 Answer 1

Reset to default
3

No, you will have to build the statement as a string and call sp_execute on it.

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.