Viewing 15 posts - 5,806 through 5,820 (of 9,399 total)
Instead of using:
DECLARE @a int;
SET @a = 52;
DECLARE @str nvarchar;
EXEC @str = TwoDigitsNumber @a;
SELECT @str;
GO
Use:
DECLARE @a int;
SET @a = 52;
DECLARE @str nvarchar(20);
EXEC @str = TwoDigitsNumber @a;
SELECT @str;
GO
June 12, 2015 at 8:11 am
koles2004 (6/12/2015)
I use nvarchar(20) everywhere, but it doesn't help (
When you call your function, you're using the following line to declare your variable:
DECLARE @str nvarchar;
The function may return properly, but...
June 12, 2015 at 8:03 am
Phil hit the nail on the head. With a declared variable, if you don't specify a size for your string, the default length is 1.
June 12, 2015 at 8:01 am
crookj (6/12/2015)
Ed Wagner (6/12/2015)
BWFC (6/12/2015)
Eirikur Eiriksson (6/12/2015)
Ed Wagner (6/12/2015)
crookj (6/12/2015)
Ed Wagner (6/12/2015)
BWFC (6/12/2015)
djj (6/12/2015)
BL0B_EATER (6/12/2015)
Eirikur Eiriksson (6/11/2015)
TomThomson (6/11/2015)
Ed Wagner (6/11/2015)
djj (6/11/2015)
eccentricDBA (6/11/2015)
Eirikur Eiriksson (6/11/2015)
Ed Wagner (6/11/2015)
crookj (6/11/2015)
ZZartin (6/11/2015)
BottleRum
Running
quirky
Qt
cutie
QT?
One Way
Communication
Cycle
Motorcycle
Void
Null
Not
Logical
Captain
Admiral
rear...
June 12, 2015 at 7:59 am
BWFC (6/12/2015)
Eirikur Eiriksson (6/12/2015)
Ed Wagner (6/12/2015)
crookj (6/12/2015)
Ed Wagner (6/12/2015)
BWFC (6/12/2015)
djj (6/12/2015)
BL0B_EATER (6/12/2015)
Eirikur Eiriksson (6/11/2015)
TomThomson (6/11/2015)
Ed Wagner (6/11/2015)
djj (6/11/2015)
eccentricDBA (6/11/2015)
Eirikur Eiriksson (6/11/2015)
Ed Wagner (6/11/2015)
crookj (6/11/2015)
ZZartin (6/11/2015)
BottleRum
Running
quirky
Qt
cutie
QT?
One Way
Communication
Cycle
Motorcycle
Void
Null
Not
Logical
Captain
Admiral
June 12, 2015 at 7:48 am
crookj (6/12/2015)
Ed Wagner (6/12/2015)
BWFC (6/12/2015)
djj (6/12/2015)
BL0B_EATER (6/12/2015)
Eirikur Eiriksson (6/11/2015)
TomThomson (6/11/2015)
Ed Wagner (6/11/2015)
djj (6/11/2015)
eccentricDBA (6/11/2015)
Eirikur Eiriksson (6/11/2015)
Ed Wagner (6/11/2015)
crookj (6/11/2015)
ZZartin (6/11/2015)
BottleRum
Running
quirky
Qt
cutie
QT?
One Way
Communication
Cycle
Motorcycle
Void
Null
Not
June 12, 2015 at 7:04 am
Jason, the local PASS chapter is called SPID. It meets on the second Tuesday of the month at the Microsoft office in Southfield and starts at 6:00. It's...
June 12, 2015 at 6:15 am
Joel Ewald (6/12/2015)
It depends on the business value and cost.
Agreed. Risk versus reward has to evaluated.
June 12, 2015 at 5:51 am
Ed Wagner (6/12/2015)
Procedures are simpler to rename, but they have...
June 12, 2015 at 5:49 am
I don't generally rename tables, columns, etc. once they're in production. There are just too many things that reference it.
Procedures are simpler to rename, but they have to be...
June 12, 2015 at 5:24 am
The question had several things to look at and consider. Nice.
June 12, 2015 at 4:51 am
BWFC (6/12/2015)
djj (6/12/2015)
BL0B_EATER (6/12/2015)
Eirikur Eiriksson (6/11/2015)
TomThomson (6/11/2015)
Ed Wagner (6/11/2015)
djj (6/11/2015)
eccentricDBA (6/11/2015)
Eirikur Eiriksson (6/11/2015)
Ed Wagner (6/11/2015)
crookj (6/11/2015)
ZZartin (6/11/2015)
BottleRum
Running
quirky
Qt
cutie
QT?
One Way
Communication
Cycle
Motorcycle
Void
June 12, 2015 at 4:47 am
djj (6/11/2015)
eccentricDBA (6/11/2015)
Eirikur Eiriksson (6/11/2015)
Ed Wagner (6/11/2015)
crookj (6/11/2015)
ZZartin (6/11/2015)
BottleRum
Running
quirky
Qt
cutie
QT?
June 11, 2015 at 1:12 pm
There's a duplicate post at http://www.sqlservercentral.com/Forums/Topic1693743-3077-1.aspx with a solution that worked.
June 11, 2015 at 12:43 pm
drew.allen (6/11/2015)
Also, IMNSHO you should almost never use spaces in column or table names.
+1000.
Is this homework? I'm asking because you have things in your OP that don't make sense....
June 11, 2015 at 12:06 pm
Viewing 15 posts - 5,806 through 5,820 (of 9,399 total)