Guest User

Untitled

a guest
Jun 18th, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. SqlCommand cmd = new SqlCommand("Update [Table] set HodinNumber='" + hodinnumber + "',Date Planning='" + dateplanning + "',Loading='" + loading + "',Delivery='" + delivery + "',TruckIn='" + truckin + "',TruckOut='" + truckout + "',Status='" + status + "'Where LogOnNumber='" + logonnumber + "'", connection);
  2.  
  3. CREATE TABLE [dbo].[Table] (
  4. [LogOnNumber] BIGINT IDENTITY (65400000, 1) NOT NULL,
  5. [HodinNumber] INT NULL,
  6. [Date Planning] DATE NULL,
  7. [Loading] BIGINT NULL,
  8. [Delivery] BIGINT NULL,
  9. [TruckIn] DATE NULL,
  10. [TruckOut] DATE NULL,
  11. [Status] INT NULL,
  12. PRIMARY KEY CLUSTERED ([LogOnNumber] ASC)
Add Comment
Please, Sign In to add comment