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 2000 Forums
 SQL Server Development (2000)
 user datatype

Author  Topic 

misterraj
Yak Posting Veteran

94 Posts

Posted - 2004-12-14 : 23:29:17
is this possible in T-sql. This is a pseudo-code of what has to be transalted as sql-stmt.

stored proc1
{
struct a{
int b;
char c
}
func1(a)
func2(a)
}

func1(a) func2(a)
{ {
a.b = 1 a.b= a.c
} }


a must be a datatype of struct or a user defined datatype, and is global. is this possible to do in t-sql, if so how?

Thanks,
Venkat.

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2004-12-14 : 23:49:17
check user-defined data types in BOL

--------------------
keeping it simple...
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2004-12-14 : 23:52:27
Duplicate post but:

Look at what is being done rather than how it is being done and you'll probably find it's simple.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -