Êàê çàïóñòèòü ïîëüçîâàòåëüñêóþ function íà SQL ñåðâåðå? È ïîëó÷èòü îòâåò
|
|
Ñðåäà, 14 Ìàðòà 2018 ã. 08:50
+ â öèòàòíèê
Ñ êîäîì íà çàïóñê õðàíèìêè ðàçîáðàëñÿ. À âîò ñ function...
Âîò êîä äëÿ çàïóñêà õðàíèìêè
Private Sub Blocada(Íîìåð As Long, Chel As String, YesNo As Integer)
Dim cmd As ADODB.Command
Set tek = CurrentProject.Connection
Set cmd = New ADODB.Command
cmd.ActiveConnection = tek
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "Blocada"
cmd.Parameters("@Íîìåð") = Íîìåð
cmd.Parameters("@Name") = Chel
cmd.Parameters("@YesNo") = YesNo
cmd.Execute , , Options:=adExecuteNoRecords
Set cmd = Nothing
Set tek = Nothing
End Sub
À êàê function? È ïîëó÷èòü îòâåò? Èëè Õðàíèìêà ìîæåò îòâåòèòü?
http://www.sql.ru/forum/1287614/kak-zapustit-polzovatelskuu-function-na-sql-servere-i-poluchit-otvet
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-