Script Home
  • SQL server in the random function NewID and Rand

    +Read more
    Author:zyq / Release:2015-10-20 / category:Mssql / crowd0 views time+ / Comments Off on SQL server in the random function NewID and Rand /
    in SQL Server, random function rand (), NewID (), the rand is random access within 0 to 1, NewID is to generate random uniqueidentifier unique identifier. SELECT * FROM Northwind.. The Orders the ORDER BY NEWID () - random sort SELECT TOP 10 * FROM Northwind. J. The Orders the ORDER BY NEWID...
    newidrandom function
  • SQL SERVER backup database stored procedure method

    +Read more
    Author:zyq / Release:2015-10-18 / category:Mssql / crowd0 views time+ / Comments Off on SQL SERVER backup database stored procedure method /
    used to bulk export stored procedure in the query analyzer, select the database - the "right" task "--" in the popup menu select "generation script "- "" next" - "to choose your database to a stored procedure is -" "Next", "checked" stored procedures ", and the next step -> Check you to gene...
    BACKUPdatabasethe stored procedure
  • SQL Server are common data types, rounding

    +Read more
    Author:zyq / Release:2015-10-18 / category:Mssql / crowd0 views time+ / Comments Off on SQL Server are common data types, rounding /
        Each variable in the SQL Server, such as parameters, the expression has a data type. The system to provide the data types are divided into several categories, as shown in table 4-2.       Among them, BIGINT, SQL_VARIANT and TABLE is SQL Server 2000 new three data t...
    data typesSQL Server
  • How to solve the deployment on Azure is essentially not network access

    +Read more
    Author:zyq / Release:2015-10-15 / category:Mssql / crowd0 views time+ / Comments Off on How to solve the deployment on Azure is essentially not network access /
    in the deployment of Azure virtual machine recently, always can't access the network database, search information just know, Azure default is not to open the access rules, need to manually. in the Windows firewall as the database engine default instance open TCP port 1. In the "start" menu, ...
    essentially
  • MSSQL in SQL for decimal division results show zero solution

    +Read more
    Author:zyq / Release:2015-10-14 / category:Mssql / crowd0 views time+ / Comments Off on MSSQL in SQL for decimal division results show zero solution /
    today in SQL using MSSQL division, found a decimal, operation result and the integer part of 0, the results show that 0, after a test found the solution, to share. let's assume that we have the following a SQL division: select field1/field2 from table should assume the operation result was...
    SQL division
  • Before the SQL Server query methods of N record summary

    +Read more
    Author:zyq / Release:2015-10-14 / category:Mssql / crowd0 views time+ / Comments Off on Before the SQL Server query methods of N record summary /
    this paper examples about SQL Server query N records before the commonly used method. Share with you for your reference. Specific as follows: N record before SQL Server query operation, that we often should use the following SQL Server query before N records method has made the detailed introd...
    SQL Serverthe query
  • ASP and SQL Server how to construct the web firewall

    +Read more
    Author:zyq / Release:2015-10-14 / category:Mssql / crowd2 views time+ / Comments Off on ASP and SQL Server how to construct the web firewall /
    the ASP is a Web client/server structure of the middle layer, although it USES a scripting language (Java Script, VB Script, etc.), the program code running on the server, the client can be seen only by ASP output dynamic HTML files, but still have some holes the ASP, take measures can also see ...
    firewallSQL Serverthe asp

0Wide search 1Web Design 2Script 3Network Programming 4Database 5Operating system 6Network Security