5 items found in the SQL Category
Finding Yesterday in SQL and C#
Mikesdotnetting
-
12 July 2010 21:27
Here's something that comes up often in forums - How To Find Yesterday in SQL or C#. Piece of cake, if you know how, but tricky if you don't. And especially tricky to get the right value if you are not clear on the requirement.
Click to read more about Finding Yesterday in SQL and C# ...
Preventing SQL Injection in ASP.NET
Mikesdotnetting
-
19 August 2009 07:28
I, and many other contributors to the forums at www.asp.net find examples of code posted on a daily basis that are vulnerable to SQL Injection attacks. We continue to exhort beginners (and some more experienced programmers) to code against them. This article examines just how serious a flaw vulnerable coding can be, and what you should do about it.
Click to read more about Preventing SQL Injection in ASP.NET ...
Filed under:
SQL
ADO.NET
ASP.NET 3.5
as
Article
Viewed: 22684 times
Sql JOINS and the Sql Server Management Studio Query Designer
Mikesdotnetting
-
28 November 2007 13:19
There are a whole bunch of articles, blog entries and tutorials that seek to explain how SQL JOINS work. Some of them are excellent, and others are just confusing. The reason I am adding my go at trying to clarify JOINS to the mix is to highlight how proper use of the tools available to you can seriously reduce the chances of getting the JOIN syntax or type wrong. Since JOINS are all about how to relate data from one table to another, I thought it appropriate to illustrate the subject using Parents and Children (who may, or may not be related to eachother). So let's meet the families.
Click to read more about Sql JOINS and the Sql Server Management Studio Query Designer ...
Filed under:
SQL
SQL Server Express
ADO.NET
as
Article
Viewed: 5281 times
Getting the identity of the most recently added record
Mikesdotnetting
-
05 June 2007 22:13
The built-in functions @@Identity and Scope_Identity() are designed to retrieve the most recently added record's autoincrement identity value from Access and Sql Server respectively. Here are some usage examples.
Click to read more about Getting the identity of the most recently added record ...
Filed under:
SQL
SQL Server Express
MS Access
ADO.NET
as
Article
Viewed: 53588 times
Insert Single Value With Stored Procedure ASP.NET C#
Mikesdotnetting
-
03 April 2007 14:16
Code for calling stored procedure in the Code-Behind to insert a single value from a text box.
Click to read more about Insert Single Value With Stored Procedure ASP.NET C# ...
Filed under:
ASP.NET 2.0
SQL
ADO.NET
as
Snippet
Viewed: 5926 times