How to save the query in Views in the same database name?

There is no native way to store often required queries in database itself. However, you have two options:

1/ Create a stored procedure and store the query there and execute stored procedure whenever you wish to execute that query. Especially good option when you have parameters to the query.

2/ Create a view and store the query there and issue "select * from view_name" whenever you with to execute that query. Especially good option when you have loads of complex joins and iifs and case when statements. Parameters are not allowed.

The typical practice is to store often required queries (which are not part of project / product / application itself) in .sql files somewhere on the disk and open them in Management Studio and execute / modify / save as the case may be. These are typically not persisted in database as objects.

Hope it clarifies.