How to identify end of rows/recodrs in a table

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi All,

It will we helpful if some could assist me resolving the issue. I've a following table and I want to know if there are no more rows in the table.

Table Name: Test

Name LastName
----- -------
Gena | Marry
Sam | Scott
April | Jones

The actual problem is, I want to insert a new record if and only if 'LastName' is not repeated in the column. (i.e. If LastName is Scott then there should be no new record inserted and /or LastName is Rio then only new record should be inserted.

Please assist.

Posted 20-Sep-14 18:24pm

aniruddhajagdale

Add a Solution

1 solution

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)

ChauhanAjay · Answer 1 · 2014-09-20T18:47:00

The follow are the steps for what you want to achieve

1. Write a small stored procedure where you pass all the values to be inserted in the table.
2. Check count of lastname which matches with the lastname you have passed.
3. if count is 0 the insert the record

if you dont understand what I am trying to say then check the code below

SQL

create procedure CheckCountOfLastName(@name varchar(20), @lastname varchar(20))
as
	declare @count numeric
	select @count = count(lastname) from yourtablename where lastname=@lastname
	if (@count = 0)
	begin
		insert into yourtablename(name, lastname) values(@name, @lastname)
	end

Hope it helps