I am writing SQL Stored Proc that takes a single table parameter. Is it possible to create a table type in a parameter definition, for example:
CREATE PROCEDURE example ( @param (CREATE TYPE tableparameter ( column1 int, colunn2 varchar.... )) READONLY )
No.Databases will want the type to exist before it can be specified as a parameter type, otherwise the database has no way of knowing if the data it receives is valid or not.
Source: https://habr.com/ru/post/1752894/More articles:What is this tree of objects? - designCan you get around SQL Server Express size limits by stacking databases? - sqlPython quick string analysis, manipulation - performanceHow to store decimal value in java - javaWhy is it allowed to set a property that does not set anything in C #? - c #Where is the jQuery data method information located? - javascriptГеномный браузер, встроенный в java: Swing и awt или Swing and Processing? - javaWhat structure and database should I use? - c #WxPython segmentation error with editors - pythonhow to define two foreign keys in cakePHP - cakephpAll Articles