In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.
COURSE of the MONTH
12 days, 17 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
tsql check field if is a number from 1 to 40 ??
Posted on 2012-12-24
i have field @message selected from
select @message = message from inserted
select @reqport = reqport from inserted
i want to check if this @message is between 1 to 40
maybe the message contain other word i want to check if it's numeric and if @message is a number from 1 to 40
and i want to add for the first one to check if @reqport is 1234 or 4567 or 7890 and the message between 1 to 40
how i can write this using if (
select @message = message from inserted
select @reqport = reqport from inserted
i want to check if this @message is between 1 to 40
maybe the message contain other word i want to check if it's numeric and if @message is a number from 1 to 40
and i want to add for the first one to check if @reqport is 1234 or 4567 or 7890 and the message between 1 to 40
how i can write this using if (
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
3 Comments
Hi,
IF @message > 1 and @message < 40
BEGIN
//SOME SQL
END
ELSE
//SOME SQL
same goes for @reqport
IF @reqport = 1234 OR @reqport = 4567 OR @reqport = 7890
BEGIN
//SOME SQL
END
ELSE
//SOME SQL
IF @message > 1 and @message < 40
BEGIN
//SOME SQL
END
ELSE
//SOME SQL
same goes for @reqport
IF @reqport = 1234 OR @reqport = 4567 OR @reqport = 7890
BEGIN
//SOME SQL
END
ELSE
//SOME SQL
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on.
…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…
Suggested Courses
Course of the Month12 days, 17 hours left to enroll
777 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.