sql-server - Read For Learn

DateTime2 vs DateTime in SQL Server

The MSDN documentation for datetime recommends using datetime2. Here is their recommendation: Use the time, date, datetime2 and datetimeoffset data types for new work. These types align with the SQL Standard. They are more portable. time, datetime2 and datetimeoffset provide more seconds precision. datetimeoffset provides time zone support for globally deployed applications. datetime2 has larger date range, a larger default fractional precision, and optional user-specified precision. Also depending on the user-specified … Read more

Find all tables containing column with specified name – MS SQL Server

Is it possible to query for table names which contain columns being ?

Why use a READ UNCOMMITTED isolation level?

This isolation level allows dirty reads. One transaction may see uncommitted changes made by some other transaction. To maintain the highest level of isolation, a DBMS usually acquires locks on data, which may result in a loss of concurrency and a high locking overhead. This isolation level relaxes this property. You may want to check … Read more

How can I delete using INNER JOIN with SQL Server?

You need to specify what table you are deleting from. Here is a version with an alias:

How can I truncate a datetime in SQL Server?

This continues to frequently gather additional votes, even several years later, and so I need to update it for modern versions of Sql Server. For Sql Server 2008 and later, it’s simple: Note that the last three paragraphs near the bottom still apply, and you often need to take a step back and find a … Read more

DateTime2 vs DateTime in SQL Server

Find all tables containing column with specified name – MS SQL Server

Why use a READ UNCOMMITTED isolation level?

How can I delete using INNER JOIN with SQL Server?

How can I truncate a datetime in SQL Server?

Keeping it simple and how to do multiple CTE in a query

Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint

Conversion failed when converting from a character string to uniqueidentifier – Two GUIDs

Check if table exists in SQL Server

How to find sum of multiple columns in a table in SQL Server 2005?