Jesoba.com is launched, Click below image to access it

Jesoba.com is launched, Click below image to access it
Technology and Entertainment Blog

How to create Store procedure in Sql Server

Title : How to create procedure with perameter .

Article ID : SS001

Create PROCEDURE usp_get_FillGrid
                 (@Mode As INT = NULL,@IdCommonPurposeD As BIGINT = NULL,@IdCommonPurposeH As BIGINT = NULL,
                  @IdImage AS BIGINT = NULL, @imag AS IMAGE = NULL , @pdfdata AS VARCHAR(MAX) = NULL)
AS


         SET NOCOUNT ON             
         SET DATEFORMAT DMY            
         SET ARITHABORT OFF              
         SET ANSI_WARNINGS OFF


IF @Mode = 1---save Image
   BEGIN      
    INSERT INTO imagelogo
    (
        IdImage,
        imag,
        pdfdata
    )
    VALUES
    (
        @IdImage,
        @imag,
        @pdfdata
    )
   END

Google+ Badge

About Author

My photo

I am Senior Server Expert and Professional Blogger.