Database

Ebube wrote:

set union constraint

SELECT * FROM
(
	SELECT TOP 1 [name] FROM sysobjects WHERE [name] LIKE ('sysh%') 
	UNION
	SELECT TOP 2 [name] FROM sysobjects WHERE [name] LIKE ('sys%') 
	UNION
	SELECT TOP 1 [name] FROM sysobjects WHERE [id] < 0
) AS myCTE ORDER BY [name]

SELECT TOP 1 *
FROM TBL_SWBOM_CHECKLIST_TEMPLATES
WHERE TEMPLATEOWNER = 'Joe Smith'
union
SELECT TOP 1 *
FROM TBL_SWBOM_CHECKLIST_TEMPLATES
WHERE TEMPLATEOWNER = 'Jane Smith'
union
SELECT TOP 1 *
FROM TBL_SWBOM_CHECKLIST_TEMPLATES
WHERE TEMPLATEOWNER = 'GI Jane'
order by lastchange desc

Select * from (
	SELECT TOP 1 *
	FROM TBL_SWBOM_CHECKLIST_TEMPLATES
	WHERE TEMPLATEOWNER = 'Joe Smith' 
	order by lastchange desc
) d
union
Select * from (
	SELECT TOP 1 *
	FROM TBL_SWBOM_CHECKLIST_TEMPLATES
	WHERE TEMPLATEOWNER = 'Jane Smith'
	order by lastchange desc
) d
union
Select * from (
	SELECT TOP 1 *
	FROM TBL_SWBOM_CHECKLIST_TEMPLATES
	WHERE TEMPLATEOWNER = 'GI Jane'
	order by lastchange desc
) d

cmd = new SqlCommand();
            cmd.Connection = con;
            cmd.CommandText = "Your_SP";
            cmd.CommandType = CommandType.StoredProcedure;
            if (con.State != ConnectionState.Open)
                con.Open();
            cmd.Transaction = con.BeginTransaction();
            
            try
            {
                parentmainid=Subroutine_For_Parent_Insert(userid);
                for (items = 0; items <= _alldata.Count - 1; items++)
                {
                    Subroutine_For_Child_Insert(parentmainid,childdata);
                }
                cmd.Transaction.Commit();
                _status = true;
            }
            catch (Exception e)
            {
                cmd.Transaction.Rollback();
                _status = false;
            }

Select * from Table where ID in(1,23,4,56,700)