• 0

[SQL] Varchar cutting off my string!


Question

Ive got a long stored proc that adds several strings to a varchar variable at different steps then outputs the full varchar result at the end.

Its adding the first 2 strings to the varchar, but it only adds half of the 3rd one and none of the 4th one.

I thought maybe the varchar variable was full... but ive set it to VARCHAR(8000) and when i do a LEN() on the final varchar variabl its only 269.

Anyone know why its cutting off the end of my varchar!?!?

(Using SQL Server 2000 btw)

Link to comment
https://www.neowin.net/forum/topic/319106-sql-varchar-cutting-off-my-string/
Share on other sites

5 answers to this question

Recommended Posts

  • 0

This is really annoying me now... here is some code... ne1 see whats wrong?

DECLARE	@NewsMessage  VARCHAR(8000)

SELECT	@NewsMessage = 'Battle Report from Planet ' + PlanetName +  '[' + CAST(XPos AS VARCHAR(3)) + ':' + CAST(YPos AS VARCHAR(3)) + ':' + CAST(ZPos AS VARCHAR(3)) + '].<BR>'
FROM	tblAccount
WHERE	AccountID = @AccIDUnderAttack

SELECT	@NewsMessage = @NewsMessage + 'Defending Fleets: ' + CAST(@DefendFleets AS VARCHAR(5)) + '<BR>Defending Ship Quantity: ' + CAST(@DefendTotalShips AS VARCHAR(15)) + '<BR>Defending Ship Luck: ' + CAST(@DefendLuck AS VARCHAR(5)) + '<BR>Defending Ship Loss: ' + CAST(@DefendShipLoss AS VARCHAR(15)) + '<BR>'

SELECT	@NewsMessage = @NewsMessage + 'Attacking Fleets: ' + CAST(@AttackFleets AS VARCHAR(5)) + '<BR>Attacking Ship Quantity: ' + CAST(@AttackTotalShips AS VARCHAR(15)) + '<BR>Attacking Ship Luck: ' + CAST(@AttackLuck AS VARCHAR(5)) + '<BR>Attacking Ship Loss: ' + CAST(@AttackShipLoss AS VARCHAR(15)) + '<BR>'

  • 0

Found out what was goin on...

I was using MS SQL Server 2000's Query Analyser application to retrieve these results. It appears the Query Analyser application only lets you display 260 odd characters per line in the results window. And rather than indicate that it had cut off the result from the results pane, and rather than continuing on the line below, it just stops out putting the data.

So there is no problem when i run it cos i can see the correct long varchar result in my application (which doesnt limit the result output!).

