How to return all testers even they have not taken the test yet and their corresponding test names.
SELECT l_name, f_name, test_name LEFT JOIN test ON TESTER.tester_id = TEST.tester_id
Can you tell me what I made a mistake.
Can you tell me where the error is?
can you please help, (Im usning SQL 2008 R2)
Conversion failed when converting the varchar value 'KM' to data type int.
Conversion failed when converting the varchar value 'sh' to dat…
How to restrict the returned result set to 100 rows in TSQL?
How to select all rows from the STUDENTS table where the ID number is any number from 100-500? Do I use in or between
What is not an advantage of using a filtered index over a full table index? A better query performance and less index storage/maintenance costs than a full table index or a filtered index is larger th…
What is a benefit of using stored procedures
Are they run slower than single lines of code and are easier to audit. Also can they are temporarily held in memory and can be compiled and run faster t…
I have a 64 bit Windows 2008 Server machine running multiple SQL Server 2008 R2 instances (also 64 bit). Most of the instances are full SQL Server Standard editions, but we have one old SQL Server 200…
what is the purpose of the DATETIMEOFFSET feature
Is JOIN is better than WHERE efficiency wise and low memory consumption.
How to return a result set that excludes rows from the first query if they also occur in the second query
SELECT CLastName, CFirstName
SELECT PLastName, PFirstName
what's the mean affinity mask in sql server for: processors and IO
i am using sql server 2016 upgrade advisor
what's the mean: set rowcount in context insert / update / delete.
Why should be TOP?
Can I use a square brackets for a single insert?
INSERT INTO OrderDetails
(1011, ‘123-199’, ‘2009-01-23’, 59.95, 0, 1, 1),
(1034, ‘123-234’, ‘2009-01-19’, 99.95, 1, 1, 0),
if we want to see why the same queries on diff server perform differently , I'd like to compare index and the index used by the SAME queries on diff server,
the showplax_text on will help?
Is this is correct
DECLARE @TopSellers INT
SET @TopSellers = 10
SELECT TOP (@TopSellers) EmployeeID, Ename FROM HR.Employee
What is the use of over in select
SELECT ROW_NUMBER() OVER(ORDER BY emp_id) AS 'Row Number', * from dbo.employee
ORDER BY SSN
Okay, so I have this query, with a case statement:
For some reason its repeating the value for the first case twice:
Case 1 - 23
Case 2 - 23
Case 1 - 23
I have SQL 2008R2 installed on a server but there is no SQL Server Management Studio installed. I have tried to install SQL Server Management Studio on this system. I downloaded the Management Studio…
I am receiving a null value for the Budget Request; I want to find which deptid, account number is giving me this value. How would I modifyt the sql below to add the additional columns, deptid…
I have below data :
II. THSVCSTATUS :
1. TrsNo, foreign key to THSVCWO
1. 'Rcv', order receiv…
I am trying to create a transactional replication process from 2008 to 2016 server. In which 2008 is my publisher and 2016 is going to be my subscriber. And i have created distributor on 200…