Windows Service – Error: “Service on Local Computer started and then stopped”
Error message meaning [html] This means code is throwing an unhandled exception. [/html] Debug Event Viewer -> Windows Logs -> Application [html]Login failed for user […]
Database
SQL Statements – JOIN
INNER JOIN Return common records from 2 tables LEFT JOIN Return all records from LEFT table Return matching records from RIGHT table CROSS JOIN OUTER […]
SQL statements – INSERT
How to INSERT data? How to insert by EXECUTE sql string? Example [sql] DECLARE @strSQL varchar(max) SET @strSQL = ‘SELECT * FROM <one_table>’ INSERT INTO […]
SQL Server: How to import data file into a table?
Ideas 1. Create a setting table having temporary import table name, format file name, stored proc name, upload folder name 2. Create Windows service to […]
SQL Server: Error – Web application can’t import data from a file to SQL server anymore
Related information: This happens afer database migration is done from SQL 2008 to SQL 2015 Solution Reason: The workaround was to ensure that the Web […]
SQL: DB/ Table Queries
SQL Server Management Studio How to find a certain string inside a stored procedure/ function [sql]SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, ‘IsProcedure’) = 1 AND […]
SQL statements – SELECT
How to know number of rows being affected by SELECT/INSERT/UPDATE…? SQL Server[sql] UPDATE Employee SET JobTitle = N’Executive’ WHERE NationalIDNumber = 123456789 IF @@ROWCOUNT = […]
Query tuning
General Speed depends much on indexes than other things JOIN is quicker than IN Index Index improves performance of SELECT queries Index should be applied […]