Insert Data Dynamically in SQL Server

-
    In this tutorial see about SQL Server insert Data Dynamically.

create a table  tbl_name
     create table tbl_name(id int identity primary key,name nvarchar(20),age int)




declare @ID as int
set @ID=1
while(@ID<=5)
begin
insert into tbl_name values('name'+ CAST(@ID as nvarchar(20)),@ID)
print @ID
set @ID=@ID+1
end

 Output:

Comments

Post a Comment

Thank You for your Comment

Popular posts from this blog

Display Canvasjs Line Chart using Data from Database

-
Image
Aspx Page: <% @ Page Language ="C#" AutoEventWireup ="true" CodeBehind ="Canvasjs.aspx.cs" Inherits ="BloggerCont.Canvasjs" %> < html xmlns ="http://www.w3.org/1999/xhtml"> < head runat ="server">     < script src ="jquery-1.7.1.js" type ="text/javascript"></ script >     < script src ="canvasjs.min.js" type ="text/javascript"></ script >     < script type ="text/javascript">         $(document).ready( function () {             Disp();         });         function Disp() {             var dataPts = [];             var var1;         ...
Read more

What are the SOLID principles, and why are they important

-
 The SOLID principles are a set of five design principles in object-oriented programming that help developers create more understandable, flexible, and maintainable software. These principles were introduced by Robert C. Martin, also known as Uncle Bob. They are: Single Responsibility Principle (SRP) Open/Closed Principle (OCP) Liskov Substitution Principle (LSP) Interface Segregation Principle (ISP) Dependency Inversion Principle (DIP) 1. Single Responsibility Principle (SRP) A class should have only one reason to change, meaning it should have only one job or responsibility. Importance: Promotes cohesive functionality. Simplifies debugging and testing. Makes the system more understandable and reduces the risk of changes affecting unrelated functionalities. 2. Open/Closed Principle (OCP) Software entities (classes, modules, functions, etc.) should be open for extension but closed for modification. Importance: Encourages code reuse and flexibility. Reduces the risk of introducing b...
Read more

Write Text in Notepad files Using Asp.net

-
                In asp.net Provide many Supporting Classes and Objects files. To write Text or data in Notepad Files Using Your Asp.net and windows Applications. Using StreamWriter Class to write a Text files in Notepad.    Using Class file  using  System.IO  and point to the Text files and open the text files. StreamWriter  streamwriter; streamwriter=  new   StreamWriter ( File .Open(Server.MapPath( "~/sample.txt" ),  FileMode .OpenOrCreate));         streamwriter.WriteLine( " ******************************** " );         streamwriter.WriteLine( "         Heading    " );   streamwriter.WriteLine( "          ***************        " );   ...
Read more