BrightMind LearningHub

SQL Server - Find Manager Names of the Employees CODE create table Emp ( empid integer , empname varchar ( 100 ), managerid integer ); insert into Emp values ( '1' , 'Krishna' , null ); insert into Emp values ( '2' , 'Rakesh' , '1' ); insert into Emp values ( '3' , 'Rateesh' , '1' ); insert into Emp values ( '4' , 'Ajeesh' , '1' ); insert into Emp values ( '5' , 'Madhu' , null ); insert into Emp values ( '6' , 'Jain' , '5' ); insert into Emp values ( '7' , 'Jaya' , null ); select e . empname , m . empname managername from Emp e left join Emp m on e . managerid = m . empid

Python - Loop through files and folders CODE import os fileAndDirList = os . scandir () for f in fileAndDirList : if f . is_file (): print ( "File: " + f . name ) elif f . is_dir (): print ( "Directory: " + f . name )

Java - Write data to a file CODE import java . io .*; public class Main { public static void main ( String [] args ) throws IOException { FileWriter fw = new FileWriter ( "output.txt" ); fw . write ( "This is a sample data." ); fw . close (); } }

SQL Server - Create a sample procedure CODE CREATE PROCEDURE CalculateSum ( @ a Integer , @ b Integer ) AS SELECT @ a + @ b EXEC CalculateSum 10 , 20

SQL Server - Create a sample function CODE CREATE FUNCTION CalculateSum ( @ a Integer , @ b Integer ) RETURNS Integer AS BEGIN RETURN @ a + @ b END --Call the function SELECT dbo . CalculateSum ( 10 , 20 )

Shell - Print even numbers from 1 to 10 CODE i = 1 while [ $i - le 10 ] do if [ `expr $i % 2` == 0 ] then echo $i fi i =$(( $i + 1 )) done