Format of the initialization string does not conform to specification starting at index

Short one.   You are letting your user connect to your trusted SQL Server (fairly common scenario J) They are connecting using SQL Authentication (it is recommended to use Windows Authentication however) an intermittently the application throws an exception:   Unhandled Exception: System.ArgumentException: Format of the initialization string does not conform to specification starting at…

4

Why is autogenerated UPDATE and DELETE statements complex?

  Sometimes people ask why the code generated for INSERT/UPDATE/DELETE is so complex, or verbose if you like, why not just operate on the primary key? To illustrate what we are talking about here, create a table in SQL Server and insert some rows:   create table Person (Id int primary key, FirstName nvarchar(50), LastName…

1

My take on @@IDENTITY vs SCOPE_IDENTITY()

  This may be considered to be somewhat of a ‘classic’, but as mentioned, many of the entries in this blog are reminders and/or point of reference for myself. Which I am of course happy to share. This one is about a question that comes every now and then;   “There is something wrong with…

0

DataTable.GetChanges(DataRowState.Modified) returns NULL

  The scenario; you have a DataGridView on a Windows Form, you then manually, in code, create a DataTable and set this to be the DataSource of the DataGrid. You then edit some of the data in the grid and then you need to get hold of a subset of data containing the Modified rows:…

0