Some days back I wrote one chunk of code for fixing one of the client specific defects in one of application on which I was working. I used Int32.Parse for parsing string value to integer. After some days the issue resurfaced again. I debugged the code for finding the root cause behind the issue, and I found that for some values Int32.Parse was failing.
Then I decided to dig into all the options available for parsing and just thought to share my findings with you.
There are lots of new feature introduced with SQLServer 2008 for improving the SQL experience of developers. Here we will cover some very important and useful features of SQLServer 2008. Features which we are going to cover is –
- Declaring and initializing new variables.
- Compound assignment operators
- Table value constructor
- Enhanced Convert Function
- Date and Time Data types
- Table Type