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.

Friends

Request Friendship



Upload Image

Chennai, India
Male
Madhivanan
2 · 40% · 13039
  • How the max(id) value differ based on Datatype

    Madhivanan Commented 4 Years ago through Ask | 10 Points
    Which version of SQL Server are you using? I think the MAX on VARCHAR does the implicit integer convertion. But I do not see this behaviour in 2012 Express edition...
    ABHISHEKONLINE4ALL
    106 · 2% · 503
  • How to keep data persistent in someway if database goes offline

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    Which front end tool are you using? .NET supports disconnected recordset which will serve what you need....
    bhawna.koul
    604 · 0% · 60
  • Date format

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    How are you passing date values to SQL Server? Make sure to read this post http://beyondrelational.com/modules/2/blogs/70/posts/10898/understanding-datetime-column-part-ii.aspx...
    strivesupport
    646 · 0% · 54
  • How to keep data persistent in someway if database goes offline

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    If you want to handle this in an application level, one way is to export data into a text file and keep it with the local system's directory and get data (read only) from it until the connectivity to the server is established. However users can not do a...
    bhawna.koul
    604 · 0% · 60
  • decimal values get truncated after casting to varchar if the length of data is greater than 7 digits

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    1 Why do you convert DECIMAL into FLOAT? Note that FLOAT is approximate type 2 Why do you want to convert the result into VARCHAR? You cannot do any calculations on this. Let the front end application do the formation If you want to convert in sql...
    jaySampat
    710 · 0% · 47
  • SQL query to set different first day of the week for different years

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    Start with this SET DATEFIRST 1 -- Monday SELECT DateKey , CalendarDate , CalendarYear , CalendarQuarter , CalendarMonth , CalendarDay , [Da...
    Praveen
    85 · 2% · 664
  • Want Querry

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    If want to swap the column values(column option1), here is one of the ways DECLARE @t TABLE ( QuestionNo INT IDENTITY, Question VARCHAR(20), Option1 VARCHAR(20), Option2 VARCHAR(20), Option3 VARCHAR(20), Option4 VARCHAR(20), A...
    ravikumar.gungegmail.com
    811 · 0% · 36
  • Query Help

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    The MasterIP value of your last update statement should be '5.46.200.1.462222.2.1' isn't it?...
    sqldba2k12
    617 · 0% · 58
  • Need help to generate unique alphanumeric values

    Madhivanan Commented 5 Years ago through Ask | 10 Points
    Depends on your requirement, use one of these http://beyondrelational.com/modules/2/blogs/70/posts/10813/random-password-generator.aspx http://beyondrelational.com/modules/2/blogs/70/posts/10858/filling-random-passwords-set-based-approach.aspx...
    Raymchan
    530 · 0% · 71
  • openrowset insert from sql server 2000 to dbf file

    Madhivanan Replied 5 Years ago through ASK | 1 Point
    Make sure that the SERVER has Jet engine installed for EXCEL...

    0 · 0% · 0
Previous 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ... Next

Managed Windows Shared Hosting by OrcsWeb

Copyright © Rivera Informatic Private Ltd.