query server
MS SQL Server Management Studio, I read part of my query for a file on my hard drive. How?
In programming in C, for example, can specify that an # include file contains part of your program, so that the C language considered that the directive # include, and incorporates the contents of the file in your program at compile time. I do this with MS SQL SMS. I have read only access on the database, so you can not store procedures, etc., but I want some kind of modularity, so do not have to cut and paste the code redundant. How can I do this?
There is no equivalent in SQL to C / C + + # include directive. What you have is SQL stored procedures and user defined functions. If you are stuck with read-only access then cut and paste is your choice.