sql server northwind database

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

Execute SQL Server database backup and SQL database backup using Windows batch processing commands Create mybackup. bat and enter the following content to directly run the script to start automatic database backup. You can also ad

Tags: style blog http io color OS SP for strongTo synchronize data from Oracle in real time to MS SQL Server, you need to read and write data directly to SQL Server in Oracle, and you can install the Oracle database for SQL Server

local or global temporary table. A local temporary table is visible only in the current session, and the global Temporary tables are visible in all sessions. Prefix the name of a local temporary table with a single number ((#table_name), while the name of the global temporary table Prefix (# #table_name) preceded by a two-digit number. Queries against temporary tables perform very quickly because they usually take a result set with only one Tables instead of dynamically connecting multiple tabl

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 wher

SQL Server restoration options: -- Create a backup device Sp_addumpdevice ' Disk ' , Jasonbak, ' C: \ Jason. Bak ' -- Backup Backup Database Northwind To Jasonbak With Noinit -- (Additional, default when no parameter is added) With Init -- (Rewrite the b

T-SQL statement to modify the logic name, database name, and physical name of the SQL Server database, t-sqlsql This example describes how to modify the logical name, database name, and physical name of the

like '% @ str %'Create an encrypted stored procedure or function WITH the with encryption parameter before theYou can use sp_decrypt to decrypt encrypted stored procedures and functions.10. View user and process information in the databaseSp_whoView information about active users and processes in the SQL Server databaseSp_who 'active'View the locks in the SQL

parameter mode, what problems the automation parameters will bring, and how to solve them.The problem itself is very simple, if you do not notice still occasionally will appear confused. Off Topic Have a little feeling very deep, that is, more and more practical problems, have to have theoretical knowledge to support,But it is often theoretically said that the situation does not appear frequently or even if there is no attention, there is time to neglect some theoretical knowledge.For the prob

very deep, that is, more and more practical problems, have to have theoretical knowledge to support,But it is often theoretically said that the situation does not appear frequently or even if there is no attention, there is time to neglect some theoretical knowledge.For the problems encountered, if you really want to find out, still have some theoretical knowledge to do the groundwork. Many times, often after encountering problems, recalled once good seems to have seen this aspect of theoretica

I. Back up the database1. Open SQL Enterprise Manager and click Microsoft SQL Server in the root directory of the console.2. SQL Server group --> double-click to open your Server --> double-click to open the

store all the backup history. The SQL Server Agent will use this library. Sample Database Northwind sample Database The Northwind Traders sample database