--This is the Stored Procdeure CREATE PROCEDURE [dbo].[SampleProcedure] ( -- which accepts one table value parameter. It should be noted that the parameter is readonly @Sample As [dbo].[SampleDataType] Readonly ) AS Begin -- We simply insert values into the DB table from the parameter -- The table value parameter can be used like a table with only read rights Insert Into SampleTable(SampleString,SampleInt) Select SampleString, SampleInt From @Sample End
By viewing downloads associated with this article you agree to the Terms of use and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)
Skills that self-taught computer programmers lack