We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Data type conversion has been one of the most used features of any programming language. Microsoft SQL Server users are familiar with the two functions: CAST() and CONVERT() and use them regularly, and more specifically, interchangeably. A few months ag...

Data type conversion has been one of the most used features of any programming language. Microsoft SQL Server users are familiar with the two functions: CAST() and CONVERT() and use them regularly, and more specifically, interchangeably. A few months ag...

This challenge is about finding second highest salary for each department...

In previous versions, if we select a row in gridview in page 1, if we move to page 2 and come back to page 1, previously selected row will be unselected. I saw many questions in forums to persist this selection. We used to write a lot of custom code. No...

In previous versions, if we select a row in gridview in page 1, if we move to page 2 and come back to page 1, previously selected row will be unselected. I saw many questions in forums to persist this selection. We used to write a lot of custom code. No...

In previous versions, if we select a row in gridview in page 1, if we move to page 2 and come back to page 1, previously selected row will be unselected. I saw many questions in forums to persist this selection. We used to write a lot of custom code. No...

In previous versions, if we select a row in gridview in page 1, if we move to page 2 and come back to page 1, previously selected row will be unselected. I saw many questions in forums to persist this selection. We used to write a lot of custom code. No...

In previous versions, if we select a row in gridview in page 1, if we move to page 2 and come back to page 1, previously selected row will be unselected. I saw many questions in forums to persist this selection. We used to write a lot of custom code. Now i

SQL Server added another function CHOOSE(). which returns a value from the list of given values based on a given position. Suppose, below query will give output "Two". [code] SELECT CHOOSE(2,'One','Two','Three','Four') [/code] You can specify ...