|
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($)
after getting one bug i learn this from bol...
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
Was trying to install HDInsight on Windows 7 machine but when I tried running the [Microsoft Web Platform Installer][1] and searched for [Hadoop or HDInsight][2], the search was failing. After some search online, I found that, HDInsight for Windows i...
|
-
Guru Samy Learned 4 Months ago through Just Learned | 1 Point
ISNUMERIC returns 1 for some characters that are not numbers, such as plus (+), minus (-), and valid currency symbols such as the dollar sign ($)
after getting one bug i learn this from bol...
|
-
Guru Samy Learned 4 Months ago through Just Learned | 1 Point
Was trying to install HDInsight on Windows 7 machine but when I tried running the [Microsoft Web Platform Installer][1] and searched for [Hadoop or HDInsight][2], the search was failing. After some search online, I found that, HDInsight for Windows i...
|
-
Guru Samy Learned 4 Months ago through Just Learned | 1 Point
I just learnt that, based on the frequency of data access and type of storage, there are three different categories of data.
**Hot Data**: Data that is frequently accessed and stored on high speed storage/disks.
**Warm Data**: Data that is mode...
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
I just learnt that, based on the frequency of data access and type of storage, there are three different categories of data.
**Hot Data**: Data that is frequently accessed and stored on high speed storage/disks.
**Warm Data**: Data that is mode...
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
It is very small point but developers are unaware of it that's why i am sharing it here.
Len function in sql server returns total no of characters in any string which is passed to it as a parameter,but it excludes trailing blanks
example
sele...
|
-
Guru Samy knew 4 Months ago through Just Learned | 1 Point
It is very small point but developers are unaware of it that's why i am sharing it here.
Len function in sql server returns total no of characters in any string which is passed to it as a parameter,but it excludes trailing blanks
example
sele...
|
-
Guru Samy Liked 4 Months ago through Just Learned | 1 Point
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**...
|
-
Guru Samy Learned 4 Months ago through Just Learned | 1 Point
Today I came across the problem.
When One my SP has Insert Into Table Exec SP_Name and doing same another SP using the Main SP.
The moment I am getting the error "An INSERT EXEC statement cannot be nested."
To resolve the Issue
Do the steps.
**...
|