Posts Tagged ‘ms-sql’

SQL – Filtering WHERE condition on two rows

iStock_000005792139Medium I received the following question a couple of days ago from a programmer using the “Ask  a Question” form which you can access from the menu of this blog:

Given the following table:

Name Language
Nikhil Hindi
Nikhil English
Kisu Hindi
Kisu English
Rakesh Hindi
Kousik Bangali

How do I select names of persons who know both Hindi and English?

In this table, that query should return Nikhil and Kisu.

Read the rest of this entry »

Other Related Items:

Wilson Jones 362 Line Basic Round Ring View Binder, 3-Inch Capacity, 8.5 x 11 Inch Sheet Size, White (W362-49W)Wilson Jones 362 Line Basic Round Ring View Binder, 3-Inch Capacity, 8.5 x 11 Inch Sheet Size, White (W362-49W)Looks good on the shelf or on the go. Customize for filing or presentations with a non-glare overlay on the spine and front and back covers. Use the round ring open and close triggers for easy access. Take advantage of interior pockets for extra storage.
Microsoft SQL Server 2000 High AvailabilityMicrosoft SQL Server 2000 High AvailabilitySQL SVR 2000 HIGH AVAILABILITY

Random in SQL – SQL For Programmers

IMG_1382 Last week I had an interesting assignment: Given a specific record, randomly retrieve three related records from the database.

Naturally, as a programmer, I started looking for the SQL random function.  Which I found.

But even as I was searching for how to use that function, I was thinking to myself, “How am I going to structure things in such a way so as to randomly select the records once I have the function?  It isn’t like I can retrieve the records into an array and then select them out.  Am I going to have to retrieve them into a temp table?”

Read the rest of this entry »

Other Related Items:

SQL Server 2008, Developer EditionSQL Server 2008, Developer EditionSQL Svr Developer Edtn 2008 En
1Pk Oem Sql Svr 08 Std Small Bus 5 Dev Cal Only1Pk Oem Sql Svr 08 Std Small Bus 5 Dev Cal OnlyThis edition of SQL Server is an entry level edition that is intended for use in small single-server office environments with a small user base. SQL Server Standard for Small Business provides the capabilities of SQL Server Standard Edition.

SQL WHILE – SQL For Programmers

The IF statement we looked at on Tuesday was pretty tame compared to the WHILE construct.

Actually, the main thing you need to keep in mind is that WHILE is all you have.  There is no such thing as a FOR loop or a DO WHILE loop.  So, you have to force WHILE to do those for you.

The basic syntax of WHILE looks like this:

Read the rest of this entry »

Other Related Items:

Fright NightFright NightA TEENAGE ENLISTS THE HELP OF A TV HORROR MOVIE HOST TO SUBDUE A SUAVE VAMPIRE IN THIS CLASSIC. SPECIAL FEATURES: FULL SCREEN AND WIDESCREEN VERSIONS, DOLBY SURROUND SOUND, SUBTITLES: ENGLISH, SPANISH, FRENCH, PORTUGESE, CHINESE, KOREAN, AND THAI, AND THEATRICAL TRAILER.
The Complete Adult Psychotherapy Treatment Planner (PracticePlanners?)The Complete Adult Psychotherapy Treatment Planner (PracticePlanners?)The Complete Adult Psychotherapy Treatment Planner, Fourth Edition provides all the elements necessary to quickly and easily develop formal treatment ... Read More >
Microsoft SQL Server 2000 Administrator's Pocket Consultant (It-Administrator's Pocket Consultant)Microsoft SQL Server 2000 Administrator's Pocket Consultant (It-Administrator's Pocket Consultant)If specialization is for insects, those of us who have only two legs are bound to need reminders when we sit down to perform a specialized task. For... Read More >

Basic SQL Commands – SQL For Programmers

Before we get into the specifics of the commands that can be used within a stored procedure, I think it would be helpful to review some of the more basic commands that we can use that don’t really need a whole lot of discussion.

I know I said I wasn’t going to spend a lot of time on the basics, but my research indicates that a lot of people are searching for basic sql commands and very few sites are addressing that issue specifically.

So, if this is unhelpful to you, just consider this Dave’s SEO experiment.

Read the rest of this entry »

Other Related Items:

Call Bell, 3.5" diam.Call Bell, 3.5" diam.Just like the one in Mel's Diner. Allow your customers to call you when you're busy in the backroom. Call bell emits a clear, clean ring. In stock and ready to ship. Features: Made of nickel plate with black steel case. Specs: Dimensions: 2 1/2" H x 3 1/4" D.
Microsoft SQL Server 2005 Implementation and Maintenance (Exam 70-431)Microsoft SQL Server 2005 Implementation and Maintenance (Exam 70-431)Interactive Instructor-Based Microsoft SQL Server 2005 Implementation and maintenance (Exam 70-431) Video Training Course on DVD-ROM. Computer Based ... Read More >

SQL For Programmers – Stored Procedure Basics

trav-035 Now that we’ve established a reason for using them, let’s continue with the basic syntax of the stored procedure. I think you’ll find that it is not that dissimilar to writing a procedure in any other language. Although, as we move on, I think you’ll find that the syntax we have to use to get anything done is quite cryptic.

Read the rest of this entry »

Other Related Items:

Disney Club Penguin 2'' Mix 'N Match Figure Pack - Court Jester and KingDisney Club Penguin 2'' Mix 'N Match Figure Pack - Court Jester and KingIncludes throneUnlock Items Online with special coin2'' HPlasticAges 5+ImportedCollect all the 2'' Figure Packs for more Mix 'N Match fun, sold separately
5 Piece Safari Animal Print Auto Interior Gift Set - 2 Snow Leopard Front Bucket Seat Covers for Truck and SUV arm rest seats, 1 Snow Leopard Steering Wheel Cover, and 2 Snow Leopard Shoulder Harness Pressure Relief Cover5 Piece Safari Animal Print Auto Interior Gift Set - 2 Snow Leopard Front Bucket Seat Covers for Truck and SUV arm rest seats, 1 Snow Leopard Steering Wheel Cover, and 2 Snow Leopard Shoulder Harness Pressure Relief CoverProduct Description Fun Safari Animal series print seat covers are made from velour to fit both low back and high back seats. Velour is a soft silky v... Read More >
Age of Empires II GoldAge of Empires II GoldMicrosoft Age of Empires II: Gold 2.0 Win32 English North America CD DVD Box Gold
DotNetNuke Sponsor

 

Most Valuable Blogger
Sponsor