Wednesday, April 15, 2015

Sql Stored Procedure

  • Syntax for creating Procedure
  • We can insert row using SP
  • W can delete rows using SP
  • We can change Data Type of any column using SP
  • We can drop same table of which we are executing the SP
  • Stored Procedure can accept parameters
  • Triggers will be called from SP
  • Trigger will be called  even if there were no action took place of Delete Sql statement written in SP
  • Create procedure must be the first line in the batch this is why we have to use GO keyword
Syntax for creating procedure without Parameter

CREATE PROCEDURE Your Procedure Name
      SELECT *
      FROM   Your Table Name

Syntax for creating procedure with Parameter

    SELECT *   FROM   test1    

        WHERE  empid = @ID   AND NAME = @name 

Friday, April 3, 2015

How to Install exe as a Windows Service

In this tutorial I will show you how to install a exe as a windows services.

For this I have created a simple exe in Visual studio 2010 you can create it in any version of Visual Studio.

1. Open up your command prompt
2. Type the following line in CMD

sc create Service_Name binPath= "Exe Path"

3. Replace Service_Name with your service name and ExePath with your exe path with quotes


sc create MyService1 binPath= "c:\Taqi.exe"

I hope it was informative for you and I would like to Thank you for reading.