SQL Server

Note: The following table in 0 is actually the date 1900-1-11.0 Points of the daySELECT DATEADD (Day,DATEDIFF(Day,0,GETDATE()),0)The above DateDiff (Day,0,getdate ()) means to calculate the number of days of the day and 1900-1-1, let's remember that

The main reason for writing this stored procedure is that I am too lazy to do the data on the table every day, so I wrote him. Not only study, but also their own exercise.Use [Oaerp]GO/****** object:storedprocedure [dbo].    [S_GET_AUTOYH] Script

Operating the server today, suddenly the lower right corner of the prompt "C disk space is insufficient"!A fright! ~Take a look at the C drive, and 7m!!!. How could this big C-disk space be gone? You can't wait for the server to move!The first

One, lck_m_s, waiting to acquire a shared lockBegins an SQL TRAN that performs an update to a data. But it is not a commit, nor a rollback.begin Tran Update [dbo]. [hr_employee] Set [Description] = ' ZZ 'In this way, the [Employee] table is locked

First, define the definition of the database object: The database object defines the structure of the database content. They are included in the database project, and the database project can also contain data generation plans and scripts.Common

Reference: http://www.pawlowski.cz/2011/04/querying-active-directory-sql-server-t-sql/1. Set up link server.Use master　　GoEXEC sp_addlinkedserver ' ADSI ', ' Active Directory Services 2.5 ', ' adsdsoobject ', ' Adsdatasource '2.exec sp_configure '

Grouping top data is a common query in T-SQL, such as the Student information management system that takes out the top 3 students in each subject. This query is tedious to write before SQL Server 2005 and requires a temporary table association query

This is the last topic of the index, index coverage, of course, the better way to learn is to look at the masters of the design of the index, to see what nutrients can be extracted from the things, let us seeLook at one of the core orders tables in

1 CREATE PROCEDUREP_deletesamedata2 (3 @table nvarchar( -),--Table name4 @columns nvarchar( $)--column name, format such as: Id,name,age5 )6 as7 BEGIN8 BEGINTRY9 BEGIN TRANSACTIONTen DECLARE @SQL NVARCHAR( +),

Original: SQL Server Tour--seventh station Why do we say that a field with few States cannot be indexedWhen we were learning SQL Server, most textbooks and seniors said that the less-state fields don't index, and the overhead is not as good as

SQL Server System table sysobjects describes and usesAll information about the SQL Server database is stored in its system table. I wonder if you have spent more time checking the system tables because you are always busy with user forms. However,

With the widespread popularization of Internet application, the storage and access of massive data has become the bottleneck problem of system design. For a large-scale Internet application, every day millions even hundreds of millions of PV

One, the encryption process(1) Switch to master:Use master;(2) Create a master key based on a custom password:CREATE MASTER KEY Encryption by PASSWORD = ' password ';(3) Create a master key certificate, subject to any of the fields:CREATE

Before setting up an extranet to access the SQL2008 database , you must first ensure that there is no problem with access SQL2008 within the LAN . Then, we first look at the local area network access to the SQL2008 database what steps and settings

SQL Server recently used more, time formatting is always forgotten, now sorted as follows: (from the Internet, the specific source address forgotten, after all, MSDN it)SELECT CONVERT (varchar), GETDATE (), 0): 2006 10:57amSELECT CONVERT (varchar),

When SQL SERVER Report 2005 was made, it was found that the row height specified in the reports was not used. Google a bit and found a solution. Make both CanGrow and CanShrink is False for all of the cells in the row. This is because Excel

reprint please indicate from Zhu Zhu Homeland http://blog.csdn.net/zhgl7688To modify the SA authentication login method in SQL Server:1. In the Start menu, locate SQL Server Management Studio, double-click Open, enter with Windows authentication.2.

--sql Server table description and field description Add, delete, change, Query--sql Server 2000 system table sysproperties invalid in SQL 2008 Today, inadvertently found on the Internet SQL Server has an extended attribute system table

How to modify the SQL SERVER internal storage process SQLSERVER is estimated to be for installation or other aspects, it has built-in a batch of dangerous stored procedures. Ability to read registry information, write registry information, and read

Quick Method for counting the number of rows in each table in SQL Server This article mainly introduces how to calculate the number of rows in each table in SQL Server. This article does not use the traditional count () function because it is slow