|
|
-
Yogesh Bhadauriya knew 2 Years ago through Just Learned | 1 Point
Many developers will face problem when converting string to particular numeric datatype. Some times it will give error if string is non numeric.
Non numeric string means, it may contain any extra string character or may be white space with numeric v...
|
-
Yogesh Bhadauriya knew 2 Years ago through Just Learned | 1 Point
Many developers will face problem when converting string to particular numeric datatype. Some times it will give error if string is non numeric.
Non numeric string means, it may contain any extra string character or may be white space with numeric v...
|
-
Yogesh Bhadauriya knew 2 Years ago through Just Learned | 1 Point
I just learned that there is an undocumented stored procedure sp_MSgetversion that will give us the current version of Microsoft SQL Server
[Code]
EXEC master..sp_MSgetversion
[/Code]
will returns below 3 columns
[Code]
/*
Character_Val...
|
-
Yogesh Bhadauriya knew 2 Years ago through Just Learned | 1 Point
I just learned that there is an undocumented stored procedure sp_MSgetversion that will give us the current version of Microsoft SQL Server
[Code]
EXEC master..sp_MSgetversion
[/Code]
will returns below 3 columns
[Code]
/*
Character_Val...
|
-
Yogesh Bhadauriya Learned 2 Years ago through Just Learned | 1 Point
In Earlier versions of .NET, String class has IsNullOrEmpty() method, which can be used to check whether the string is null or empty. To check for white spaces, we need to write additional code. Now .NET 4.0 introduced a new method, IsNullOrWhiteSpace()
|
-
Yogesh Bhadauriya Liked 2 Years ago through Just Learned | 1 Point
I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing:
[code]
/*
I would like to insert information from table ...
|
-
Yogesh Bhadauriya Learned 2 Years ago through Just Learned | 1 Point
I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing:
[code]
/*
I would like to insert information from table ...
|
-
Yogesh Bhadauriya Learned 2 Years ago through Just Learned | 1 Point
In Earlier versions of .NET, String class has IsNullOrEmpty() method, which can be used to check whether the string is null or empty. To check for white spaces, we need to write additional code. Now .NET 4.0 introduced a new method, IsNullOrWhiteSpace...
|
-
Yogesh Bhadauriya Liked 2 Years ago through Just Learned | 1 Point
I found a very interesting and ingenious solution for the poster's problem in MSDN Transact-SQL forum by Peter Larsson (PESO) and it was so interesting, that I'd like to share this whole thing:
[code]
/*
I would like to insert information from table ...
|
-
Yogesh Bhadauriya Learned 2 Years ago through Just Learned | 1 Point
In Earlier versions of .NET, String class has IsNullOrEmpty() method, which can be used to check whether the string is null or empty. To check for white spaces, we need to write additional code. Now .NET 4.0 introduced a new method, IsNullOrWhiteSpace...
|