teach sql server

we open the database and connect to the server object,Then right-click Hang (specifically the database you are connected to, this is the one I used to connect with the SQL statement) property was originally without nt authority\system account, which I added myself, you also need to nt authority\system Add to User mapping, remote user and remote password is another database login password, generally with

Recently, I am working on a small project. I need to allow my colleagues to access the database under my computer, so I have to set up remote access to my database. It took a long time to complete the process, share your experience here. My environment is 64 Recently, I am working on a small project. I need to allow my colleagues to access the database under my computer, so I have to set up remote access to my database. It took a long time to complete the process, share your experience here. My

divides the enterprise-wide plans into multiple phases. The first phase should include sections that have the least complex user databases. This gives the team members a chance to practice before encountering more difficult mergers. This phase should also teach them how to handle user databases more easily between SQL Server as the database load changes over ti

TableNamedrop table TableNameSELECT * Into TableName from #Tmpdrop table #TmpThis duplication occurs because the table is poorly designed and the unique index columns are added to resolve.2, this kind of repetition problem usually requires to keep the first record in the duplicate record, the operation method is as followsSuppose there is a duplicate field name,address, which requires the result set to be unique for both fields Copy CodeThe code is as follows:Select Identity (int,1,1) as Autoid

and copying the security, you are about to start and run the SQL Server distributor, but you are still in the last step, even in the TCP/IP environment, SQL Server still needs to start named pipes to complete merge and copy tasks. Start SQL

is a return parameter. The value of this option can be returned to Exec [ute]. The output parameter can be used to return information to the call process. The text, ntext, and image parameters can be used as output parameters. The output parameter using the output keyword can be a placeholder cursor. N It indicates that up to 2100 parameter placeholders can be specified. {Recompile | encryption | recompile, encryption}Recompile indicates that SQL

Example: The company staff to take three shift system: 0:00 to the morning 8:00 for the first class, 8:00 to 4:00 for the second shift, 4:00 to the evening 12:00 for the third class. The employee signs with an electronic clock that automatically adds records to the SQL Server database. Sometimes, however, a night shift is required; even if the shift takes place the next day, it will still be considered the

Note: Many of the content in this article is also one of the most important links for merging and copying. Therefore, configuring publisher will be divided into two chapters for translation.) When SQL Server distributorAfter the configuration is complete, you can configure it as full as possible. SQL Server publisher P

Tags: style blog http use data reIn general, we create a database using SQL Server, and occasionally the column names in the table are incorrectly created when we create the base tables. Want to change the name of the list, there are generally many kinds of modification, but the complexity is not the same, some people to delete the entire table, re-established to achieve the modified column name ... It usua

SQL write ratio. netProgramThere is no smart prompt. You need to remember keywords, functions, or constantly copy table field names, user-defined functions, stored procedures, and so on. However, in vs2010, we can use smart prompts, as shown in the following figures: In the editor, Enter Shift + J (Note: In vs2010 development tool, CTRL + J should actually be SHIFT + J) to automatically open this smart prompt. This function is also available i

In the pop-up Add filterOn this page, you can list all the fields in the table in the left column. Double-click the cityid column to move it to Fileter statementTo add a condition like cityid = 1, which will reduce the number of data synchronized by the subscriber. Of course, the value here must be defined as a constant, so this is called Static Filter(Static query ). In our applications, it is normal to have millions of data entries in the table, but sometimes the data required by the device

Now make sure that the domain user configured in Article 2 has access to this PublicationSo we need to add this user SQL ServerAnd can manage and publish this Publication. Open our SQL Server, Expand SecurityFolder and right-click LoginsSelect New Login... InLogin-NewOn this pageSyncdomain/syncuserUser inputLogin NameText Box. InSelect a pageSelectUser Mapping

MSSQL has launched the image function since 2005. The SQL Server image is unreadable. The entire database is in the norecovery mode. SQL Server images can only be 1-to-1 images, but images and logshipping can be used to achieve one-to-many and image chains. SQL

columns are added to resolve.2, this kind of repetition problem usually requires to keep the first record in the duplicate record, the operation method is as followsSuppose there is a duplicate field name,address, which requires the result set to be unique for both fieldsSelect Identity (int,1,1) as Autoid, * into #Tmp from TableNameSelect min (autoid) as autoid into #Tmp2 from #Tmp Group by name,autoidSELECT * from #Tmp where autoid on (select Autoid from #tmp2)The last select is the result se

My current project includes a table with 62 million rows and more than 500 columns. Where the data comes from outside of SQL Server, they arrive in a table that identifies the primary key, and all remaining columns are saved in varchar (50). Problem solving There are many dates saved in YYYYMMDD format, which is the first question I have noticed. I'll change these dates to integer columns. Then I found th

　Instance 1: only the stored procedure of a single record set is returned. The table of bank deposits is as follows: 　Requirement 1: query the stored procedure of bankmoney Create procedure sp_query_bankmoneyAsSelect * From bankmoneyGoExec sp_query_bankmoney Note * you only need to replace the SQL statement with the name of the stored procedure during usage, which is convenient! 　Instance 2 (passing parameters to the stored procedure ): Add a record t

A few days ago also encountered a large log file problem, the actual size of the database is 600M, the actual size of the log file is 33M, but the log files occupy a space of 2.8G!!! Try a variety of ways, Shirnk DATABASE, TRUNCATE LOG file, there is no way to reduce the file. Anyway, this should be a bug in SQL Server. Then find the following code, you can reduce the log file to the size you want. Copy t

Optimizing queries can be a common thing for SQL Server optimizations. Since the optimization of database is a wide topic in itself, this article only talks about how to understand SQL Server query plan when optimizing query. After all, my knowledge of SQL

First: If the database backed up has two files, respectively. LDF and. MDF, open Enterprise Manager, right-click on the instance---All Tasks-append database, then select that. MDF file, it's OK. Or, in Query Analyzer, enter: Copy Code code as follows: sp_attach_db "Database name", "path \ filename. ldf", "path \ filename." MDF " There are two ways to backup a SQL Server database, one is

The following is my personal experience with the "SQL Server Analysis Services Tabular Model Table Modeling" tutorial available on MSDN, which contains a picture instance of each lesson, step-by-Step document import from a data source, creating a relationship , computed columns, metrics, hierarchies, perspectives, roles to deployment, and so on each stage, is believed to be a useful supplement to this tutor