SQL Server

SQL Server database Mirroring (i) Single-server mirror script configuration without witnessSQL Server database Mirroring (ii) Full mirroring script configuration in a domain environmentAfter a few days, build the domain, the server joined the domain

String str = @ "Data source=.\sqlexpress;integrated Security=sspi; Attachdbfilename=z:\ttt.mdf; User Instance=true ";Where the user instance=true parameter is not limited.Http://www.cnblogs.com/yuanyuan/archive/2011/02/12/1951871.htmlThe default

First, the most basic way to connect:Private String URL = "Jdbc:odbc:driver={sql Server}; Server=dell-pc;database=medicaldata ";p rivate string user =" sa ";p rivate string password =" Netlab ";p rivate Connection ConnClass.forName

Original: SQL Server Programming Series (2): About operations for SMO common objectsIn the previous week, I briefly described some of the basic concepts of SMO, in fact, the SMO architecture is far more than the simple one described in the previous

Select CONVERT (varchar), DATEPART (YYYY,A.FSSJ) as years,--get yearCONVERT (varchar), DATEPART (MM,A.FSSJ) as months,--get monthSUM (case if b.fszt in (' 1 ', ' 2 ') then A.cfs else 0 end) as Fscgnumber,SUM (A.CFS) as FsnumberFrom T_mtn_sendrecord

Set maximum number of connectionsThe following T-SQL statement can configure the maximum number of concurrent user connections allowed by SQL Server.exec sp_configure ' show advanced options ', 1exec sp_configure ' user connections ', 100The first

Dynamic Statement Basic syntax:1: Normal SQL statements can be executed with execSELECT * from TableName exec (' select * from TableName ')EXEC sp_executesql n ' select * from TableName '--please note that the string must be added n before2: Field

In the initial SQL Server performance issue (2/4), we discussed the list of waiting resources or running session scripts. In this article we will look at how to list blocked sessions with specific information.1 /**************************************

Definition of UDFSimilar to stored procedures, user-defined functions are also an ordered set of T-SQL statements, and UDFs are pre-optimized and compiled and grams as a unit of love. The main difference between UDFs and stored procedures is how the

CREATE PROCEDURE dbo. uspoutputdata @tablename sysnameAsDECLARE @column varchar (1000)DECLARE @columndata varchar (1000)DECLARE @sql varchar (4000)DECLARE @xtype tinyintdeclare @name sysnameDECLARE @objectId intdeclare @objectname sysnameDECLARE

Select CONVERT (varchar), GETDATE (), 0): 10:57amSelect CONVERT (varchar), GETDATE (), 1): 05/16/15Select CONVERT (varchar), GETDATE (), 2): 15.05.16Select CONVERT (varchar), GETDATE (), 3): 16/05/15Select CONVERT (varchar), GETDATE (), 4):

In the query process and query results for SELECT, each column, variable, expression, and parameter has a related data type. The data type is used to specify the type of data that an object can hold.The data types of SQL Server systems are: numeric

Reference:http://www.cnblogs.com/coconut_zhang/archive/2009/02/02/1382598.htmlHttp://blog.itpub.net/14766526/viewspace-1156100/Select GETDATE () as ' current date ',Datename (Year,getdate ()) as ' year ',Datename (Month,getdate ()) as ' month

The stored procedure (stored procedure) is sometimes called sproc, it is a real script, more accurately, it is batch processing (batch), but neither is very exact, it is stored with the database rather than in a separate file.The stored procedure

Today, my Mmssql 2000 suddenly bad use, the database server can be started, but enterprise management is not open, but also pop-up tips information, it is strange, never encountered such a situation.I thought the installation file for SQL Server was

MSDN to the official explanation: These three functions all return the last generated identity value. However, the "last" scope and the session defined in each of these functions are different.1. Ident_current returns the most recent identity value

Original: SQL Server Automation Operations series--about mail notification that something (. NET Developer Benefits)Requirements DescriptionIn our production environment, in most cases, we need to have our own operation and maintenance system,

Originally the project needs a tree structure, and then randomly chose a easyui tree open source Framework, and then encountered a problem, I want to recursively from the database structure, turn to JSON, how to do? Is it a recursive stitching

1. Returns a valueDECLARE @count int exec @count = testreturn \ ' 111\ ', \ ' 222\ ' select @count@count is the value returned is the INT type2. Return a data tableStart by creating a new data tableCREATE TABLE Test ( tmp_order_id varchar

It is very easy to create the same symmetric key. The symmetric keys created using the same key_source, algorithm, and Identity_value key options will be the same.--Create test use [temp]go--drop table enrypttest CREATE TABLE enrypttest (ID int not