SQL Server

A stored procedure, a collection of named T-SQL statements stored on a server, is a way to encapsulate repetitive work.Why use stored procedures?All clients can ensure consistency of data access and modification through the same stored

SQL Server Basic FunctionsSQL Server Basic functions1. String Functions length and analytical use1,datalength(char_expr) Returns a string that contains the number of characters, but does not contain subsequent

1. Connect two tables query select * from TABLE1,TABLE2//2. Connecting two table queries select * FROM table1 join table2 on Table1.id=table2.id1. The result of the first connection query is a Cartesian product: That is, the row count of table 1

PIVOT Syntax:SELECT ..... Frompivoted_tablepivoted_table:: =Table_sourcePIVOT Pivot_clause>Table_alias       table_source:: =Table,view, Sub-query,xml ..., that is, the SQL statement from the keyword can be followed by everything, the definition is

Method 1, DBCC OPENTRAN + sys.dm_exec_connectionsDBCC OPENTRAN;You can see that the driest activity was initiated by the 54 session. Let's take a look at what it does.Select Conn.session_id,sess.program_name,sqltext.textFrom Sys.dm_exec_connections

Install the WINDOWS8 after installing the sql2012, the installation process stopped in the "starting the operating system features" NETFX3 "" not move, very anxious, so the Internet to check the information, the original NetFx3 refers to Framework3.5

* JDBC Connection SQL Server database code template* Connection: Connect the database and assume the task of transmitting data;* Statement: Execute SQL statement;* ResultSet: Saves the results of the query resulting from statement execution. **

SQL Server database paging query has been SQL Server's short board, Idle to do nothing, think of several methods, assuming that there is a table article, Field ID, year ... (other omitted), Data 53,210 (customer real data, amount of small), page 30

SQL Server 2008 does not allow remote connections by default, and if you want to connect to SQL Server 2008 on a remote server by using SSMs locally, connect to the database remotely. You need to do two-part configuration:1,sql Server Management

Insert Values Insert Select Insert Exec Select into Bulk Insert Insert values is the most common way to insert data, the basic syntax is as follows, the name of the target column can be specified after the table name, and this

　　When writing complex stored procedures in a SQL Server database, it is common practice to stitch strings and finally use the Exec sp_executesql ' stitched string ' to query the results.Look at the code first:1 -- ===================================

Original address: HTTP://SUPPORT.MICROSOFT.COM/GP/ANXIN_TECHTIP6/ZH-CNWhy does SQL Server use so much memory? SQL Server users often find that the SQL process uses a lot of memory. Most of this memory is used to cache the data the user wants to

Problem: During the development process, the operating system was out of the question and decided to reload the system. However, the database files in SQL Server are not separated and the system is directly in the grid. Attaching the database file

There are three of tables:CompanyAddressContactEstablish foreign key in address and contact, foreign key ID is company's ID,Then you cannot delete company arbitrarily. But if the foreign key constraints in the Cascade Delete selected, it will be

--Check for temporary tables that have been marked as needing to be deletedSELECT * FROMT_bas_temporarytablename;--Temporary tables and views created by all systemsSELECT * from Sys.tablesWHERE name like ' tmp% '--View the space occupied by all the

Optimized processing for SqlServer2000, SqlServer2005, SqlServer2008, SqlServer2012, and SqlServer2014 library log files, reducing disk space.Processing method:The following columns are SqlServer2012:　　Recovery mode: Complete-Simple, then click

DECLARE @what varchar SET @what = ' lll '--the string to be searchedDECLARE @sql varchar (8000)DECLARE tablecursor CURSOR LOCAL for select sql= ' IF EXISTS (select 1 from [' +o.name+ '] WHERE [' +c.name+ '] like '% '[E Mail protected]+ '% ') the

IntroductionIn SQL Server, the common table-to-table inner Join,outer Join is executed by the engine based on the selected column, the data is indexed, and the selected data is selectively converted to loop Join,merge Join,hash Join one of the three

SQL Server creates an index on a view the criteria for creating an index on a view requires three conditions: first, the view must be bound to the schema. To do this, you must add the with SCHEMABINDING in the CREATE VIEW statement, and if you are

CREATE table TB (name varchar (10), course varchar (10), fractional int)INSERT into TB values (' Zhang San ', ' language ', 74)INSERT into TB values (' Zhang San ', ' math ', 83)INSERT into TB values (' Zhang San ', ' physical ', 93)INSERT into TB