Advertisement
Guest User

Untitled

a guest
Feb 21st, 2019
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. Id| Car Plate| Username| Color| Year| Rent|
  2.  
  3. UPDATE [yourTableName]
  4. SET Rent = 0
  5. WHERE Rent IS NULL
  6.  
  7. Select Id, Car Plate, Username, Color, Year, IsNull( Rent , Convert(bit, 0)) AS Rent
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement