SQL Server

CREATE function [dbo].[F_testfunc]( @v_id nvarchar(4000) ,@v_type nvarchar(4000) ) returns NVARCHAR(4000) asbegin Declare @str_res NVARCHAR(4000); Declare @str_id NVARCHAR(4000); Declare @str_code NVARCHAR(4000); Declare @str_name

Designing a database is actually a table in the design database. What should you pay attention to in order to design good one database? One purpose, 8 recommendations.A purpose "to minimize the number of tables, each table in as few columns as

The backup set holds a backup of a database other than the existing ' xxdb ' database.time 2014-04-25 11:03:39 csdn blog Similar article (0) original http://blog.csdn.net/wzhiu/article/ details/24459511 One:He backup set holds a backup of a

--Returns a result set consisting of a list of databases and log files contained in the backup set.--Main access to logical file namesUse masterRESTORE filelistonlyFrom DISK = ' g:\back. Bak

Because the project requires the management of MSSQL (multiple versions)There was an open-source project for Websqladmin, but the feeling was too weak, and the SQLDMO approach was a bit outdated.So consider the upgrade, there are probably several

1. Create a database2. View database InformationThere are several ways in which you can view database information in SQL Server, such as using catalog views, functions, stored procedures, and so on.2.1> using the catalog viewUse catalog view to view

Example code:DECLARE @TranCounter INT;SET @TranCounter = @ @TRANCOUNT;IF @TranCounter > 0 --Procedure Called when there is --An active transaction. --Create a savepoint to be able -- to roll back only the work done --In the procedure

define the table type first: CREATE TYPE T_bak_tables as TABLE (table_name VARCHAR (200)) then define the backup process: CREATE PROC sp_bak_tables @tbs t_bak_tables READONLY, @bak_path varchar asdeclare @now varchar (8) = CONVERT (varchar (8 ),

SQL Server 2005 Image authoringHere are the steps to proceed:-- ===========================================--whether it is the principal server, the mirror server, or the witness server--Except for special instructions, you need to ensure that the

In the course of doing the project today, I encountered a problem with the title, such as:The database uses the SQL Server2012 version, and the script to create the table is as follows:CREATE TABLE [dbo]. [Type]([TypeId] INT not NULL PRIMARY

When monitoring SQL Server, you can add metrics. However, only system resource-related metrics have data, and SQL Server-related metrics have no data.Workaround:Instead of adding SQL Server counters in system Resource graphs by adding Windows

1. Theory OF triggers:A trigger (Trigger) is a special type of stored procedure that is performed on a user's data on a tableA program that is triggered when an UPDATE, INSERT, and DELETE operation is performed. Triggers help to force references to

The following prompt appears when you open SQL Server:SQL2008 user ' sa ' Login failed (Error 18456)Workaround:1. Open the database --Log in to the database with Windows identity2. Security----logon name---SA---open property settings3, General-Set

1, DBCC FREEPROCCACHE;2. DBCC FREESYSTEMCACHE (' All ') | DBCC FREESYSTEMCACHE (' pool_name ');3, declare @dbid as int = db_id (' Studio '); DBCC FLUSHPROCINDB (@dbid);4. Disconnecting the database5. Turn Auto_Close on or off6. Use the following

1. Export informal ExcelEXEC Master. xp_cmdshell ' bcp t.dbo.tcad out D:\MySelf\output\Temp.xls-c-q-s '. "-U" sa "-P" sql2008 "'--Parameter: S is the SQL Server name; U is the user; P is the password2. Enable/disable xp_cmdshell--to-allow advanced

Select * fromBankInsert intoBankValues(10000)Insert intoBankValues(20000)--Open a transactionbegin Tran--Defining temporary variablesDeclare @num int = 0;UpdateBankSetBalance=Balance-15000 whereId=1Set @num = @num + @ @error;--Previous statement

SQL Server permissions can be divided into three categoriesOn the first type of server level:SELECT * from sys.fn_builtin_permissions (default)Where Class_desc like ' server ';　　　　The second type of database plane:SELECT * from

---Enable or disable all foreign KEY constraints on the specified table ALTER TABLE Pub_stru NOCHECK constraint all; ALTER TABLE Pub_stru CHECK constraint all; ---Build enables or disables the specified table FOREIGN KEY constraint for SQL

Tips for SQL Server addition, deletion, modification, and query Insert statement 1. Insert only the default value in the data: Insert into [DBTrain]. [dbo]. [log_info]Default values 2. In a field that can be null, if you want to set null, you can

To sum up the usage of sqlserver group by, sqlservergroup Today, we will summarize the usage of group by with examples. To sum up, group by: ALL, Cube, RollUP, Compute, Compute Create data script Create Table SalesInfo(Ctiy nvarchar (50 ),OrderDate