Category - Table
Results 1 - 5 of 103
07 Dec 2020 07 Dec 2020 0 Comments  3573 Views
Here Mudassar Ahmed Khan has explained with an example, how to split a String into Rows in SQL Server.

This article will illustrate how to create a function that will split a string separated (delimited) by comma, space or some other special characters into Table Rows in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  8389 Views
Here Mudassar Ahmed Khan has explained with an example, how to execute Stored Procedure with Table Valued Parameters in SQL Server.

First a Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter.

Then it is passed as Parameter to the Stored Procedure and the Stored Procedure is executed using the EXEC command in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  2170 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
15 Oct 2020 15 Oct 2020 1 Comments  6098 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass Table Variable as Parameter to Stored Procedure in SQL Server.

A Table Variable of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
15 Oct 2020 15 Oct 2020 0 Comments  3673 Views
Here Mudassar Ahmed Khan has explained with an example, how to pass TEMP Table as Parameter to Stored Procedure in SQL Server.

A TEMP Table of User Defined Table Type has to be created of the same schema as that of the Table Valued parameter and then it is passed as Parameter to the Stored Procedure in SQL Server.
Results 1 - 5 of 103