I hope they do something about this for SQL Server 2005's Query Analyser... very dodgy...

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • Microsoft shares Windows 10 ESU key guide for office PCs that don't support Windows 11 by Sayan Sen Recently, the Indian government issued a caution about the upcoming end of support for Windows 10 which is about four months away. Interestingly, on that very day, Microsoft made a major announcement regarding this as the tech giant debuted free enrollment options wherein support would be extended for another year at no extra cost. Microsoft is also trying to make it easy to set up Extended Security Updates (ESU) with a new tool. You can see in the image below: New ESU enroll wizard Following that, today, the company has shared a new guide on how to activate ESU via Intune in the case of Windows 10 office PCs that are not supported on Windows 11. First up, Microsoft has reminded users of the prerequisites of Windows 10 ESU: The system needs to be on Windows 10 22H2 with KB5046613 (November 2024 Patch Tuesday) or newer. The device needs access to the network endpoints required for client activation. The process that is used for activation needs administrative privileges on the device. The guide contains several PowerShell scripts and are meant for IT admins and system admins. One of those is a validation script "Check-Win10ESUPrereq.ps1" that Microsoft has published to help "verify a device has the required version and patch level for Windows and it can communicate to the required network endpoints." Essentially, it checks if the aforementioned requirements are satisfied and can be used for troubleshooting against those prerequisites. After the "validation," Microsoft says there are two ways to proceed with the ESU key activation. First. it can be done by either Remediation through: Detection Script (Win10ESUActivation-detect.ps1) and Remediation Script (Win10ESUActivation-remediate.ps1). And second, by Win32 Application with Win32 Install Script (Win10ESU-install.ps1) and Win32 Detection Script (Win10ESU-detection.ps1). In the case of Remediations, Microsoft mentions "some licensing considerations" due to which "some smaller companies may not have that option." Finally, Microsoft has also shared some Activation IDs for manual verification via Slmgr VB script for obtaining volume activation information: Win10 ESU Year1: f520e45e-7413-4a34-a497-d2765967d094 Win10 ESU Year2: 1043add5-23b1-4afb-9a0f-64343c8f3f8d Win10 ESU Year3: 83d49986-add3-41d7-ba33-87c7bfb5c0fb You can check the full guide and the details here on Microsoft's official Tech Community website.
    • It blows me away how overpriced Synology is. $600+ for a 3+ year old SATA NAS with only gigabit networking!! Even for 2022 that is pretty low-end hardware. Yes, the Synology software is fantastic, but if we say this hardware is worth $300 max (and that is even giving a generous premium to the fact that it is made by a respected OEM), their software is NOT worth an additional $300, especially considering it is locked to the hardware it shipped on and you have to pay that premium again for your next devices. Important correction to the specs table above. Saying Disk Capacity is 72TB and even going further to detail that is 4x18, strongly implies it comes with those disks, which it does not. I would rather see it say "Max Capacity: 72TB (disks not included)."
    • well again if w11 adoption its so high there's no reason why they try to explain us why is "better" to move to w11. If they are so right about their downgraded UI, why they add some of their UI elements back things like never combine and now small icons. Last time i check majority is still on 10 over 11 so yeah millions of users that did not upgrade to w11
    • Size 15. In the first week I managed to get a full week before having to recharge from 10%. I looked online and Samsung recommends recharging it when it gets to 20-30% to preserve the battery life. In the second week, started wearing my Galaxy Watch6 Classic again, because I read that it offsets sensors to the Watch, meaning the battery lasts even longer... and a week on (today) the ring was at 31% when I recharged it fully again, so a difference of over 20% in combination with the Watch. By the way I do not wear my Watch to bed, so it is only the Ring doing the sleep tracking (which is hit or miss tbh) it stops tracking for an hour or two in the night, which is really annoying. I had the same thing with the Watch, and I found it uncomfortable to have on in bed. I have been reading that the battery can start to go bad even after the first week so I am glad it isn't affecting me (yet).
    • Visual Studio gets even smarter with more AI models and billing updates by Usama Jawad Visual Studio and Visual Studio Code are among the most popular integrated development environments (IDEs) out there. The tools boast more than 50 million monthly active users, which isn't surprising considering their platform agnosticism, deep integration with the Microsoft ecosystem, and the power of GitHub Copilot. Now, Microsoft is looking to entice even more customers who are eager to use AI models to boost their productivity during the development process. In a blog post, Microsoft has stated that it has updated the AI models list available in Visual Studio to default to smarter options. For example, Copilot will now use GPT-4.1 rather than GPT-4o, since it offers better responses with faster performance. In addition, users can now select between the following models to enhance their coding experience based on their preferences: Claude Sonnet 4 Claude Opus 4 Claude Sonnet 3.5 Claude 3.7 (non-thinking and thinking) OpenAI o3 mini Gemini 2.0 Flash Gemini 2.5 Pro Microsoft has noted that your selected model will persist across your workflows, so if you're unsure about which model to leverage, you can refer to its documentation here. Furthermore, Visual Studio is making it easier to switch between models that are included in your plan through a prompt in the model selector. When it comes to billing updates, Microsoft has built a new Copilot Consumptions user experience that can be accessed by navigating to the Copilot badge present in the top-right corner of the IDE. As the name suggests, this panel shows your consumption in an easily digestible format. You can also click on Manage Plan, which will take you to the GitHub website. It is important to note that some models are request-heavy, and Visual Studio will now indicate this to you while you are selecting your model. If you exhaust your premium requests, you will shift to a standard model seamlessly. You should also keep in mind that the GitHub Copilot pricing plans have been updated, and the billing experience in Visual Studio does reflect them.
  • Recent Achievements

    • Conversation Starter
      Kavin25 earned a badge
      Conversation Starter
    • One Month Later
      Leonard grant earned a badge
      One Month Later
    • Week One Done
      pcdoctorsnet earned a badge
      Week One Done
    • Rising Star
      Phillip0web went up a rank
      Rising Star
    • One Month Later
      Epaminombas earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      529
    2. 2
      ATLien_0
      207
    3. 3
      +FloatingFatMan
      168
    4. 4
      Michael Scrip
      149
    5. 5
      Steven P.
      122
  • Tell a friend

    Love Neowin? Tell a friend!