SQL Server

How to query the user's object permissions and roles in--sql server --Querying the user's object permissions exec sp_helprotect NULL, ' sa ' --Query user-owned role EXEC sp_helpuser ' public ' --Query which users have the specified system role exec

There are three ways to get the physical location of a database data file in SQL Server: sp_helpdb Bright Name filename Filegroup size ------------- ------------------------------- ---------- ----------- Bright Z:\MSSQL\data\Bright.mdf PRIMARY 101302

We know that the Oracle Database installation architecture can be 1 databases corresponding to 1 or more instances. In SQL Server, the schema is the exact opposite of Oracle, which is 1 instances (the default instance named hostname hostname)

Causes and resolutions of deadlock in SQL Server 2006-07-18 05:12:10Category: SQL ServerIn fact, the deepest cause of all deadlocks is one: resource competitionPerformance One:A User A accesses table A (locks up table A), then accesses table B,

SQL Server AlwaysOn is based on SQL Server 2012 and has been greatly increased, such as the ability to create hybrid solutions for AlwaysOn availability groups through the Add Azure Replica Wizard, and the maximum number of secondary replicas from 4

I asked this question on the CSDN forum, but no one talked me about it, and I finally got it done.The original link, there is no solution, the following provides a workaround.Confirm that the SQL Server service is openFirst, manage access from my

The main difference is that the connection protocol differs from the former (localhost) using the TCP protocol, which ("(local)") uses the Namedpipe protocol. Sample code with SQL Server connection strings often use localhost and (local)

The rationality of database structure and index affects the performance of database to a great extent, but with the increase of database information load, the performance of database is also greatly affected. Maybe our database has high performance

Get through the SQL Server System self-brought functionString sql ="INSERT into goods values ('"+ TextBox1.Text +"',"+ TextBox2.Text +", 0,"+ TextBox3.Text +", ', '"+ DropDownList1.SelectedItem.Text +"', '"+ session["username"]. ToString () +"', 0, '

One, time and date function1.Set Datefirst 1--setting Monday as the first day--datepart function to return a part of a time date--parameter 1 refers to which part is returned, and DW represents DayOfWeek--Parameter 2 refers to the time and date in

SELECT TOP 1000--Creation timeQs.creation_time,--Query statementsSUBSTRING (St.text, (QS.STATEMENT_START_OFFSET/2) +1,(Case Qs.statement_end_offset WHEN-1 then datalength (st.text)ELSE qs.statement_end_offset End-qs.statement_start_offset)/2) + 1)

In the application system, especially in the online thing processing system, the data query and processing speed have become the standard to measure the application system.The use of index to speed up the data processing speed has become the

Select CONVERT (varchar, GETDATE (), - ) 2004-09- AOne :: ,Select replace (replace (varchar, GETDATE (),),'-',"),'',"),':',‘‘)20040912110608Select CONVERT (varchar ((), GETDATE (),111 ) 2004/09/ ASelect CONVERT (varchar ((), GETDATE (), the ) 200

sp_help Sys_user--Table StructureSELECT Case whenCol.colorder= 1 ThenObj.nameELSE "' END astable name, Col.colorder asserial number, Col.name ascolumn name,ISNULL(ep.[value],"') ascolumn description, T.name asdata type, Col.length

This article discusses how to import a MySQL database into SQL Server, so first you need to install both databases, and then follow the steps below.I. Installing ODBC Drivers for MySQL1. Download MySQL ODBC Connector,

Emptying records from all data tables in SQL ServerClear all records in the data table:execsp_msforeachtable@Command1 ='truncate TABLE?'Delete all data tables: exec sp_msforeachtable ' Delete N "' ? " "Method of emptying all table data in a SQL

The recent system for testing companies needs to install databases such as SQL Server 2000,2005,2008,2008 r2,2012, and of course there are a variety of problems. Due to the existence of VMS, we can easily choose to install different versions of the

This article original website: http://blog.csdn.net/htl258/article/details/5695391------------------------------------------------------------------------------------author:htl258 (Tony)--Date: 2010-06-25 22:23:18--version:microsoft SQL Server (RTM)-

This morning, I learned about the use of primary and foreign keys in SQL Server and how to establish the connection between primary key and foreign key.In the afternoon, I learned how to apply the subquery inside SQL Server, and also practiced the

Analysis of Problems easily caused by modifying function names in SQL SERVER 1. Problem Today, I encountered a strange problem: the function definition name queried by using sp_helptext XXX is different from the function name, and sp_helptext is