USE library
SELECT
LOWER(firstname + middleinitial + SUBSTRING(lastname, 1, 2))
AS email_name
FROM member
WHERE lastname = 'anderson'
GO
请问middleinitial 是怎么个用法?我查了联机丛书没有找到。请高手赐教。谢谢!
...全文
264打赏收藏
sql server 2000的问题
sql server 2000中 USE library SELECT LOWER(firstname + middleinitial + SUBSTRING(lastname, 1, 2)) AS email_name FROM member WHERE lastname = 'anderson' GO 请问middleinitial 是怎么个用法?我查了联机丛书没有找到。请高手赐教。谢谢!