ALLInterview.com :: Home Page kalaajkal.Com
 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  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
  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   Oracle Interview Questions  SQL Server interview questions   SQL Server Interview Questions  MS Access interview questions   MS Access Interview Questions
 MySQL interview questions   MySQL Interview Questions  Postgre interview questions   Postgre Interview Questions  Sybase interview questions   Sybase Interview Questions
 DB Architecture interview questions   DB Architecture Interview Questions  DB Administration interview questions   DB Administration Interview Questions  DB Development interview questions   DB Development Interview Questions
 SQL PLSQL interview questions   SQL PLSQL Interview Questions  Databases AllOther 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