Sql server 2008用户定义的数据类型

时间:2021-08-25 16:32:29

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传递给存储过程?