I have a following query in Oracle that I need to convert to SQL Server

Oracle:

create or replace
TYPE "PARAMS" as table of varchar2(3000)

I am unsure how to convert 'as table of' object to SQL Server.

CodePudding user response：

I'm pretty sure that's Oracle's way of creating user defined table types. In T-SQL it would look like this:

CREATE TYPE Params AS TABLE
(
    [value] Nvarchar(3000) 
)