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
How to encrypt data between dialogs?
Can you pass expressions to function parameters?
What is candidate key with example?
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
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)
What is the advantage of sql server?
How can we solve concurrency problems?
How to create a view on an existing table in ms sql server?
What is a primary index?
what is create database syntax? : Sql server database administration
Difference between rowid and rownum in SQL?
Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).