Advertise your Business Here      Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new    Refer this Site               Login  |  Sign Up                         To Refer this Site to Your Friends   Click Here

Categories  >>  Software  >>  Databases  >>  SQL Server        Suggest New Category      Question  Asked @ Answers Views     select   WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX L&T  1  17 event classes in sql server Accenture  1  27 WHAT IS UNIQUE IDENTIFIER DATA TYPE? Sparsh  1  23 A left outer join B B right outer join A gives the same result then what is the use of two?  0  8 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? Lason  1  19 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 h  0  31 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  1  37 Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)  3  68 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 f f g h  0  17 9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18  1  57 write down the code for "how we delete a table without using of Drop command " ? Sonata  1  186 i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L  4  59 How can we write or define DDL statements in Sql server and DML statements?  1  65 what is difference between nchar and char in Sql server ?  2  236 what is trigger NIIT  1  342 E-Mail New Answers        Answer Selected Questions        Post New SQL Server Question    [1]    2  ... 5   ... 9   ... 13   ... 17   ... 21   ... 25   ... 29   ... 33   ... 37   ... 41   ... 45    Next         Oracle Interview Questions     SQL Server Interview Questions     MS Access Interview Questions     MySQL Interview Questions     Postgre Interview Questions     Sybase Interview Questions     DB Architecture Interview Questions     DB Administration Interview Questions     DB Development Interview Questions     SQL PLSQL Interview Questions     Databases AllOther Interview Questions       Un-Answered Questions    Question Views Asked at   Select   what are questions asked in TCS for database tester (sqlserver)for 2-3 exp? 116 TCS What is the difference between referencing and joining? 194   How To Find That One Week Change in My DataBase we Have Done Like We Have A database Test I Change Table,Stored Procd. Then I Find Which SP,Table We Have Edit/Change in Seven Dayes 141   Explain what are db_options used for? 332 InterGraph why we use cursor? 111 Melstar 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 h 31   What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan. 240   Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype? 153 Value-Labs what is difference between view and Dip. 137   How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000? 163   How retrieve field names from the table in SQL through JAVA code? 83   How we create SQL Server 2005 Reporting Services ? Give me Sample 120 HCL my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify. 127   hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results. 166   whate is advantages of sql server 2000 158   Any one plz send me SQL Server Developer/DBA resume for 4 years experience 305   What is Data model and how to prepare a data model.? 193 TCS what is package and it uses and how can u call a package 101 Satyam What is Index Segmentation ? 105 TCS Explain Capacity planning to create a database? and how to monitor it? 78   E-Mail New Answers        Answer Selected Questions

Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |            Copyright © 2007  ALLInterview.com.  All Rights Reserved. ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com