sql server if then else example

Usage Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->Exec sp_addlinkedserver @ server, @ srvproduct, @ provider, @ datasrc, @ location, @ provstr, @ catalog; Exec sp_addjavassrvlogin @ rmtsrvname, @ useself, @ locallogin, @ rmtuser, @ rmtpassword; Exec sp_serveroption @ server, @ optname, @ optvalue; Sp_helpserver Sp_incluservers Sp_dropserver For

(@ day as varchar (4 ))GO How to call user-defined functions in SQL Server Stored Procedures A function that returns a single value. It can be used as a variable, for example, select dbo. function Name (parameter 1, parameter 2 ,...) from... where abc = dbo. function Name (parameter 1, parameter 2 ...)The function that returns the table can be used as a data tab

Original: 17th--Configure SQL Server (1)--Configure more processors for SQL ServerObjective:SQL Server provides a system stored procedure, sp_configure, that can help you manage the configuration at the instance level. Microsoft recommends using the default configuration, but depending on the

SQL Server Stored Procedures and SQL Server Stored Procedures Stored Procedures in Transact-SQL are very similar to methods in Java. They can be called repeatedly. After the stored procedure is executed once, you can cache the statements so that the statements in the cache a

, you can buy a book to master the basic knowledge and then find a case to practice.If you only want to deal with a specific operation, you can directly view the SQL statements of that database, such as stored procedures and views.After the backup is done-for example, copy the SQL statement directly and paste it into the new text document and save it.If an error

4 methods for backing up databases from SQL Server and 4 methods for SQL Server 1. SQL server maintenance plan Here I will not explain it. This is relatively simple. It is nothing more than dragging two 'backup database' tasks and

Client protocols Aliases The Protocol is the same as (2). You can specify more configurations. 3. sp_configure/reconfigure Displays or changes the global configuration settings of the current server. Many configurations need to be set through sp_configure. Syntax: sp_configure [ [ @configname = ] 'option_name' [ , [ @configvalue = ] 'value' ] ] reconfigure For example: To configure advanced opti

Tags: blog http io ar using strong on file dataThe database is installed and the connection string is required for use in the program. How to write it? Take SQL Server R2 as an example.1, after installing SQL Server R2, similar to Oracle's Plsql tool.

not think of its impactThis parameter is a data-level option that can be set up to refer to　　What is the automatic parameterization of the case?In a simple parameterized mode, SQL Server automatically parameterize a adhoc SQL statement with only one execution mode, thus achieving the purpose of reusing the execution plan.What types of

in SQL Server. Each data page read from the disk is written back before it is used.Each row of this sys.dm_os_buffer_descriptors dynamic management view (DMV) represents each data page held by the current memory, and you can use this script to see how much space each database occupies in the data cache:1 SELECT Count(*)*8/1024x768 as 'Cached Size (MB)'2, Casedatabase_id3 when 32767 Then 'Resourc

status of the logical scheduler, as well as the health record type.Ring_buffer_memory_broker-Monitors the behavior of internal memory agents used to balance memory allocations between caches.Ring_buffer_security_error-Security-related error message. For example, a login failure may have more detailed information about the operating system error code.Ring_buffer_scheduler-The actual scheduler activity, like a context switch. You can reconstruct the ex

introduce the meaning of the message. [393] Waiting for SQL Server recovery database ... The SQL Server Agent service has started, but it cannot be configured and run because the msdb database is not yet available. Most of the configuration and settings for SQL

Tags: des blog http io ar os sp for strongAugust 30, 2012by pinal DAVE SQL server–beginning of SQL SERVER architecture–terminology–guest PostSQL Server Architecture is a very deep subject. Covering it in a single post was an almost impossible task. However, this subject was

SQL Server trigger and SQL Server triggerA trigger is a special type of stored procedure, which is different from the stored procedure we introduced earlier. A trigger is triggered by an event and automatically called for execution. The stored procedure can be called by the name of the stored procedure. Ø what is a tri

query through this statement: SELECT * FROM Sysfiles DBCC shrinkfile (1) 4. To minimize the log file (if it is SQL 7.0, this step can only be done in Query Analyzer) 　　Detach Database: Enterprise Manager--server--database--right key--detach database Delete log files on my Computer 　Additional databases: Enterprise Manager--server--database--right Key--add

As SQL Server 2008 gets more and more into the spotlight, there's a growing number of voices saying that SQL Server 2008 (Kaitmai) is just a patch pack for SQL Server 2005. That's what I thought, too, because we put too much atten

error|server| Program Error : "When connecting to SQL Server 2005, the default setting for SQL Server to disallow remote connections may cause this failure. (provider: Named pipe provider, error:40-cannot open a connection to SQL

1 SQL Server 2000 data import SQL Server 2005 In SQL Server 2000, backup the data, right-click in the database, select "Backup Database" under "All Tasks", pop up a dialog box, then click the "Add" button and enter the correspond