SQL Server

DECLARE @CurrentTime VARCHAR( -),@FileName VARCHAR( $),@FileName2 VARCHAR( $),@FileName3 VARCHAR( $),@FileName4 VARCHAR( $),@FileName5 VARCHAR( $)SET @CurrentTime = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR,GETDATE(), -),'-','_'),' ','_'),':',"')

BEGINSET NOCOUNT on;If @_mode not in (' A ', ' M ', ' D ')BeginRAISERROR (' parameter Error! ', 16, 3);ReturnEnddeclare @rowcount int, @error int;If @_mode= ' A 'BeginInsert into Szdxinfo (id,bh,[name],nation) Select@Id, @Bh, @Name,@Nation;If @

Update Fct_stockmove set disabled=disabled^1 WHERE moveid= ' Dce268e0-2cb3-4d17-ac4e-0046fb459cad ';1. Using the take-back operatorUpdate T1 set C1=~C1;2. Use XOR operator for INT type operationUpdate T1 set c1=c1^1;3. Using arithmetic methods to

SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCreating a stored procedure in SQL Server will have the code above, what exactly does it mean?Ansi_nullsFor example, the following table, when there is a null value in column Column1.If ANSI_NULLS is on,

One of the reasons why SQL Server was used as the primary database instead of MySQL was that the single-machine SQL Server performance was much stronger than MySQL, and another reason was that most of the previous customer's system administrators

Original: SQL Server partition (top)Division development History The table-based partitioning feature provides flexibility and better performance for simplifying the creation and maintenance of partitioned tables. Functions that trace back to the

SQL Traversal parsingIn SQL stored procedures, functions, it is often necessary to use traversal (traversal table), where a cursor, temporal table, and other traversal methods are common. In the face of small data volume, these kinds of traversal

The first time you install SQL Server is version 2016, because "the win7-64 version of the system configuration is low", so it is unsuccessful.The second installation of version 2012, in the "Database engine configuration", the choice is "Add

DECLARE @DiscrepancyLoanNos varchar (max)Set @DiscrepancyLoanNos = ' 00123,00456,00789 'DECLARE @Loans Table(Loanno varchar (10))while (CHARINDEX (', ', @DiscrepancyLoanNos) <>0)BEGINInsert @Loans (Loanno) VALUES (substring (@DiscrepancyLoanNos,

Company to replace the computer, clear SQL Server remember the user name and passwordPlease follow the location found in the corresponding file SqlStudio.bin, and then delete it, please put 100 hearts, this file will be automatically generated.Note

SQL Server random data Extraction efficiency optimization2013-05-11 1 Comments Vegetable Light Collection I want to contributeSQL Server random data Extraction efficiency optimization Hermit I recently encountered a very tangled matter, is how to

--Field DECLARE @sql_colH VARCHAR (MAX) SELECT @sql_colH = ISNULL (@sql_colH + ', ', ') + QUOTENAME ([PARAM]) from (---row , first go to field SELECT * from Ate_data WHERE [email protected]) as A GROUP by [PARAM] Print @sql_colHSET @sql_table = '

Today, a very practical problem has been encountered in the work, the customer in the OA interface employee leave in the intermediate table provides a continuous period of leave records, for example: Zhang San, 2018-12-1 ~2018-12-31, sick leave, 31

Str= "Data Source=ip; Network LIBRARY=DBMSSOCN; Initial catalog= database; User Id=sa; Password=xx " stringstr = configurationmanager.appsettings["Con_mes"]; Try { using(SqlConnection conn =NewSqlConnection (str))

SQL Server learning and growth path, each technology learning process is worth to be memorable, and now Baidu on the sqlser on a lot of information, but are too miscellaneous, I hope to share a little easy to understand the dry, with everyone to

What is a stored procedureStored procedures are functions similar to those in the C language that are used to perform administrative tasks or to apply complex business rules. Stored procedures can take parameters, or they can return results(Contains

Original: SQL Server file operationIn the master database, SQL Server provides system-extended stored procedures, where some stored procedures are named starting with Xp_ and are used to process the operating system's files.One, determine whether

Trigger Name:DML triggers: Refers to triggers that are enabled when a DML event occurs in the database. A DML event is an INSERT, UPDATE, delete that modifies data in a table or view.DDL triggers: is enabled when a DDL event occurs in a server or

A: Database: Sqlserver2012 Enterprise EditionView database server, on-site situation, due to SQL Server licensing restrictions, only use 40 logical CPUs, the scene is 64 logical CPUs, there will be 24 logical CPUs are idle, and SQL Server 2012

Based on Event triggering between vue sibling components (detailed description), vue triggering Go straight to the topic! An event is triggered between sibling components. The general idea is to exchange data with parent components, and watch is