Interested to Buy Any Domain ? << Click Here >> for more details...
How to select top 5 coloumn from a table without using
coloumn name
- 5 Answers
- 7862 Views
- I also Faced
- E-Mail Answers
Answer Posted / dj
Select Top(5) COLUMN_NAME
from INFORMATION_SCHEMA.COLUMNS
Where TABLE_NAME = 'Emp';
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Mention the differences between substr and charindex in sql server.
What is transaction server explicit transaction?
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?)
What the different components in replication and what is their use?
What is tempdb database? : SQL Server Architecture
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
What is named query? : sql server analysis services, ssas
What is data block and how to define data block size?
What are the different normalization forms?
What are pessimistic lock and optimistic lock?
Explain iaas, paas and saas?
What do you understand by check constraint in sql server?
What program is used to store the data source file?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
