SQL Server

Recently has been studying the blog, in fact, is now a popular self-media, it is interesting that the netizens have written their own blog, the establishment of a small station, and now went to the platform for others to work free, but also enjoy

1. Introduction to Partitioned TablesA partitioned table is logically a table and physically multiple tables. From the user's point of view, the partition table and the normal table are the same. The primary purpose of using partitioned tables is to

Create a read-only account and only read certain tables.Now let's share the steps of the operation.The premise of this operation is that the database is relatively large, there are many data tables, you need to select their own read-only data tables.

SQL SERVER queries data between rows 20th through 301. Query the first 20 rows of the ID, after the query to remove 20 records of the first 10 recordsSelect Top * from Tbbankwhere bankid No in (select top of BankID from Tbbank ORDER by BankID ASC)2.

Today, sharing a beginner program on how to learn to use MS SQL Server, I've come up with a lot of resources from the Internet, like SQL Server2008 Programming Primer Classic (3rd edition),Head First Sql,sql must Know (4th edition), SQL Server 2008

1. Open the installation file for installation2. Click Install to install3. Wait for the installation test4. Enter the Product Key5. Accept the license6. The Setup program supports rule testing7. Feature Installation options8. Select function9.

Fix SQL Server R2 hint evaluation period has been over1. The registry changes the CommonFiles value in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL server\100\configurationstate to 32 . Enter the installation center in the SQL2008 R2

One, SQL Server Remote call failedWorkaround: Uninstall "Microsoft SQL Server Express LocalDB" in the Control Panel-programs and features, depending on the version of VS you installed, my VS2012(Pro-Test available)Second, SQL Server does not allow

SQL Server Data Automation operationsSpeaking of the current database type, currently the main popular MySQL, SQL Server, Oracle and other three kinds, the difference I believe we are already very familiar with, so there is not much introduction,

SQL Server original Windows authentication cannot log on after the computer name is modifiedTags: database2016-09-26 15:04 1491 People read review (1) Favorite ReportCategory: DB Road--sqlserver (3)After renaming the computer, the SQL database

The time (2) type retains two bits of milliseconds, and after the application converts the time (2) type to int to SQL Server, the following two methods can convert int to time (2):--Method 1DECLARE @T Intset @T = 10455836SELECT DATEADD (hour, (@t/10

Source: One reason SQL Server can update subscription data conflictsWhy are updatable subscriptions conflicting?Updatable subscriptions, when the upgrade adds a field, typically increases in the publisher's publication database, and after the table

Original: SQL Server transactional replication uses scripts to add publications for an object--use [Publish Library]-Add Table: Create the project and add it to the publication exec sp_addarticle @publication = n ' replicationname ', @article = N '

Original: SQL Server subscription expiration workaroundThe database Distribution Agent is no longer enabled because the distribution database is performing a long transaction that reaches the system's scheduled 72 hours, causing the subscription to

First, define variables--Simple assignment  declare @a intset @a=5 print @a   --Assigning values using SELECT statements  declare @user1 nvarchar (50)  select @user1 = ' Zhang San ' print @user1  declare @user2 nvarchar  select @user2 = Name from St_

Business requirementsRecently made a small tool for the company to bring data from one database (data source) into another (target database). The data required to import the target database cannot be duplicated. But the situation is that the data

SQL Server database File typesThe database is stored on disk as a file, consisting of data files and transaction log files, and a database should contain at least one data file and one transaction log file.The database is created on the NTFS

This section describes how to use JMeter for connection testing of SQL Server, using test libraries and test tables as well as the previous section, "Performance test Tool operations Database (vii)-loadrunner and SQL Server", to make it easy for you

SQL SERVERDatabaseMasterDatabase RecoveryFirst, the experimental steps probably1 , first create a database and a table to be used for post-recovery validation. 2 , the Master The database is backed up well in advance. 3 , Simulation Master database

CREATE FUNCTION Dbo.sf_ds_splitnvarchar(@strValues nvarchar (4000))RETURNS @tblStrList TABLE (id int identity (), value nvarchar (4000))AsBEGINdeclare @strTmp nvarchar (4000)DECLARE @intPos intSelect @strValues =ltrim (RTrim (@strValues))While