|
|
|
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 Visual Studio 2005 pro SQL express Posted by Shane Nation at 10/14/2006 6:30:55 PM I have installed Visual Studio 2005 pro, which installs SQL server express.
Can I create an SQL database to store data in using VS and if so how?
...more >>
Any Limitations If Any - Which Edition ! Posted by lovely_angel_for_you NO[at]SPAM yahoo.com at 10/14/2006 12:43:46 AM Hi
I am working on a VB6 application for my office where we will be
getting the backend as SQL 2005, which edition that I am not sure. The
VB6 application will be installed on 400-500 client machine and they
will be connecting to the SQL Server on the network. Now these user
will be frequentl...more >>
Investigating foreign key constraints Posted by Steve Hershoff at 10/13/2006 2:12:45 PM In running an insert statement I've encountered this message:
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'fk_benkey'
All well and good, but is there a way through the Enterprise Manager or
Query analyzer to show me which table(s) are using this column as a foreign
key, so...more >>
IMport Acess database intou Express ??? Posted by serge calderara at 10/13/2006 4:25:02 AM Dear all,
I have an Access database that I would like to import under SQL express 2005.
Is there a way to do this ?
SQLserver 2000 privide a tool for that but could not find a way for EXpress
2005
Thnaks for help
regards
serge...more >>
SQL 2005 management studio missing on SBS R2 Posted by Jack at 10/13/2006 12:00:00 AM I need to move some databases to a new drive but there is no management
studio on the server.
It is SBS R2 with SQL 2005 workgroup edition
What to do ?
Jack
...more >>
Help with insert query Posted by Matt Williamson at 10/12/2006 10:46:48 AM I need to add entries to an existing table. The table has 2 columns (name,
number). I need to routinely add entries for multiple names and multiple
numbers for each name I'm just not sure the best way to do it. I know I can
just do a Insert..values query, but I don't want to specify each one
...more >>
Using forms with drop down lists to populate criteria in an SQL Function Posted by Ernie at 10/12/2006 7:34:21 AM I have a selection form that collects the following data with their
associated form field names:
Warehouse (Whse) This is a drop down list of appx 40 items
Part Number (PartNumber) This is a drop down list of appx 2300 items
Status (Status) This is a drop down list of appx 1...more >>
sql standard Posted by atif at 10/12/2006 12:00:00 AM Hi,
Any would plz tell me which standard of SQL, MS Sql Server uses. and is
there any free source code to validate sql query?
thanx in Advance
Regards
___
Atif
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Table data sort order Posted by Al at 10/11/2006 6:50:15 PM I used to work with SQL 200 Enterprise Manager. Now I started to use SQL
2005.
Unlike in SQL 2000, if I open table data is displayed in some strange order
(I even do not know what order is used).
For instance in SQL 2000 all data is displayed in order it was entered in
the table - first inse...more >>
Can't delete object Posted by SAC at 10/11/2006 4:08:33 PM I'm attempting to table with Enterprise Mgr and it hangs up. The table was
corrupted and I made a new one, but the old one won't delete.
Any ideas on how to delete it?
Thanks.
...more >>
how to query out sections? Posted by _adrian at 10/11/2006 12:38:13 PM So I have a table with various records, each with different datetime fields
populated..I want to query the records and then display them on a web page
(ASP) so that when there's a different month, it breaks out as:
1/10/06
1/20/06
1/30/06
(note the space between eac...more >>
MDF File Sizes Posted by Vayse at 10/11/2006 12:00:00 AM Hi
I have two databases set up, one for Office A and one for Office B. The
databases have the same structure.
There is a lot more data in the Office A database. Yet the Office B mdf is 6
times larger. Why would this be?
Thanks
Vayse
...more >>
NULL in query Posted by Anders Eriksson at 10/10/2006 6:15:47 PM Hello,
I want to make an SQL query that selects all records in a table where a
certain column is NOT -1
The column is an int but may have the value NULL
I have used this SQL statement:
SELECT * from MyTable where (NOT (MyCol=-1))
If I have an integer value in the column then it works...more >>
SQL Query Books Posted by Jaz at 10/10/2006 11:01:06 AM I am new to SQL and I was wondering if anybody has any recommendations on
books to learn how to write SQL queries.
Any suggestions on where I can start this learning process?
Thanks,
Jasper
...more >>
SQL Server 2005 - How to record the time of record insertion Posted by Frank at 10/9/2006 1:58:51 PM Ok, I feel like a retard for having to ask this, but...
In SQL Server 2005, I wish to have a column keep track of when that specific
record was created/updated.
Any suggestions?
I thought I could use GETDATE() in the Formula property, but if I do so,
whenever the aspx page loads and dis...more >>
Question on new purchase of Standard Edition 2005 Posted by angela at 10/9/2006 9:53:01 AM I recently bought SQL Server 2005 Standard Edition, 1 server and 5 CALs, from
an online store (techusastore.com), but did not received any information such
as product key or licensed key or authorization number, or anything like
that. No documents. Just the 2 cds in the cd sleves. Not even a ...more >>
SQL Server Security Posted by Vayse at 10/9/2006 12:00:00 AM Hi
I am in the process of writing some SQL based reports.
The will be around 3 groups of reports. The setup will be
Group 1 will be viewable by all staff.
Group 2 will be viewable by managers, and above. Some accounts staff may
also require access.
Group 3 will be only viewable by...more >>
VS 2003 and SQL 2005 Report Service Posted by luke at 10/9/2006 12:00:00 AM Hi,
Is it possible to use SQL 2005 report service in VB.net 2003? I cannot find
SQL 2005 report viewer component in VS 2003.
Thanks
Luke
...more >>
Help me to choose ??? Posted by serge calderara at 10/8/2006 11:59:09 PM Dear all,
We have a supervision application which is based on concurent access and
strorage of data actually in an Access database 97. This actually run under
windows 2000.
Today we are thinking to review our application and plan to move it under
Windows Vista.
One of our issue is to re...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |