Viewing 15 posts - 106 through 120 (of 484 total)
Further more you can't return messages to stdout from VB so the output will always be NULL
You can get a return code from VB that maps to the ERRORLEVEL in...
November 26, 2002 at 3:11 am
Yep thats right its a really arse sometimes.
If you have a really complex expression put it in a derived table i.e
select fullname
from (
select Name + Surname as Fullname ) as...
November 26, 2002 at 3:08 am
A small note that TOP is mroe performanct than ROWCOUNT as it is integrated in the optimiser, which supports Gregs view on why it can't take a variable. I agree...
November 25, 2002 at 4:46 pm
Even better
exec sp_msforeachtable 'xp_cmdshell ''bcp database.? out ?.dat -S(local) -c -E'''
or something like that
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 3:47 pm
sysdepends will give you the information, depid points to the object id and dep number points to the colid.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 3:45 pm
Further more an indid of 0 or 255 represent the base table. 255 is when there is a text page being used.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 10:01 am
When the view is built I believe it actually converts the * to the column names at that time. If the columns change then the view won't, you need to...
November 25, 2002 at 9:59 am
This will do
select allocdet.*
from (select min(alloc_num) as alloc_num
from allocdet
group by price_num, serv_prlv, agent_num) a
inner join...
November 25, 2002 at 9:57 am
NO only the columns you specifiy get changed
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 8:39 am
Do you want the first row for an occurrence of price_num, serv_prlv, agent_num. Do you have a primary key on the table?
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 8:38 am
Don't know, anything like that gets messy with VB. I would definitely prefer the other mechanism of inserting into a second table and polling that table
Simon Sabin
Co-author of SQL Server...
November 25, 2002 at 8:32 am
Restoring master also restores the location and names of the other databases, if they do not exists then it should just set the to suspect. And from there you restored...
November 25, 2002 at 8:02 am
Implementing data level security can be a ***** so using multiple databases can solve this, but then, as said, the issue of consolidating, or splitting of data becomes and issue.
You...
November 25, 2002 at 6:41 am
It won't work. You would have to create a new thread under which the application runs.
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 6:28 am
-c is not essential, this just means it is not starting as a service, so can't be controlled through services
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
November 25, 2002 at 6:10 am
Viewing 15 posts - 106 through 120 (of 484 total)