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.
| Author |
Topic |
|
jeff06
Posting Yak Master
166 Posts |
 Posted - 2007-08-14 : 14:27:56
|
| I only have select right to sql server, I wonder is there a way in tsql to define a temprary funtion for repetitive work.I want something like that.select myvalue=mytempfuntion(a.date) from mytable a.---how to define my temp funciton?mytemfunction(date)-------Thanks |
|
|
pootle_flump
1064 Posts |
Posted - 2007-08-14 : 14:33:16
|
| Not without some sort of permissions to create objects. What is the function? Maybe it is simple enough to include directly in the SQL (which has the added bonus of probably being much more efficient). |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-08-14 : 14:35:06
|
| if you have only select rights then no you can't.try using tempDb. maybe you can create it there and then call your functions with tempDb..functionName._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
|
|
|
Temprary function