Click here to Skip to main content
11,409,097 members (64,780 online)


AnswerRe: sql server 2008 PinmemberPIEBALDconsult18-Jan-13 5:01 
Questionsql server Pinmemberyogika17-Jan-13 20:15 
AnswerRe: sql server PinmvpEddy Vluggen18-Jan-13 2:37 
AnswerRe: sql server PinmemberRichard Deeming18-Jan-13 2:37 
  1. Wrong; a table-valued function[^] may return more than one value as part of a result-set;
  2. Correct; functions may not have OUTPUT parameters;
  3. Wrong; a multi-statement UDF may contain[^]:
    • assignment statements;
    • control-of-flow statements (except TRY...CATCH);
    • DECLARE statements;
    • SELECT statements;
    • cursor operations referencing local cursors;
    • INSERT, UPDATE and DELETE statements modifying local table variables; and
    • EXECUTE statements calling extended stored procedures[^];

  4. Sort-of; a function may call an extended stored procedure[^], but not a regular stored procedure;
  5. Correct; a function may not contain a TRY...CATCH block;

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 3:13 
GeneralRe: sql server PinmemberRichard Deeming18-Jan-13 3:18 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 3:22 
GeneralRe: sql server PinmemberPIEBALDconsult18-Jan-13 15:36 
AnswerRe: sql server PinmemberPIEBALDconsult18-Jan-13 5:04 
GeneralRe: sql server PinmemberShameel22-Jan-13 5:31 

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

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

Advertise | Privacy | Mobile
Web03 | 2.8.150414.5 | Last Updated 24 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid