Spaces:
Sleeping
Sleeping
File size: 1,969 Bytes
8b66d42 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | SELECT TOP (1000)
[EmployeeID]
, [LastName]
, [FirstName]
, [Title]
, [Team]
, [BirthDate]
, [HireDate]
, [ReportsTo]
, [Address]
, [City]
, [Region]
, [PostalCode]
, [Country]
, [WorkPhone]
, [Extension]
, [FaxNumber]
, [HomePhone]
, [MobilePhone]
, [EmailAddress]
, [Notes]
, [RegionCvrd]
, [ChristmasCard]
, [Inactive]
, [Password]
, [EmployeeType]
, [IsInternationalUser]
FROM [hs-prod3].[dbo].[Employees]
WHERE Inactive = 0 AND [Password] IS NOT NULL;
DELETE FROM [hs-prod3].[dbo].[Employees]
WHERE LastName = 'string' AND FirstName = 'string';
UPDATE [hs-prod3].[dbo].[Employees]
SET EmployeeID = 'RAJESH'
WHERE FirstName = 'RAJESH' AND LastName = 'KUMAR';
UPDATE [hs-prod3].[dbo].[Employees]
SET [Password] = 'Tucker21'
WHERE EmployeeID = 'MILDA';
-- Update the real table with the default password
-- rajeshg820
-- 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
UPDATE dbo.Employees
SET Password = 'Tucker21'
WHERE Password IS NULL OR LTRIM(RTRIM(Password)) = '';
SELECT *
FROM dbo.Bidders
WHERE ProjNo=15878;
SELECT *
FROM dbo.ProjectNotes
WHERE ProjectNo=15884;
SELECT *
FROM dbo.Projects
WHERE ProjectNo=15886;
SELECT *
FROM dbo.ContactAddress
WHERE ContactId IN (SELECT ContactId
FROM dbo.Contacts
WHERE CustomerId=16422);
SELECT *
FROM dbo.CustomerNotes
WHERE CustomerID=16428;
SELECT FollowupDate
FROM dbo.Customers
WHERE CustomerId=16428;
SELECT *
FROM dbo.FOB;
SELECT *
FROM dbo.EstFreight;
SELECT *
FROM dbo.ProductApplications;
SELECT COUNT(*)
FROM dbo.CompanyTypes
WHERE CustomerTypeID=1 AND Inactive=0;
SELECT *
FROM dbo.States
WHERE CustomerTypeID=1;
SELECT *
FROM dbo.LeadGeneratedFroms;
SELECT *
FROM dbo.Bidders
WHERE [Primary]=1 AND OrderNr IS NULL;
SELECT *
FROM dbo.Projects
|