Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / monty
i have other solution if you have table employee with
duplicate rows. You can create other table that doesn't
have duplicate rows
select distinct * into newtable from employee
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the most common trace flags used with sql server?
What is lock escalation and what is its purpose?
List the various tools available for performance tuning?
What do you think of this implementation? Can this be implemented better?
what's the difference between delete table and truncate table commands? : Sql server database administration
Explain transaction server consistency?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
How do we know if any query is retrieving a large amount of data or very little data?
What is data source in connection string?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Explain the properties of subqueries in sql server?
What are the tools available in market as an alternative to sql server reporting services?
What are the types of stored procedures in an sql server?
What is rs.exe utility?
List some advantages and disadvantages of stored procedure?
