Interested to Buy Any Domain ? << Click Here >> for more details...
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 500
14 22179One 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 h
1 3975how 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 28917After recovering the database by using tail log backup.How to verify the data has been sucessfully restored or not.?
2086A 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 5583What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)
1 11972What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
2 6167what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
2 16825Diff between Composite key, Alternate Key, Candidate Key, Primary Key, Unique Key, Super Key, Foreign Key
1 10788
What is tempdb in sql server?
What is coalesce in sql server?
Explain Reporting Life Cycle?
What stored by the model?
How to list all user defined functions in the current database?
What are the extra roles available in msdb? : sql server security
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
What the different components of Replication and what is their use?
What is bcnf normalization form?
Explain ranking functions?
What is instead of trigger sql server?
What is filestream?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
