loster_Li的博客

1）转换为实际内容select convert(varchar(10),0xCED2CAC7C8CB)/*我是人*/2)转换为实际内容的十六进制字符串--方式2CREATE FUNCTION Binary2HexStr(@bin VARBINARY(8000))RETURNS VARCHAR(8000)ASBEGIN DECLARE @re VARCHAR(8000),@i ...

select * from(select row_number()over(order by (select 1))rn,* from tb)t where rn=2

DECLARE cursor_fruit CURSOR FOR --创建游标SELECT cs_id,cs_name FROM Base_Customer;OPEN cursor_fruit --打开游标    DECLARE @cs_id varchar(50)    DECLARE @cs_name varchar(50)        FETCH NEXT FROM curs...