256 Kilobytes

All Content > SQL Server

Type All Category All Tag SQL Server

Profile Photo - Some Guy

[SQL Server] Difference between datetime and datetime2?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

Last ReplyDATETIME2 has a date range of "0001 / 01 / 01" through "9999 / 12 / 31" while the DATETIME type only supports year 1753-9999. Also, if you need to,... Univa,

DATETIME2 has a date rang...

Wed, 08 May 2019 08:08:40 -07002 years ago1
🗨 1
🐏 0
👁 487
Profile Photo - Some Guy

How to fix "Operand should contain 1 column(s)"?

Answers in Databases | By Some Guy

Published

Profile Photo - Univa

Last ReplyThis error can occur if you accidentally use commas instead of AND in the ON clause of a JOIN. FOR EXAMPLE: JOIN joined_table ON (joined_table.c... Univa,

This error can occur if y...

Thu, 18 Apr 2019 07:57:10 -07002 years ago1
🗨 1
🐏 0
👁 537
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreIn the database, which should I use for a website on the Information Superhighway, PostgreSQL vs MsSQL / SQL Server database?
🗨 0
🐏 0
👁 390
Profile Photo - Some Guy
Profile Photo - Some Guy

MoreI'm new to Databases having been on the web development side. Have a question for you experts: On a SQL Server, what is the difference between a...
🗨 0
🐏 0
👁 420
Profile Photo - Some Guy

Fix "Insert statement conflicted with foreign key constraint"?

Answers in Databases | By Some Guy

Published

Profile Photo - Some Guy

I'm using MySQL to manage data on a...

MoreI'm using MySQL to manage data on an SQL server I have, and it's been giving me this error that says the insert statement conflicted with th...
🗨 0
🐏 0
👁 339