1070 2
How to convert nvarchar column to datetime in SQL Server?

Hello, I am using nvarchar column to store datetime as string, but I would like to convert this column from nvarchar into datetime in sql server. How can I do it.

Current time format is '2019-01-29 14:55:50'

...
Type
Question
1161 1
What is SQL Query to get dates between two dates?

Hello, I have one more question related to SQL query, in which I would like to know how can I get all dates between two dates using SQL Query. For example, I have start date = 10/02/2022 and end date = 14/02/2022, then query must return dates 11/02/2022, 12/02/2022 and 13/02/2022.

I am using SQL Server for this, but I think SQL query will remain the same for oracle or MySQL too.

...
Type
Question
683 2
How to check if Columns exits in SQL Server table?

Hello, I am still learning SQL and SQL Server, so I would like to know how can I verify or check if a column exists in the database table using SQL Query in SQL Server?

...
Type
Question
603 0
Difference between SQL and NoSQL (SQL vs NoSQL)
In this article, I have provided details of what is difference between SQL and NoSQL or you can say providing details of SQL vs NoSQL.
Type
Article
1866 0
SQL Comments (Comment in SQL Query)
In this article, I have provided example to add comment in SQL Query for SQL Server, MySQL, SQL Comment in Postgres
Type
Article

1461 1
Query to get all database name in SQL Server?

I am looking at this article Query in Sql server to list all stored procedures in all databases which give all stored procedures name in all database, so I would like to know SQL query to list all databases of an SQL Instance. As I would be allowing users to show list of databases in Front-end, to select and then get all stored procedures of the database.

...
Type
Question
2183 2
Check if table exists then delete it in SQL Server

I am checking this article, which allow you to drop all tables of SQL Server database, but I just want to delete a specific table of the database, so how can I do it?

to check if table exists then drop it completely from the database, without risking any other DB table in SQL Server.

...
Type
Question
2686 1
Error "Connection was established with server but error occurred during login process" SSMS

When I am trying to login into my local database server using SQL server management studio, I am getting an error, as shown below

A connection was successfully established with the server, but then an error occurred during the login process. 
(provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) 

...

Type
Question
1435 1
What is database management system and it's types
In this article, I have explained what is a database management system with its advantages and types of database management system.
Type
Article
2577 1
How to enable full text search on SQL Server database?

I have already created SQL Server database, but when I am trying to run a query that requires full-text search enabled database, it is not working and throwing error

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblLocation' because it is not full-text indexed.

So, how can I enable full-text index to remove above error?

...
Type
Question

Page 5 of 10