SQL Server

There is a system table sysobjects in the database, which stores information about each object in the database. Can be queried to see the results. You can see that each object has an ID that stores information about tables, stored procedures,

/* Query all Sundays @startdate Start date @enddate End date in a certain date */declare @startDate datetimedeclare @endDate datetimedeclare @week varchar Set @startDate = ' 20150101 ' Set @endDate = ' 20151231 ' while @startDate Copyright NOTICE:

What happens when a query is submitted?When you submit a query to SQL Server, many processes on the sever start working on the query. The goal of these processes is to manage this system so that the query can select, INSERT, UPDATE, and delete

In the previous article also talk about SQL Server 2008 handling implicit data type conversions in the execution plan enhancements, I mentioned that implicit data type conversions increase the data distribution to a very uneven table, the estimated

Tortured me for a night of problems, finally solved! Do not uninstall sql2008 and then reinstall, to the dead!Installing SQL Server R2 Enterprise Edition error message Unable to continue installation, error message: Could not open

Used to connect to the database using the Entity Framework, this article is to experience using the SqlConnection connection database. Open SQL Server 2008, create the database, and create the following table: CREATE TABLE Product( Id int

Public BOOLCreatetb_property_modellbylist (listentity) { Try { if(Entity. Count >0) { stringstrSQL ="Delete from Tb_property_model where documentmodel= '"+ entity[0].

Recently made a project about data compression, to change all the table objects under the entire SQL Server server to page compression. So take this opportunity to learn about SQL Server compression technology.This article is almost a complete

Scenario one with update and replace--Replacement statement (because the maximum value of varchar (max) is 8000, so a portion greater than 8000 is truncated)UPDATEDbo. Sns_userblogSET [Description]=REPLACE(CAST([Description] as VARCHAR(Max)),'SX',"'

For SQL performance, it's been a long time since you've been watching. Because of the recent project neither tens of millions of of the massive data nor too much performance requirements, so in the performance is not too much effort. However, not

Current system date, timeselect2015-06-18 14:52:27.123Extracting data from a dateday(), month(),year() Select GETDATE (); –2015-06-18 14:52:27.123Select year (GETDATE ()); –2015Select MONTH (getdate ()); –6Select Day (getdate ()); –18Date format

--SQL Server Split function --author:sq-- Description: Split field: Short_str--Support for multi- byte delimiter ----select * from splits ('1203401230105045','0'--select * from splits (' 1203401230105045 ', ' 123 '-- Cross Apply Splits (T1.name, ',

First, the graphical interface operation of the indexSQL Server is very powerful is the graphical interface operation. About the index is also so powerful, many operations such as rebuilding the index Ah, look at various statistics Ah, can be

Introduction to Partitioned TablesThe partitioned table is a new concept introduced by SQL Server2005, which logically divides a table physically into multiple parts . (That is, it allows a table to be stored on a different physical disk). Before

Original: Lock in SQL Server insert operationThis blog post briefly describes the locks used in an INSERT statement in SQL Server.Preparing DataFirst we create a table table_1, which has two column IDs (bigint) and value (varchar), where the ID

1. Add sqlsrv Extensions for PHPGo to Microsoft official website https://www.microsoft.com/en-us/download/search PHP,Click Microsoft Drivers forPHP for SQL ServerDownload the latest version of SqlsrvXX.exe (i downloaded SQLSRV32.EXE)Run the

1, set the host file for the Subscriber C:\Windows\System32\drivers\etc directory, add the Distributor (my environment is that the publisher and the Distributor are together, So the address of the publisher is specified here) information: 192.168.1.1

USE [master]GO-- Method 1: I use this methodEXECsp_attach_single_file_db @dbname=‘TestDb‘,@physname=N‘C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\TestDb.mdf‘GO-- Method 2:CREATEDATABASETestDb ON(FILENAME = N‘C:\Program Files\

SQL Server finds the file and file group based on the partition table name. SELECT ps. name AS PSName, dds. destination_idAS PartitionNumber, fg. name AS FileGroupName, fg. name, t. name, f. name as filename FROM (sys. tables AS t inner join sys.

A question about database (Classic parent-child ID Association), parent-child id Yesterday, a database question that happened together was the type of classic parent-child IDs designed in the same database table. You need to add a field to the