What is the fastest way to permanently delete a 1 million row table named custom

What is the fastest way to permanently delete a 1 million row table named customers?

Question Posted / meraj ahmed

0 Answers
1259 Views
I also Faced
E-Mail Answers

No Answer is Posted For this Question
Be the First to Post Answer

More SQL Server Interview Questions

hi to all teachers,... Friends who write in the query mode Full text Search in Sql Server have experience Who make(Convert) this Stored Procedure as a normal Full text Search, which contains and .. Is used, into Advance of the tips I have thanked all friends perfection. Email : rezaafandi@yahoo.com Create PROCEDURE Sp_student @fname varchar(50), @lname varchar(50), @tel varchar(50), @code varchar(50), @adr varchar(50), @search_operation varchar(50), @totalRowCount bigint output AS begin if @search_operation = 'and' begin SELECT f3,f4,f5,f6,f7 FROM tb_student WHERE( f5 like '%' + @fname + '%' and f4 like '%' + @lname + '%' and f6 like '%' + @tel + '%' and f7 like '%' + @code + '%' and f3 like '%' + @adr +'%' ) select @totalRowCount = @@rowcount end

0 Answers

What is meant by datasource?

0 Answers

What is the maximum length of an alert name?

0 Answers

What is temporal data type?

0 Answers

What is tablesample?

0 Answers

When you use @@error and try-catch?

0 Answers

What is the difference between executequery () and executeupdate ()?