Click here to Skip to main content
15,908,166 members
Home / Discussions / Database
   

Database

 
AnswerRe: sql Date conversion not working in sql 2000 Pin
Eddy Vluggen8-Jun-12 1:51
professionalEddy Vluggen8-Jun-12 1:51 
AnswerRe: sql Date conversion not working in sql 2000 Pin
Luc Pattyn8-Jun-12 2:47
sitebuilderLuc Pattyn8-Jun-12 2:47 
AnswerRe: sql Date conversion not working in sql 2000 Pin
PIEBALDconsult8-Jun-12 4:11
mvePIEBALDconsult8-Jun-12 4:11 
AnswerRe: sql Date conversion not working in sql 2000 Pin
vvashishta10-Jun-12 19:09
vvashishta10-Jun-12 19:09 
Questionfunction Pin
Rafat Ali Khan7-Jun-12 21:39
Rafat Ali Khan7-Jun-12 21:39 
AnswerRe: function Pin
Simon_Whale7-Jun-12 21:42
Simon_Whale7-Jun-12 21:42 
AnswerRe: function Pin
vvashishta10-Jun-12 19:10
vvashishta10-Jun-12 19:10 
AnswerRe: function Pin
kmoorevs14-Jun-12 5:08
kmoorevs14-Jun-12 5:08 
Table-Valued functions are awesome, like a view with input parameters. Like this:
CREATE FUNCTION [dbo].[Function_Name] (@inputParameter int) RETURNS table AS Return (<select clause> <from clause> WHERE <filterFieldName> = @inputParameter [<group by clause>])

Works in sql 2000+.
"Go forth into the source" - Neal Morse

QuestionHow to send an invitation mail in c# to a client Pin
rp7867-Jun-12 18:43
rp7867-Jun-12 18:43 
AnswerRe: How to send an invitation mail in c# to a client Pin
Paul Conrad7-Jun-12 18:49
professionalPaul Conrad7-Jun-12 18:49 
AnswerRe: How to send an invitation mail in c# to a client Pin
Sandeep Mewara7-Jun-12 20:04
mveSandeep Mewara7-Jun-12 20:04 
AnswerRe: How to send an invitation mail in c# to a client Pin
vvashishta10-Jun-12 19:11
vvashishta10-Jun-12 19:11 
QuestionSQL Server CLR Parameter Types Pin
cjb1106-Jun-12 4:32
cjb1106-Jun-12 4:32 
AnswerRe: SQL Server CLR Parameter Types Pin
PIEBALDconsult6-Jun-12 4:58
mvePIEBALDconsult6-Jun-12 4:58 
QuestionOR in a JOIN Pin
PIEBALDconsult5-Jun-12 13:51
mvePIEBALDconsult5-Jun-12 13:51 
AnswerRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 14:03
professionalPaul Conrad5-Jun-12 14:03 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult5-Jun-12 14:26
mvePIEBALDconsult5-Jun-12 14:26 
AnswerRe: OR in a JOIN Pin
Luc Pattyn5-Jun-12 16:27
sitebuilderLuc Pattyn5-Jun-12 16:27 
GeneralRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 17:00
professionalPaul Conrad5-Jun-12 17:00 
AnswerRe: OR in a JOIN Pin
Luc Pattyn5-Jun-12 17:31
sitebuilderLuc Pattyn5-Jun-12 17:31 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult5-Jun-12 18:10
mvePIEBALDconsult5-Jun-12 18:10 
GeneralRe: OR in a JOIN Pin
Paul Conrad5-Jun-12 19:15
professionalPaul Conrad5-Jun-12 19:15 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 3:46
mvePIEBALDconsult6-Jun-12 3:46 
GeneralRe: OR in a JOIN Pin
Paul Conrad6-Jun-12 7:38
professionalPaul Conrad6-Jun-12 7:38 
GeneralRe: OR in a JOIN Pin
PIEBALDconsult6-Jun-12 9:12
mvePIEBALDconsult6-Jun-12 9:12 

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.