Thiyagu-343189
SSC Veteran
Points: 209
More actions
June 27, 2006 at 8:14 am
#169316
Hi to all
Can i use insert statement inside the user defined function? if no can u give the reason
Eddie Wuerch
SSChampion
Points: 12535
June 27, 2006 at 8:29 am
#646075
This sounds like a homework question...
Have you tried it? What was the result and what would you like explained?
-Eddie
Eddie WuerchMCM: SQL
June 27, 2006 at 10:13 pm
#646272
Msg 443, Level 16, State 15, Procedure sample, Line 9
Invalid use of side-effecting or time-dependent operator in 'INSERT' within a function.
Bhushan
Default port
Points: 1427
June 28, 2006 at 10:16 am
#646414
SQL Server will not support using DML statements inside UDF
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply