Can anybody please tell me what user defined data type is in sql server and also how to create one.
任何人都可以告诉我在sql server中用户定义的数据类型是什么,以及如何创建一个。
And can i create a user defined datatype which resembles a .net datatable and pass this datatable as parameter to a stored procedure.
我可以创建一个类似于.net数据表的用户定义数据类型,并将此数据表作为参数传递给存储过程。
1 个解决方案
#1
3
See this introductory article here: "What's the Point of [SQL Server] User-Defined Types?"
请参阅此处的介绍性文章:“[SQL Server]用户定义类型的重点是什么?”
This answer on SO explains how to pass these UDT types to a stored procedure: Classic ADO.NET - How to Pass UDT To Stored Procedure?
这个答案解释了如何将这些UDT类型传递给存储过程:Classic ADO.NET - 如何将UDT传递给存储过程?
#1
3
See this introductory article here: "What's the Point of [SQL Server] User-Defined Types?"
请参阅此处的介绍性文章:“[SQL Server]用户定义类型的重点是什么?”
This answer on SO explains how to pass these UDT types to a stored procedure: Classic ADO.NET - How to Pass UDT To Stored Procedure?
这个答案解释了如何将这些UDT类型传递给存储过程:Classic ADO.NET - 如何将UDT传递给存储过程?