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                         SiteMap shows list of All Categories in this site.

Categories >> Software >> Databases >> SQL Server        Suggest New Category      Question  Asked @ Answers Views     select   how can i view structure of table in sql server? tell me that query.  1  91 Accidentally i deleted my table. How can i get that table?  1  114 what is difference between having and where clause ?  1  66 employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.  1  139 I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000    5  284 can you any body tell me the how to decrease the logfile  2  119 can you any body tell me which service pack is installed in the sql server?  1  91 Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)  1  212 Name three version of sql server 2000 and also their differences?  1  156 Which virtual table does a trigger use?  3  239 How do you find the error, how can you know the number of rows effected by last SQL statement?  1  154 What types of integrity are enforced by a foreign-key constraint  1  176 internal language used in sql server 2000?  1  82 How are SQL Server databases physically stored under Windows 2000?  1  95 syntax for deleting the database in T SQL  3  219 E-Mail New Answers        Answer Selected Questions      [1]    2  ... 4   ... 7   ... 10   ... 13   ... 16   ... 19   ... 22   ... 25   ... 28   ... 31    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   Which command displays the SQL command in the SQL buffer, and then executes it? 39 TCS Questions on identity? 30 Infosys How would you Update the rows which are divisible by 10, given a set of numbers in column? 31   code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that 10 IGT i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database? 61   Explain sp_configure commands, set commands? 30   Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype? 14 Value-Labs what are questions asked in TCS for database tester (sqlserver)for 2-3 exp? 14 TCS How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000? 33   How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005? 13   Scalability, Availability, Integration with internet, etc.)? 26   where the connection string store in the database 32 HCL 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. 45   Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ... 45 Crown-Solutions What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes? 58 Wipro What is the difference between NOROW and LOCKROW? 28 Honeywell What is the difference between referencing and joining? 75   Can we rewrite subqueries into simple select statements or with joins? Example? 57   whate is advantages of sql server 2000 41   Explain the storage models of OLAP? 26   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