[Daily] SQL Server random query, string comparison, ASP. net1.1 server settings

SQL random Query SQL Server: 
Select Top N * from Table order by newid ()
The newid () function creates a unique value of the uniqueidentifier type. The preceding statement reads N records randomly from the table. MySQL: 
Select * from Table order by rand () limit 10

STR converts a number to a string for comparison.

  select  ( case   STR  ( 100 , 4 ,  2 )  when   '000000'  then   'Equality ' else   STR  ( 100 , 4 ,  2 )  end )   

Result: 100
 

When the number is converted to a string, a leading space is always reserved for the number symbol. If the number is positive, the returned string contains leading spaces with the plus sign. Negative Numbers include minus signs (-) without leading Spaces Function http://hi.baidu.com/wqk1025/blog/item/f736ff8ff3825be5f11f36ae.html for sqlserver Bytes ------------------------------------------------------------------------------------------------------------- . net2003 reported an error, prompting: Visual studio.net has detected that the Web server is not running ASP. net1.1 Change the IP address in the "Default web site" attribute in IIS to "(all are not allocated )", Publish via wiz