SQL Server

First of all, I want to say, I really is slag, a this thing to get a half-day, forget, directly into the subject bar.The first step:Write the stored procedure first.You have two tables, you build it yourself.If exists (select name from sysobjects

A stored procedure is a compiled, optimized set of SQL statements placed on the database server, which can be called directly by the application. There are several advantages to using stored procedures:1. Faster execution speed than normal SQL

1, right-click the database connection,2. Click PropertiesSelecting SQL Server and Windows authentication modes in security3. In security, locate the SA in the login name, right-click Properties, and set the SA password in general, as follows4, then,

A. Function: There are 3 custom functions in sqlserver2008: scalar function/Inline table-valued function/multi-statement table-valued function, first summarizes their grammatical similarities and differences: The same point: 1. Create definition is

--sql Server 2005, or 2012:select * from Information_schema.tables--sql server 2000:select * from sysobjects WHERE xt ype= ' u ' select * from sysobjects WHERE xtype= ' u ' select table_name from GEOVIDNU. Information_schema. Tablesselect

Bit integral typeThe bit data type is integral, and its value can only be 0, 1, or null. This data type is used to store data that has only two possible values, such as Yes or No, True or false, on, or off.Note: A data type that is space-saving and

SQL Server Auditing (Audit)--How to create an auditYou can use SQL Server Management Studio or Transact-SQL to define auditing. After you create and enable auditing, the target receives the items.You can use the Event Viewer utility in Windows to

Original address: http://www.cnblogs.com/marvin/p/HowCanIHandleBigDataBySQLServer.htmlFirst of all, I am just a programmer, not a professional DBA, the following article is written from a problem solving process, rather than the beginning to give

First of all, I am just a programmer, not a professional DBA, the following article is written from a problem solving process, rather than the beginning to give you a correct result, if there is something wrong in the text, please correct the

In SQL Server, when a database is started, SQL Server creates a corresponding Task scheduler (Scheduler) for each physical CPU (including physical CPU and hyperthreaded), and Scheduler can be thought of as a logical CPU (Logical CPU).Depending on

    because the server unexpectedly loses power, causes the database on the SQL Server server to appear "suspect" but cannot use, through the net search, found the following method solves the problem, here records: when produces the database to

DECLARE @s VARCHAR (100)SET @s= ' r1-1-1 ' gets the number after the last "-"SelectREVERSE(@s) return value: 1-1-1R reverses the character. SelectLEN(@s) return value: 6 Get length SelectCHARINDEX(‘-‘,REVERSE(@s)) Return value: 2--Gets the position

Original: Configuring SQL Server R2 Reporting ServicesRecords How to configure SQL Server R2 Reporting Services locally, the author environment for Windows 7 64-bit + SQL server R2First, the preparatory workIn fact, the preparation is simple, just

partition table in SQL Server 2005 (iv): Delete (merge) a partitionCategory: SQL Server2009-12-04 09:10 8735 People read comments (0) favorite reports SQL Server2010functionmerge Storage DatabaseIn the previous section we described how to create

IntroductionThe transaction log in SQL Server is undoubtedly one of the most important parts of SQL Server. Because SQL Server uses transaction logs to ensure persistence (durability) and transaction rollback (Rollback). This also partially ensures

This article is the third in a series of articles, the first two addresses are as follows:On transaction log in SQL Server (i)----the physical and logical architecture of transaction logsTalking about transaction log in SQL Server (ii)----The role

The Common Language runtime (CLR) is at the heart of the Microsoft. NET Framework and provides the execution environment for all. NET Framework code.  code that runs in the CLR is called managed code. the CLR provides the various functions and

background : The project started with a SQL Server database, and the business requirements are now to tune the database to MySQL. Online collection of a number of tutorials, found a relatively simple and convenient (temporarily did not find obvious

--Understanding transparent Data encryption (TDE)--https://technet.microsoft.com/zh-cn/library/bb934049 (v=sql.105). aspx transparent Data encryption (TDE) Real-time I/O encryption and decryption can be performed on data and log files. This

Network-related or instance-specific errors occur when you establish a connection with SQL Server. Server not found or inaccessible When I started the system this morning, I found that I could not log on to the database when I opened SQL Server