|
|
|
January 2003 March 2003 April 2003 May 2003 June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 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 April 2008 August 2008 |
Filter by Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Flag vs. Auxiliary Table Posted by querylous at 2/11/2006 8:33:13 PM Hi, I want to accomplish the simple task of flagging a few rows (1-200) in a
large table (many rows i.e. 1,000,000+). I want to find these flagged rows
quickly. After some queries are run against these rows, the flag will be
changed to indicate "don't process these rows". If I use a bit or int...more >>
Using Count on a SubTable Posted by msnews.microsoft.com at 2/11/2006 8:13:08 PM Ladies / Gentlemen
I have two tables 'Orders' and 'OrderItems' and I need to do the
following query
Select *
From Orders
Where Orders.LineItemCount <> ( Select Count(*)
from
OrderItems
...more >>
Data Modeling Question Posted by Jordan R. at 2/11/2006 7:35:13 PM I'm designing a database for a medical group that must keep track of various
"People"
Some are doctors and some are patients.
The client currently categorizes patients according to the type of
procedure(s) they have been seen for (e..g, "Jane is a Botox patient because
she had Botox inje...more >>
"Invalid column name" problem Posted by Balt at 2/11/2006 6:08:26 PM Hi all,
I have this insert statement:
INSERT INTO dta ("CH1", "CH2", "CH3", "CH4", "CH5", "Date", "OLSTime",
"Latitude", "Longitude", "Orbit", "Scan") VALUES ( -71.74, 13.36,
34.32, -158.13, 1237.52, 5001, 1007, 1.02, -42.25, 26117, 1);
This statement works fine when exec...more >>
difficulty with SELECT SCOPE_IDENTITY(); Posted by Joe Befumo at 2/11/2006 4:40:33 PM This has me stymied, but I'm betting it's something real simple. I'm working
in vb/asp/sql-server, and trying to insert a record into a table, and
retrieve the new index.
Dim objDataConn
Dim strSql
Dim intNewKeyVal
Set objDataConn = Server.CreateObject("ADODB.Connection")
o...more >>
Using the Between statement Posted by msnews.microsoft.com at 2/11/2006 4:16:29 PM Ladies / Gentlemen
I would like to find out if this is a valid use of the 'Between' Statement
Select *
From Bids
Where GetDate() is Between StartDate and EndDate
Mark Moss
...more >>
SQL CLR Bug Posted by Ashkan Daie at 2/11/2006 3:41:14 PM Okay here is the scenario:
I have a managed stored procedure. The procedure takes some parameters and
generates a SQL statement and calls ExecuteAndSend on the SqlPipe class.
When calling the stored procedure and the underlying table has ~100K records
I get the following error:
(100 row(...more >>
Using GetOleDbSchemaTable and Visual Basic .NET for MS-Access and SQL Server Express Posted by Marcus at 2/11/2006 3:19:42 PM I need to write a VB.Net application that will take an mdb file (Access
2000) and create corresponding copy of it in SQL Express, creating all
the tables and relationships, and transferring over the data (using an
existing application like DTS in SQL Server or something else is NOT an
option - ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
insert into mytable (id) values () does not work Posted by Andreas Klemt at 2/11/2006 2:40:46 PM Hello,
I have this
create table myTable (id int identitiy(1,1))
insert into mytable (id) values () <<-------- Error
What is wrong?
Thanks for any help in advance!
Andreas Klemt
...more >>
WHERE EXISTS clause in BOL Posted by Bullfrog1870 at 2/11/2006 2:07:27 PM Why do I get different results when I include 'publishers' to the inner query?
--SCENARIO #1 (from BOL)
USE pubs
GO
SELECT DISTINCT pub_name
FROM publishers
WHERE EXISTS
(SELECT *
FROM titles
WHERE titles.pub_id = publishers.pub_id
AND titles.type = 'business')
GO
--SCEAN...more >>
sql server how retrieve info from transaction log? Posted by mtczx232 NO[at]SPAM yahoo.com at 2/11/2006 1:17:55 PM where i can find simple (in .NET if have) how retrieve info from
transaction log?
...more >>
Parsing Numeric from Varchar Posted by Mike Harbinger at 2/11/2006 9:39:15 AM We have a field typed as varchar(50) that usually contains only a numeric
but that can contain text.
Examples: "1890", "18 90", "L1890", "1890L"," 189O"
Problem is because this is looked upon as a numeric by users, they expect
a numeric sort. Is there anything in SQL that would pull just the n...more >>
Sql Server 2005 FTP Task Posted by timdennis30 NO[at]SPAM gmail.com at 2/11/2006 6:56:09 AM How do you loop through files on a remote server using the FTP Task?
The ForEarch Loop won't work because the files are stored on an FTP
server which needs a ftp connection string. The ftp task looks like it
only works for one file at a time. The file names are not known before
the package ru...more >>
Another T-SQL puzzle Posted by Alex at 2/11/2006 4:58:54 AM Hi all,
Sorry if this has been asked before, I've had a very long day and I think my
brain has switched off...
I have a table that records transactions (changes) in another table, and I'm
interested in getting an audit trail (i.e. who did what) for specific state
changes.
So, given th...more >>
Apostrophe in char and varchar columns Posted by Robert Bravery at 2/11/2006 4:34:55 AM HI all,
When trying to insert text into a char or varchar column that contains an
apostrophe ' I get an error message
"the value you entered is not consistant with the datatype or length of the
colum"
I know the length is not a problem, and I'm sure that ' is a char value.
How do I deal with...more >>
how to obtain further error information? Posted by Balt at 2/11/2006 3:28:27 AM I'm using DBlib to access a SQL Server DB. Some very trivial calls however
fail, and the call to dbresults() returns 2. Is there any API I can call to
obtain more detailed error information?
- Balt...more >>
Saving HTML into SQL2000 Posted by Nestor at 2/11/2006 12:00:00 AM Hello all,
How do I save the HTML source of a webpage into SQLServer 2000?
Thanks.
...more >>
DATATYPE PROBLEM(cross) Posted by Savas Ates at 2/11/2006 12:00:00 AM I have a column in my table BizdekiFiyat . The datatype = float length =8
(to save money values).. It is impossible to change these attributes for
some reasons.
It has records like This
BizdekiFiyat
110
24
29.5
31.35
I use Vb.Net . I use ExecuteReader To select values from my db....more >>
Old dates Posted by Mark Rae at 2/11/2006 12:00:00 AM Hi,
Sorry if this is a frequently-asked question, but I'm about to start
designing a database for cataloguing historical artefacts and documents,
many of which are from much earlier than the SQL Server minimum value for a
datetime field of 1753.
I've done a bit of a trawl on Google and e...more >>
General SQL Error Posted by Islamegy® at 2/11/2006 12:00:00 AM When i try to open programs which my database it give this error.. so i
tried to run
DBCC CHECKDB and here is the result but i'm unable to repair it with
REPAIR_ALLOW_DATA_LOSS or REPAIR_REBUILD
so how could i repair my database??
Below is a part of the excution result but the group server d...more >>
Comparing 2 files Posted by Edward Low at 2/11/2006 12:00:00 AM Dear All,
Periodically, i need to copy a file from the source folder to destination
folder. the source file will be updated from time to time. Before copying
the file to destination folder, i need to compare the modified date of the
file, mean only copy the file to destination folder if the...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |