After running the query to update table records the record(s) is missing. Run this query to find the missing record. SELECT Table1.column FROM Table1 LEFT JOIN Table2 ON Table1.column = Table2.Column WHERE Table2.column is NULL; * Replace Table1 and *2 with your table names
Archive for the 'MS SQL' Category
VB.NET – Limited user (checkbox) selection
I found this script very helpful while designing surveys for my organization. This post applies to: – MS SQL server 2005+ – VB.NET – VS2010 – .NET 4.0 Framework Javascript code <asp:content ID=”Content1″ ContentPlaceHolderID=”HeadContent” Runat=”Server”> <script type=”text/javascript” language=”javascript”> function CheckCheck() { var chkBoxList = document.getElementById(‘< %=CheckBoxList1.ClientID %>’); var chkBoxCount = chkBoxList.getElementsByTagName(“input”); var btn = document.getElementById(‘< […]
SQL Primary Key Constraint on alter table
– Login to your server MS SQL Management Studio Express – Expand the database; expand the tables folder, right click on the table “[your table name]”, click “Open Table.” Make sure the primary key column(s) have been declared to not contain NULL values (when the table was first created). With the open table click on […]