|
|
|
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 August 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 SQL Server login dialog Box Posted by Baskar at 6/13/2004 11:59:01 PM Hi
We developed an application in VB 6.0 with SQL 2000 as Back-End.
Our application is working fine in our office. In the client place if we run our application every time it is asking to enter (SQL server Login) user name & PWD (sa/empty) in
SQL Server login dialog Box.
This some thing re...more >>
SQL Server login dialog box Issue Posted by Baskar at 6/13/2004 11:38:01 PM Hi
We developed an application in VB 6.0 with SQL 2000 as Back-End.
Our application is working fine in our office. In the client place if we run our application every time it is asking to enter (SQL server Login) user name & PWD (sa/empty) in
SQL Server login dialog.
This some thing relate...more >>
More efficient delete statement Posted by Jet at 6/13/2004 11:35:01 PM Hi,
I have a scenario to delete records from Table A where TableA.primary key matches TableB.primary key.
If Table A has a large volume of 30 milion records and in average Table B has 7 million records, is progressive deletion more effective than one single delete statement where this one dele...more >>
How to deal with invoice detail money amounts? Posted by Ian Boyd at 6/13/2004 11:00:41 PM i'm update a legacy system to SQL Server (anyone else know of CodeBase?).
Each detail entry of an invoice originally only stored a "Unit Price" and a
"Quantity".
So in order to get an invoice printed out, you have to:
1. For each detail entry, calculate TRUNC(UnitPrice*Quantity*100)/100
...more >>
master..xp_cmdshell Error 997 from GetProxyAccount Posted by toomuchphill NO[at]SPAM hotmail.com at 6/13/2004 9:44:27 PM Hello all,
I have an aspx page that inserts a record in a table via a stored
procedure. That table has a trigger which gets fired on an insert. The
trigger has the following code
EXEC master..xp_cmdshell 'C:\MyApp\try.exe'
This all works when the stored procedure is fired inserting the re...more >>
DATEDIFF - get a formatted time Posted by Just D at 6/13/2004 7:52:18 PM All,
I got some problem writing a sql query returning a formatted time in
HH:mm:ss for an expression like this:
'SessionTime'=CASE
WHEN (s.FinishTime IS NULL) THEN DATEDIFF(second, s.StartTime,
GETDATE())
ELSE DATEDIFF(second, s.StartTime, s.FinishTime)
END
It returns the...more >>
best tool or script to compare 2 database's structure? Posted by Les Caudle at 6/13/2004 7:16:42 PM What is the best script or 3rd party tool to compare two database's structure?
--
Thanks in advance, Les Caudle...more >>
Comma separated results... Posted by Ivan Debono at 6/13/2004 5:04:14 PM Hi ppl,
I have a main table A and a table B. I would to select all records in table
B that match their id in table A, but instead of having the results in a
list, the query would return the results with the records from table B comma
separated in 1 line, example:
I have the following values...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Using Self-Joins in Indexed Views Posted by Mark Pauker at 6/13/2004 4:53:54 PM I posted this a few days ago in a different forum, and although I got one
response, I still have no viable solution. I hope it's okay to repost it
here...
I realize that SQL Server doesn't support indexed views that have
self-joins, but are there any reasonable work-arounds to this?
In the...more >>
ado.net problem [insert - datareader/store procedure] Posted by Agnes at 6/13/2004 4:14:42 PM My design is - load a blank form which got over 30 textbox to be filled int.
The user press "new" button, input the data, After he/she press "SAVE"
I will insert the new data into tables,
Now, some textbox got several ways to do.
Case As) by using datareader.
Dim str as string ="insert mytable...more >>
Functions vs Sprocs Posted by Frank Ashley at 6/13/2004 2:12:45 PM Is it noticeably quicker for a sproc to use a function or the function
algorithm to be part of the sproc?
thanks
Frank Ashley
...more >>
Calling an Executable Within a Trigger Posted by Stavros Varavvas at 6/13/2004 12:29:01 PM
Hello everyone,
I am developing a standalone application that needs to be executed after the data in a table changes. I started by utilizing the Trigger properties of a table upon performing an update. However I can’t figure out how to call an external executable (my application) within th...more >>
UNIQUE constraint problem Posted by Honza Ambroz at 6/13/2004 11:37:01 AM Hi all,
I have a question concerning the difference in functionality of UNIQUE constraints between MS Access and SQL Server 2000.
I have a table with a nullable column on which I have defined a UNIQUE constraint. In MS Access, everything works fine even if I have multiple nulls entered (this i...more >>
Declaring a Variable problem Posted by martino at 6/13/2004 11:33:27 AM Hello
I am trying to set the value of this variable by passing a
select statement that will read the value of the curmth
stored in table mbrcategory.
It does not seem to work, i got an incorrect syntax error
in query analyzer
this is the query i am writing:
declare @curmth as int
...more >>
Extended stored procedures and SQL thread scheduler Posted by faustus NO[at]SPAM pureevil.org at 6/13/2004 6:26:05 AM If an extended stored procedure initiates a lengthy IO operation, can the
SQL thread scheduler detect this and release another thread in its place?
Or will the blocked thread continue to consume its SQL "quanta" because
the blocking happens out of the scheduler's sight?
--
Curt Hagenlocher
c...more >>
Storing Dynamic Mathematical Expression Result, A Better Way? Posted by nospam_mytrash9 NO[at]SPAM bellsouth.net at 6/13/2004 3:14:35 AM I have a UDF that replaces variables with their actual values. The variables are
actually pointers to row data in a table. So something like
SELECT dbo.FormulaToValue('(10CC01 + 10CC20) / 10CC05')
would return something like
(3.21 + 5.62) / 12.0
The formulas are user defined, so hard co...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |