SQL Server

using SQL Server today, I found a problem with the INSERT into database name. dbo. Table name (field) values (values) When this statement returns an error: SQL Server Principal The database cannot be accessed under the current security context.So I

first, the introduction of Petapoco.netcore, Petapoco.netcore is based on the Petapoco light-weight orm, Support for. NETFramework and. Netcore, support for single Entity object mapping, multi-entity object mapping, Netcore No driver connection

1, session save in SQL Server configuration method1) runs. NETFramework the corresponding version of Aspnet_regsql.exe in the installation directory to create related databases, tables and stored procedures, such as:

Establish dept and EMP Tables, and set the foreign keys of the EMP table with the dept_id in the Dept tableCREATE TABLE Dept (dept_name nvarchar () not NULL, dept_address nchar (+), dept_id int constraint pk_dept primary key--dept table's primary

In the original: View in SQL Server (top) http://www.cnblogs.com/xbf321/archive/2009/06/16/view_in_sqlserver.html1, what is a view?2, why use a view;3, order by in the view;4, refresh the view;5, update the view;6, view options;7, indexed view;Go

Original:. Comparison of image type data in SQL ServerIn SQL Server, if you are comparing data for text, ntext, or image data types. You will be prompted that you cannot compare or sort the text, ntext, and image data types unless you are using the

Primarily used to collect database operations for client servers, export-import to local analytics.This tool does not modify your data and structure, it only reads the relevant data.1) Tool software

In a stored procedure, there are oftenSQL code SET quoted_identifier on SET quoted_identifier off SET quoted_identifier OnSET quoted_identifier offSuch a statement, then SET QUOTED_IDENTIFIER what exactly mean, what is the use of

Concept IntroductionDevelopers like to use with (NOLOCK) in SQL scripts, with (NOLOCK) is actually one of the table hints (table_hint). It is equivalent to readuncommitted. The specific function functions are as follows (from MSDN):1: Specifies that

In SQL Server, both the cast and CONVERT functions are available for type conversions, and their functions are the same.It's just a different syntax.Cast is generally easier to use, and the advantage of convert is that dates and values can be

SQL Server Configuration Manager, expand SQL Server Network Configuration, right-click Protocols for Properties.">In SQL Server Configuration Manager, expand SQL Server network configuration, right-click Protocol, and then select Properties.

SQL Server Date functionDefinition and UsageThe CONVERT () function is a general function that converts a date to a new data type.The CONVERT () function can display date/time data in different formats.GrammarCONVERT (data_type (length),

SQL Server time formatBackground knowledge:SQL server comes with a convert function that converts a field of a date type to a string format as specified, and you can copy the following script to Query Analyzer execution;DECLARE @now datetimeSET @now

Server A, Server BSELECT * FROM (Select a.ID as hid,a.subjectid as hsubjectid,b.id as lid,b.subjectid as lsubjectid,c.* from OPENROWSET (' Msdasql ',' Driver={sql Server}; Server=a; Uid=sa; pwd=*** ',DbName) as a left join OPENROWSET (' Msdasql ','

SQL Server supports two character data types---general and Unicode, and general types include char and varchar;unicode including nchar and nvarchar. Each character in the general occupies one byte of storage, while the Unicode data type consumes 2

Summary of SQL Server R2 issues installed inside Windows Server R2The premise is that Windows Server R2 is already installed, (only the service is not configured to complete the installation)1. Open the dashboard, Server Manager2. Click on the top

Currently in a project optimization, want to analyze SQL Server system performance through the database layer, check the online code, modify the title and DMVs code, the following code can be used to analyze the system after a period of time, those

The basic syntax is:ALTER Table Table NameDROP CONSTRAINT constraint name 1, constraint name 2 ...If you delete a constraint, you do not need the name of the constraint after the comma, and if you delete two and more than two constraints, you must

declare @DBName nvarchar (max)declare @BakName nvarchar (max)--Modify the database name hereSelect @DBName = ' [Lfbmp. PO] '--Specify the save path \\192.168.100.2\d$\DBBakSelect @BakName = ' \\192.168.100.2\d$\DBBak\aa ' +replace (@DBName, '. ', ' _

SQL Server obtains the Server time SQL statement, serversql SQL server 2000 how to obtain the current system time using SQL statements GETDATE (); GetDate () in SQL () A very powerful date Formatting Function in SQL Server Select CONVERT(varchar(100)