I forgot to supply an example. The following is a minimal function that
gives the error
CREATE FUNCTION KUKU()
RETURNS INT
BEGIN
SET ROWCOUNT 1
return 1
END
"Boaz Ben-Porat" <bbp@.milestone.dk> wrote in message
news:O2BhOfTFGHA.3200@.tk2msftngp13.phx.gbl...
> When I call SET ROWCOUNT <number> inside a User Defined Function I get the
> following error:
> Error 443: Invalid use of 'UNKNOWN TOKEN' within a function.
> I couldn't find anything about this error in the BOL.
> Any solution ?
> TIA
> Boaz Ben-Porat
> Milestone systems
> Debmark
>A scalar UDF, by definition, returns exactly one "row", so what do you need
to override it for, and what do you consider to be a "row"? This returns a
single value... there are no rows or columns...
"Boaz Ben-Porat" <bbp@.milestone.dk> wrote in message
news:eqhochTFGHA.216@.TK2MSFTNGP15.phx.gbl...
>I forgot to supply an example. The following is a minimal function that
>gives the error
> CREATE FUNCTION KUKU()
> RETURNS INT
> BEGIN
> SET ROWCOUNT 1
> return 1
> END
>
>
> "Boaz Ben-Porat" <bbp@.milestone.dk> wrote in message
> news:O2BhOfTFGHA.3200@.tk2msftngp13.phx.gbl...
>
Showing posts with label returns. Show all posts
Showing posts with label returns. Show all posts
Tuesday, March 20, 2012
Saturday, February 25, 2012
Can I use a UDF in an IF statement?
Is it possible to use a user defined function in an IF statement? The UDF returns a scalar value. Like:
IF dbo.DoSomething (@.x)
The only way I can see to call a UDF is with
SELECT @.y = dbo.DoSomething (@.x)
Thank you!
YES but you have to compare its result with something or your function should return bit or integer value IF dbo.DoSomething (@.x)=1
Thursday, February 16, 2012
can I return output from stored procedure into an HTA to display in browser?
Hi all. I have a stored procedure on my sql server that returns a
simple informtation about that tim a database was backed up. I owuld
like to create an HTA that operator types can look at to make sure
that the backups finished, can someone help me do this?
simple informtation about that tim a database was backed up. I owuld
like to create an HTA that operator types can look at to make sure
that the backups finished, can someone help me do this?
The stored procedure in called sp_lastback and the output looks like
this:
database days since backup timestamp of backup
dbase1 0 2004-10-14 00:41:21.000
dbase2 0 2004-10-14 00:08:36.000
dbase3 1 2004-10-13 22:46:57.000
Can this be done? If someone could help me with this simple problem, I
could probably reuse the same method a 100 useful ways.
Thanks in advance!"sumGirl" <emebohw@.netscape.net> wrote in message
news:a5e13cff.0410141529.23a19fd8@.posting.google.c om...
> Hi all. I have a stored procedure on my sql server that returns a
> simple informtation about that tim a database was backed up. I owuld
> like to create an HTA that operator types can look at to make sure
> that the backups finished, can someone help me do this?
> The stored procedure in called sp_lastback and the output looks like
> this:
> database days since backup timestamp of backup
> dbase1 0 2004-10-14 00:41:21.000
> dbase2 0 2004-10-14 00:08:36.000
> dbase3 1 2004-10-13 22:46:57.000
> Can this be done? If someone could help me with this simple problem, I
> could probably reuse the same method a 100 useful ways.
> Thanks in advance!
You'll probably get a better response in a group for HTA users. I guess you
could write a client script to execute the procedure with ADO, then loop
over the ResultSet and build the .hta file dynamically, but I have no idea
about any details.
Simon|||Here's a generic technique to render a resultset using dynamic html. There
may be better ways to accomplish the task, though.
<html>
<head>
<body>
<Script Language="VBScript"
Sub btnListBackups_OnClick()
Set oConnection = CreateObject("ADODB.Connection")
oConnection.Open "Provider=SQLOLEDB" & _
";Data Source=" & "DBDELTA1" & _
";Integrated Security=SSPI"
Set recordSet = oConnection.Execute("EXEC tempdb..sp_lastback")
myResultTable = "<table border=""1"">"
myResultTable = myResultTable & "<tr>"
For i = 0 To recordSet.Fields.Count - 1
myResultTable = myResultTable & _
"<th>" & _
recordSet.Fields(i).Name & _
"</th>"
Next
myResultTable = myResultTable & "</tr>"
Do While Not recordSet.EOF
myResultTable = myResultTable & "<tr>"
For i = 0 To recordSet.Fields.Count - 1
myResultTable = myResultTable & _
"<td>" & _
recordSet.Fields(i).Value & _
"</td>"
Next
myResultTable = myResultTable & "</tr>"
recordSet.MoveNext
Loop
myResultTable = myResultTable & "</table>"
recordSet.Close
oConnection.Close
Results.innerHTML = myResultTable
End Sub
</script
<input type="button" id="btnListBackups" value="List Backups">
<hr>
<nobr Id=Results></nobr>
</body>
</html
--
Hope this helps.
Dan Guzman
SQL Server MVP
"sumGirl" <emebohw@.netscape.net> wrote in message
news:a5e13cff.0410141529.23a19fd8@.posting.google.c om...
> Hi all. I have a stored procedure on my sql server that returns a
> simple informtation about that tim a database was backed up. I owuld
> like to create an HTA that operator types can look at to make sure
> that the backups finished, can someone help me do this?
> The stored procedure in called sp_lastback and the output looks like
> this:
> database days since backup timestamp of backup
> dbase1 0 2004-10-14 00:41:21.000
> dbase2 0 2004-10-14 00:08:36.000
> dbase3 1 2004-10-13 22:46:57.000
> Can this be done? If someone could help me with this simple problem, I
> could probably reuse the same method a 100 useful ways.
> Thanks in advance!|||Thanks Dan! Thats exactly the kind of example I can run with!
Subscribe to:
Posts (Atom)