How to get a list of columns in a view using "sys.columns" in ms sql server?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How to encrypt data between dialogs?

0 Answers  


Can you pass expressions to function parameters?

0 Answers  


What is candidate key with example?

0 Answers  


Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  


How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,






What is the advantage of sql server?

0 Answers  


How can we solve concurrency problems?

0 Answers  


How to create a view on an existing table in ms sql server?

0 Answers  


What is a primary index?

0 Answers  


what is create database syntax? : Sql server database administration

0 Answers  


Difference between rowid and rownum in SQL?

1 Answers   Virtusa,


Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,


Categories