Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 50014 13029
One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h1 1816
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?9 18236
A left outer join B B right outer join A gives the same result then what is the use of two?1 3483
After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?942
A successfully created SSIS package in SQL Server 2005 runs fine in MS BIDS and Integration Services. But gives error when run through an SQL-Job. What are the possible reasons?2 3113
What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)1 9862
What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query2 3868
what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?2 12262
Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key1 8809
How do you Implement SSIS Packages in your Project?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
wat wil hapn if we give the both read and deny read permission to user?
What is RMS migrations?
How to convert a table data in XML format in sql server?
how can u get last observation in an unknown dataset ?
If user is owning any SQL Objects, can we drop that user
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
your distribution database is full what will u do
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
What is the difference between online clustering and Offline clustering?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
You are doing log shipping due to some reasons it is failing. How you will proceed from there