86 View
Nov 16 2020 5:45PM
I have a database column containing an integer value that represents a systems up time in seconds. I'd really like a query to be able to show me that up time in a easy to read format day(s) hour(s) minute(s) but I'm not quite sure how to do it. A lot of examples I've found appear to use parameters as an example but never much of how to use it in a select function.
Read More..
|
|
71 View
Nov 16 2020 5:38PM
I have a database column containing an integer value that represents a systems up time in seconds. I'd really like a query to be able to show me that up time in a easy to read format day(s) hour(s) minute(s) but I'm not quite sure how to do it. A lot of examples I've found appear to use parameters as an example but never much of how to use it in a select function.
Read More..
|
|
96 View
Nov 3 2020 12:10PM
How to solve?
error: Operand type clash: table type is incompatible with nvarchar(500)
Read More..
|
|
92 View
Nov 3 2020 11:39AM
I want to give an array of identifiers as argument to a stored procedure.
I got the error :
Operand type clash: int is incompatible with (TableName)
Read More..
|
|
794 View
Mar 4 2020 2:43PM
In this article, we found out about How to know whether index fragmentation has occurred or not?
Read More..
|
|
231 View
Mar 4 2020 1:38PM
Below are steps to shrink the database log file
1. Take the backup of TestDB database
2. Run below query to get logical log file name
Read More..
|
|
434 View
Feb 17 2020 5:42PM
Error : arithmetic overflow error converting expression to data type int.
Read More..
|
|
362 View
Feb 8 2020 2:32PM
Need to change only the year part of every ChangedDate Column to 2017. i.e
Read More..
|
|
351 View
Jan 30 2020 11:30PM
In this article, we found out about Constraints in SQL.
Read More..
|
|
1301 View
Jan 30 2020 11:29PM
In this article, we found out about SORTING in SQL.
Read More..
|