sql server if then else

In daily work, it is often necessary to connect to a remote MS SQL Server database. Of course, the following connection errors are often present.Workaround:1. Set the database to allow remote connections, the DB instance name-right----> Properties---Connections----> Tick enable remote Connections to the this server.2. Turn on the TCP/IP protocol:

Label:Cmd Osql-s server name-e SQL file path ------------------------------------------------------ Recently encountered a problem, in SQL Server Query Analyzer executes a database script more than 100MB, found that the "trigger type is" System.OutOfMemoryException "exception", the Internet to check a bit, The main rea

Label:Initial selection ResultsSELECT * FROM WorddictionaryThe following is the alphabetical order by Chinese charactersSELECT * from Worddictionary ORDER by word collate chinese_prc_cs_as_ks_wswhich_ci (CS) is case sensitive, CI is not differentiated, CS is distinguished_ai (AS) are accent-sensitive, AI not differentiated, as differentiated_ki (KS) Whether the kana type is differentiated, KI does not differentiate, KS differentiates_WI (WS) Whether the width of the WI is differentiated, WS-Diff

server| Data | database | statement 1. View the version of the databaseSELECT @ @version2. View the machine operating system parameters of the databaseEXEC master.. xp_msver3. View Database Startup Parameterssp_configure4. View Database Startup timeSelect CONVERT (varchar, login_time,120) from master. sysprocesses where spid=1To view the database server name and instance nameprint '

SQL Server---Troubleshoot SQL Server data subtotals with caseNearly half a year has been responsible for the development and maintenance of a city's personnel file management system, before the customer gave a table, need me to summarize the data, and then fill in the table.Specific needs: Statistics of how many differ

1.sql Server Download installation package path: HTTP://PAN.BAIDU.COM/S/1QWUZDDQ2. Installation process illustration tutorial, reference URL: http://jingyan.baidu.com/album/948f592434b407d80ef5f97d.html?picindex=13Secret key:SQL Server 2008 Serial number:Developer:pttfm-x467g-p7rh2-3q6cg-4dmybEnterprise:jd8y6-hqg69-p9h84-xdtpg-34mbb3. Install after opening the fa

SQL server calculates the value of a field in the database, removes duplicate data, and SQL server Sometimes, some duplicate data exists in the database, but we want to calculate the value of a field, and we need to remove the duplicate data ,: In the preceding figure, we can see that all four pieces of data with id =

SQL server interview questions, SQL SERVER interview questions I went to the interview today and got caught by a small database problem. I am ashamed and brave. SQL interview questions 1. I can't help but want to say this, because the field type in the first question

1. View the version of the database SELECT @ @version 2. View the machine operating system parameters of the database EXEC master.. xp_msver 3. View Database Startup Parameters sp_configure 4. View Database Startup time Select CONVERT (varchar, login_time,120) from master. sysprocesses where spid=1 To view the database server name and instance name print ' Server Name ... ...: ' + CONVERT (varchar (), @ @SE

SQL Server lock queuing mechanism, SQL Server queuing mechanism 1. Create a new table and insert 1010000 data: create table test(id int identity(1,1) ,name varchar(600)) goinsert into testvalues(replicate('a',600));go 1010000create index idx_test_id on test(id) 2. Open A new session (A) and run the following state

Myth #5: AWE must be turned on in 64-bit SQL Server Error! The various versions of the set of awe that have been circulated are confusing. For example, how settings work, how settings don't work, whether you need awe on 32-bit and 64-bit. Well, let me summarize: In a 64-bit system (SQL SERVER 2005+ versio

Tags: des http io ar os for SP Strong onError:When click 'New Database Diagram', a error popped up and said 'attempted to read or write protected memory. This is often a indication that other memory is corrupt. (Microsoft.VisualStudio.OLE.Interop)"Related Link:https://social.msdn.microsoft.com/Forums/en-US/fa9df00f-49ba-4345-b036-423ae30a5d47/ problem-to-create-new-database-diagram-in-microsoft-sql-server-m

Method One: Using the graphical operation (GUI), open ssms (SQL Server Management Studio) The first step: Right-click the database you want to downgrade, press Select:Step Two: In the dialog box, in advanced, set as follows.Step three: Save the script and run the script in the lower version of SQL Server.Open the low-version