Click here to Skip to main content
15,860,972 members
Home / Discussions / Database
   

Database

 
QuestionRe: sql server 2008 Pin
Eddy Vluggen18-Jan-13 1:30
professionalEddy Vluggen18-Jan-13 1:30 
GeneralRe: sql server 2008 Pin
Kapilkp20-Jan-13 23:06
Kapilkp20-Jan-13 23:06 
GeneralRe: sql server 2008 Pin
Eddy Vluggen21-Jan-13 1:15
professionalEddy Vluggen21-Jan-13 1:15 
GeneralRe: sql server 2008 Pin
PIEBALDconsult21-Jan-13 4:57
mvePIEBALDconsult21-Jan-13 4:57 
AnswerRe: sql server 2008 Pin
PIEBALDconsult18-Jan-13 4:01
mvePIEBALDconsult18-Jan-13 4:01 
Questionsql server Pin
yogika17-Jan-13 19:15
yogika17-Jan-13 19:15 
AnswerRe: sql server Pin
Eddy Vluggen18-Jan-13 1:37
professionalEddy Vluggen18-Jan-13 1:37 
AnswerRe: sql server Pin
Richard Deeming18-Jan-13 1:37
mveRichard Deeming18-Jan-13 1: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 Pin
Eddy Vluggen18-Jan-13 2:13
professionalEddy Vluggen18-Jan-13 2:13 
GeneralRe: sql server Pin
Richard Deeming18-Jan-13 2:18
mveRichard Deeming18-Jan-13 2:18 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 2:22
professionalEddy Vluggen18-Jan-13 2:22 
GeneralRe: sql server Pin
PIEBALDconsult18-Jan-13 14:36
mvePIEBALDconsult18-Jan-13 14:36 
AnswerRe: sql server Pin
PIEBALDconsult18-Jan-13 4:04
mvePIEBALDconsult18-Jan-13 4:04 
GeneralRe: sql server Pin
Shameel22-Jan-13 4:31
professionalShameel22-Jan-13 4:31 
QuestionDo I need a pivot Query? Pin
GREG_DORIANcod16-Jan-13 10:09
professionalGREG_DORIANcod16-Jan-13 10:09 
AnswerRe: Do I need a pivot Query? Pin
Mycroft Holmes16-Jan-13 19:36
professionalMycroft Holmes16-Jan-13 19:36 
GeneralRe: Do I need a pivot Query? Pin
GREG_DORIANcod17-Jan-13 1:59
professionalGREG_DORIANcod17-Jan-13 1:59 
AnswerRe: Do I need a pivot Query? Pin
Jörgen Andersson21-Jan-13 8:58
professionalJörgen Andersson21-Jan-13 8:58 
QuestionTotals of each transaction type Pin
Richard.Berry10015-Jan-13 21:38
Richard.Berry10015-Jan-13 21:38 
AnswerRe: Totals of each transaction type Pin
Mycroft Holmes15-Jan-13 22:57
professionalMycroft Holmes15-Jan-13 22:57 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 0:36
Richard.Berry10016-Jan-13 0:36 
GeneralRe: Totals of each transaction type Pin
PIEBALDconsult16-Jan-13 3:42
mvePIEBALDconsult16-Jan-13 3:42 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 5:36
Richard.Berry10016-Jan-13 5:36 
QuestionCustomize color coding in SQL editor window Pin
biop.codeproject15-Jan-13 20:04
biop.codeproject15-Jan-13 20:04 
AnswerRe: Customize color coding in SQL editor window Pin
Mycroft Holmes15-Jan-13 22:51
professionalMycroft Holmes15-Jan-13 22:51 

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.