|
|
-
Sanjay Bhatia Liked 2 Years ago through Just Learned | 1 Point
Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa"
When you are using replicate function, if it returns more than 8000 characters, it will truncate that.
To prevent that, you need to cast to nvarc...
|
-
Sanjay Bhatia Liked 2 Years ago through Just Learned | 1 Point
Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa"
When you are using replicate function, if it returns more than 8000 characters, it will truncate that.
To prevent that, you need to cast to nvarc...
|
-
Sanjay Bhatia Learned 2 Years ago through Just Learned | 1 Point
Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa"
When you are using replicate function, if it returns more than 8000 characters, it will truncate that.
To prevent that, you need to cast to nvarc...
|
-
Sanjay Bhatia Learned 2 Years ago through Just Learned | 1 Point
Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa"
When you are using replicate function, if it returns more than 8000 characters, it will truncate that.
To prevent that, you need to cast to nvarc...
|
-
Sanjay Bhatia Liked 2 Years ago through Just Learned | 1 Point
Replicate() function can be used to replicate characters. suppose replicate('a',5) will returns "aaaaa"
When you are using replicate function, if it returns more than 8000 characters, it will truncate that.
To prevent that, you need to cast to nvarchar
|