Aqua Data Studio 14.0.0-rc-27 Database-MS SQL Server 7.0
Please go through following steps:
A)Create Table:
1)Connect to "MS SQL Server 7.0"->Go to Databases->Right click on "User Tables" object folder->Select "Create Table" option->New create table dialog is opened.
2)I have created Table as follows:
"CREATE TABLE [Ashwini_schema].[third_data_type]
( [c1] nchar(25) NULL,
[c2] ntext NULL,
[c3] numeric(15,5) NULL,
[c4] nvarchar(25) NULL,
[c5] real NULL,
[c6] smalldatetime NULL,
[c7] smallint NULL,
[c8] smallmoney NULL,
[c9] uniqueidentifier NULL)
ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] WITH (DATA_COMPRESSION = NONE)"
Table is created.In table "c6" column having "smalldatetime" datatype.
3)I have inserted some records in table.
4)Right click on table("third_data_type")->Select "Edit Table Data(Top 1000)"->Edit table data window is opened.
5)In Table Data Tab go to search icon & click on it->Drop down list is pop up->Checked on "c6" column->Enter Date & time string in text box->No any result is display for entered string.