Monday, 13 November 2017

Learn Sql server in hindi/urdu part-4 (Alter Table ,Update Table and Whi...





alter table student



add dateofadmission date





select * from student



update student

set dateofadmission='11/14/2016'

where id in (2,4)







Declare @Number int



Set @Number = 1008

While(@Number <= 1010)

Begin



 update student

set dateofadmission='11/11/2016'

where id =@Number





 Set @Number = @Number + 1





End







insert into student(name,batchcode,contactnumber,dateofadmission)

values('xyz','14b2v1','090078601',GETDATE())





select * from student




No comments:

Post a Comment

Pass Dynamically Added Html Table Records List To Controller In Asp.net MVC

Controller Code: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; using ...