Insert into agree (AgreeKur,DateAgreeKur,typeUser,username,idPlan) 
  values (Select CONVERT (bit, 'true'), '2016-04-29 11:10:40', 'test', 'test', '166')

SELECT TYPE_NAME(system_type_id)
FROM sys.columns
WHERE name = 'AgreeKur'
    AND [object_id] = OBJECT_ID('dbo.agree')

IF OBJECT_ID(N'tempdb..#T','U') IS NOT NULL DROP TABLE #T;
CREATE TABLE #T(X BIT NULL);
INSERT #T(X) VALUES('TRUE');
SELECT * FROM #T;
IF OBJECT_ID(N'tempdb..#T','U') IS NOT NULL  DROP TABLE #T;

DECLARE @t TABLE (id INT, b BIT)
INSERT INTO @t
VALUES
    (1, CONVERT (BIT, 'TRUE')),
    (2, 'TRUE'),
    (3, 'FALSE')

INSERT INTO @t
VALUES
    (4, 0),
    (5, 1),
    (6, 665) -- = 1

SELECT * FROM @t

IF OBJECT_ID(N'tempdb..#T','U') IS NOT NULL DROP TABLE #T;
CREATE TABLE #T(X BIT NULL);
INSERT #T(X) VALUES('TRUE');
SELECT * FROM #T;
IF OBJECT_ID(N'tempdb..#T','U') IS NOT NULL  DROP TABLE #T;

IF OBJECT_ID(N'tempdb..#T','U') IS NOT NULL DROP TABLE #T;
CREATE TABLE #T(X VARBINARY(1) NULL);
INSERT #T(X) VALUES('TRUE');
SELECT * FROM #T;
IF OBJECT_ID(N'tempdb..#T','U') IS NOT NULL  DROP TABLE #T;