|
|
|
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 |
Filter by week: 1 2 3 4 5 select statement??? Posted by Alex at 9/13/2003 8:14:24 PM 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 **** **** **** ****
13 **** **** **** ****
29 **** **** **** ****
34 **** **** **** ****
42 **** **** **** ****
67 **** **...more >>
SQL roles Posted by jeyarajan Ramanujam at 9/12/2003 11:33:22 PM How to display the roles granted to a user.
Thanking you....more >>
memory usage in sql server 2000 Posted by CHRIS at 9/12/2003 12:49:12 PM running sql server 2000 and 1gb ram. ram usage is always
very high. is this normal? interfering with timely
queries and batches....more >>
leading 0 Posted by awwin at 9/12/2003 11:10:24 AM 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 help....more >>
Max size for a grouping for an IN clause Posted by Dan Sprouse at 9/11/2003 11:00:52 AM 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 getting a stack
overflow error, which I found out more about through
Microsoft's knowledge base. However, I couldn't find what
the maximum a...more >>
Copying Data from one table to another Posted by Wes at 9/11/2003 2:06:01 AM 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 differently in each
table but the order of the columns is correct.
Here's an example ...
Table 1
CUST_NAME CUST_ADDR CUST...more >>
Writing Efficient Queries- Getting Programmer to Listen Posted by William Ryan at 9/10/2003 10:09:30 PM 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 an
'inconvenience' starts unending discussions. I've given up the battle on
normalization (or primary table has 70+ fields) because they won't budge
(and I'm in th...more >>
SQL server why? Posted by Wilf at 9/10/2003 9:55:05 AM I have a stand alone athlon based computer with windows
xp home. MSSQL server is running Why and do I need it?...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Need Query Help Posted by jb at 9/9/2003 6:13:23 AM
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 number2
3 5
3 6
4 8
5 14
6 2
6 2
8 1
8 1
Thank You,
JB...more >>
Error 137: must declare the variable '@mytbl' Posted by nksridevi at 9/8/2003 5:00:29 PM
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 which was prettty much the same error as stated above. But, as
suggested in that thread, my proc statement has the same lower case
variable whic...more >>
have a guess as to what a "SQL file" is Posted by M D at 9/8/2003 2:06:08 PM 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 is built to run on top of SQL Server or Oracle so I'm guessing
from the description that it is in fact the SQL Server flavor. It is
described to m...more >>
Truncating a log file Posted by Mike Stevens at 9/8/2003 1:56:35 PM 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 novice at this SQL
stuff.
Thanks.
Mike Stevens...more >>
we want to fine tune our server Posted by rakesh dubey at 9/8/2003 5:51:31 AM 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 3 or 4 query is run
simultaneously. CPU utilization becomes 100 %. It moves
only when one of the query is finished.
Can anyone help us in th...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |