A student management system on Microsoft SQL Server, managing data with basic SQL queries as well as advanced techniques like INNER JOIN, LEFT JOIN, Stored Procedures and Triggers. - enescidem/Form-DB ...

THEN 'IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N''' + TableName + ''') AND name = N''' + IndexName1 + ''') columnname = c.name, is_descending ...

I'm doing a package tracking feature for the website of a delivery service out here. I'm trying to perform an inner join based on the success of an if statement in my sql query.