SQL > Execute Stored Procedure
For the procedure, you would just need something that either outputs the value into a table, and grab it that way, or as an output parameter to the procedure.
Something like:
CREATE PROCEDURE [dbo].[utcnow]
-- Add the parameters for the stored procedure here
@utcnow datetimeoffset(7) OUTPUT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
SET @utcnow =(SELECT GETUTCDATE())
UPDATE [dbo].[getutcdate]
SET [timestamp]=@utcnow
WHERE [id]=1
END
