Can not insert data

The problem is basically that you have no idea what you're doing, and you don't even know enough about programming to know that we need to see code in order to tell you what you did wrong.

The other obvious issue is that your inability to write code, does not constitute and urgent problem for us. If you're sufficiently incapable of basic research to require our help on a problem like this, then you need to accept that you have to wait until we feel like giving you free help, we don't owe you anything.

first provide your query, then ask for help. As there is no clue about the problem.

CREATE TABLE [dbo].[Module](
    [ModuleID] [nchar](2) NOT NULL,
    [ModuleName] [nvarchar](50) NOT NULL,
    [ModuleDescription] [ntext] NULL,
    [SetDate] [datetime] NULL,
    [UserName] [nvarchar](20) NULL,
 CONSTRAINT [PK_Wing] PRIMARY KEY CLUSTERED
(
    [ModuleID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

DROP TABLE userlist

CREATE TABLE [dbo].[UserList](
    [UsrUserID] [varchar](20) NOT NULL,
    [UsrName] [varchar](35) NULL,
    [UsrPassword] [varchar](500) NOT NULL,
    [UsrModuleID] [varchar](50) NOT NULL,
    [UsrEnabledYN] [bit] NOT NULL,
    [UsrRemarks] [text] NULL,
    [UsrCreateDate] [datetime] NULL,
    [SetDate] [datetime] NOT NULL,
    [UserName] [varchar](20) NULL,
    [PwdChangedYN] [bit] NOT NULL,
    [UsrPIN] [varchar](8) NULL,
    [usrClassID] [tinyint] NOT NULL,
 CONSTRAINT [PK_UserList] PRIMARY KEY NONCLUSTERED
(
    [UsrUserID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[UserList] ADD  CONSTRAINT [DF_UserList_UsrEnabledYN]  DEFAULT ((1)) FOR [UsrEnabledYN]
GO

ALTER TABLE [dbo].[UserList] ADD  CONSTRAINT [DF_UserList_SetDate]  DEFAULT (getdate()) FOR [SetDate]
GO

ALTER TABLE [dbo].[UserList] ADD  CONSTRAINT [DF_UserList_PasswordChangedYN]  DEFAULT ((0)) FOR [PwdChangedYN]