r1d3rzz

if ("geolocation" in navigator) {
  // Geolocation is supported
  navigator.geolocation.getCurrentPosition(
    (position) => {
      // Success callback
      const latitude = position.coords.latitude;
      const longitude = position.coords.longitude;
      console.log(`Latitude: ${latitude}, Longitude: ${longitude}`);
    },
    (error) => {

r1d3rzz

ALTER DATABASE test SET TRUSTWORTHY ON;
GO


SELECT 
	'CREATE INDEX ' + ix.name + ' ON ' + t.name + '(' + CAST(STRING_AGG(c.name, ', ') AS VARCHAR(MAX)) + ');' AS create_index_statement
FROM 
    sys.indexes ix
JOIN 
    sys.tables t ON ix.object_id = t.object_id

r1d3rzz

It looks like the `--use-database-names` option isn't being recognized in your `Scaffold-DbContext` command. This issue can sometimes occur due to the version of Entity Framework Core tools you're using or how the command is structured.

Here are a few steps to troubleshoot and resolve this:

1. **Ensure you have the latest version of EF Core tools**:
   ```powershell
   dotnet tool update --global dotnet-ef
   ```

2. **Use the `dotnet ef` CLI command instead of the Package Manager Console**:

r1d3rzz

SELECT
    s.Name AS SchemaName,
    t.Name AS TableName,
    p.rows AS NumRows,
    CAST(ROUND((SUM(a.total_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Total_MB,
    CAST(ROUND((SUM(a.used_pages) / 128.00), 2) AS NUMERIC(36, 2)) AS Used_MB,
    CAST(ROUND((SUM(a.total_pages) - SUM(a.used_pages)) / 128.00, 2) AS NUMERIC(36, 2)) AS Unused_MB
FROM
    sys.tables t
    JOIN sys.indexes i ON t.OBJECT_ID = i.object_id

r1d3rzz

PRINCIPAL_AMOUNT*(INTEREST_RATE/100)/INT_BASIS*TERM

r1d3rzz

SELECT 
    s.session_id,
    s.login_name,
    s.host_name,
    s.status,
    s.last_request_start_time,
    s.last_request_end_time,
    r.cpu_time,
    r.total_elapsed_time,
    r.reads,

r1d3rzz

SELECT DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), CURRENT_TIMESTAMP), event_time) AS event_time_afterconvert,
	getdate() 'Current_system_time'
	,statement --for reason
	,*
FROM fn_get_audit_file('D:\code\SSMS\Audit\*', DEFAULT, DEFAULT) WHERE action_id = 'LGIF' -- LGIF mean Login Fail

r1d3rzz

$.extend(true, $.fn.dataTable.defaults, {
    processing: true,
    responsive: true,
    mark: true,
    order: [[0, "desc"]],
    iDisplayLength: 5,
    aLengthMenu: [[5, 10, 25, 50, -1], [5, 10, 25, 50, "All"]],
    layout: {
        topStart: {
            buttons: [

r1d3rzz

DTExec.exe /file "D:\filepath" /de "something" 

r1d3rzz

use HRMS
go

update Employees set Department_Branch_Id = Departments.Department_Id
from Departments
WHERE Departments.Name = Employees.DepartmentName