No announcements
Found 3221106 threads
-
0 VotesUser-Defined Table Types
User Defined Table types when passed as table-valued parameters (TVP) to store procedure, do not maintain statistics.Answered | 2 Replies | 5351 Views | Created by Manigandan A - Tuesday, March 5, 2013 5:46 AM | Last reply by Krishnakumar S - Tuesday, March 5, 2013 6:26 AM
-
0 Votes
User defined Table Types
If I understand Oracle's user defined table types, you should be able to do the same thing in SQL Server 2008.Answered | 1 Replies | 7793 Views | Created by sanooj82 - Tuesday, July 6, 2010 8:01 PM | Last reply by JasonRoth - Friday, July 9, 2010 5:13 PM -
0 Votes
User Define Table Type
Is it possible to use the same User Define Table Type as a parameter in multiple stored procedures simultaneously?Answered | 2 Replies | 723 Views | Created by Lionbk - Thursday, April 14, 2016 6:36 PM | Last reply by Erland Sommarskog - Thursday, April 14, 2016 10:03 PM -
0 Votes
User defined Table Types
No, you cannot use temp tables.Answered | 5 Replies | 5693 Views | Created by Sarah2005 - Saturday, January 8, 2011 12:44 AM | Last reply by Erland Sommarskog - Saturday, January 8, 2011 10:18 PM -
0 Votes
What are User-Defined Table Types?
Hallo Icerni, basically a UDT (user definied data type) is nothing else as a "synonyme" for for a "real" data type.Answered | 2 Replies | 3174 Views | Created by lcerni - Friday, July 19, 2013 2:27 PM | Last reply by Tom Cooper - Friday, July 19, 2013 3:05 PM -
0 Votes
Using User Defined Table Types...
User defined table data type only works for SQL 2008 or later.Answered | 12 Replies | 16862 Views | Created by rebulanyum - Friday, March 25, 2011 8:20 AM | Last reply by rebulanyum - Friday, March 25, 2011 3:15 PM -
0 Votes
Dynamic SQL - Parameters - User-Defined Table
Exactly what Guillaume said: a user-defined table tpye: CREATE TYPE hoppla AS TABLE (a int NOT ...Answered | 6 Replies | 6861 Views | Created by Guillaume Fraiture - Wednesday, May 9, 2012 1:43 PM | Last reply by Guillaume Fraiture - Thursday, May 10, 2012 6:50 AM -
0 Votes
User-Defined Table Types - nested
Unfortunately, you confused the discussion with your initial statements about nested tables.Answered | 1 Replies | 3443 Views | Created by sakhi5 - Monday, June 10, 2013 7:05 PM | Last reply by scott_morris-ga - Tuesday, June 11, 2013 2:11 PM -
3 Votes
Create User Defined Types
And besides, the mentioned article gives you a good example for coding a user defined struct.Answered | 4 Replies | 1247 Views | Created by Pasupathi - Tuesday, September 11, 2012 10:48 AM | Last reply by Stefan Hoffmann - Wednesday, September 12, 2012 6:37 AM -
0 Votes
User defined data / table type
If you need to return multiple rows of data from function then you probably just need a "user table function" or you can use Stored Procedure. in both options you do not ...Answered | 3 Replies | 887 Views | Created by Rajendra Lella - Thursday, May 7, 2015 12:22 PM | Last reply by pituach - Thursday, May 7, 2015 11:13 PM -
0 Votes
script failur on user defined table type
Then you can search the User-Defined Table Type from the definition of published view or stored procedure.Answered | 1 Replies | 1944 Views | Created by JimHoopsDSC - Thursday, August 20, 2015 3:08 PM | Last reply by Lydia Zhang - Tuesday, August 25, 2015 3:55 AM -
1 Votes
How to use user Defined table types?
create type tt_example AS TABLE (spid int) go create procedure ...Answered | 2 Replies | 18846 Views | Created by QLoveQ - Monday, June 4, 2012 8:59 AM | Last reply by QLoveQ - Tuesday, June 5, 2012 3:39 AM -
1 Votes
change structure of a User Defined Table Types
E.g. if you need to drop the table type, you first drop the procedures, re-create the type, then re-create procedures.Answered | 4 Replies | 758 Views | Created by neibala - Wednesday, November 4, 2015 12:05 AM | Last reply by Naomi N - Thursday, November 5, 2015 4:32 PM -
0 Votes
User Define Types
User-Defined Types mainly have two types: User-Defined data type and User-Defined Tables ...Answered | 3 Replies | 489 Views | Created by srinivas_ch - Tuesday, April 21, 2020 10:54 AM | Last reply by Lily Lii - Thursday, April 23, 2020 8:33 AM -
0 Votes
Identity user defined type
SQL Server does not support that kind of user defined data type.Answered | 12 Replies | 574 Views | Created by ZionAssedo - Monday, November 27, 2017 11:17 AM | Last reply by ZionAssedo - Monday, December 18, 2017 3:21 PM -
1 Votes
User defined data type
User defined data types can also be used when several tables must store the same type of data in a column .Consistency in ...Answered | 5 Replies | 1129 Views | Created by PAPIAS53 - Sunday, December 7, 2014 8:34 AM | Last reply by dani671 - Friday, December 12, 2014 10:24 PM -
0 Votes
Is it possible to use dynamic types with Azure?
When you call the MobileServiceClient.GetTable overload which takes the table name as a parameter, you get a reference to what I call an untyped table - the operations on it ...Answered | 4 Replies | 1055 Views | Created by mcd023 - Tuesday, February 4, 2014 2:40 AM | Last reply by mcd023 - Wednesday, February 5, 2014 2:14 PM -
1 Votes
User-Defined Table Types in SQL Server 2005
Table alias data types & Table-Valued parameters were introduced in SQL Server 2008 so are not available in prior versions.Answered | 5 Replies | 1187 Views | Created by Elmozamil Elamir - Tuesday, July 25, 2017 10:23 AM | Last reply by Erland Sommarskog - Tuesday, July 25, 2017 12:47 PM -
0 Votes
Pass User Defined Table Types (TVP) as arguement of User defined function in MSSQL2008
You can't execute dynamic SQL inside a UDF, that's one of a limitation.Answered | 4 Replies | 2332 Views | Created by Kasim Mandapam - Sunday, September 9, 2012 6:48 AM | Last reply by Manoj Pandey (manub22) - Monday, September 10, 2012 8:15 AM -
0 Votes
MsSQL User-Defined Types
I also think this would make sense; instead of defining certain "standard types" over and over again it would make sense to map them to alias types.Answered | 3 Replies | 6741 Views | Created by Vladimir A Marchenko - Tuesday, April 28, 2009 9:30 AM | Last reply by KristoferA - Monday, May 4, 2009 6:13 AM - Items 1 to 20 of 3221106 Next ›
No announcements
