jaySampat (profile) - Beyondrelational.com Member Profile

Getting Started with Adobe After Effects - Part 6: Motion Blur

First Time? You can support us by signing up. It takes only 5 seconds. Click here to sign up. If you already have an account, click here to login.

jaySampat

779 · 0% · 37

My name is jaySampat.

decimal values get truncated after casting to varchar if the length of data is greater than 7 digits

jaySampat Commented 8 Months ago through Ask

But the problem with the above is that after converting to varchar data gets truncated and with the above solutions is that extra zeros get attached to it. So finally we found other solution by replacing all the zeros with a blank space the rtrim the ...

Question of the month September 2012 - Identify incorrect CREATE TABLE statements

jaySampat Commented 8 Months ago through Blogs

sorry u have posted some comments on my question which are wating for moderators approval vallabh.sampat@gmail.com...

Madhivanan JR

3 · 39% · 12430

jaySampat Liked 8 Months ago through Pages

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Jacob Sebastian

1 · 100% · 32002

decimal values get truncated after casting to varchar if the length of data is greater than 7 digits

jaySampat Posted 8 Months ago through Ask

I have a problem while casting float data to varchar.Could you please help. declare @var1 numeric(24,6), @var2 numeric(24,6), @var3 numeric(24,6) select @var1 = 550000,@var3 = 550050, @var2 = 10000 Select cast((@var3/@var2) as fl...