Problem 3. Town Names Starting With

nadejda91iv 11 Точки

Здравейте, може ли помощ по тази, понеже ми дава с моя код 20/100 .

Благодаря предварително!

CREATE PROCEDURE usp_GetTownsStartingWith (@townName VARCHAR (50))
AS
BEGIN
SELECT [Name] FROM Towns
WHERE LEFT ([Name],1) IN ('B')
END

задачата:

Write a stored procedure usp_GetTownsStartingWith that accept string as parameter and returns all town names starting with that string.

Example

Here is the list of all towns starting with “b”.

Town

Bellevue

Bothell

Bordeaux

Berlin

Тагове:

18/06/2020 15:55:14 Databases Basics

Bobby_Apostolov 128 Точки

Best Answer

Здравей, уловката е в условието, търси се стринг, а не само една буква :)

CREATE PROC usp_GetTownsStartingWith(@searchedString NVARCHAR(50))

BEGIN

DECLARE @stringCount int = LEN(@searchedString)

SELECT [Name] FROM Towns

WHERE LEFT([Name],@stringCount) = @searchedString

END

18/06/2020 16:18:07 18/06/2020 16:19:36

nadejda91iv 11 Точки

Благодаря ти много :)

19/06/2020 16:34:09