Welcome, Guest Ohm namah shivoy
www.faqpanel.com
Home | ASP.Net | C-Sharp | Winforms | MS SQL | AJAX | XML | .Net Training*** | Search
Invite friends 
Extras 
VS Tips & Tricks
Top 10 .Net Tools
Special folders in ASP.Net
VS Find Combobox
 ASP.Net Interview Questions and Answers
How to SELECT TOP N records from mytable without using TOP keyword?
SET ROWCOUNT N
select * from mytable
SET ROWCOUNT 0

To turn this option off (so that all rows are returned), specify SET ROWCOUNT 0.
What command is used to create a table by copying the structure of another table in SQL Server?
What is the DEFAULT constraint in SQL Server?
What is Cross Join in SQL Server?
Which function is used to find the largest integer less than or equal to a specific value?
What is the difference between CAST and CONVERT in SQL?
Which operator performs pattern matching in SQL Server?
How many Columns per SELECT statement is possible in SQL Server?
What is the advantage of Materialised View?
What are defaults? Is there a column to which a default can’t be bound?
What is the REPLACE function in SQL?