Click here to Skip to main content
       

Database

 
QuestionRe: sql server 2008 PinmvpEddy Vluggen18-Jan-13 2:30 
GeneralRe: sql server 2008 PinmemberKapilkp21-Jan-13 0:06 
GeneralRe: sql server 2008 PinmvpEddy Vluggen21-Jan-13 2:15 
GeneralRe: sql server 2008 PinmemberPIEBALDconsult21-Jan-13 5:57 
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 
QuestionDo I need a pivot Query? PinmemberGREG_DORIANcod16-Jan-13 11:09 
AnswerRe: Do I need a pivot Query? PinmemberMycroft Holmes16-Jan-13 20:36 
GeneralRe: Do I need a pivot Query? PinmemberGREG_DORIANcod17-Jan-13 2:59 
AnswerRe: Do I need a pivot Query? PinmemberJörgen Andersson21-Jan-13 9:58 
QuestionTotals of each transaction type PinmemberRichard.Berry10015-Jan-13 22:38 
AnswerRe: Totals of each transaction type PinmemberMycroft Holmes15-Jan-13 23:57 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 1:36 
GeneralRe: Totals of each transaction type PinmemberPIEBALDconsult16-Jan-13 4:42 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 6:36 
QuestionCustomize color coding in SQL editor window [modified] Pinmemberbiop.codeproject15-Jan-13 21:04 
AnswerRe: Customize color coding in SQL editor window PinmemberMycroft Holmes15-Jan-13 23:51 

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
Web04 | 2.8.1411022.1 | Last Updated 22 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid