Use of Multiple Test Expressions in an 'If' Statement

Question

Can anyone clarify for me please, as to whether you can specify more than one expression in the test part of an 'If' statement. I would like to check for two, or more, conditions in my 'If' statement. In the case the none of the conditions are met, I want the same 'else' statement to be executed. I have tried various techniques: if(test1) _____if(test2) MessageBox.Show("HelloWorld"); else MessageBox.Show("GoodbyeWorld"); if(test1) { _____if(test2) MessageBox.Show("HelloWorld"); } else MessageBox.Show("GoodbyeWorld"); But have have come to the conclusion that I will have to repeat the else part twice, which surely cant be so. In VB you can do the following: If (Test1 = true) Or (Test2 = true) Then _____MessageBox.Show("HelloWorld") Else _____MessageBox.Show("GoodbyeWorld") End If Can someone put me out of my misery, in a kind and gentle way please!

Answer 1

Gaurav,

Would like to understand few things.

Whether you want to delete the records in a table based on the count of rows (parameter)? irrespective of which 10 or 40 records to be deleted.

Below link has the sample stored procedure to delete the records (result of search query) from the table.

https://technet.microsoft.com/en-us/library/ms189634(v=sql.105).aspx

Hope it will solve your issue.

Answer 2

Another approach you can take is schedule the deletion of rows during a time when database is not used.

Example during Night.

Then you would not need to implement any extra logic.

But use this, only if deletion can be done later.

Answer 3

CREATE PROCEDURE spDeleteRecord
@DeleteBatchSize INT,
@DelayTime DATETIME
AS
BEGIN
SET NOCOUNT ON;
DECLARE @DeleteRowCount INT
SET @DeleteRowCount = 1

WHILE (@DeleteRowCount > 0)
BEGIN
BEGIN TRANSACTION
DELETE TOP(@DeleteBatchSize) SchemaTableName;
SET @DeleteRowCount = @@ROWCOUNT;
PRINT @DeleteRowCount;
COMMIT
WAITFOR DELAY @DelayTime
END
END
GO

Answer 4

https://sqlperformance.com/2013/03/io-subsystem/chunk-deletes