Database

select itemid from (select count(*) as TotalWords, itemid
			from item_keyword ik inner join keyword k on ik.keywordid = k.keywordid 
			where k.keyword in(<code>'C++','C#','ASP'</code>)
			group by itemid) as tbl 
<code>where TotalWords = 3</code>

Elina Blank wrote:

My concern is, that if there are 3 keywords, say 'Java','C#','ASP',
this query will still select it, or wouldn't it?

devboycpp wrote:

In two of my pages I have 6 roundtrips to sql server.In the other 3.Lets say in the worst case average of 3 roundtrips per page.All queries are simple queries that return records with few fields.and number of records are not more than 30.
Can problem be from my side ???? Is it that hard ?

SELECT AccountTypes.ATypeID, AccountTypes.AType, Accounts.OpDr +<br />
  SUM([Transaction].Debit) AS TDr, Accounts.OpCr +<br />
  SUM([Transaction].Credit) AS TCr<br />
FROM Accounts<br />
LEFT OUTER JOIN [Transaction]<br />
 ON Accounts.ATypeID = [Transaction].ATypeID<br />
 AND Accounts.AC = [Transaction].AC <br />
INNER JOIN AccountTypes<br />
 ON Accounts.ATypeID = AccountTypes.ATypeID<br />
GROUP BY Accounts.OpDr, Accounts.OpCr, AccountTypes.AType, AccountTypes.ATypeID

swgzj wrote:

where can find A ADOConnection CLASS

Ed.Poore wrote:

A parameter by the name of 'Id' does exist in the command's parameters (C# side of things)

ALTER PROCEDURE dbo.UpdateAssembler (@Id int, @Name char(20), @IsActive bit, @Stamp timestamp) AS
BEGIN
    IF EXISTS(SELECT * FROM Assembler WHERE ID = @Id)
        /* Check the TimeStamp */
        IF EXISTS(SELECT * FROM Assembler WHERE (ID = @Id AND Stamp = @Stamp))
            UPDATE Assembler
                SET Name = @Name,
                    IsActive = @IsActive
                WHERE ID = @Id
        ELSE
            RAISERROR('Different TimeStamps',10,1)
    ELSE
        INSERT INTO Assembler
            (Name, IsActive)
            VALUES (@Name, @IsActive)
END

// Build the Command
SqlCommand command = new SqlCommand("UpdateAssembler");
command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("Id", SqlDbType.Int);
command.Parameters.Add("Stamp", SqlDbType.Timestamp);
command.Parameters["Id"].IsNullable = true;
command.Parameters["Stamp"].IsNullable = true;

updateCommand.Parameters["Id"].Value = item.Id;			// an int? object
updateCommand.Parameters["Stamp"].Value = item.TimeStamp;	// byte[]
updateCommand.ExecuteNonQuery();