tsql array parameter

Solutions on MaxInterview for tsql array parameter by the best coders in the world

showing results for - "tsql array parameter"
Fabio
21 Aug 2018
1SELECT ProductId, Name, Tags  
2FROM Product  
3WHERE 'clothing' IN (SELECT value FROM STRING_SPLIT(Tags, ',')); 
Mariangel
13 Feb 2018
1CREATE TYPE dbo.IDList
2AS TABLE
3(
4  ID INT
5);
6GO
7
8CREATE PROCEDURE dbo.DoSomethingWithEmployees
9  @List AS dbo.IDList READONLY
10AS
11BEGIN
12  SET NOCOUNT ON;
13
14  SELECT ID FROM @List; 
15END
16GO
Rodrigo
23 Jan 2017
1CREATE FUNCTION dbo.SplitInts
2(
3   @List      VARCHAR(MAX),
4   @Delimiter VARCHAR(255)
5)
6RETURNS TABLE
7AS
8  RETURN ( SELECT Item = CONVERT(INT, Item) FROM
9      ( SELECT Item = x.i.value('(./text())[1]', 'varchar(max)')
10        FROM ( SELECT [XML] = CONVERT(XML, '<i>'
11        + REPLACE(@List, @Delimiter, '</i><i>') + '</i>').query('.')
12          ) AS a CROSS APPLY [XML].nodes('i') AS x(i) ) AS y
13      WHERE Item IS NOT NULL
14  );
15GO
queries leading to this page
passing array of objects to stored procedurec 23 stored procedure pass arraysql variable array length parameter stored procedurepassing collection of id to sp sqlsql stored procedure array parameterhow to pass string array to stored procedure in sql serverinput array sqltsql array parametermql4 array as function parametersql pass array to functionpass array into procedurepass array to sql procedurehow to pass collection to sql stored proceduresql stored procedure pass arraymssql pass array to stored procedurec 23 load array from stored procedurehow accet integer array as ms sql server sp input parameterc 23 pass array to stored procedurepass array response from sql using c 23sql exec sp with arrypassing array parameter to sql stored procedurepass and receive array of int in sql server stored proceduresql exec stored procedure with array of parametersstored procedure parameter int arrayhow to pass array of values into sql server stored proceduresending an array of data to sqlpass array sql parameterpass array to stored procedurepass array into stored procedurehow to send array as argument in stored procedure issql stored procedure parameter arraymql5 array parameterhow to pass array as argument in stored procedurepass a store procedure an array using c 23sql stored procedure pass int arrayt sql stored procedure array of integer parameterspass sql parameter array to functionhow to pass string array to foreach adf to execute procedurec 23 stored prodecure to arraysql stored procedure with array parameterparameterized sql for arraysend array to sqlsql function array parameterpass array of strings to stored procedure c 23c 23 pass array to sql stored procedurestring array in sql stored proceduresql parameter arraynumber table pass as array c 23how to send array as argument in stored proceduresql server pass a arraytsql stored procedure array parametersending array to stored procedeurepassing array to stored procedureturn array into list of parameters sqlpass int array to stored procedure sql serverpassing array parameters to a stored proceduremql4 array as function parameter 5csql server params rraytsql array variablemssql function array parametersql server array parameter stored procedurehow to pass array to stored procedurepass array to store procedure inserttsql pass array to stored procedurehow to pass value for a store procedures sql parameter array in c 23pass array response from c 23 using sqlc 23 load stored procedure into arraysql udt string array param store procedurec 23 sql array trough methodsql sp array parameter vbsql udt to pass string arraypass array as parameter to sql stored procedurec 23 populate array from sql stored proceduresql send arraystored procedure string array parameterc 23 stored procedure load into arraypass array of string to stored proceduresql stored procedure pass array of stringsarray of int in stored procedurestored procedure with array parameterstored procedure array parameterhow to pass array in stored procedurepass array parameter to stored procedure c 23how to pass int array to stored procedure in c 23create stored procedure in sql with array string parameterssql server procedure input arrayhow to pass an array along with other parameters to stored procedurewhere in sql pass arraypassing array to sql server stored procedurebest way to pass a collection sql input parametertsql array parameter