SQL Server

SQL Server has system-provided functions such as AVG, SUM, GETDATE (), etc., and users can also customize functions.User-defined functions include scalar and table-valued functions, where scalar functions and system functions are used, and

Original address: http://www.cnblogs.com/CareySon/archive/2012/03/30/2424880.htmlIntroductionA database snapshot, as its name implies, is a view of the database at a point in time. is an attribute introduced by SQL Server in the version after 2005.

First, SQL ProfilerEvent class Stored procedures\rpc:completed tsql\sql:batchcompletedEvent key Fields Eventsequence, EventClass, SPID, DatabaseName, Error, StartTime, TextData, HostName, ClientProcessID, ApplicationName, CPU, Reads, writes,

SQL Server tables: SELECT COUNT (1) from sysobjects where xtype= ' U ' views: select COUNT (1) from sysobjects where xtype= ' V ' number stored procedures Selec T count (1) from sysobjects where xtype= ' P 'SELECT * from sysobjects WHERE (xtype = '

Because the work needs to do a mirrored offsite backup of SQL, has not been studied before, Baidu has an article record, convenient later queryReprint Address: http://jingyan.baidu.com/article/d5c4b52b20843fda560dc581.htmlDatabase mirroring is a

1) SQL Server service suddenly fails to startProblem Description: There was no problem, suddenly one day could not startWorkaround: View the Event Viewer, Administrative Tools, control Panel, and discover that the login failed to start.Find the

SELECT (case if A.colorder=1 then d.name else null end) Table name,A.colorder field ordinal, a.name field name,(Case if ColumnProperty (a.id,a.name, ' isidentity ') =1 then ' √ ' else ' end) is identified,(SELECT count (*) from sysobjectsWHERE (name

First, the questionFor example, how does the data in table A and Table B become table C through SQL statements? Table A is the username phase, summarizing salary data in descending order of month, table B is the upper value of username corresponding

A string of "1;2;1;1;1".Excuse me:How to implement the following features in SQL Server:1. Determine if there are duplicate numbers in the stringIf there are duplicate numbers, an error message is returnedIf there are no duplicate numbers, the

One or two binary dataBinary data is stored in 16 binary form.Format: 1, binary (n) ———— a fixed-length n-byte binary data2, varbinary (n) ———— n bytes Variable-length binary dataOx24 ———— Where: Ox is a hexadecimal type, 24 is hexadecimal

Database design Paradigm1 Paradigm: Column atomicity, column cannot be split2 Paradigm: Cannot describe multiple information in a table and cannot have data sink3 paradigm: Referencing primary key information from other tablesConstraints A

When a system uses a lot of tables, and there are a lot of stored procedures, when a table in the database deleted a field, then the corresponding stored procedures need to be changed, but we do not know which stored procedures used the field, then

The log files for SQL Server become larger as data modifications are processed, and when processing log files, it is common for us to truncate the logs and shrink them.Backup log databasename to disk= "DBCC SHRINKFILE (Databasename_log)Of course, if

SELECT * Into A--automatically generate table A, and table A's structure data is the same as table BFrom BINSERT into A--a to be created in advanceSELECT * FROM BInsert into A (field 1, Field 2,...)Values(value 1, value 2,...)INSERT INTO

1. One of the more common and usefulSELECT TOP Ten *, NEWID () as RandomFrom tableORDER by randomThe--NEWID function randomly generates a GUID, a long string, which we can use to take random numbers.2. One of the more rapid ()--declare @d

Webconfig Code?Database Class CodeUsing System;Using System.Data;Using System.Configuration;Using System.Web;Using System.Web.Security;Using System.Web.UI;Using System.Web.UI.WebControls;Using System.Web.UI.WebControls.WebParts;Using

--SQL Server 2008Use [master]GOALTER DATABASE [UENCDOP1] SET RECOVERY simple with no_waitGOALTER DATABASE [UENCDOP1] SET RECOVERY Simple--Simple ModeGOUse [UENCDOP1]GODBCC shrinkfile (N ' Pencdop1_log ', one, truncateonly)GO--Here's dnname_log if

How to import SQL Server database and powerdesignersql in PowerDesigner After using PD to create a table, compile it into an SQL script and run it in SQL Server to generate a database. Can I directly generate a PD document for the database? After

How to use SQL for reasoning and SQL for reasoning Database environment: SQL SERVER 2008R2 There are the following requirements:Baker, Cooper, Fletcher, Miller and Smith live on different floors of a house.Baker cannot live on the top layer. Cooper

How to use a random record set in SQL Server In today's article, I want to give you a brief introduction to how to randomly Record Sets in SQL Server. SELECT * FROM Person. PersonORDER by newid () GO This introduces a new UNIQUEIDENTIFIER data