Learning Site

alter procedure Insert100rows   as begin   declare @id int select @id = 1 while @id >=1 and @id <= 1000 begin     insert into HardwareDbTable(AssetName,Manufacturer,Model) values('jack' + convert(varchar(5), @id), 'dd','kk')     select @id = @id + 1 end end

< !DOCTYPE   html > < html > < head >      < meta   charset = "utf-8"   />      < title ></ title >      < link   href = "compiled-4.5.7.min.css"   rel = "stylesheet"   />      < style >          .timepicker.picker__input.picker__input--active  {              border-bottom :  1px   solid   #e3f2fd         }      </ style > </ head > < body >      < div   class = "row" >          < div   class = "col-md-4" >              < input   placeholder = "Selected time"   t...

< link   type = "text/css"   rel = "stylesheet"   href = "https://cdn.datatables.net/1.10.9/css/dataTables.bootstrap.min.css"   />     < link   type = "text/css"   rel = "stylesheet"   href = "https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css"   />     < link   type = "text/css"   rel = "stylesheet"   href = "https://cdn.datatables.net/responsive/1.0.7/css/responsive.bootstrap.min.css"   /> < asp : GridView   ID = "gvlist"   AutoGenerateColumns = "false"   runat = "server"   class = "table table-striped"   ClientIDMode = "Static" >             < Columns >                 < asp : TemplateField   HeaderText = "Id" >          ...

< asp : GridView   ID ="GridView1"   HeaderStyle-BackColor ="#3AC0F2"   HeaderStyle-ForeColor ="White"      runat ="server"   AutoGenerateColumns ="false"   OnDataBound ="OnDataBound">      < Columns >          < asp : BoundField   DataField ="Id"   HeaderText ="Id"   ItemStyle-Width ="30"   />          < asp : BoundField   DataField ="Name"   HeaderText ="Name"   ItemStyle-Width ="100"   />          < asp : BoundField   DataField ="Country"   HeaderText ="Country"   ItemStyle-Width ="100"   />      </ Columns > </ asp : GridView > protected   void  Page_Load( object  sender,  EventArgs  e) {      if  (! ...

Create procedure Registerationinsert @email nvarchar(max),@passwaord nvarchar(max) as Begin      Declare @Count int,@regcount int      Select @Count = Count(EmployeeMailID)      from EmployeeDuplicate      where EmployeeMailID = @email      If @Count > 0   select @regcount=count(EmployeeEmail) from AMS_Registration where EmployeeEmail=@email   if @regcount = 0   begin insert into AMS_Registration (EmployeeID,EmployeeEmail,Password,EmployeeName,PhoneNumber,Role) Select EmployeeID, @email,@passwaord,EmployeeName,   EmployeePhoneNumber,EmployeeDesignation from EmployeeDuplicate where EmployeeMailID=@email   end   else if @regcount >0   begin   select 1 as Alreadyregistered   end      Else if @Count = 0           Select 0 as Notvalid End < div   class = "col-md-12" >  ...