PRO*C Precompiler Oracle Equivalent for SQL Server

• ZawMinTun

  SSC Enthusiast

  Points: 170

  More actions

  June 4, 2010 at 2:37 am

  #236070

  Hello everyone,

  How can I pre-compile MS SQL Script to C++ code file, like what we did in Oracle with PRO*C Precompiler?

  Thank you for your sharing.

  Regards,

  Zaw Min Tun

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  June 4, 2010 at 6:03 am

  #1176462

  You are correct, Pro*C is Oracle specific.

  On the Windows/SQL Server side of the world research ESQL/C - short for "Embedded SQL for C". You can start here... http://technet.microsoft.com/en-us/library/bb463140.aspx

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

• ZawMinTun

  SSC Enthusiast

  Points: 170

  More actions

  June 7, 2010 at 7:08 pm

  #1177278

  Thanks a lot, Paul.

  I'll try it.

  Let me get back if I have any question.

  Best regards,

  Zaw Min Tun