Click here to Skip to main content
15,904,346 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL question Pin
NewPureLand28-Aug-04 19:38
NewPureLand28-Aug-04 19:38 
GeneralRe: SQL question Pin
Colin Angus Mackay28-Aug-04 22:55
Colin Angus Mackay28-Aug-04 22:55 
GeneralRe: SQL question Pin
mike.hall@lehigh.edu30-Aug-04 2:46
mike.hall@lehigh.edu30-Aug-04 2:46 
Generalfunctions Pin
jairajanbrothers27-Aug-04 23:42
jairajanbrothers27-Aug-04 23:42 
GeneralRe: functions Pin
Mazdak27-Aug-04 23:51
Mazdak27-Aug-04 23:51 
GeneralRe: functions Pin
Colin Angus Mackay28-Aug-04 2:04
Colin Angus Mackay28-Aug-04 2:04 
GeneralRe: functions Pin
Mazdak28-Aug-04 3:10
Mazdak28-Aug-04 3:10 
GeneralRe: functions Pin
Colin Angus Mackay28-Aug-04 4:31
Colin Angus Mackay28-Aug-04 4:31 
Are you sure? I've checked the books online and I cannot see anything about running functions with the EXECUTE COMMAND. I also created a sample, on the Northwind database, to try out.

CREATE FUNCTION dbo.AllProducts()
RETURNS TABLE
AS
RETURN(SELECT * FROM PRODUCTS)

Then I tried to execute it like this:
EXECUTE dbo.AllProducts

I got an error message
Server: Msg 2809, Level 18, State 1, Line 1
The request for procedure 'AllProducts' failed because 'AllProducts' is a function object.



"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell

Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!


GeneralRe: functions Pin
Mazdak28-Aug-04 4:40
Mazdak28-Aug-04 4:40 
GeneralRe: functions Pin
Colin Angus Mackay28-Aug-04 2:04
Colin Angus Mackay28-Aug-04 2:04 
GeneralRe: functions Pin
Rocky Moore31-Aug-04 19:55
Rocky Moore31-Aug-04 19:55 
GeneralMdb question Pin
jzb27-Aug-04 23:40
jzb27-Aug-04 23:40 
GeneralRe: Mdb question Pin
Colin Angus Mackay28-Aug-04 2:08
Colin Angus Mackay28-Aug-04 2:08 
Questionado.net connections and .dispose? Pin
Roger Alsing27-Aug-04 1:39
Roger Alsing27-Aug-04 1:39 
AnswerRe: ado.net connections and .dispose? Pin
Colin Angus Mackay28-Aug-04 2:12
Colin Angus Mackay28-Aug-04 2:12 
GeneralRe: ado.net connections and .dispose? Pin
Roger Alsing29-Aug-04 20:25
Roger Alsing29-Aug-04 20:25 
GeneralRe: ado.net connections and .dispose? Pin
Colin Angus Mackay30-Aug-04 1:27
Colin Angus Mackay30-Aug-04 1:27 
AnswerRe: ado.net connections and .dispose? Pin
Rocky Moore31-Aug-04 20:01
Rocky Moore31-Aug-04 20:01 
GeneralIdentity primary key Pin
Diego F.26-Aug-04 23:18
Diego F.26-Aug-04 23:18 
GeneralRe: Identity primary key Pin
David Salter26-Aug-04 23:28
David Salter26-Aug-04 23:28 
GeneralRe: Identity primary key Pin
Diego F.26-Aug-04 23:50
Diego F.26-Aug-04 23:50 
GeneralRe: Identity primary key Pin
David Salter27-Aug-04 1:12
David Salter27-Aug-04 1:12 
GeneralRe: Identity primary key Pin
Colin Angus Mackay27-Aug-04 1:33
Colin Angus Mackay27-Aug-04 1:33 
GeneralSQL and the growing log file Pin
totig25-Aug-04 20:02
totig25-Aug-04 20:02 
GeneralRe: SQL and the growing log file Pin
mikasa26-Aug-04 3:40
mikasa26-Aug-04 3:40 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.