SQL Server

--several commonly used custom SQL functions for digital processing--decimal starts with no 0 and end superfluous 0 handlesCREATE function [dbo].[formatfloat](@dec decimal( -,Ten)) returns varchar( -) as begin Declare @inValue varchar( -); Set

I. BACKGROUNDOriginally learned the relevant content of the database, just form, never practiced, slowly drifting just, now in the engine room, a lot of knowledge needs to use the view, only to begin to slowly practice.View: What I understand is a

ObjectiveCompany to carry out a project, according to the customer's mobile phone location to obtain accurate ads around, in particular, the Administrator on the map to draw polygons on the advertising range, fall within the scope of the customer to

Took some time to complete the look over, feeling that this is a concise version of the reference book, there are many demos can be done in full, basically involved as all functions, can have a holistic understanding of as, about the last

The previous database installed in the virtual machine, today on the machine installed a SQL2008, remote connection to the virtual machine on the SQL Server, after the drop database test to delete the previous tests failed, prompting "cannot delete

Lock hint DescriptionThe HOLDLOCK retains the shared lock until the transaction completes, instead of releasing the lock as soon as the corresponding table, row, or data page is no longer needed. HOLDLOCK is equivalent to SERIALIZABLE.NOLOCKDo not

SQL Server 2008 opens the remote Access database1. Enter the database Manager in Windows Authentication mode.Step Two: Right-click the SA and select Properties:In the General tab, re-fill in the Password and confirm the password (changed to a good

Use CRM--Current database creation roleexec sp_addrole ' Rapp '--Assign View permissions GRANT SELECT on veiw to [role]--Specify the View listGRANT SELECT on v_city to RappGRANT SELECT on V_LP to RappGRANT SELECT on v_qy to RappGo--Add only users

--A stored procedure that generates INSERT statements based on data in a tableCreate Proc Proc_insert (@tablename varchar (256))As--table nameBeginSET NOCOUNT ONDeclare @sqlstr varchar (4000),@sqlstr1 varchar (4000),@sqlstr2 varchar (4000)Select

1, sysobjectsThe System Object table. Objects that hold the current database, such as constraints, default values, logs, rules, stored procedures, and so onsysobjects important field Explanation:SysObjects (Name sysname,--object namesID int,--object

In our daily development process, when designing a database, we often encounter problems with selecting data types, choosing what type of data is most appropriate, and then choosing the corresponding CLR type when we create the corresponding entity

SQL statements that generate 300 different random numbers and SQL statements with random numbers -- Generate 300 random numbers with no duplicates DECLARE @ I INT = 0; DECLARE @ j INT; DECLARE @ qnum INT = 300; -- number of random numbers generated

In SQL Server, use sp_password to reset the SA password instance and sp_passwordsa The following error occurs when the SA password of SQL2000 cannot be changed:Copy codeThe Code is as follows: Error 21776: [SQL-DMO] the name 'dbo' was not found in

Only the first and first of the duplicate data are retained. -- CREATE test TABLE [dbo]. [testtab] ([id] [nchar] (10) NULL, [name] [nchar] (10) NULL ); -- insert test data into the test table: insert into testtab values ('1', '1'); insert into

SQL Server paging query common stored procedures (only for paging query), SQL stored procedures It has been used since the project was started. SORRY, the creator of this stored procedure, wrote this SQL code very well. On this basis, I adjusted the

SQL statement UNION intersection JOIN (inner JOIN, Outer JOIN) and so on, unionjoin1. a. union select column1, column2 FROM table1 union select column1, column2 FROM table2b. intersection join select * FROM table1 AS a JOIN table2 B ON. name = B.

In Linux, use BIEE to connect to the SQLServer business data source, bieesqlserver 1. Client First, configure the odbc data source on the client. You can directly enter odbcad32 in the running state to open the configuration interface-System

In-depth analysis of mssql in high frequency, high concurrency access key to find the deadlock problem, a simple description of mssql Deadlock is no stranger to DBAs or database developers. It can lead to a variety of causes. In general, database

SQL Server database bcp export backup file application /** * Authorization */ EXEC sp_configure 'show advanced options', 1; Go Reconfigure; Go Exec sp_configure 'xp _ Your shell', 1; Go Reconfigure; Go /** Import the text file of the specified table

SQL replace cursor writing example, SQL cursor writing example Update Tb_Garden1 G Set Steward = (Select Id From Zyq. tb_User U Where Replace (U. name, 'region') = G. name And Rownum = 1) where exists (select 1 from zyq. tb_user u where Replace (U.