SQL

Most Viewed first Recent First
4961 2
Relational Algebra and Relational Calculus

I am new to Database systems and I don't really have the best lecturer and we are learning about Relational algebra and relational calculus, not many videos or help online. 

Please can someone assist me with this topic as i would like to get further knowledge 

...
Type
Question
4944 4
SUM and JOIN 2 columns with different tables but it duplicates results

Trying to SUM and JOIN 2 columns with different tables but it duplicates results, here is my query

...
Type
Question
4934 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
4912 0
Import data from Excel to SQL Server
In this article, I have provided step by step procedure to import excel in SQL Server database using SSMS or using SQL Query.
Type
Article
4772 0
Download and Install SQL Server Management Studio (Step by Step)
In this article, I have mentioned how you can download and install SQL Server management studio (SSMS) in your local pc and how to use SSMS.
Type
Article

4706 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
4703 0
Free SQL Server Reporting Tools
In this article, I have provided list of free SQL server reporting tools with their features, so you can easily which sql server reporting tool will be good for your company.
Type
Article
4538 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
4458 0
Change theme in SQL Server Management Studio (SSMS, Dark Mode)
In this article, I have mentioned how we can change SQL Server Management Studio (ssms) to dark mode theme, with little changes.
Type
Article
4449 0
Convert Int To String (varchar) in SQL Server
In this article, I have mentioned how we can convert Int to string (varchar) in SQL Server using examples
Type
Article

Page 7 of 11