| Groups | Blog | Home |
|
March 2003 April 2003 May 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 |
Filter by week: 1 2 3 4 5 rowcount help Posted by D.B. at 5/20/2006 5:25:54 AM i'm trying to get total rows found by query that uses top clause...
for example:
select top 10 myTable.* from myTable where myTable.number > 200
let's say there are 13 rows matching that condition, and by using
@@rowcount my result would be: 10.
is there any way to get total row count, ...more >>
Has anybody installed SQL Server 2005 in VMware Posted by Wang Xiaoning at 5/19/2006 9:14:37 AM i tried to install it but on installation options, only show two
avialable options, which are really just Client and document. if i try
to install on a real machine (instead of Virtual machine) i can see all
the components.
...more >>
SQL 2005 INSERT INTO Binary Column Posted by yogeshvc NO[at]SPAM gmail.com at 5/19/2006 6:55:42 AM Hi,
Can any one help me with syntax of INSERT INTO Statement for inserting
into binary columne of the table.
I have read multiple articles using stored procedure. I need to embed
that binary data in INSERT INTO Statement.
Please help.
...more >>
Execution plan Posted by Vino at 5/19/2006 12:12:53 AM What is server execution plan ? what is the use of it ?
...more >>
Moving Data Across Domains Posted by salpay NO[at]SPAM gmail.com at 5/18/2006 10:03:57 AM Hi all. Let's talk in the abstract for a minute.
I've got a 2000 instance of SQL Server in _my_ domain, and I've got
another instance in _their_ domain. We're talking about a third-party
domain controller that I can RDC into via 192.168.XXX.XXX. My company
owns the server, but the third par...more >>
Hierarchal Table Design SQL 2005 Posted by Maxus at 5/17/2006 11:48:23 PM Hi People,
I'm in the lucky position of building a database from scratch for my
company in SQL 2005. We have a situation where we have customers and
each customer can have a child customers and so on and on.
So the best way I found of doing this was putting everything in one
table called "C...more >>
Backup works but timestamp of BAK file doesn't reflect changes Posted by jwwishart NO[at]SPAM gmail.com at 5/17/2006 4:35:10 PM hi,
I'm having an issue with backup of Sql Server 2000,
We've organized an automated backup of Sql Server 2000, The Server is
running constantly, the Service Agent is running constantly, the backup
is sheduled and seems to be running fine but when i look at the Backup
files timestamp it doesn...more >>
Full text search on 2 columns Posted by r1x at 5/17/2006 3:55:37 PM Hi,
I have a table with 3 columns, "id", "text" and "author_name". Let's
say the table has 1 row like this
id text author
1 "behavioral targeting" "roger"
So when I search for 'behavioral and targeting and roger', there's no
result shown cause no...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Lowest and highest dates? Posted by Noozer at 5/17/2006 12:00:00 AM Looking at the following two tables...
orders:
id type identity
description type varchar(40)
tasks:
id type identity
id_order type int (linked to order.id, many to one)
req_start type datetime
req_end type datetime
.... I would like to be able to output rows containing the id o...more >>
FLOAT precision Posted by John B at 5/17/2006 12:00:00 AM I declare a table as follows:
create table test(ColOne FLOAT(53))
Then try and insert into it with:
insert into test select
0.000000000000000000000000000000000000000000001401298
which fails reporting:
The number '0.000000000000000000000000000000000000000000001401298' is
out of the range...more >>
how to connect to multiple database? Posted by cipcip at 5/16/2006 5:15:25 PM Is it possible to connect to 3 database and execute a cross db query?
I usually use SqlConnection(connectionString) for a single connection
...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |