SQLINFO – We play with data and technology

7 thoughts on “SQL SERVER – RESTORE VERIFYONLY – TO CHECK WHETHER DATABASE BACKUP CORRUPT OR NOT”

2. 

   Good post varunji…it’s really helpful..

3. 

   Hai varun,
   Your blog is really helpful and understandable to the beginners in SQL.Your posts are highly remarkable..
   Now i have a scenario can u plz help me?.I have a table and it contains a Varchar field .The data in the field like ‘17262000003’.I need to create a stored procedure
   to select the specified field .but my problem is i need to get a results set its satisfy the following:

   1.if the field contains 11 digits eliminate the last digit and make it as a 10digit.
   2.if the field contains 12 digits take the digits from 2 to 11 and make it as 10 digit(eg.’102345678921′ it should be ‘0234567892’)
   3.if the field contains more than 12 digts need to check in the same way..
   I need to retrieve a new column which contains only 10 digits along with my original column from my stored procedure..Waiting for a good solution from you.
   Thanks in advance
   Preethy Kamath

   1. 

      Hi Preethy,

      I think this script may help you.

      select [OrginalCOlumnName],case when LEN(‘172620000034’) > 11
      then substring(‘17262000003’,2,11)
      when LEN(‘172620000034’) = 11
      then SUBSTRING(‘17262000003’,0,10)
      else ‘17262000003’ end as [DerivedColumn]
      Use This in the Stored Procedure.Hope this may help u.

      Reply

      1. 

         Thanks Varun…I got expected results from this.

         Reply

4. 

   Hi Varun,
   txs for your precious site full of usefull things.

5. 

   Thanks Wolfgang…!

6. 

   Hi Varun,
   I would like to be a member of your blog…

   Regards,
   Chandra