| Groups | Blog | Home |
|
January 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 |
Filter by week: 1 2 3 4 5 SQL 6.5 to SQL 2000 performance question Posted by Robert at 1/31/2004 11:54:05 PM We are running SQL Server in 6.5 compatability mode. We have some queries
that are supported in 2000, that is the reason for the 6.5 version. What,
if any, would be gained in performance by switching to 2000.
...more >>
Valid T-SQL syntax? Posted by DFS at 1/31/2004 11:23:40 PM Version 1:
--------------------------------
If Condition = A
UPDATE query 1
UPDATE query 2
ELSE IF Condition = B
UPDATE query
Version 2:
--------------------------------
If Condition = A
BEGIN
UPDATE query 1
UPDATE query 2
END
ELSE IF Condition = B
BEGIN
UPDATE ...more >>
using mssqlserver with win xp Posted by shlomys NO[at]SPAM inter.net.il at 1/31/2004 2:27:57 PM Is it possible that I can't use microsoft SQL server under my windows
xp pro ? I checked the web site and it looks like it is not
supported........more >>
weird error when precompiling genwin.mak with nsqlprep Posted by akumar1 NO[at]SPAM mn.rr.com at 1/31/2004 2:18:45 PM I am trying to compile the sample program genwin.sqc, using nsqlprep
which is used to precompile embedded sql in C. I am getting weird
errors and that is because windows.h is included in the genwin.sqc
file. I am using
Setting the lib and include path:
set INCLUDE=C:\Program Files\Microso...more >>
Locking Users Out of Table Posted by Tim Morrison at 1/30/2004 4:32:27 PM SQL Server 2000, MSDE 2000
I have a procedure in my application that I would like only one user at a
time to be able to run. Is there a TSQL command I can run that will
esentially lock a set of tables so others cannot access the table until the
user is done with the procedure or until the user...more >>
Cursed Error Messages Posted by dedejavu NO[at]SPAM hotmail.com at 1/30/2004 10:40:05 AM Hi everyone,
How do I get the error message?
I have a very long sproc that needs to be done in one transaction. I
have an error happening somewhere in the middle, but with a low enough
severity it doesn't terminate the procedure. To make sure I don't
miss any errors, I am storing @@error afte...more >>
Outer Join syntax Posted by cook_ml NO[at]SPAM hotmail.com at 1/30/2004 8:07:26 AM I am now working on SQL Server 2000 having had previous experience on
a different database. Both of the OUTER JOIN syntaxes is different
from what I am used to and I am finding it slightly confusing.
For example, given two tables :
wipm_tbl_mi
wipm_tbl_wi (which may not have data in it for...more >>
SQL Question Posted by shane.peterson NO[at]SPAM figis.com at 1/30/2004 6:51:23 AM I have a one to many relationship between two tables. A products
table and a prices table. The prices table has a description field
that describes the type of price (Original Retail, Final Retail) and a
price field. I want to be able to specifically query the "Original
Retail" and "Final Reta...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Creating a string from Date Fields Posted by laurenquantrell NO[at]SPAM hotmail.com at 1/29/2004 2:43:15 PM I have a table with a startdatetime and an enddatetime column such as:
StartDateTime EndDateTime what I want to see returned
is:
01/29/2004 10:30AM 01/29/2004 1:30PM "1/29/2004 10:30AM - 1:30PM"
01/29/2004 10:30AM 01/30/2004 1:30PM "1/29/2004 10:30AM - 1/30/2004
1:30PM"
0...more >>
How do I Copy back in a DTS script? Posted by David Greenberg at 1/29/2004 1:29:01 PM
Hi !
I know how to save a DTS as a structured storage file and how to
recreate a DTS using that file.
What I can't find is a command, either in t-sql or from a DOS level,
with which I can save the DTS as a structured storage file, for example
in a scheduled job for backup purposes.
Hopeful...more >>
Storing a stored-proc's result into a temp table Posted by takayasu.harada NO[at]SPAM csfb.com at 1/29/2004 11:40:54 AM I'm trying to write a SQL that stores a result from a stored-procedure
into a temporary table.
Is there any way of doing this?...more >>
Adding entry to DB and getting unique ID at the same time Posted by alex NO[at]SPAM totallynerd.com at 1/29/2004 11:36:34 AM Hi all,
I'm writing a website with Cold Fusion and when a user submits a
request and it's stored in the MS SQL database, I want the unique ID
(Identity field in table) to be given to the user on screen plus
emailed to user.
Now can I store data to the database (where the ID is created) and
...more >>
How to return a range of rows in sql server Posted by alexravv NO[at]SPAM hotmail.com at 1/29/2004 10:50:42 AM Hello,
John Bell posted a reply on 2003-11-02 04:11:02 PST, that gave me an
idea how to achieve paging in sql server without row number
functionality. Thank you John. The following works for me, not very
eficient though:
SELECT * FROM
( SELECT top 5 * FROM
( SELECT top 10 * FROM
...more >>
SQL Server 2000 standard on Windows 2000 Advanced Server Posted by barbd NO[at]SPAM infocision.com at 1/29/2004 8:32:03 AM What is the limitation of memory that SQL Server 2000 Standard can use
when running on a Windows 2000 Advanced Server platform?...more >>
searching for latest date and time only Posted by jasuk NO[at]SPAM postmaster.co.uk at 1/29/2004 8:23:26 AM > This is what I want to do with the data table below.
>
> I only want it to show one id for each issue. ( ie, 4001 only once,
> 4002 only once, etc. But only the one with the latest date and time)
>
> Ie. 4001 should only be in the table once, with the latest date -
> which should be :
...more >>
Why select ... where 'Anna ' = 'Anna' returns TRUE? Posted by aeror NO[at]SPAM op.pl at 1/29/2004 2:55:53 AM Sorry for asking stupid questions...
I can't remember which settings in MS SQL define the behaviour of this comparison:
select * from table where 'Anna ' = 'Anna'
to be TRUE. Both strings are different because the first contains trailing blanks.
How to change it to return FALSE what i...more >>
How to Stop Logging Posted by s_laha NO[at]SPAM rediffmail.com at 1/29/2004 2:12:34 AM Hi,
I am doing some resource hungry tasks (some extraction and loading
through DTS), for which each time the SQL Server Log files gets filled
up!
Is there any way to stop the logging (like as during restore)?
Thanks in advance.
-surajit...more >>
xp_smtp_sendmail html+plain text Posted by karl NO[at]SPAM dinressurs.no at 1/29/2004 1:22:06 AM Hi all. Iv'e tryed out xp_smtp_sendmail, and I like what I can see so
far. The thing I wonder about is if the xp supports sending both html
AND plain text in the same mail. I'm on a sql2000 sp3 and I have no
problem with the xp when i either send plain text or html, but as
stated above I need to...more >>
backups Posted by jeff wilmoth at 1/29/2004 12:19:00 AM I am in search of a simple .bat file or .vbs script that I can use to
stop my SQL database server. I am looking to schedule a script of sorts
to initiate at a certain time every day. This script needs to be able to
stop my server and/or initiate a backup. The script should be able to be
ran remo...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |