sql-server Archives - Page 7 of 39

SELECT logcount, logUserID, maxlogtm , DATEDIFF(day, maxlogtm, GETDATE()) AS daysdiff FROM statslogsummary WHERE daysdiff > 120 I get “invalid column name daysdiff”. Maxlogtm ...

May 28, 2022
0 Comments

Programming, sql-server

IT Nursery

SQL Server Index Naming Conventions [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 28, 2022
0 Comments

Programming, sql

IT Nursery

Set database from SINGLE USER mode to MULTI USER

I need help with setting a database that was restored in SINGLE_USER mode to MULTI_USER. Every time I run ALTER DATABASE BARDABARD SET ...

May 28, 2022
0 Comments

Programming, sql

IT Nursery

What is best tool to compare two SQL Server databases (schema and data)? [duplicate]

This question already has answers here: What is a free tool to compare two SQL Server Databases? [closed] (7 answers) Closed 2 years ...

May 28, 2022
0 Comments

Programming, sql

IT Nursery

How to drop SQL default constraint without knowing its name?

In Microsoft SQL Server, I know the query to check if a default constraint exists for a column and drop a default constraint ...

May 28, 2022
0 Comments

Programming, sql-server

IT Nursery

Hidden Features of SQL Server

Locked. This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting new ...

May 28, 2022
0 Comments

Programming, tsql

IT Nursery

Getting the minimum of two values in SQL

I have two variables, one is called PaidThisMonth, and the other is called OwedPast. They are both results of some subqueries in SQL. ...

May 28, 2022
0 Comments