SQL Calling A Saved Query from Another Query in SQL Server

Question

In other computing languages, you can call other methods or subroutines within a method or subroutine.

In VBA:

Public Sub x()
   Call y
End Sub
Private Sub y()
   Debug.Print "Hello World!"
End Sub

Can you do this in SQL?

Declare @FilePath as VarChar(Max)

Set @FilePath = '\\SomeServerExtension\MyFile.sql'

Execute @FilePath

It would save space and make the query appear cleaner.

You should read about and understand stored procedures. You nearly described the main benefit. — Sean Lange, Apr 14 '16 at 15:50

score 0 · Answer 1 · answered Apr 14 '16 at 15:17

0

You can EXEC other stored procedures from a stored procedure. You cannot execute arbitrary files (fortunately), even if the server could access them. It'd be a security nightmare, frankly.

answered Apr 14 '16 at 15:17

Jeroen Mostert

27,176
2
52
85

SQL Calling A Saved Query from Another Query in SQL Server

1 Answers1