How to remove duplicate rows from table?
No Answer is Posted For this Question
Be the First to Post Answer
What are the restrictions while creating batches in sql server?
there is a table having two columns no and name and the data is 1 A 2 B 3 C write a query that will result a horizontal output A,B,C
How many primary keys are possible in a table?
Is null in sql server?
Do you know what is similarity and difference between truncate and delete in sql?
What is the difference between getdate and sysdatetime?
can an automatic recovery be initiated by a user? : Sql server administration
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
List out the differences between the clustered index and non-clustered index in sql server?
What is 2nf normalization form?
What are date and time data types in ms sql server?