Jump to content

nomore_sr

Members
  • Posts

    5
  • Joined

  • Last visited

nomore_sr's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. nomore_sr

    sum

    This querySELECT IsNull(SUM(Total),0) FROM CargoD Where Folio=100 will return 0 if there are no records and sum if sum is not null
  2. Hope this useful. I tried and it workedCreate trigger St_update on Studentfor updateAs update Point set [iD]=(select [iD] from Inserted), [Name]=(select [Name] rom Inserted), Class=(select Class from Inserted) where [iD]=(select [iD] from Deleted) Your Student table should have primary key. In this case I chose ID as primary key
  3. this's useful. Thank youAnother way to select the first 8 rowsSELECT top 8 * FROM table_name ORDER BY date_field DESC
  4. This is my solution sp_rename 'TableName','NewName'
  5. Other ppl won't see the password if method="post" like this<form id="login" action="" method="post" onsubmit="LogIn(); return false;"> default method is post
×
×
  • Create New...