Viewing 15 posts - 12,886 through 12,900 (of 13,469 total)
could the entire row of each data be considered unique? or would there be multiple rows with identical data?
basically, if you can't identify what makes the row unique, you can't...
November 28, 2006 at 12:38 pm
typically, you use SQL Server to store the blob, and something like ADO to do the actual stream-to-file operations.
as far as i know, if you were to try and do...
November 27, 2006 at 10:42 pm
just wanted to confirm you must write to the registry at [HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group],
adding it to the .Default does not work, so forget that idea.
much easier...
November 22, 2006 at 7:59 am
i know you can export the registry key and port it to other machines;
[HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X\SQL Server Group], but to add the items via a program would basically...
November 22, 2006 at 7:38 am
not sure about bcp, but you can easily do it like this:
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=D:\testing.xls;',
'SELECT * FROM [Sheet1$]') select * from SQLServerTable
insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel...
November 22, 2006 at 7:23 am
if you have both SQL2005 and SQL 2000 , you can retore the 2005 on a 2005 instance, and then use SQL2000 DTS to connect to the 2005 server and...
November 22, 2006 at 7:01 am
if a table is assigned to a filegroup, it stays within that file group.
if the filegroup is comprised of more than one physical file, when inserts occur, the data...
November 22, 2006 at 6:31 am
on a slight tangent, in sql 2005 i know there is a SQL Native Client, which is the provider that replaces SQLOLEDB to connect to a SQL instance...maybe he's trying...
November 20, 2006 at 8:41 am
I seem to remember that the first time a query is run is typically the longest... SQL server builds an execution plan and saves it on the first time; subsequent...
November 20, 2006 at 8:04 am
If it were me, I think i'd add all the product details to the actual order detail table at the time of order creation. I'd add all the relevant product...
November 20, 2006 at 8:00 am
the usual story around my shop...we have tons of desktop-type machines, with a gig of ram and a P2.0 or above processor; I can have a dozen of em if...
November 17, 2006 at 1:04 pm
Pretty sure you just set it's size in Enterprise manager:
right click on tempdb in EM and choose properties....
Click the Data File tab; my db was defaulted to 8meg; changed it...
November 17, 2006 at 11:42 am
SELECT ID FROM tblProjects WHERE
NOT (ID IN (SELECT ProjectID FROM tblLinks))
the above would return no rows if there is a ProjectId that is NULL.
change to this:
SELECT...
November 17, 2006 at 11:36 am
you will have to update the base tables;
a view is really just a saved SELECT statement. this article might help a little bit:
http://www.sql-server-performance.com/nn_views.asp
you'd most likely want to create a...
November 17, 2006 at 10:27 am
this works for me, assuming the files and the folder structure exists: I'm moving a local file to a server named DAISY. The server has a share named C_DRIVE, and...
November 17, 2006 at 10:11 am
Viewing 15 posts - 12,886 through 12,900 (of 13,469 total)