1

Can anybody please tell me what user defined data type is in sql server and also how to create one.

And can i create a user defined datatype which resembles a .net datatable and pass this datatable as parameter to a stored procedure.

John Saunders
  • 160,644
  • 26
  • 247
  • 397
Sidharth
  • 1,251
  • 1
  • 25
  • 40

1 Answers1

3

See this introductory article here: "What's the Point of [SQL Server] User-Defined Types?"

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?

Community
  • 1
  • 1
Simon Mourier
  • 132,049
  • 21
  • 248
  • 298