The DELETE statement conflicted with the REFERENCE constraint
You will get this error when you are trying to Delete the record from a Table which has a reference …
SQL Server
DELETE vs TRUNCATE in SQL Server
Delete command removes the specific set of rows from a table based on the condition in a WHERE clause. Truncate …
Event 17058 – initerrlog: Could not open error log file (SQL Server)
I got an error when I try to start the SQL Server service and the error message suggest me to …
How to Store and Retrieve File in SQL Server Database using C# .Net
Description: In this article I am going to write C# code to insert/save/store any type of file (pdf/txt/image/.zip) into Sql …
Difference between Integrated Security SSPI vs True
We can use two kinds of Authentication to connection SQL Server namely SQL Server Authentication and Windows Authentication. To force …
How to Store and Read Byte Array in SQL Server Database using C# .Net
Description: Byte is an immutable value type that represents unsigned integers with values that range from 0 to 255. You …
How to Store and Read C# Class Object in Sql Server
Description There is no build-in sql datatype to store C# class object. But we can save C# class object either …
ERROR: Operand type clash: sql_variant is incompatible with image
I got this error while insert the image file’s byte [] data into Sql server database in image datatype column. …
How to Store and Retrieve Image in SQL Server Database using C# .Net
Description: In this article, I am going to write C# code to insert/save/store the image into Sql server database and …
String or binary data would be truncated the statement has been terminated
Description This SQL error occurs when database field’s datatype,size does not match with the inserting or updating value. Suppose we …