| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Hi,
I was wondering if anyone could help me. I need to return
a number of results from a table that require me to use
many select statements....
JenC
|
09-25-2003 03:14 AM
T.S.Ramesh  | 2 | 95 |
| | | Hi;
my hard drive crushed and I lost everything. with a new
hard drive and Windows NT 4. Workstation OS(my previus
OS). I did reinstall and restored...
Mike Alemi
|
09-25-2003 03:09 AM
T.S.Ramesh | 2 | 95 |
| | | Hi,
I am a programmer with resonable knowledge in SQL SERVER
and DTS I am interested in expanding my knowledge in
Datawarehousing, Cubes and OLAP...
Sunny
|
09-24-2003 06:26 AM
Ray Higdon | 1 | 95 |
| | | We are increasing the size of a varchar field from 7 to 9
in a table with 187,000 rows. The table also has an image
column in it, but we are not...
Catherine McKay
|
09-23-2003 02:51 PM
Catherine McKay | 0 | 125 |
| | | How can I send the query results directly to a text file
in SQL Server 6.5 ?
Omar
|
09-23-2003 11:04 AM
Omar | 0 | 88 |
| | | I'm curious if this is possible using only standard
queries... if not, feel free to post alternate code.
Here is what I'm trying to accomplish...
I...
Ken
|
09-22-2003 10:06 PM
Vishal Parkar | 2 | 102 |
| | | It shouldn't cause any speed problems unless it is called
many times concurrently - in which case you can get
contention with tempdb system...
Nigel Rivett
|
09-21-2003 11:22 PM
Nigel Rivett | 0 | 94 |
| | | After you restore a backup, how do you assign a new
filegroup?
I have a 280 GB that uses one file group and I want the
current files to point to...
delbert
|
09-21-2003 11:19 PM
Nigel Rivett | 1 | 101 |
| | | Hi all,
I have a database consisting of more than 2000 records. I
need only a certain number of records be displayed on the
page at a time. When I...
Chaitanya
|
09-19-2003 12:12 PM
Yigong | 4 | 92 |
| | | Hello,
I would like to know if there is a neater way to do
what I am currently doing.
The User needs to be able to 'Copy and Paste' from an
excel...
Rhonda Fischer
|
09-17-2003 10:24 AM
Rhonda Fischer | 0 | 110 |
| | | Here's my table:
CREATE TABLE foo
(
id INT UNSIGNED NOT NULL
AUTO_INCREMENT,
PRIMARY KEY (id),
password CHAR(16) NOT NULL
DEFAULT...
Button Boy
|
09-17-2003 09:17 AM
Anith Sen | 1 | 115 |
| | | I have a query that builds a concatenated string, which
will be 409 characters. I am using a Char type, which from
my research can have up to 8000...
James Upton
|
09-16-2003 05:43 PM
James Upton | 2 | 97 |
| | | I am trying to query a table to get records sorted in a certain way. There
are two kinds of records - A and B. I want A's to be sorted on "Start...
Calvin Steele
|
09-15-2003 06:53 PM
Vishal Parkar | 3 | 100 |
| | | Pulling data from an Oracle Server and creating a temp
table(User, Response, ResponseDate). Have 75 unique users,
and over 10,000 responses and the...
Will
|
09-15-2003 04:58 PM
Will | 2 | 82 |
| | | I am trying to query a table to get records sorted in a
certain way. There are two kinds of records - A and B. I
want A's to be sorted on "Start...
Calvin
|
09-15-2003 02:12 PM
Calvin | 0 | 106 |
| | | How to display the roles granted to a user.
Thanking you.
jeyarajan Ramanujam
|
09-15-2003 01:48 PM
Vishal Parkar | 3 | 124 |
| | | running sql server 2000 and 1gb ram. ram usage is always
very high. is this normal? interfering with timely
queries and batches.
CHRIS
|
09-14-2003 04:34 PM
William Ryan | 1 | 96 |
| | | I have a table with Identity colomn and becouse some of
the records was deleted it is looks like that now:
ItemID Col1 Col2 Col3......
09 ****...
Alex
|
09-14-2003 11:11 AM
Alex | 1 | 98 |
| | | How do I add a leading '0' to an existing value with a
data type of vachar? For example, I'd like to
change '1234' to '01234'. Thank you for your...
awwin
|
09-12-2003 01:24 PM
Anith Sen | 1 | 107 |
| | | It is a new feature in SQL 2000, where you can install multiple 'copies' of
the database server in a single machine. Each 'copy' is called an...
Anith Sen
|
09-12-2003 01:08 PM
Anith Sen | 1 | 107 |
| | | What is the size limit on a grouping of ID's for an IN
clause? I have a large string of ID's that I'm trying to
use with the IN clause. I'm currently...
Dan Sprouse
|
09-12-2003 08:19 AM
Vishal Parkar | 2 | 87 |
| | | I want to know the ODBC driver which supports JDBC2.0 for
connecting SQLServer2000. Quick answers are welcomed.
Krish
|
09-12-2003 07:09 AM
Krish | 0 | 88 |
| | | I have 2 database tables with the same number of columns.
Using SQL, I want to transfer all the data from one table
to another. The columns are named...
Wes
|
09-12-2003 04:15 AM
Wes | 2 | 106 |
| | | Can anyone tell me how I go about truncating a log file
in my database and then restoring it? Or where I can go
to find this info? I'm kind of a...
Mike Stevens
|
09-11-2003 07:13 PM
William Ryan | 5 | 92 |
| | | I need Help. Here's the deal. I'm a C# programmer but I am also the
production DBA. I love my co-workers, but everything that is...
William Ryan
|
09-11-2003 01:22 PM
William Ryan | 2 | 91 |
| | | SQL isn't installed by "default". Who else beside you installed it? Did
you installed Visual Studio .Net?
"Wilf" <dubyadixon (AT) aol (DOT) com>...
Flicker
|
09-10-2003 01:08 PM
Flicker | 0 | 105 |
| | | Hi;
I want to know if a DTS connection (ODBC/OLEDB)automatically locks a
foxpro table while reading from it OR do I have to exlicitly lock the
DBF...
kambiz afkhamian
|
09-09-2003 04:05 PM
kambiz afkhamian | 0 | 100 |
| | | IIRC, it was 256 MB (check SQL Server Books Online for the exact limit). In
any case, you can split up the files into smaller ones & load...
Anith Sen
|
09-09-2003 01:49 PM
frankie | 1 | 111 |
| | | I need a SQL query that will return row1 and 2. The rule
would be "2 (and only 2) occurences of number1 where
number2 is not the same.
number1...
jb
|
09-09-2003 11:14 AM
JB | 2 | 92 |
| | | Just CAST/CONVERT it to an INT. You can do:
SELECT CAST(bitcol AS INT), MAX(dtcol)
FROM tbl
GROUP BY CAST(bitcol AS INT) ;
Note that in SQL Server...
Anith Sen
|
09-09-2003 10:52 AM
Anith Sen | 0 | 103 |
| | | Dear All,
We have Hp LC 2000 server , P-3 @ 1 GHz, 1 GB ram, 3 X 36
GB hdd Netraid, windows 2000 OS, SQL 2000 server as DBMS.
Our server gets lock if...
rakesh dubey
|
09-08-2003 05:42 PM
Anith Sen | 2 | 101 |
 | | Iam new to stored procedures in MSSQL. But this is very simple and i'm
getting the above stated error. I went through another thread in this
website...
nksridevi
|
09-08-2003 05:36 PM
Anith Sen | 1 | 162 |
| | | I have a customer who says they got a file that is "SQL" and probably
originated from SalesLogix. Now I know that SaleLogix is an application
which...
M D
|
09-08-2003 05:33 PM
Anith Sen | 1 | 104 |
| | | Given a table that includes 2 digit test scores how can
you write a function that eliminates the three largest
and the three smallest values and...
Swami
|
09-08-2003 06:14 AM
Vishal Parkar | 1 | 107 |
| | | How would you write a function that takes as its input, a
proper name and returns the name in Proper Case?
Swami
|
09-08-2003 05:30 AM
Vishal Parkar | 1 | 94 |
| | | http://www.quest.com/spotlight_sql/
"Yousef Jeraiseh" <v-yousej (AT) microsoft (DOT) com> wrote
William Ryan
|
09-05-2003 03:37 PM
William Ryan | 0 | 96 |
| | | Thanks but I am confused now . .
Does the trigger not fire every time a record is added therefore the
inserted table will only ever have 1...
Newbie
|
09-05-2003 08:46 AM
Vishal Parkar | 10 | 169 |
| | | I'm quite new to developing with SQL server and have some questions about
upgrading from Access to SQL. One of my servers wants to charge me $240...
Ian O'Betz
|
09-04-2003 05:28 PM
Ian O'Betz | 0 | 106 |
| | | How i can DeFrage index of whole database(one database) in
single statement. My database name is "Sidathyder_host"??
Reha Afzal
|
09-04-2003 05:28 PM
William Ryan | 2 | 98 |
| | | I'm customizing Network Associates (Magic Solutions
Division) Magic HelpDesk software for our environment. I'm
creating custom helpdesk forms for our...
Don Woeltje
|
09-04-2003 05:16 PM
William Ryan | 1 | 112 |
| | | I'm transitioning from Oracle to SQL Server. Need to know
the MS command that is equivalent to "Rownum" in Oracle so
I can restrict the row output...
Jake
|
09-04-2003 04:32 PM
Dmitry Balin | 5 | 128 |
| | | see following example
create table #t (col1 varchar(500))
insert into #t values('0723312')
insert into #t values('07-Keep This Text')
insert into #t...
Vishal Parkar
|
09-04-2003 03:15 PM
Chris T | 1 | 106 |
| | | We have some our applications and they related to SQL
through COM objects, DLLs and Web-pages.
Sometimes(aprox.once a day(in different time, do...
Viktor
|
09-04-2003 09:02 AM
TheHeater | 1 | 89 |
| | | I need to have a database server to be case in-sensitive,
how can I do it?
Thank you,
Alice
Alice
|
09-04-2003 01:10 AM
Vishal Parkar | 1 | 96 |
| | | Is there any stored procedure or utility which can make a
copy of my database(.mdf) without data... only structure
with constraints
Rehan
Rehan Afzal
|
09-03-2003 12:23 AM
Rehan Afzal | 0 | 102 |
| | | Is there any stored procedure or utility which can make a
copy of my database(.mdf) without data... only structure
with constraints
Rehan
Rehan Afzal
|
09-03-2003 12:23 AM
Rehan Afzal | 0 | 83 |
| | | When querying a linked server using a declared variable,
a simple query takes forever to run. example is...
declare @temp varchar(10)
set @temp =...
Nick
|
09-02-2003 09:27 AM
Nick | 0 | 86 |
| | | Done. Use Datediff function.
Harvey Chaplin
|
09-01-2003 01:35 PM
Harvey Chaplin | 0 | 90 |
| | | #temptable got order,fname and age.
trying to find two high maxes per each order.
query returns (1) but (2) is correct answer.
supposedly, max(age2)...
ricksql@yahoo.com
|
09-01-2003 12:22 PM
John Gilson | 3 | 104 |
| | | Hi,
Can anyone tell me how to retrieve fieldnames for all
tables in my SQL2000 database. What SQL statement would I
use?
Thanks,
C.Verweij
Constant
|
09-01-2003 05:19 AM
Vishal Parkar | 1 | 104 |
