Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

在sql server中编写一个批量,计算1到100的偶数和。(使用while)

  1. User

    在sql server中编写一个批量,计算1到100的偶数和。(使用while)

  2. Assistant

    DECLARE @i INT = 1 DECLARE @sum INT = 0 WHILE @i <= 100 BEGIN IF @i % 2 = 0 SET @sum = @sum + @i SET @i = @i + 1 END SELECT @sum as sum_of_even_numbers

  3. User

    在sql server中编写一个批量,针对Toys表,如果价格大于25元的玩具数量在10种之上,则打印下列消息‘Maybe the price of toys on globaltoyz is not cheap ’,否则,打印消息‘You can search something on globaltoyz’。(使用IF…ELSE语句)

  4. Assistant

    IF (SELECT COUNT(*) FROM Toys WHERE Price > 25) > 10 PRINT 'Maybe the price of toys on globaltoyz is not cheap' ELSE PRINT 'You can search something on globaltoyz'

  5. User

    在sql server中使用简单的CASE语句,对于Shopper表,查询代码为‘000020’的详细情况,根据该用户所使用的信用卡信息打印不同的信息,如果其使用的是 ‘Master Card’,打印消息‘Great priority’,如果使用的是 ‘Visa Card’,打印消息 ‘Potential’,否则答应消息 ‘Normal’。

  6. Assistant

    SELECT CASE CreditCardType WHEN 'Master Card' THEN 'Great priority' WHEN 'Visa Card' THEN 'Potential' ELSE 'Normal' END AS CreditCardInformation FROM Shopper WHERE Code = '000020'