Viewing 15 posts - 1 through 15 (of 137 total)
not sure if you can bcp from proc. As far as I know, can only bcp from table, view and query.
what you can do is grab the result set returned from...
September 18, 2006 at 4:04 pm
have you tried this sum(value1) + sum(value3) ?
your query has no control over how null value should be defined.
September 17, 2006 at 9:57 pm
also if you do :
select sum(value1+value2) -- you get unexpected result.
September 17, 2006 at 6:33 pm
one way is to use xp_cmdshell to call a batch file where the batch file contains the exec proc statement. In the function you can call the extended proc.
September 17, 2006 at 6:06 pm
I'm not saying that you're wrong. What you got there is correct.
It depends on how you want to treat the null value.
ie. if it is null do you want to...
September 17, 2006 at 3:32 pm
depends on how you call proc inside a function, there's always a work around.
Don't just accept what it is in bol.
September 17, 2006 at 3:21 pm
you're doing backup log from A and restore log to B.
if you want to create a new column do it in A, log shipping will automatically carry a new column...
September 14, 2006 at 4:14 pm
replication is good a choice, you can control how/when you want to do the move.
another way is, what about using timestamp datatype on source and varbinary(8) on destination. This is how...
September 14, 2006 at 3:51 pm
The orginal question "I can save a DTSpackage as DSTpack.BAS. But, how can I load this file again in my DTS-editor? I can do this with files with .DTS...
September 14, 2006 at 3:40 pm
I thinks you still can....though I never tested.
if you can call clr in a stored proc you can call it a function.
September 14, 2006 at 3:35 pm
you have to think again... where putting isnull before or after the sum function.
September 14, 2006 at 3:30 pm
September 13, 2006 at 9:42 pm
you can put a quote on the alias name eg. select dbid 'sid' from sysdatabases
September 13, 2006 at 6:36 pm
if you save a dtspackage as vba file, can you re-open it in the dts gui?
September 13, 2006 at 6:14 pm
you can do whatever you want in a function, update/insert/delete exec proc..etc
As long as the function returns a value.
September 13, 2006 at 5:57 pm