Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lock row
Message
From
21/03/2004 06:04:51
Fabio Lunardon
Lunacom
Marostica, Italy
 
 
To
20/03/2004 17:45:59
Wilson Guerra
Villanueva, Honduras
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Re: Lock row
Miscellaneous
Thread ID:
00888209
Message ID:
00888271
Views:
11

Would this worked?

UPDATE dbo.myTable SET column1=MyFunction(column1),@myValue=MyFunction(column1) WHERE selectTheRow

UserDefine function
---------
MyFunction(@Number)
return @Number + 1

Just an example, maybe sintax is not correct


Only if MyFunction() is deterministic.

Fabio
Previous
Reply
Map
View

Click here to load this message in the networking platform