Monday, April 15, 2024

How do you reset the identity start value in SQL Server?

TRUNCATE TABLE YourTableName; -- Delete all records 

DBCC CHECKIDENT ('YourTableName', RESEED, 1); -- Reset identity column 

Wednesday, April 10, 2024

How do electricity charges work in Telangana?

 1.If your monthly consumption is less than 100 units:

  • The first 50 units will be charged at Rs. 1.95 per unit.
  • The remaining 50 units will be charged at Rs. 3.10 per unit.
  1. If your monthly consumption is between 100 and 200 units:
  • The first 100 units will be charged at Rs. 3.40 per unit.
  • The remaining 100 units will be charged at Rs. 4.80 per unit.
  1. If your monthly consumption exceeds 800 units:
  • The first 200 units will be charged at Rs. 5.10 per unit.
  • The next 100 units (201-300) will be charged at Rs. 7.70 per unit.
  • The next 100 units (301-400) will be charged at Rs. 9.00 per unit.
  • The next 400 units will be charged at Rs. 9.50 per unit.
  • Any remaining units beyond 800 will be charged at Rs. 10.00 per unit.