程序人生

1. SQL Aggregate Functions  (聚合函数)

When copying the database using wizard in SQL server is failed, I use the following method to copy the database successfully.--backup the databasebackup database test1 to disk='c:\test1_full.

[175] Combine Two Tables[176] Second Highest Salary[177] Nth Highest Salary[178] Rank Scores[180] Consecutive Numbers[181] Employees Earning More Than Their Managers[182] Duplica

use masterGOdeclare @oldname varchar(50) = 'LldName'declare @newname varchar(50) = 'newName'exec ('Alter database '+ @oldname+ ' set single_user')exec ('sp_renamedb ' + @oldname + ' , '+ @newna

Declare @SSRSreportIDTable TABLE( ID int)Declare @UserNameTable Table( username nvarchar(50))INSERT INTO @SSRSReportIDTable Select SSRSReportID FROM SSRSReport WHERE SSRSReport.[SSRSRepor

The Script to create the countries and codeALTER TABLE [GeoCity]ADD [CountryName] NVARCHAR(128) NULLGODELETEFROM [GeoCity]WHERE [Region] IN ('')GOSELECT 'Afghanistan' [CountryName],'Ka

SELECT [Name]FROM [sys].[key_constraints]WHERE [type] = 'PK'AND OBJECT_NAME(parent_object_id) = N'PropertyChannel' ALTER TABLE [dbo].[PropertyChannel]DROP CONSTRAINT [PK_PropertyChannel_ID

1. Insert only one row of data2. Insert several rowsINSERT INTO [PropertyChannel] (PropertyId, ChannelId)SELECT 1, 2UNION ALLSELECT 1, 3UNION ALLSELECT 2, 1UNION ALLSELECT 2, 2UNION AL

1. SQL SELECT INTO Statement-- copy one table into a new tableSELECT *INTO newtable [IN externaldb]FROM table1-- copy only columns into the new tableSELECT colName(s)INTO newtable [IN ext

1. SQL SELECT INTO Statement-- copy one table into other tablesSELECT *INTO newtable [IN externaldb]FROM table1

1. SELECT TOP Clause--TOP used to specify the number of records to return,SQL SERVERSELECT TOP number|percent colNameFROM tableName

4. SQL Basic Statement-- SQL SELECT SyntaxSELECT column_name, column_name, *FROM table_name;

1. What is SQLSQL is for Structured Query Language. It used

SQL Joins are used to combine ROWS from two or more tables. Join operator is

Finally, the issue that the dynamical Sp not working on Entity framework is fixed by putting  'SET FMTONLY OFF' in the beginning of the stored procedure. When entity framework tries to retriev