|
|
|
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 31 help on query Posted by Jen at 10/30/2004 11:04:03 PM Hi,
I have an preorder table,
create table preorder (
order_id numeric(17) NOT NULL PRIMARY KEY,
purchase_date date_time NOT NULL,
.....)
data will be:
1, 1/23/2005
2, 12/30/2004
3, 12/21/2004
4, 2/12/2005
etc
Now I need to count the order for a user in every month so that it can't
...more >>
query problem Posted by Hammy at 10/30/2004 10:46:02 PM Hi all,
I am having a problem creating a query for the following scenario...
I have a table of users (primary key is user_id).
I have a table of orders ( with user_id as a field).
what would the query look like if I wanted to get a list of all users and
their latest order id?
Thanks,
...more >>
query to find space used w/indexes for all tables in a database Posted by Hassan at 10/30/2004 10:20:07 PM Need help running a query to find size along with index size for all tables
in a database
Thanks
...more >>
Storing / Retrieving Column Name in a Variable Posted by Vince at 10/30/2004 5:39:53 PM This could be a stupid question...
How do I store a column name in a variable and access it. I mean:
declare @test varchar(50)
set @test='D5'
select @D5 from table
What I need to do is to access the column D50 from the table 'table'. The
above example does not work. The reason I need t...more >>
command object problem about stored Posted by Savas Ates at 10/30/2004 4:43:08 PM it doesnt work with that
this error
VBScript runtime (0x800A01F9)
<!--#include file="conn.asp"-->
<%
Set cmd=server.CreateObject("ADODB.Command")
cmd.CommandType=4
cmd.CommandText = st_myfriends
cmd.ActiveConnection=baglantim
cmd.Parameters.Append .CreateParameter("@userid", adNumeric,...more >>
SQL syntax for Access Switch function Posted by smk23 at 10/30/2004 3:56:02 PM Thanks in advance for your help.
I have the following function in a MS Access query statement so that instead
of seeing the table value, I see the interpretation of that value. I would
like to use a pass-through query and "switch" is an Access function. Could
you tell me what syntax would acc...more >>
Execution Plan Posted by Ed at 10/30/2004 2:23:01 PM Hi,
Are there any info./links to talk about how to look at the graphical
execution plan?
I could not find any and I am not quite sure what all the graphics mean
and how to improve the performance, too...
Thanks
Ed...more >>
DBISAM Posted by Adam Right at 10/30/2004 1:32:23 PM Hi all,
I had a customer using a program written in Delphi using DBISAM database.
Now I am in need to read and store some of these data to SQL Server tables.
I mean, I need to open / read those DBISAM database files.
Is there a way to do this ?
Thanks for your help.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Oracle can, why not MS-SQL?????????? Posted by geeksgk NO[at]SPAM yahoo.com at 10/30/2004 1:21:45 PM Hello,
Can anyone tell me the SQL equivalent of the following Oracle stored
procedure?
CREATE OR REPLACE
Procedure NAFTA_DELETEUSER(iuser_id IN nafta_user.user_id%TYPE)
Basically this Oracle stored procedure declare a parameter iuser_id
but it gets the length and datatype dynamically fr...more >>
Highest and lowest functions Posted by John at 10/30/2004 12:57:05 PM Hi all,
I have table1 with the following info:
Name Hi Lo
A1 10 2
A2 20 1
and the second table Table2
Name HiHi Hi Lo LoLo
B1 2 1 0.5 0.1
B2 20 ...more >>
Encrypting Stored Procedures - Production Support Posted by Guadala Harry at 10/30/2004 12:52:11 PM Just wondering if encrypting stored procedures would make production support
more difficult. I have an application that currently tells me (via ADO.NET)
offending lines of code (line number) in stored procedures that choke -
something very useful to know when troubleshooting in a production serve...more >>
CASE IF EXISTS Posted by scott at 10/30/2004 12:30:49 PM I'm trying to use 'IF EXISTS' to test a CASE statement. I want CASE to
return a 'Y' if the t_users.userID exists within the SELECT statement or 'N'
if userID isn't within the SELECT statement.
I just need help with the 'CASE WHEN IF EXISTS' part. QA gives me an syntax
error at 'IF EXISTS'
...more >>
Is it possible to set a scheduled job for executing a store procedure? Posted by RC at 10/30/2004 11:37:52 AM And after the transcation is completed, sent a email alert to user....
Thanks
...more >>
Gnerate a view with sp rowset Posted by eval at 10/30/2004 8:05:50 AM Hi, all.
Sorry if this is a level -100 question, but:
Is there any way to generate a view with the rowset generated by a
stored procedure?
Something like this might be great:
create view myView
as
exec myStoredProcedure
Any ideas?
Regards
eval...more >>
Database Role that allows execution of stored procedures? Posted by Laurence Neville at 10/30/2004 2:44:11 AM We have a rule for developing database-driven applications that all
interaction with the database must be done through stored procedures i.e.
all selects, inserts, updates etc.
I am looking for simple ways to enforce & support this design principle -
and one would be if I could put the SQL ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |