|
|
|
November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 SQL SErver installation Posted by Jouhayna at 6/28/2007 10:46:01 PM Hi ,
Thanks for every one trying helping me .
I need to ask a questiom about installaion the SQL Server Managment studio
in SQL 2005
which is enterprise Manager in SQL SEVER 2000 .
Really I have installed a tested phase of all the SQLSERVER 2005 collection
from Server management...more >>
SQL problem... Posted by Bauhaus at 6/28/2007 8:42:12 PM Hello,
I'm an Access/SQL novice and I have an sql problem:
I have the following table Price:
FuelID PriceDate Price
LPG 1/05/2007 0,2
LPG 13/05/2007 0,21
SPS 2/05/2007 1,1
SPS 15/05/2007 1,08
And I have to make the following query:
FuelID PriceDate_from PriceDa...more >>
Just learing SQL Server 2005, but have to export images from a table Posted by PJ at 6/28/2007 2:50:51 PM I am trying to figure out how to export a table of images stored on a SQL
2005 database to a directory on the local drive. In SQL 2000 one would use
DTS, but this does not seem to be the way to do it in 2005. Does anyone
happen to have a T-SQL script or maybe an explanation on how to do this...more >>
SQL Related Error Messages In Event Viewer. Posted by John at 6/28/2007 12:55:28 PM I have Vista Business with SQLserver2005 and SP2. I am having these two
error messages and would like any help.
This is related to SQL Browser: The configuration of the AdminConnection\TCP
protocol in the SQL instance MSSMLBIZ is not valid.
This is related to MSSQLServerADHelper: '0' is an i...more >>
Import CSV file to SQL table Posted by nelson at 6/28/2007 12:00:00 AM Greetings,
How do I import data from CSV file (source.csv) to my MSSQL table
(dbo.target)?
Kindly advise.
Thanks
ascll
...more >>
Query problem: Conditional/transform Posted by Arild Grimstad at 6/26/2007 12:00:00 AM Hello out there, hope anyone could help with a small problem when querying
two tables. Here is a shaved and simplified description to focus on where I
am banging my head into the wall. Two tables like this (example data),
Person and Activity:
Pid Name
01 Joe
02 Tim
03 Alan
Aid ...more >>
SQL 2005 Express, Insert & NoNullAllowedException Posted by Alexander Gorbylev at 6/25/2007 6:35:01 PM Dear Sirs,
I have a traditional SQL 2005 Express table with fields,
e.g.
SubsurfaceID - (PKey) int, Not NULL (autoincremental from 1 by step 1),
Name - varchar,
Field1 stc.
After INSERT by TableAdapter VS 2005 I got exception
"NoNullAllowedException":
DataRow newSubsurface =...more >>
newbie: databases attach as read-only Posted by R.A.M. at 6/25/2007 6:32:11 PM Hello,
I would like to ask you such question. I created database but after
reinstalling Windows XP and SQL Server 2005 it attaches as read-only. What
should I do to have full access?
Thanks for help
/RAM/
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Help with this Query Posted by rhaazy at 6/25/2007 4:35:57 PM I have a results table with details in it, each detail has a detail
ID. There is a detail table with all the detail IDs. The detail IDs
belong to root IDs. More than one detail ID can belong to a root ID.
For example.
rootID1 detailID1 result
rootID1 detailID2 ...more >>
exec sp inside a sp? Posted by SAC at 6/25/2007 10:08:25 AM I'm using 2000
Can I execute a stored procedure within another stored procedure.
I tried exec sp_name buy got an error. The sp I'm attempting to run uses
bcp.
Any ideas?
Thanks.
...more >>
Recover Model Database Posted by Gabe Matteson at 6/25/2007 12:56:13 AM SQL 2000.
I was trying to move the system files, I managed to move the master, msdb,
tempdb but then it died on the model. and I need to recover database... the
sql service keeps failing. thank you!!!
...more >>
stored procedure variable from ms access frontend Posted by SAC at 6/23/2007 11:25:13 AM I have a stored procedure which uses an input variable.
I'm using ms access as the frontend.
I've attempted to use a pass thru query and used a reference to a control on
a form to pass the variable but I haven't been able to get it to work.
What should I do?
Thank!
...more >>
Import an Excel spreadsheet Posted by SAC at 6/22/2007 5:46:51 AM I'm using 2000.
I'd like to know how to write the code to use in a stored procedure to
import a spreadsheet in a table. I've used dts to do it, but now I need to
write the code to do it.
Can you point me in the right direction or give me some generic code?
Thanks.
...more >>
GROUP BY problem Posted by Luiz Horacio at 6/22/2007 2:22:23 AM Hi,
I have a query where I group results using three conditions: date, exam =
and solicitant. Solicitants are selected in WHERE condition using '... =
where solicitant in (string variable) and...'.
My problem is that I have, in string variable, a sequence like =
'70214,70214,58256,58256,0,0...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |