|
|
|
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 sum question Posted by JB at 6/23/2007 5:51:00 PM In the example query below, does the sum() get evaluated once or twice or
sometimes once and sometimes twice depending on the exact definition of the
query(the two sums are the same) ?
SELECT Sum(tbl1.col1 * tbl1.col2) as A, Sum( tbl1.col1 *
tbl1.col2)*tbl2.col3 as B
FROM tbl1 inner join t...more >>
Why doesn't SQLOLEDB.1 provider work for SQL Server 2005? Posted by Jen at 6/23/2007 4:59:04 PM I understand the new provider name is SQLNCLI and that works. The problem
is, my ASP.NET application installer installs a web.config file that has
SQLOLEDB.1 as the provider, which apparently doesn't work with SQL Server
2005. And I doubt if SQLNCLI will work with SQL Server 2000 right? So ...more >>
Design question for inventory application Posted by Edgard L. Riba at 6/23/2007 9:55:38 AM Hi,
I have an inventory application where I keep track of items in different
warehouses. I have a table where I mantain the onhand inventory, the
current average cost, last cost, last purchase date, last date item was
sold, and a few other data.
Something like this:
CREATE TABLE iInv
(...more >>
ON DELETE RESTRICT Posted by chrisw at 6/23/2007 9:41:07 AM Hello,
I'm trying to use the following code in SQL Server 2005 but I am getting an
error on the ON DELETE RESTRICT code. Is there a substitute for this? This
code came from an SQLite database I'm trying to convert. (I have changed the
DATE type to SMALLDATETIME)
CREATE TABLE match (
...more >>
Case Sensitive Comparison Posted by Ed at 6/23/2007 9:26:01 AM Hi,
Is there anyway I can compare the case sensitive in the "SELECT" statement?
e.g.
Select * from customers where customerID like 'Jon%'
but I need to retrieve all rows with Jonxxxx not jon or JON.
Unfortunately, I have a messy database with that situation I need to clean up.
Thanks
...more >>
Stored Procedures / Compile Time Data Type Validation Posted by Mark at 6/23/2007 9:01:01 AM SQL Query Analyzer does not appear to validate parameter data types at
compile time .. the errors are identified at run-time.
Is this also true if you are using Visual Studio 2005 for development of
stored procs ?
This is another one of those "Oracle does that" arguments that I am hearin...more >>
Ordered by most frequent appearance in another table? Posted by jobs at 6/23/2007 5:01:24 AM Hello.
I have a table of jobs and a table with log entries with a variety of
types of log entries which includes the execution of jobs, that log
has columns to identify log entry type and job name which is the what
the job table is keyed by.
I'd like select all jobs in order of most recent ...more >>
T-SQL varchar truncation / no errors or warnings Posted by Mark at 6/23/2007 2:17:00 AM Why doesn't the following block of code return a warning or error when I
stuff ten (10) bytes of data into a varchar variable that has been defined
with a max size of four (4) bytes ? I get no warnings, and output window
contains "1234" after this code is executed :
set ansi_warnings on
go...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to find and list stored proc? Posted by Andreas Klemt at 6/23/2007 12:00:00 AM Hello,
is there a stored procedure where I can find a keyword within the stored
procedure
and then list all stored procedure?
Thanks for any help!
Regards
Andreas
...more >>
temporary table problem Posted by Ganesh at 6/23/2007 12:00:00 AM Hi There,
I've created a stored procedure using temporary table initially that
contains approximately 1500 records, then i use the temp table with other
permanent table then update the reason fields for different reason by
executing couple of sqls.
if i do on my local server it works fin...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |