sql Statement to Insert rows into a table, where a specific word could not included

Question

0.00/5 (No votes)

See more:

SQL-server-2000

SQL-Server-2005

, +

When i insert rows into a table, particular column could not allow particular word or Amount.

Example,i have a table called Student_Master(Name, Age,Department), where a Age must have greater than 18 to be included in the table Otherwise it could not insert..

How can i write this in insert queries..

Thanks in Advance......

Posted 11-Jun-13 5:22am

MichealRay

Updated 11-Jun-13 6:17am

v2

Add a Solution

Comments

Richard C Bishop 11-Jun-13 11:23am

So just add an expression to your where clause that checks the age. What is the problem?

gvprabu 11-Jun-13 11:36am

I think U need to Check before Insert right

CHill60 11-Jun-13 11:37am

Where are you getting the data from to insert? What does your insert statement currently look like?

gvprabu 11-Jun-13 11:39am

See Y Department master table having Age, Name ? simply Don't ask like this question in Code Project and don't waste out time.

gvprabu 11-Jun-13 11:40am

before insert, U have to create TRIGGER and check the values or CHECK Constraint you have to create for your table then u have to check the values.

MichealRay 11-Jun-13 12:19pm

gvprabhu No thanks i got correct answer from OriginalGriff...Thank you for wasting time sorry spending time with my Qusetion...god bless u...

gvprabu 12-Jun-13 4:29am

Its ok, always welcome. If your Question is more clear. then it will help us to give proper answer.

CHill60 11-Jun-13 12:19pm

If you still have this problem after trying OriginalGriff's solution then try using the Have a question or comment link under his solution.

MichealRay 11-Jun-13 12:24pm

Sure.. Thank u for ur kind information...

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)

OriginalGriff · Accepted Answer · 2013-06-11T05:41:00

It's not a good idea to do this as part of your INSERT query - it's too easy to have it repeated in multiple places in your code and make a mistake, or miss one if the cut-off age changes to 21 say.

Instead, this would probably be best handled by using a stored procedure on the database to check or insert:

SQL

CREATE PROCEDURE InsertWithAgeCheck 
	@PName VARCHAR(100),
	@Age int,
	@Dept VARCHAR(100) 
AS
BEGIN
IF (@Age < 18) 
   RAISERROR('Too Young',18, 1)
ELSE
   INSERT INTO MyTable ([Name], [Dept], [Age]) VALUES (@PName, @Dept, @Age)
END
GO