I have been working with SQL from some time and I know how it feels when we start using it first time. Several questions arises in our mind like, Am I writing queries in correct way? What impact on my front end performance? What should I use? etc.
Let’s start answering these questions.
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