No announcements
Found 3102574 threads
-
1 VotesUser-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 | 1235 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
T-SQL: User defined type table SQL server 2005
As suggested by "Tom Cooper" User Defined Table types are available in SQL Servr 2008 or above.Answered | 2 Replies | 620 Views | Created by virttop - Saturday, May 7, 2016 1:37 PM | Last reply by Khanna Gaurav - Saturday, May 7, 2016 7:00 PM -
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 | 7831 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-Defined Table Types
User Defined Table types when passed as table-valued parameters (TVP) to store procedure, do not maintain statistics.Answered | 2 Replies | 5395 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
But you would first have to convert the document to nvarchar(MAX), because you cannot pass the xml data type over linked servers.Answered | 5 Replies | 5726 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
Using User Defined Table Types...
User defined table data type only works for SQL 2008 or later.Answered | 12 Replies | 16945 Views | Created by rebulanyum - Friday, March 25, 2011 8:20 AM | Last reply by rebulanyum - Friday, March 25, 2011 3:15 PM -
0 Votes
What are User-Defined Table Types?
If you say that "phone" should always be a varchar(25) you can define such a UDT in the following way: -- Create the data type CREATE TYPE ...Answered | 2 Replies | 3222 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
User Define Table Type
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.seAnswered | 2 Replies | 764 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
script failur on user defined table type
Hi JimHoopsDSC, Firstly, you can execute the following T-SQL statements to check if the User-Defined Table Type ...Answered | 1 Replies | 1984 Views | Created by JimHoopsDSC - Thursday, August 20, 2015 3:08 PM | Last reply by Lydia Zhang - Tuesday, August 25, 2015 3:55 AM -
0 Votes
SQL User Defined Data Type
just in case someone else is trying to do something similar, just found out that since SQL 2005, you cannot creat RULES, so it seems UDTs are USELESS in SQL server ...Answered | 7 Replies | 3258 Views | Created by tmpp - Wednesday, January 21, 2009 4:05 PM | Last reply by Rudedog2 - Thursday, January 22, 2009 9:13 PM -
0 Votes
User-Defined Table Types - nested
Unfortunately, you confused the discussion with your initial statements about nested tables.Answered | 1 Replies | 3508 Views | Created by sakhi5 - Monday, June 10, 2013 7:05 PM | Last reply by scott_morris-ga - Tuesday, June 11, 2013 2:11 PM -
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 | 906 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
How to migrate user defined Table type in sqlserver 2008 to 2005?
Hi UserDefined Table Types were a new feature in SQL 2008, so you won't be able to recreate them in SQL 2005.Answered | 1 Replies | 1787 Views | Created by mohankumardotnet - Monday, September 24, 2012 11:10 AM | Last reply by Seth Lynch - Monday, September 24, 2012 11:27 AM -
0 Votes
User Define Types
User-Defined Types mainly have two types: User-Defined data type and User-Defined Tables ...Answered | 3 Replies | 520 Views | Created by srinivas_ch - Tuesday, April 21, 2020 10:54 AM | Last reply by Lily Lii - Thursday, April 23, 2020 8:33 AM -
1 Votes
User Defined Table Types and BCP Export
this script below is working but when I incorporate bcp, it throws an error to declare scalar variable @TVP_GLICU You are making a new connection to SQL ...Answered | 4 Replies | 895 Views | Created by Codernater - Monday, August 14, 2017 3:39 PM | Last reply by Erland Sommarskog - Monday, August 14, 2017 9:52 PM -
1 Votes
User defined data type
User defined data types are most commonly used when consistency among several tables storing the same type of ...Answered | 5 Replies | 1172 Views | Created by PAPIAS53 - Sunday, December 7, 2014 8:34 AM | Last reply by dani671 - Friday, December 12, 2014 10:24 PM -
1 Votes
How to use user Defined table types?
create type tt_example AS TABLE (spid int) go create procedure usp_example @spids tt_example ...Answered | 2 Replies | 18909 Views | Created by QLoveQ - Monday, June 4, 2012 8:59 AM | Last reply by QLoveQ - Tuesday, June 5, 2012 3:39 AM -
0 Votes
Identity user defined type
SQL Server does not support that kind of user defined data type.Answered | 12 Replies | 608 Views | Created by ZionAssedo - Monday, November 27, 2017 11:17 AM | Last reply by ZionAssedo - Monday, December 18, 2017 3:21 PM -
0 Votes
Linked Server and user defined data types with rule
Also I have been able to recreate the senario on 2 of our other servers and it works fine(1 SQL Server 2005 and 1 SQL Server ...Answered | 3 Replies | 3534 Views | Created by schwabbie88 - Monday, November 7, 2011 5:59 PM | Last reply by Stephanie Lv - Thursday, November 10, 2011 7:48 AM -
1 Votes
change structure of a User Defined Table Types
You can not change a type if you have a stored procedure depending on that type.Answered | 4 Replies | 779 Views | Created by neibala - Wednesday, November 4, 2015 12:05 AM | Last reply by Naomi N - Thursday, November 5, 2015 4:32 PM - Items 1 to 20 of 3102574 Next ›
No announcements
