SQL Scripts Archives - Page 199 of 318 - SQL Authority with Pinal Dave

SQL Function, SQL Scripts

In SQL Server Denali, there are three new conversion functions being introduced, namely: PARSE() TRY_PARSE() TRY_CONVERT() Today we will quickly look at PARSE() function. PARSE() function can convert any string value to Numeric or Date/Time format. If passed string value cannot be converted to Numeric or Date/Time format, it will…

SQL SERVER – Programming and Development – Book Available for SQL Server Certification

September 5, 2011

We recently gave away 7 physical books of Joes 2 Pros Book Volume 4. The response to following questions was overwhelming and was excellent. The book is available to purchase now in India and USA. This is great news as I often get request that where one can learn SQL…

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – OpenXML Options – Day 35 of 35

September 4, 2011

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. OpenXML Options The last posts introduced us to the OpenXML function. We learned…

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Preparing XML in Memory – Day 34 of 35

September 3, 2011

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Preparing XML in Memory If you want to take XML data and create…

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Shredding XML – Day 33 of 35

September 2, 2011

Answer simple quiz at the end of the blog post and – Every day one winner from India will get Joes 2 Pros Volume 5. Every day one winner from United States will get Joes 2 Pros Volume 5. Shredding XML Our introduction to XML in the last 3 days of…

SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Using Root With Auto XML Mode – Day 32 of 35

September 1, 2011