1 / 7
銆愪緥
5.1
銆?/p>
鍒涘缓灞�閮ㄥ彉閲?/p>
@var1
銆?/p>
@var2
骞惰祴鍊硷紝鐒跺悗杈撳嚭鍙橀噺鐨勫�笺�?/p>
鏂板缓涓�涓煡璇紝鍦?/p>
鈥?/p>
鏌ヨ鍒嗘瀽鍣?/p>
鈥?/p>
绐楀彛杈撳叆骞舵墽琛屽涓嬭剼鏈細
DECLARE @var1 char(10) ,@var2 char(30)
SET
@var1='
涓浗
'
/*
涓�涓?/p>
SET
璇彞鍙兘缁欎竴涓彉閲忚祴鍊?/p>
*/
SET
@var2=@var1+'
鏄竴涓紵澶х殑鍥藉
'
SELECT @var1, @var2
GO
銆愪緥
5.2
銆?/p>
鍒涘缓涓�涓悕涓?/p>
sex
鐨勫眬閮ㄥ彉閲忥紝
骞跺湪
SELECT
璇彞涓娇鐢ㄨ灞�閮ㄥ彉閲忔煡鎵捐〃
XSB
涓墍鏈夊コ鍚屽鐨勫鍙枫�佸鍚嶃�?/p>
USE PXSCJ
GO
DECLARE @sex bit
SET @sex=0
SELECT
瀛﹀彿
,
濮撳悕
FROM
XSB
WHERE
鎬у埆
=@sex
銆愪緥
5.3
銆?/p>
浣跨敤鏌ヨ缁欏彉閲忚祴鍊笺�?/p>
DECLARE @student char(8)
SET @student=(SELECT
濮撳悕
FROM XSB WHERE
瀛﹀彿
= '081101')
SELECT @student
銆愪緥
5.4
銆?/p>
浣跨敤
SELECT
缁欏眬閮ㄥ彉閲忚祴鍊笺�?/p>
DECLARE @var1 nvarchar(30)
SELECT @var1 ='
鍒樹赴
'
SELECT
@var1 AS 'NAME'
銆愪緥
5.5
銆?/p>
缁欏眬閮ㄥ彉閲忚祴绌哄�笺�?/p>
DECLARE @var1 nvarchar(30)
SELECT @var1 = '
鍒樹赴
'
SELECT @var1 =
(
SELECT
濮撳悕
FROM XSB
WHERE
瀛﹀彿
= '089999'
)
SELECT @var1 AS
'NAME'
銆愪緥
5.6
銆?/p>
浣跨敤娓告爣鍙橀噺銆?/p>
USE PXSCJ
GO