How to customize asp.net web application deployment

Question

actually my client is asking to run(deploy) some .sql files (it may be "create table" or "create function" or whatever scripts related to sqlserver need to run automatically when deploying the asp.net web application)during the time of deploying the application. so according to him, whereever he install the project, no need to worry about something missing as its added with the project setup. normally i run this .sql in sqlserver's query analyzer, but how can i customize setup project to do this?.