RadGridKeyValueType - SQL Server Forums

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/

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/

beatkeeper25
Starting Member

27 Posts

Posted - 2015-02-26 : 15:34:13

Ah, there it is. Thanks.

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources