SQL Server

Misunderstanding #5: AWE must be enabled in 64-bit SQL SERVER Error! The various versions related to AWE settings that have been circulated in the workshop are confusing. For example, how to set the function, how to set the function does not work,

1. ranking function and PARTITIONCopy codeThe Code is as follows:-- All dataSELECT * FROM dbo. student AS a inner join dbo. ScoreTB AS B ON a. Id = B. stuidWHERE scorename = 'China'--------------------------------------------- The usage of

When writing a statement today, execute it in the query analyzer.It takes less than 10 s to use another method, which is less than 1 s. The colleague said that it is because of the SQL sentence execution sequence. I have seen a few moments beforeI

Copy codeThe Code is as follows:USE [DAF_DB]GO/***** Object: StoredProcedure [dbo]. [PROG_WORKTASK_List] Script Date: 06/14/2010 21:14:43 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- [PROG_WORKTASK_List ,'',''-- ============================

In a select statement, only SQL functions can be used to operate fields (link to SQL server ),Select Field 1 from table 1 where field 1. IndexOf ("Cloud") = 1;This statement is incorrect because the indexof () function is not an SQL function. You

Copy codeThe Code is as follows:Declare @ delStr nvarchar (500)Set @ delStr = '' -- the injected field string/*************************************** */************/Set nocount onDeclare @ tableName nvarchar (100), @ columnName nvarchar (100), @

1. Constants A constant is a hexadecimal or numeric constant that contains text and numbers. A String constant contains one or more characters in the single quotation mark ('') or double quotation mark (" ") Character Set.If you want to use a

RemarksCompared with the DELETE statement, truncate table has the following advantages:The transaction log space is small.The DELETE statement deletes a row at a time and records an entry for each row in the transaction log. Truncate table deletes

The SQL Server service cannot be started due to logon failure.SymptomWhen you restart SQL Server, SQL Executive, or SQL Server Agent, the Service may fail to be started and the following error message is displayed:Error 1069: The service did not

Check whether SQL exists-- Determine whether the database existsIf exists (select * from master .. sysdatabases where name = N 'database name ')Print 'exists'ElsePrint 'not exists'----------------- Determine whether the table name to be created

With the help of old colleagues, I sent this script in my blog:Exec sp_configure 'show advanced options', 1ReconfigureExec sp_configure 'ad Hoc Distributed Queries ', 1ReconfigureSELECT * INTO tmp_assetFrom openrowset ('Microsoft. Jet. OLEDB.4.0

ConceptReplication is a technology that copies a set of data from one data source to multiple data sources. It is an effective way to publish a set of data to multiple storage sites. With the replication technology, users can publish a copy of data

I wrote this code today.Copy codeThe Code is as follows:DECLARE @ recognition NVARCHAR (20)SET @ ASD = NULLIF (@ ASD = NULL)BEGINPRINT 1ENDOriginally, I wanted to print out 1. But no. Modify the Code as follows:DECLARE @ recognition NVARCHAR (20)SET

Table: the name of the deleted data Table.1: The table must be a fact-existing table. The table must be a table that actually exists in the database. It must be an intermediate table created by a select statement.2: This method allows you to join

Recently, two select results of union are used in a project. When debugging SQL statements, an error is always reported. The error only indicates that there is a problem near union, because group is used in SQL, maybe union does not support this

--> Title: Generating test data--> Author: wufeng4552--> Date: 09:56:07If object_id ('tb') is not null drop table tbGoCreate table tb (ID int, name text)Insert tb select 1, 'test'Go-- Method 1Copy codeThe Code is as follows:Select SQL

Notes: several simple basic SQL statementsSelect: select * from table1 where rangeInsert: insert into table1 (field1, field2) values (value1, value2)Delete: delete from table1 where rangeUpdate: update table1 set field1 = value1 where rangeSearch:

1. Back up a single database through the Enterprise Manager. Open the SQL server Enterprise Manager, expand the database under the SQL SERVER group LOCAL, right-click the database you want to back up, and select the backup database under all tasks

Copy codeThe Code is as follows:Use masterDeclare @ DbName varchar (60)Declare @ BackSql varchar (1000)Declare myCursor cursorSELECT [name] FROM SYSDATABASESWhere [name] not in ('master', 'model', 'msdb', 'tempdb ')Order by [name]Open myCursorFetch

Copy codeThe Code is as follows:Exec sp_configure 'show advanced options', 1ReconfigureExec sp_configure 'ad Hoc Distributed Queries ', 1Reconfigure Copy codeThe Code is as follows:SELECT * from opendatasource ('Microsoft. Jet. OLEDB.4.0 ','Data