Viewing 15 posts - 12,871 through 12,885 (of 14,953 total)
balbirsinghsodhi (7/11/2008)
That is not a temp table. It's a real table with # in the begning.
What database does it say it exists in?
July 14, 2008 at 7:33 am
g.brennan (7/13/2008)
Assuming you are using some form of integer as identity, you have a misconception about actual byte storage in the low-level workings of a computer. Recall that integer...
July 14, 2008 at 7:31 am
I really can't give you a meaningful VB example, since it's going to be specific to your application. In VBA, you would create a filesystem object, define a textstream...
July 14, 2008 at 7:26 am
Generally, since it reduces IO from the disk, it will probably result in an improvement in performance.
In most modern computers, the CPU has clock cycles to spare that can be...
July 14, 2008 at 7:12 am
The NullIf thing will only work if the value is -1 (or am I missing something). I'm assuming the possibility exists for any valid negative integer.
And yes, subtracting the...
July 11, 2008 at 3:13 pm
The way to get the result you're looking for is:
select
case contacttitle
when 'Owner' then 'Honcho'
else 'Peon'
end as Newtitle
from customers
"If" is a flow control, not a data function.
July 11, 2008 at 3:08 pm
I guess it depends on your hardware, but Crystal is pretty resource hungry (or was last time I played with it), and might cut into what SQL Server wants.
With that...
July 11, 2008 at 3:04 pm
Since Enterprise is an upgrade from Standard, you should be able to use that without any problems. Call/e-mail MS customer support if you need their exact answer on it,...
July 11, 2008 at 3:02 pm
Either some application is trying to connect to the server using that, or some person is.
Have you traced what that login is doing in the database and server? (Profiler...
July 11, 2008 at 2:59 pm
Assuming this is a temp table, created by someone else, why are you trying to drop it anyway? There's generally no need to do so, and if they are...
July 11, 2008 at 2:57 pm
Carl Federl (7/11/2008)
create table...
July 11, 2008 at 2:55 pm
Can you give me a table structure for those last two tables? I think they're the last ones I'm missing. (And sample data, of course.)
I think I can...
July 11, 2008 at 2:51 pm
A delete trigger will have effectively zero impact on inserts and updates. It will have an impact on deletes, obviously, but if you just dump the "deleted" table contents...
July 11, 2008 at 2:49 pm
Viewing 15 posts - 12,871 through 12,885 (of 14,953 total)