+ Reply to Thread
Results 1 to 14 of 14

SQL Stored Procedure (Without Parameters) In Excel

Hybrid View

  1. #1
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: SQL Stored Procedure (Without Parameters) In Excel

    I am sorry, I don't use SQL too much.. Here it is -

    USE [ZZ_Common]
    GO
    /******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[Update_Vol]
    	
    
    AS
    BEGIN
    	
    	SET NOCOUNT ON;
        
    
    update XR..VolSurf with (rowlock)set LastVolUpdated_At = GETDATE()
    
    update XR.. VolSurf_Sales with (rowlock) set LastVolUpdated_At = GETDATE(),Published_At = GETDATE()
    
    update XR.. VolSurfSmile with (rowlock) set LastVolUpdated_At = GETDATE(),Published_At = GETDATE()
    
    END
    Last edited by NeedForExcel; 05-13-2015 at 03:04 AM.
    Cheers!
    Deep Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 10-02-2012, 03:06 PM
  2. How do I run an MSSQL 2005 stored procedure with no parameters?
    By Scotbot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-22-2012, 06:46 AM
  3. VBA to Pass Parameters to SQL Stored Procedure
    By ker9 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2011, 01:31 PM
  4. Replies: 2
    Last Post: 06-16-2006, 02:24 PM
  5. External Data from Stored Procedure with parameters
    By Ben Rum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2005, 12:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1