Muthukkumaran Kaliyamoorthy, please refer to this post for your answer. I happen to post it in different window instead of replying to your post 😀

True there is no such command called "Bulk Delete" in SQL. But you can wrapped DELETE statement in transaction to delete records from your table. Deleting is bulk is faster than just issuing DELETE command. Here's the code snippet. It deletes records in batch of 100000 rows at a time.

BEGIN TRANSACTION

SET NOCOUNT ON;

DECLARE @totalRowint;

DECLARE @intRowCount int;

DECLARE @intErrNoint;

SELECT @totalRow = COUNT(*) FROM [Table] WITH (NOLOCK)

WHERE [Condition] OPTION(MAXDOP 2);

SELECT@intRowCount = @totalRow,

@intErrNo = 0;

WHILE @intRowCount > 0 AND @intErrNo = 0

BEGIN

SET ROWCOUNT 100000;

DELETE FROM [Table]

WHERE [Condition] OPTION(MAXDOP 2);

SELECT @intErrNo = @@ERROR

, @intRowCount = @@ROWCOUNT;

END;

SET ROWCOUNT 0; -- Reset batch size to "all"

END;