How Can create procedure with loop insert

Question

1.44/5 (3 votes)

See more:

I need procedure to Insert many Number In Table
I need To Use In C#
Like This:

SQL

DECLARE 
@count INT,
@num int 
SET @count = 0155460000
SET @num = 15546
WHILE (@count <=  155462000)
BEGIN
   INSERT INTO TestCodeTBL (CodeNumbber,CodeWithSerial) VALUES (@count, @num) 
   SET @count = (@count + 1 )  
END

How Can Use This Code In Windows Form
I need To Pass Tow Parameter
1-@count
2-@num

Posted 14-Oct-15 2:22am

Member 11280947

Updated 26-Feb-20 23:01pm

Tomas Takac

v2

Add a Solution

Comments

Tomas Takac 14-Oct-15 9:26am

A Beginner's Tutorial for Understanding ADO.NET[^]

Thava Rajan 14-Oct-15 9:41am

what is wrong with that sql statement?
why did you go to the front end?
what is the real issue to you?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Palash Mondal_ · Answer 1 · 2015-10-14T03:58:00

Just to help you getting started, here is the sproc:

SQL

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE AddTestCodeTBL
    @count INT,
    @num INT
AS
BEGIN

    SET NOCOUNT ON;

    WHILE (@count <=  155462000)
    BEGIN
        INSERT INTO TestCodeTBL (CodeNumbber,CodeWithSerial) 
        VALUES (@count, @num) 
        
        SET @count = (@count + 1 )  
    END

END
GO

Refer: How To Write a Stored Procedure in SQL Server[^]

Naveen.Sanagasetti · Answer 2 · 2015-10-14T04:42:00

Solution 3

Using Do while you can achieve looping concept in SQL; Refer below link for more details how to implement While loop in SQL Server While Loop in SQL Server[^]

Posted 14-Oct-15 4:42am

Naveen.Sanagasetti

Kornfeld Eliyahu Peter · Answer 3 · 2015-10-14T03:44:00

Solution 1

Learn how to create a stored procedure here: https://msdn.microsoft.com/en-us/library/ms345415.aspx[^]
Than learn how to call such stored procedure from C# (ADO.NET) here: http://www.c-sharpcorner.com/UploadFile/gtomar/storedprocedure12052007003126AM/storedprocedure.aspx[^]

Posted 14-Oct-15 3:44am

Kornfeld Eliyahu Peter