SQL Server???????????????????????
???????????? ???????[ 2012/12/19 9:46:09 ] ????????
???????????????????£????????????????????????????μ????????????????У?Person.Person ???LastName????nvarchar???????????????????????????????洢?????????????varchar?????
alter procedure dbo.PrecedenceTest(
@LastName varchar(50)
)
as
begin
set nocount on
select *
from Person.Person
where LastName = @LastName
end
go
exec dbo.PrecedenceTest 'Tamburello'
go
??????м?????????????????????????????
??????Index Seek???????????????????LastName????????????????????????????????????????nvarchar?????
???????????в????????????????????????????????????м????
????????????????ó????????洢?????ж??????????????????????е?????????????е???????????????????????????????????????????
???????????????????????????????
????1??user-defined data types (highest)
????2??sql_variant
????3??xml
????4??datetimeoffset
????5??datetime2
????6??datetime
????7??smalldatetime
????8??date
????9??time
????10??float
????11??real
????12??decimal
????13??money
????14??smallmoney
????15??bigint
????16??int
????17??smallint
????18??tinyint
????19??bit
????20??ntext
????21??text
????22??image
????23??timestamp
????24??uniqueidentifier
????25??nvarchar (including nvarchar(max) )
????26??nchar
????27??varchar (including varchar(max) )
????28??char
????29??varbinary (including varbinary(max) )
????30??binary (lowest)
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11