SQL Server

This is a common face test, which is often used in practical projects.Requirements: To find product categories for the group, the most expensive product information in each group.The implementation process is as follows:Declare @t table (ProductID

To back up the database:String connectionString = "server= server name; database= database name; uid= login name; pwd= login Password"; Login name and password to find in SQL Serverprivate void Btnbackdatabase_click (object sender, EventArgs

There are many articles about nolock in the blog Park, most of which are well written, for example: http://www.cnblogs.com/huangxincheng/p/4292320.htmlThis is a personal note that only combines individual items.Nolock methods of use such as:SELECT *

Workaround:1. Find the file location of Sqlmgmproviderxpsp2up.mof2. Open Window+r Open command prompt (enter cmd): Enter sqlmgmproviderxpsp2up.mof file location path, return (enter), enter Mofcomp + Absolute path of the sqlmgmproviderxpsp2up.mof,

Connection methods that involve configuration files:Way One:in the configuration file: "ConnectionString"Value="The name of the data source= server; Initial catalog= the name of the database to connect to; User id= Database login name; password=

SET NOCOUNT on;DECLARE @sql VARCHAR (1024)DECLARE @table VARCHAR (64)DECLARE @column VARCHAR (64)DECLARE @value VARCHAR (64)Set @value = ' 14799059407 'CREATE TABLE #t (TableName VARCHAR (64),ColumnName VARCHAR (64))DECLARE TABLES CURSORForSELECT

--/1th Step ********** Remove foreign KEY constraints for all tables *************************/ DECLAREC1cursor forSelect 'ALTER TABLE ['+ object_name(parent_obj)+ '] Drop constraint ['+Name+']; ' fromsysobjectswhereXtype= 'F'OpenC1Declare @c1

Error message: Error tip: Title: Microsoft SQL Server Management Studio Express —————————— Unable to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) For help information, click: Http://go.microsoft.com/fwlink?

Http://www.cnblogs.com/annabook/p/3835436.html1.#region"Stored procedures in SQL Server process out return values"//Public void GetData ()//{ //string str = "SERVER=192.168.XXXX; user id=xxx; [Email protected]#;d atabase=xxxxx_db;min

--Description: Splitting a string function--SELECT * FROM dbo. Split (' a,b,c,d,e,f,g ', ', ')-- =============================================CREATE FUNCTION [dbo].[Split](@Text VARCHAR(8000) ,@Sign NVARCHAR(4000) ) RETURNS @tempTable TABLE(IDINT

Use [Database name]GO DECLARE @TableName1 NVARCHAR( -); DECLARE @TableName2 NVARCHAR( -); DECLARE @DataName1 NVARCHAR( -); DECLARE @DataName2 NVARCHAR( -); SET @DataName1='Library 1'; SET @DataName2='Library 2'; SET @TableName1='Table 1'; SET

In the system often encountered in the bulk of the data inserted into the database, stored procedures do not have an array, only through the string segmentation loop inserted, here is an example of my study:CREATE proc [dbo].

Serial number Category Sql server C Sharp Note 1 Integer Bit Boolean True to convert to 1False to 0 2 tinyint Byte C sharp data types are located in the System

1, the first is the landing problem, SQL Server 2008 Select Windows Authentication cannot log on (Microsoft SQL Server, error: 18456)is when you connect to SQL Server 2008, select Windows Authentication, prompting for a wrong user name or

First, to divide the string by the specified symbol, return the number of elements after the split, the method is very simple, is to see how many separators exist in the string, and then add one, is the result of the request.CREATE function

EXEC sp_configure ' show advanced options ', 1; RECONFIGURE; EXEC sp_configure ' xp_cmdshell ', 1; RECONFIGURE;SQL2005 Open the ' OPENROWSET ' support method:exec sp_configure ' show advanced options ', 1; Reconfigure;exec sp_configure ' Ad Hoc

SQL Server data typesTransact-SQL ———— database programming languageOne or two binary data binary data is stored in 16 binary form.Format: 1, binary (n) ———— a fixed-length n-byte binary data, n means that the length of the data is 1~8000, the input

Statistical continuous time period dataIf OBJECT_ID (n ' Test ', n ' U ') is not nulldrop table Testgo CREATE table Test (pscode decimal, Outputcode int,monitortime da tetime) insert INTO Testselect 4100000406,1,convert (datetime, ' 2015-04-01 00:00

/* Filter Index SQL SERVER 2008 Test *//*Application: User table, through ID can login,You can sign in if you have a phone number, but you must ensure that the phone number is unique.*/--1, creating a test tableCREATE TABLE T(ID VARCHAR () not NULL

A paging problem, DTCms3.0, paging is based on the time page, if the Add Time (add_time) is the same value, regardless of the number of pages clicked, the data displayed is the same content, so there is a need to change the same time to specify a