|
|
-
Manoj Commented 4 Months ago through Blogs
You can try using the new THROW clause if you are in SQL Server 2012.
Thanks,
Manoj...
|
|
|
-
Manoj Liked 6 Months ago through Books
This books tries to explain the new FILESTREAM feature introduced in SQL Server 2008 from basic to advanced levels through a number of simple examples and walk-through labs...
|
-
Manoj Commented 6 Months ago through Blogs
To answer your question:
**Q1: Why is newid() not returning all the items in random order for concatenation and why does it choose only one randow item?**
Using expressions in ORDER BY clause can result in undefined behavior, agree with @Olga.
...
|
-
Manoj Commented 7 Months ago through Blogs
Recalling my older post: [http://sqlwithmanoj.wordpress.com/2011/10/04/update-statement-with-new-write-clause/][1]
[1]: http://sqlwithmanoj.wordpress.com/2011/10/04/update-statement-with-new-write-clause/...
|
-
Manoj Commented 7 Months ago through Blogs
If you do an AND between @@microsoftversion & 0xFFFF, you will get the release number for the specific Version.
Check this:
select @@microsoftversion & 0xFFFF as ReleaseNumber...
|
|
|
-
Manoj Commented 8 Months ago through Blogs
I don't think you need to do all this when you have lot of options for processing XML data.
Check this blog post: [http://sqlwithmanoj.wordpress.com/2011/10/20/save-xml-in-a-file-read-xml-from-a-file/][1]
Here I've shown how you can save XML to a ...
|
-
Manoj Commented 10 Months ago through Blogs
select COALESCE(NULL * 3, '') is giving 0 because, when you multiple NULL with 3 the result will be NULL, but it implicitly converts the NULL value to INT datatype.
And because first param is NULL, so second param value cast'ed by INT is returned, wh...
|
-
Manoj Commented 10 Months ago through Blogs
When I execute this query in 2008 R2 it get following msg: **At least one of the arguments to COALESCE must be a typed NULL.**
And in 2012 I get: **At least one of the arguments to COALESCE must be an expression that is not the NULL constant.**
Th...
|