Home » Posts tagged "SQL" (Page 2)

Archive for the 'SQL' Tag

Find missing record using query

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

VB.NET – SQL statement “LIKE”

Input box Please enter customer first or last name: <asp:RequiredFieldValidator ID=”ReqSearchfor” runat=”server” ErrorMessage=”<font color=’red’>Input box can not be empty!</font>” ControlToValidate=”SearchFor” > <asp:TextBox ID=”SearchFor” runat=”server”> <asp:Button ID=”SearchBtn” runat=”server” Text=”Search” /> SQL DataSource Design <asp:SqlDataSource ID=”SearchResults” runat=”server” ConnectionString=”< %$ myConString %>” SelectCommand=”SELECT * FROM [CustomerTbl] WHERE ([customer_name] LIKE ‘%’ + @customer_name + ‘%’)” <SelectParameters> <asp:ControlParameter ControlID=”SearchFor” Name=”customer_name” […]

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 […]