2105 2
How to access the substring from the string in sql?

I need to access substring from a string using SQL, how can i achieve it in SQL server?

Suppose my string in "Hello World in C" and i want "World" from it, how can i do that using SQL query?

...
Type
Question
2071 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
2066 0
Get month and year in sql server from date
In this article, I have mentioned how we can get month and year in sql server from datetime or date value.
Type
Article
1998 0
Import an SQL file in MySQL (Using CMD or Powershell)
In this article, I mentioned how we can Import an SQL file in MySQL (Using CMD or Powershell or using MySQL Workbench) easily and quickly.
Type
Article
1976 2
Can i have example of declare table and temp table in sql ? and how the update operation can be used on it ?

Can i have example of declare table and temp table in sql ? and how the update operation can be used on it with real life scenario ?

 

...
Type
Question

1917 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
1873 0
Microsoft SQL Server Versions List
In this article, I have mentioned about all the versions of Microsoft SQL Server, so you can decide which is good one for you.
Type
Article
1870 0
TRIM(), LTRIM(), RTRIM() Functions in SQL Server
In this article, I have discussed about SQL Server TRIM(), LTRIM(), RTRIM() Functions in SQL Server with example
Type
Article
1795 0
SQL Server Management Studio (SSMS) Alternatives (Mac, Windows, Linux)
In this article, I have mentioned SQL Server management studio (SSMS) alternatives for windows, mac and Linux, which you can try to use.
Type
Article
1782 0
Best SQL Server Tools for SQL Developers.
In this article, we have provided list of best SQL Server Tools (paid or free), which you can use with SQL Server with its features.
Type
Article

Page 8 of 11