select * from tableName where CONVERT(varchar,[Timestamp],3) = '17/03/20' //here timestamp your table column name and data type datetime.
Every Question..What does it mean? Why is this? How it works?
Microsoft .Net (pronounced dot (.) net) may be a package element that runs on the Windows software package.
.Net provides tools and libraries that change developers to form Windows package a lot of quicker and easier.
Microsoft describes it as:".Net is that the Microsoft internet Service strategy to attach data, people,
system and devices through software".I'm Choulla Naresh..!
Tuesday, March 17, 2020
How do I create a SQL table under a different schema
how to create a schema and how to apply schema.
CREATE SCHEMA SchemaName;
or go to expand the database and goto security folder then expand and create the schema.
it will create under the schema.
- here if we create any database it will create under dbo.
we want to create under our created schema
create a table and add primary key and auto-increment
then right-click on properties and change schema. that's it njoy...
CREATE SCHEMA SchemaName;
or go to expand the database and goto security folder then expand and create the schema.
it will create under the schema.
- here if we create any database it will create under dbo.
we want to create under our created schema
create a table and add primary key and auto-increment
then right-click on properties and change schema. that's it njoy...
Subscribe to:
Posts (Atom)