<div>
Search:<br />
<br />

<blockquote>
using stored procedure to insert data sql server
</blockquote>
</div>


<div>
What is SQLSRV? SQL Server?<br />
If so, explain why do you need a stored procedure and not a simple <a href="https://docs.microsoft.com/en-us/sql/t-sql/statements/insert-transact-sql" rel="ugc">INSERT</a> command?
</div>


<div>
Here is a simple Stored Procedure that inserts data. Please provide more information<br />

<pre><code class="code-10 nolinks" id="code-20-42097601-1"><span>CREATE PROCEDURE dbo.InsertExample</span>
<span>       @data1 VARCHAR(30)      = NULL  , </span>
<span>       @data2 VARCHAR(30)      = NULL</span>
<span>AS </span>
<span>BEGIN </span>
<span>     SET NOCOUNT ON </span>
<span></span>
<span>     INSERT INTO dbo.SomeData</span>
<span>          ( </span>
<span>            Data1                      ,</span>
<span>            Data2                  </span>
<span>          ) </span>
<span>     VALUES </span>
<span>          ( </span>
<span>            @data1                     ,</span>
<span>            @data2    </span>
<span>          ) </span>
<span>END </span>
<span></span>
<span>GO</span>
</code></pre>
</div>


<div>
<blockquote>
What is SQLSRV? SQL Server?
</blockquote>
Yes sir..PHP to SQL via sqlsrv on stored procedure approach
</div>


<div>
Ok. Now the 2nd part of my question:<br />
<i>&quot;explain why do you need a stored procedure and not a simple INSERT command? &quot;</i>
</div>


<div>
Thank you sir @Vitor Montalvão<br />

<blockquote>
&quot;explain why do you need a stored procedure and not a simple INSERT command? &quot;
</blockquote>
<br />
Because I need to do some UPSERT(Update Insert) using sqlsrv wich is not availbale in ms sql...I do search some of these but it was very complex for me..Unlike mysql there is ON DUPLICATE KEY used for UPSERT...
</div>


<div>
<div class="content wysiwyg-content">
Good Day! Do you have any basic tutorials or idea on &quot;How to insert data using <b>SQLSRV</b> on <b>stored procedure</b>?&quot;..I did search on this but no luck..<br />
Please help me :(
</div>
</div>


Good Day! Do you have any basic tutorials or idea on "How to insert data using SQLSRV on stored procedure?"..I did search on this but no luck..
Please help me :(

PHP - How to insert data using sqlsrv on stored procedure?

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.