<! –
Wawa Recommendations: VBS operation of the database, the realization of this type usually the main database operations, because we are in daily contact and databases, and sometimes the use of such a class is very convenient, but do not know how practical kind,…
The Java language, the most considerate of a design is that it did not intend to allow people to write procedures written procedures - people also need to consider the issue of the documentation procedures. The documentation of procedures, the biggest problem is the maintenance of…
A few days ago, the company had been running a normal procedure for ASP, installed a client suddenly can not run the side. Customers to use the Informix database server is Windows2000 Professional Simplified Chinese, in the past, we have been testing the use of the database is…
A friend recently asked me to help solve a problem, the problem description:
A table, table has three fields: f1, f2, f3, in which each field there are likely to be between 1 to 9 the number nine…
Recently downloaded from the website of the MS Visual C #. NET Express Beta 1 to play and found some long-awaited features:
1, support template category, feel so cool:
List <int> intList = new List <int> ();
IntList.Add…
How to deal with the database Null
Author: Oriental spider (to)
For beginners, in dealing with the Null database data types is a bit troublesome thing, in this article we will talk about the article Null, you will know how that is a Null value,…
By the following method (available online):
So onto the Command Command Prompt! (Wooohooo)
SQLCMD.exe will be your friend to explore the Beta 1 build of SQL Express. Here's how:
…
/**==** 1. Custom function for the group by error **==**/
— A simple function
Create function f_str (@ str sysname, @ i int)
Returns char (1)
As begin
Return (substring (str @, @ i, 1)) …
Actually is not news, released five days ago, today TheServerSide.net see from the news! Backward……
Interested friends can download here:
Http://www.microsoft.com/downloads/details.aspx?familyid=2adbc1a8-ae5c-497d-b584-eab6719300cd&displaylang=en…
N randomly selected records of SQL (mysql and sqlserver)
Mysql: select * from tablename order by rand () limit 10
Sqlserver: select top 10 * from tablename order by NEWID ()
Subject to the conditions in the data, from the…