-- Find all the courses in which Noe Coleman has ever enrolled SELECT course.Name, course.Teacher, credit.Grade FROM Course AS course INNER JOIN Credit AS credit ON credit.CourseId = course.CourseId INNER JOIN Student AS student ON student.StudentId = credit.StudentId INNER JOIN Person AS ...
-- Find all the courses in which Noe Coleman has ever enrolled SELECT course.Name, course.Teacher, credit.Grade FROM Course AS course INNER JOIN Credit AS credit ON credit.CourseId = course.CourseId INNER JOIN Student AS student ON student.StudentId = credit.StudentId INNER JOIN Person AS ...
SELECT pc.Name AS CategoryName, p.name AS ProductName FROM [SalesLT].[ProductCategory] AS pc INNER JOIN [SalesLT].[Product] AS p ON pc.productcategoryid = p.productcategoryid; On the toolbar, select Execute to run the query and retrieve data from the Product and ProductCategory tables...
CASE WHEN ((SELECT tbli.is_memory_optimized FROM sys.tables tbli WHERE tbli.object_id = i.object_id)=1 or (SELECT tti.is_memory_optimized FROM sys.table_types tti WHERE tti.type_table_object_id = i.object_id)=1) THEN ISNULL((SELECT ds.name FROM sys.data_spaces AS ds WHERE ds.t...
With the version 19.0, 19.0.1, 19.0.2 et 19.1 (on Windows 11), I cannot open the Securables of a SQL role (but it is working with the version 18). I am getting the following error "object reference not set to an instance of an object (SqlMgmt)": ...
This is the final post in a series covering changes in SSMS 19. Please review Part 1 and Part 2 for details about Microsoft.Data.Sqlclient, MSAL, removal of the SQL Vulnerability Assessment, and mor... Erin, I see your point, although 19 and 20 do seem to be closer together than pre...
(obj.schema_id) ,tr_object_name = obj.name FROM sys.objects as obj INNER JOIN sys.tables as tb ON obj.parent_object_id = tb.object_id INNER JOIN sys.triggers as tr ON obj.object_id = tr.object_id WHERE obj.type = 'TR' AND obj.is_ms_shipped = 0 AND tr.is_disabled = (1...
(obj.schema_id) ,tr_object_name = obj.name FROM sys.objects as obj INNER JOIN sys.tables as tb ON obj.parent_object_id = tb.object_id INNER JOIN sys.triggers as tr ON obj.object_id = tr.object_id WHERE obj.type = 'TR' AND obj.is_ms_...
AS RETURN ( SELECT AddressID, AddressLine1+ Coalesce(','+AddressLine2,'')+', '+ City+', '+ StateProvinceCode+', '+PostalCode AS address FROM Person.Address AS A INNER JOIN Person.StateProvince AS SP ON SP.StateProvinceID = A.StateProvinceID WHERE city LIKE @City )Listing...
Join only If you have manually prepared secondary databases on the server instances that will host the secondary replicas, you can select this option. The wizard will join the existing secondary databases to the availability group. Skip initial data synchronization Select this option if you want to...