|
|
|
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 Scalar Result from Non-existing table needed Posted by Senad Ljuca at 4/10/2004 10:19:57 PM Is there any way to generate artificial Query Result from Non-existing
table, as scalar array needed for another Query?
For Example:
There is one Table tbl1 with the Field f1, and appropriate Values v1, v2,
v3,
Therefore, a Query SELECT f1 FROM tbl1 gives the following:
f1
--
v1
v2
v3
....more >>
View Posted by Julio at 4/10/2004 10:05:18 PM How can do this
ConsumoID Fecha ClienteID Consumo Total
1 01/01/04 1 0 0
2 01/02/04 1 75 75
3 01/03/04 1 100 25
...more >>
Help Posted by Julio at 4/10/2004 9:56:52 PM Hello
How can do this
ConsumoID Fecha ClienteID Consumo Total
1 01/01/04 1 0 0
= 0-0 = 0
2 01/02/04 1 75 75
= 75-0 = 75
3 01/03/04 1 ...more >>
Need help for procedure Posted by kamal at 4/10/2004 9:56:13 PM How to store a procedue that was written by USER of sql
server in encripted format
if "SA" opens it should not in readable format
and how to decrypt it...more >>
How to Drop procedure/Job after executing Posted by kamal at 4/10/2004 9:51:26 PM I need in the in same procedure code a set of valid
statements and drop command. can it passible
example:
create procedure xyz
BEGIN
select ...
update ...
drop procedure 'xyz'
END
Thanks for help
My ID is skkamalh@rediffmail.com...more >>
rlock() in SQL Server? Posted by toylet at 4/10/2004 7:35:01 PM I used dBase rlock() frequently to qurantee only one user could update
an inventory item's quanity-on-hand field. It worked reliably and *MOST
IMPORTANTLY*
1. if the user disconnects while holding the lock, the lock would be
broken by the network OS automatically (after a certain idle perio...more >>
set and read sequence number Posted by toylet at 4/10/2004 7:21:27 PM
update seq_number_table
set mykey=mykey+1, @mykey=mykey
Could I make the increment to happen before the retrieval?
--
.~. Might, Courage, Vision. In Linux We Trust.
/ v \ http://www.linux-sxs.org
/( _ )\ Linux 2.4.22-xfs
^ ^ 7:18pm up 21:37 0 users 1.00 0.97...more >>
.NET tool to graphically create SQL? Posted by Les Caudle at 4/10/2004 10:39:43 AM In Access 2000, you can connect to SQL 2000 and create a view in a GUI window
where the tables, table relations and selected columns are displayed at top
and the resulting sql at the bottom.
Unfortunately, you have to save the view to execute the sql.
Is this feature buried somewhere in VS...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Flat view of relational dependancies Posted by John Elliot at 4/10/2004 9:48:30 AM I'm trying to figure out how I can get a 'flat' view of the dependencies in
a database. In a database that doesn't allow for circular references there
must be a way to determine this.
Say for example I wanted to delete all data from every table in my database.
I wouldn't be able to delete ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |