Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 RadGridKeyValueType

Author  Topic 

beatkeeper25
Starting Member

27 Posts

Posted - 2015-02-26 : 15:13:11
I'm trying to debug a stored procedure. There is a variable declared as RadGridKeyValueType and appears to be used similar to a table variable. I am not familiar with this type variable and was unable to find a good explanation through searching the web. Why would you use this type? and how do you display its contents? Select * from @V doesn't work.

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-26 : 15:17:17
It's probably a user-defined table type. Here's an article on it: http://www.sqlservercentral.com/blogs/steve_jones/2012/09/19/creating-a-user-defined-table-type/

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-26 : 15:18:29
If it is a user-defined table type, you'll find it in Object Explorer in SSMS under Programmability/Types/User-Defined Table Types.


Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

beatkeeper25
Starting Member

27 Posts

Posted - 2015-02-26 : 15:34:13
Ah, there it is. Thanks.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-02-26 : 15:36:46
You're welcome, glad to help.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -