how to write stored procedure for getting one of the column in the table in sequence order

Question

0.00/5 (No votes)

See more:

sir

C++

 i have one table name Register.It contains  three columns
userid 
Firstname 
lastname 

in my front end design i create
two textboxes and one submit button.

My requirement is when iam entering submit button firstname and lastname getvalues from textbox1 and textbox2 but  userid coloumn will get values automatically like that userid0001
                                                userid0002
                                                userid0003
                                                     :
                                                     :
                                                     :
for how many times we click submit button that much of time we get increment in the userid coloumn.
Pls help me

Posted 24-May-11 19:54pm

kranthi.oru

Updated 24-May-11 20:19pm

v2

Add a Solution

Comments

Ashishmau 25-May-11 1:55am

Need more clarification

kranthi.oru 25-May-11 2:06am

my requirement is i have one table name Register.It contains columns
userid Firstname lastname in my front end design i create
two textboxes and one submit button.

My requirement is when iam entering submit button firstname and lastname getvalues from textbox1 and textbox2 but userid coloumn will get values automatically like that userid0001
userid0002
userid0003

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)

Liju Sankar · Answer 1 · 2011-05-24T20:15:00

Hi Kranthi,
I really don't understand your exact requirement!
Do you mean concatenate column name with its value? or concatenate values of 3 columns together for each row?

To concatenate the values of 3 columns together

SQL

DECLARE @tmpTable TABLE (userID VARCHAR(10), Name VARCHAR(10))
INSERT INTO @tmpTable VALUES ('ID1','NAME1')
INSERT INTO @tmpTable VALUES ('ID2','NAME2')

SELECT  userID + Name FROM @tmpTable

Ashishmau · Answer 2 · 2011-05-24T20:17:00

Solution 2

As far as i Understood,
U want autogenerate ID for a particular user.
For that u can use IDENTITY in your database.
While showing in front end, u can Concatenate ur ID like
userid+(id from database).

Posted 24-May-11 20:17pm

Ashishmau

Sander Rossel · Answer 3 · 2011-05-24T20:19:00

I think you mean you want to order the values in a specific column.
Your qeury should look something like this:

SQL

SELECT userid, firstname, lastname FROM mytable ORDER BY userid ASC --ending

You could also ORDER BY another column or ORDER BY userid DESC(ending)
Maybe you are using LINQ? That has an Order By Asc/Desc too.

I hope this is what you wanted to know. Good luck :)

how to write stored procedure for getting one of the column in the table in sequence order

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0