|
|
|
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 Finding the affected row from trigger Posted by girishpal NO[at]SPAM hotmail.com at 9/7/2003 11:47:54 PM I have a trigger on delete. I want to know the primary key coloumn of
row being deleted.
How to get it....more >>
Row id Posted by girishpal NO[at]SPAM hotmail.com at 9/7/2003 11:46:24 PM Is there any implicit row id for each row in the table. If yes then
how to select it .
Thank You....more >>
SQL Help Needed Posted by MAB at 9/7/2003 7:16:25 PM I have a table
Create Table Payments {
paymentid int,
customerid int,
amount int,
date datetime
}
What I want is the sum of the amounts of the last payments of all customers.
Now the last payment of a customer is not necessarily the one with the
highest paymentid for tha...more >>
Test a Job Posted by Andrea Moro at 9/7/2003 4:40:42 PM Is there some sp to let me test an SQL agent Job.
I suppose that there is some error, but I canno know, because
I don't know how to test the jobs.
One of these errors is in command parameter. According to
BOL, it say that is possible to insert on of the tokens that
in run time is replaced w...more >>
SQL help Posted by Mustapha Amrani at 9/7/2003 4:22:48 PM I am designing a database for a conference centre. Visitors get payed
subsistence during their visits. The visitors rent rooms from the conference
centre.
Subsistence table is something like:
memcode nvarchar 8
beg_visit datetime 8
end_visit datetime 8
daily_rate float 8
the housing tabl...more >>
Parsing a Text File for an SQL Statement Posted by Amos Soma at 9/7/2003 1:25:53 PM Has anyone written a utility (preferrably in C#) that takes a text file or
string and extracts any SQL statements (e.g., Select, Insert, Update,
Delete, Alter etc.) contained in the file or string?
Thanks very much.
...more >>
Find UnMatched Keys Posted by Wayne Wengert at 9/7/2003 12:39:05 PM I am trying to re-establish relationships between some tables where some of
the tables had to be restored. I have a master NAMES table with an identity
for each entry as the PK that was restored. I have other tables with foreign
keys pointing to entries in NAMES. I want to get a list of all the r...more >>
How to get SQL dynamic results unto a static page. Posted by Judy at 9/7/2003 8:20:59 AM I have 3 tables in my SQL database. The data from the 3
tables comes as a list in my web page(through SQL query)
when I click on a link.i.e., each time the SQL Server is
called. I need a link in my web page that will show a
static page made from the dynamic tables so that the SQL
server is...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Edit Stored Procedure Posted by Jim at 9/7/2003 6:35:06 AM I have added a new colomb to the Answer table and want ot modify this stored
procedure so that it returns that ne colomb also. I have no idea of writing
stored procedures, but am willing to learn!
Thanks
Jim
CREATE PROCEDURE GetQuestions
@Id UNIQUEIDENTIFIER
AS
SET NOCOUNT ON
-- Access ...more >>
Case problem Posted by Niitmalad at 9/7/2003 5:18:20 AM Dear Friends
I have write the following query with case but it is
always giving me result of Else as 0
Please suggest what is wrong.
CREATE VIEW MaterialCostBankcharges
AS
SELECT dbo.MaterialCostViewMain.Inv_Ref,
dbo.MaterialCostViewMain.Mas_Currency,
(Case dbo.MaterialCostVi...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |