|
|
|
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 |
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 29 30 31 Field name is SQL keyword? Posted by Peter Aitken at 1/17/2004 10:12:38 PM I am working with a table that has a field named Group anda my query is not
working - I believe because Group is an SQL keyword. How do I handle this?
--
Peter Aitken
Remove the crap from my email address before using.
...more >>
Getting 100 rows at a time Posted by David D. at 1/17/2004 9:10:15 PM What are techniques for retrieving the first 100 rows of a result set; and
then later retrieving the second 100 rows (starting the search from where
the first 100 left off).
I am doing an unindexed wildcard search "%<string>%".
How would I accomplish this from
(1) straight SQL (e.g., from...more >>
Backup/Restore to Another SQL Server Posted by Dean at 1/17/2004 8:19:15 PM
Please help me create a TSQL that I can use to backup my
production SQL Server database nightly. Nightly I would
like to restore the development SQL Server database from
the production SQL Server backup.
The path to Production SQL Server database to backup is
\\Gvb_Houston\k$\pharmacy....more >>
substring? Posted by Lasse Edsvik at 1/17/2004 7:13:49 PM Hello
I have an old table where i have a column that everything starts with a =
prefix (?) and i need to find a select that displayes them without it so =
i can move to an other table.
C2_something
C22_something2
badf_something3
as_something4
how do i just get:
something
somethin...more >>
Unexpected lock with SQL Server 2000 Posted by Alexey Vinogradov at 1/17/2004 6:31:05 PM Dear all
Could you please help me with the following problem
My program submits the sequense of queries to remote SQL Server 2000
step 1. insert record into master tabl
step 2. select from master table the record inserted at step
step 3. insert into detail table record with foreign key referen...more >>
ADO and SQL SERVER Posted by Lapin at 1/17/2004 6:18:06 PM Hi,
What is the best way (the quickest !) to acceed SQL SERVER with ADO:
ODBC, SQLODBC or is there a best connection ?
Thanks.
...more >>
Time out expiry while deleting huge data Posted by Peri at 1/17/2004 6:10:09 PM I am getting the Time out expired error in VB in the following scenario
1. Table named "EntityMaster" which has around 15 fields and around 150.000
records.
DELETE FROM EntityMaster WHERE DataSource = 'R'
There are around 75,000 records which satisfies the above query.
Can any one help...more >>
SELECT statement problem Posted by Tim Robertson at 1/17/2004 4:25:23 PM I'm writing a SELECT statement for an ASP page that will select all records
from a table called Signup_List based on a "classID" (in the examply below I
assumed the search asked for all records where "classID" equaled 14. Then I
want it to take the companyID column for each of the selected record...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
how to call Column::PutIdentity on existing table? Posted by Onega at 1/17/2004 3:47:41 PM Hi ,
I can toggle Identity property of a column in an existing table on and off
with SQL Server Enterprise Manger. But how to do it programmatically?
The following code snippet failed with exception(inline):
#include <iostream>
#include <tchar.h>
using namespace std;
#undef EOF
// Prov...more >>
Date criteria problem Posted by AMC at 1/17/2004 3:07:02 PM Hi,
I have a datetime field that I am trying to query. For example, I am trying
to return all records for the date 1/14/04 by using the clause
"where recdate between '1/14/04' and '1/14/04'. There are records in this
table for this date but the query returns nothing. What am I doing wrong?
...more >>
Date from datetime Posted by AMC at 1/17/2004 2:41:28 PM Hi,
How do I get just the month day and year from a datetime column value. I
don't want to include the time.
Thanks
...more >>
Backup/Restore to Another SQL Server Posted by Dean at 1/17/2004 12:51:11 PM
Please help me create a TSQL that I can use to backup a
database on my production server. And nightly restore
that database to my development server with a different
database name.
The path to Production SQL Server database to backup is
\\Gvb_Houston\k$\pharmacy.(Production db name is ...more >>
Application Licensing to a database server Posted by Gerald S at 1/17/2004 11:13:28 AM Hello,
I have a client / server VB application which is is licensed to a single
database on a single server. But they can install the client as many times
as needed.
Does anyone have any suggestions for licensing an application to a database
server?
Thanks,
Gerad
...more >>
Performance Posted by Aaron at 1/17/2004 10:40:13 AM Is there any difference between SELECT, UPDATE, INSERT, DELETE...(sql
satements) performence-wise?
which is more resource consuming?
...more >>
Problem with updating decimal number Posted by Duclover at 1/17/2004 2:12:03 AM i'm writing a simple asp page witch updates a table
first i select the field in a html form
SELECT tbl_costs.total
FROM tbl_costs where tbl_costs.id =1
then i update
UPDATE tbl_costs SET tbl_costs.total=15 WHERE
tbl_kosten.id =1
tbl_costs.total is a decimal data type with precis...more >>
Multiuser Posted by Atul Singh at 1/17/2004 1:11:07 AM How to designe data access so that no duplication of recordID would occour while the time of updation by two user at the same time also tell me the best site where i came find "How to designe multiuser application useing VB and Sql Server
atul2parihar@indiatimes.com...more >>
multyuser enviorment Posted by Atul Singh at 1/17/2004 12:11:05 AM how to syncronise the access of a table in Sql Server...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |