SUN Jiangong's technical blog

/*by Jiangong SUN*/Here i want to introduce how to generate sql sripts of database and there are several steps.1) find out the publishing wizard pathIt's here : "$windows$\Program Files\Mi

How to make an existing column to be auto-incremented

Local database deployment problems and fixtures

SQL data reader reading data performance test

BulkCopy from source table to destination table with a column whose type is different

How to save SQL Server data as Insert INTO SQL Script

What is Index and how it works in SQL Server?

How to activate saving table modifications

Knowledge Conclusion - PART III: Entity framework & SQL Server

/*Author: Jiangong SUN*/The error:Impossible de charger le fichier ou l'assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' ou une de ses dépendances. Le f

Table should have primary keyTable should have minimum of one clustered indexTable should have appropriate amount of non-clustered indexNon-clustered index should be created on columns of table

/*Author: Jiangong SUN*/I've made a web site prototype these days, I've found there are some useful information to share with you about some usual problems about users.1/ How to create

/*By Jiangong SUN*/这里我使用的是cursor 加上top函数来删除重复的列的。先建立一个表格Create table employees(code nvarchar(20) Primary key, value nvarchar(200), description nvarchar(1000));插入数据Insert into e

/*by Jiangong SUN*/Here I create a stored procedure for searching dealers in my database, it can receive several parameters.USE DATABASENAME;GOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER O

/*************written by Jiangong SUN**************/I will introduce you how to delete unecessary duplicate rows in a parent table.There are two tables:1) Table DBO_Dealers, which is

/*By Jiangong SUN*/If you want to backup and restore one database in SQL Server.Firstly, create a shared folder, and add everyone with read/write right.Secondly, backup your database....