|
|
-
Hardik Doshi Liked 11 Months ago through Just Learned | 1 Point
You can see this from the result of this query that Sum of consecutive odd numbers starting from 1 is a perfect square
[code]select 1,1+3,1+3+5,1+3+5+7,1+3+5+7+9[/code]......
|
-
Hardik Doshi Learned 11 Months ago through Just Learned | 1 Point
You can see this from the result of this query that Sum of consecutive odd numbers starting from 1 is a perfect square
[code]select 1,1+3,1+3+5,1+3+5+7,1+3+5+7+9[/code]......
|
-
Hardik Doshi Liked 12 Months ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
Hardik Doshi Learned 12 Months ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
Hardik Doshi Liked 12 Months ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
Hardik Doshi Learned 12 Months ago through Just Learned | 1 Point
Sometimes when SQL Server is configured to use some port other than default port number (1433), then you may not be able to connect directly in SSMS just by specifying the name of the server in the **Server Name** field in **Connection to Server** di...
|
-
Hardik Doshi Commented 12 Months ago through Just Learned | 1 Point
Thanks Jacob. Really interesting.
Now following code returns the result properly:
DECLARE @p VARCHAR(MAX)
SELECT @p = REPLICATE(CAST('a' AS VARCHAR(MAX)), 5000) + CHAR(10)
+ REPLICATE('b', 3000) + CHAR(10) + REPLICATE('d', 3...
|
-
Hardik Doshi Commented 12 Months ago through Just Learned | 1 Point
Thanks Jacob. Really interesting.
Now following code returns the result properly:
DECLARE @p VARCHAR(MAX)
SELECT @p = REPLICATE(CAST('a' AS VARCHAR(MAX)), 5000) + CHAR(10)
+ REPLICATE('b', 3000) + CHAR(10) + REPLICATE('d', 3...
|
-
Hardik Doshi Commented 12 Months ago through Just Learned | 1 Point
Thanks Jacob, I am using your query to check generated query without losing the formatting. I learned from you only.
This command is print / display only 8000 characters.
Code sample for the same is as below:
declare @p varchar(max)
...
|
-
Hardik Doshi Commented 12 Months ago through Just Learned | 1 Point
Thanks Jacob, I am using your query to check generated query without losing the formatting. I learned from you only.
This command is print / display only 8000 characters.
Code sample for the same is as below:
declare @p varchar(max)
...
|