By Christian Soutou

Show description

Read Online or Download Apprendre SQL avec MySQL : avec 40 exercices corrigés PDF

Best sql books

Programming Microsoft Infopath: A Developer's Guide (Programming Series)

Create purposes that assemble, procedure, and examine details with InfoPath! InfoPath is likely one of the quickest starting to be items in the Microsoft place of work process. it's a forms-based resolution that streamlines the method of amassing, sharing, and utilizing info through allowing groups and organisations to create, proportion, and paintings with dynamic kinds.

How to Become an Exceptional DBA (2nd Edition)

A second version of Brad McGehee's well known "career advisor" for DBAs, designed to assist new and potential DBAs locate their ft within the career, and to recommend these more-experienced on how they could excel at their jobs, and so turn into unheard of DBAs.

The Definitive Guide to MySQL 5, 3rd Edition

No matter if you are a amateur or intermediate consumer, you'll make the most of large insurance of center MySQL good points like consumer management, easy and complicated querying, and safeguard. additionally, you will be brought to numerous ordinary and third-party instruments, like MySQL Administrator, question Browser, and the preferred PHPMyAdmin instrument.

Additional info for Apprendre SQL avec MySQL : avec 40 exercices corrigés

Sample text

Note the use of the "N" prefix to define the literal strings passed to the procedure as Unicode strings. Unicode is covered in more detail later in this chapter, but it's important to note that sp_executesql requires Unicode strings to be passed into it. That's why @execsql was defined using nvarchar. In this particular case, EXEC() is a better choice than sp_executesql for two reasons: It's not called within a loop or numerous times in succession, and it allows simple string concatenation within its parameter list; sp_executesql, like all stored procedures, doesn't.

000' for both dates, alleviating the possibility of a partial day skewing the results. Determining Time Gaps A common problem with dates is determining the gaps between them, especially when a table of dates or times is involved. Consider the following scenario: Per company policy, employees at a given factory must clock in and out each time they enter or leave the assembly line. The line supervisor wants to know how much time each of her employees spends away from the factory floor. Here's a script that sets up their timecard records: CREATE TABLE timeclock (Employee varchar(30), TimeIn smalldatetime, TimeOut smalldatetime ) INSERT timeclock VALUES('Pythia','07:31:34','12:04:01') INSERT timeclock VALUES('Pythia','12:45:10','17:32:49') INSERT timeclock VALUES('Dionysus','9:31:29','10:46:55') INSERT timeclock VALUES('Dionysus','10:59:32','11:39:12') INSERT timeclock VALUES('Dionysus','13:05:16','14:07:41') INSERT timeclock VALUES('Dionysus','14:11:49','14:57:02') INSERT timeclock VALUES('Dionysus','15:04:12','15:08:38') INSERT timeclock VALUES('Dionysus','15:10:31','16:13:58') INSERT timeclock VALUES('Dionysus','16:18:24','16:58:01') Pythia seems to be a dutiful employee, while Dionysus appears to be playing hooky quite a bit.

Transact-SQL Data Type Nuances aren't supported, nor are data types other than strings. Nevertheless, for certain types of parsing, xp_sscanf can be very handy. Masks Using the PATINDEX() function, you can search string fields and variables using wildcards. ' SELECT PATINDEX('%Kit%',@Song) As used below, PATINDEX() works very similarly to the LIKE predicate of the WHERE clause. The primary difference is that PATINDEX() is more than a simple predicate— it returns the offset of the located pattern as well— LIKE doesn't.

Download PDF sample

Rated 4.18 of 5 – based on 35 votes
Posted in Sql