How to Find all tables that Contain a Specific Column in SQL Server
How to Find all tables that Contain a Specific Column in SQL Server select * from INFORMATION_SCHEMA.COLUMNS where COLUMN_NAME like ‘%ProductName%’ order by TABLE_NAME
Senior Microsoft.Net developer with Min. 3 years of experience, Pune
Requirement for Senior Microsoft.Net developer with Min. 3 years of experience Technical Skills Excellent product development hands on “Microsoft Technologies” NET 4.5, ASP.NET MVC 5, C#, Web APIs Multi-threading, Tasks, OOP, Design Patterns Entity Framework 5/6, LINQ, Ado.Net Angular 2.0, TypeScript, JQuery, Javascript HTML , BootStrap 3.0, MS SQL Server 2014/16 Conceptual Skills Understands and… Read More »
taskbar missing in remote desktop
Almost every we use RDP session (remote desktop connection) to connect to remove server. Today, I did an RDP session in fullscreen mode & what i saw is taskbar missing in remote desktop which was hidden by my local computer taskbar. Resolution: Minimize the Remote session and open the task manager on the local computer. Right-click… Read More »
Ternary operator in C#
Ternary Operator: ” ?: ” Ternary operator means simple if else condition in one statement based on condition. we can say this is dicision making operator. Syntax: var output = Boolean expression ? first value : second value It three parts, First part (before ?) includes conditional expression that returns boolean value true or false. Second part (after ? and before ‘:’… Read More »
How to uninstall a Windows service if the files of that windows services are deleted
How to uninstall a Windows service if the files do not exist anymore? Method 1 – We can use the SC tool (Sc.exe) Open a Command Prompt using windows + R and write Syntax: SC Delete <Service-name-which-you-want-to-delete> Example: we wanted to delete “ABC” service, DESCRIPTION: SC is a command line program used for communicating with the NT Service… Read More »
How to check if a column exists in a SQL Server table
How to check if a column exists in a SQL Server table, Syntax: IF EXISTS(SELECT 1 FROM sys.columns WHERE Name = N’columnName’ AND Object_ID = Object_ID(N’schemaName.tableName’)) BEGIN — Column is exists in DB END Example: Let’s Check wether address column is present in Employee table or not. IF EXISTS(SELECT 1 FROM sys.columns WHERE Name =… Read More »
Add a column with a default value to an existing table in SQL Server
Syntax: ALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE} WITH VALUES Example: Alter table Employee Add Address varchar(max) null default ‘Pune’
how to access current directory in windows service
Path.GetDirectoryName(Application.ExecutablePath); will return the current directory in windows service. To work above code you need to add one dll reference System.Windows.Forms.dll. Some developers tries Directory.GetCurrentDirectory(), which actually returns C:\Windows\System32.
Lazy Loading C#.Net
Some of the interviewer’s favourate question or we can say common interview question is What is Lazy Loading in C#.Net and when to use it Lazy Loading in C#.Net Lazy loading is the concept in which we delay the loading of the object until the point where we need it. In simple terms loading the objects on… Read More »
Parallel foreach on DataTable in C#
Once, we had one situation where foreach loop is used to loop though data rows in datatable and we were marking DB call though that loop. [Calling DB functions inside loop is not good practice, but that code was very old and we just wanted to improve some performance.] but we wanted Parallel foreach on DataTable.… Read More »