USE NSMC53
GO
BEGIN
SET NOCOUNT ON
DECLARE @Int INT
DECLARE @Mod INT
DECLARE @Div INT
DECLARE @BinString nvarchar(max) --二进制字符串
SET @Int=1000 --十进制数
WHILE @Int>0
BEGIN
SET @Div=@Int/2
SET @Mod=@Int%2
SET @BinString=ISNULL(@BinString,'')+CAST(@Mod AS nvarchar(32))
SET @Int=@Int/2
END
select REVERSE(@BinString)
END