Job opening for .Net and Testing @Icertis
Job opening for .Net and Testing @Icertis. If intereseted then please send resume to f10debugs@gmail.com
How to break out of jQuery each Loop
To break out for each loop, you have to return false from it. $.each(users, function(key, value) { if(value === “jatin”) { return false; } });
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 0 0 0 0 0
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’ 0 0 0 0 0
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. 3 0 0 0 0