Learn how to get row number in SQL. The 1998 tip “Displaying the Row Number in a SELECT Query” tells you to create a temp table to display the row
Developed for a password-reset program, this routine ensures that the user-entered password matches specific password criteria. In this example, the password had to be between 8 and 12 characters long
Do your users ever complain that your WPF applications are too slow, or that they aren’t behaving properly? In many cases, you can solve such problems by taking advantage of
In previous versions of ASP.NET, to import and use user or custom controls on a page, you needed to add a page directive () in the .aspx code for that
When you build C++ applications using Vista-specific APIs and the Windows SDK for Vista, they won’t run on Windows XP. That’s because when the executable loads the system DLLs at
The following steps explain how to serialize any .NET object into a JSON string. This tip uses the .NET 3.0 Framework. You’ll find this capability particularly helpful in applications that
The following SQL query returns the size of each table in the specified database. USE sp_MSforeachtable @command1=’EXEC sp_spaceused ”?”’,@whereand=’or OBJECTPROPERTY(o.id, N”IsSystemTable”) = 1′ Here’s how it works. SQL Server’s system
If you place a HyperLinkField in a GridView in an ASP.NET page and link it to a JavaScript function, you’ll find that it doesn’t work properly. The problem is that
C++’s SAFEARRAY is difficult to use. A better option is to enumerate an array’s elements by repeatedly calling your own custom enumeration function and incrementing the element index. When the