michael.leach2015

Forum Replies Created

Viewing 15 posts - 106 through 120 (of 146 total)

RE: What it means to atomize values in 1st normal form

Sue_H - Monday, February 4, 2019 9:29 PM
michael.leach2015 - Monday, February 4, 2019 7:25 PM

February 4, 2019 at 10:50 pm

#2021103
RE: Cause of arithmetic overflow error?

Johnson Welch - Friday, February 1, 2019 10:54 PM
The error comes when you are trying to convert numeric or decimal value into...

February 4, 2019 at 7:11 pm

#2021096
RE: Purpose of SELECT before a calcuating the value of a function's return variable

Luis Cazares - Thursday, January 31, 2019 11:09 AM
michael.leach2015 - Thursday, January 31, 2019 10:25 AM

January 31, 2019 at 11:54 am

#2020753
RE: Can stored procedures return/output a value like a function can?

Chris Wooding - Thursday, January 31, 2019 9:30 AM
I tend to structure stored procedures like this.

begin try
-- Do some...

January 31, 2019 at 10:43 am

#2020742
RE: Can stored procedures return/output a value like a function can?

Sue_H - Wednesday, January 30, 2019 7:40 AM
michael.leach2015 - Tuesday, January 29, 2019 10:40 PM

January 31, 2019 at 10:34 am

#2020741
RE: Cause of arithmetic overflow error?

Sue_H - Thursday, January 31, 2019 9:45 AM
I mixed them up when I posted and didn't make it clear enough on...

January 31, 2019 at 10:31 am

#2020740
RE: Cause of arithmetic overflow error?

Luis Cazares - Thursday, January 31, 2019 9:16 AM
michael.leach2015 - Thursday, January 31, 2019 8:44 AM

January 31, 2019 at 10:30 am

#2020739
RE: Purpose of SELECT before a calcuating the value of a function's return variable

gvoshol 73146 - Thursday, January 31, 2019 8:45 AM
You can code something like this for SELECT

SELECT
@a...

January 31, 2019 at 10:25 am

#2020737
RE: Cause of arithmetic overflow error?

Sue_H - Thursday, January 31, 2019 7:45 AM
michael.leach2015 - Wednesday, January 30, 2019 10:54 PM

January 31, 2019 at 8:44 am

#2020715
RE: Purpose of SELECT before a calcuating the value of a function's return variable
gvoshol 73146 - Thursday, January 31, 2019 5:22 AM
Remember some key differences when using SET or SELECT:
SET can only assign...
January 31, 2019 at 8:36 am

#2020712
RE: Cause of arithmetic overflow error?

Sue_H - Wednesday, January 30, 2019 6:38 PM
michael.leach2015 - Wednesday, January 30, 2019 4:26 PM

January 30, 2019 at 10:54 pm

#2020657
RE: Cause of arithmetic overflow error?

drew.allen - Wednesday, January 30, 2019 4:19 PM
Precision, scale, and Length
Because NUMERIC(4,2) sets two spaces for decimals, which only...

January 30, 2019 at 5:17 pm

#2020649
RE: Cause of arithmetic overflow error?

Sue_H - Wednesday, January 30, 2019 4:10 PM
michael.leach2015 - Wednesday, January 30, 2019 3:45 PM

January 30, 2019 at 4:26 pm

#2020648
RE: Purpose of SELECT before a calcuating the value of a function's return variable

Jeff Moden - Tuesday, January 29, 2019 10:45 PM
Would you post your original code as code as a graphic so that I...

January 29, 2019 at 11:31 pm

#2020525
RE: Can stored procedures return/output a value like a function can?

Sue_H - Tuesday, January 29, 2019 5:15 PM
michael.leach2015 - Tuesday, January 29, 2019 4:09 PM

January 29, 2019 at 10:40 pm

#2020520

Viewing 15 posts - 106 through 120 (of 146 total)