-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Êàê çàïóñòèòü ïîëüçîâàòåëüñêóþ 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


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó