![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
SQL Server
文章平均质量分 57
garcon1986
永远走在路上的前行者
关注实现细节,向专家进发!!!
展开
-
Generate sql script using sql server publishing wizard
/*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原创 2012-01-25 17:53:47 · 770 阅读 · 0 评论 -
MS SQL Server - How to change an existing column to auto-increment column
How to make an existing column to be auto-incremented原创 2015-03-27 06:55:25 · 2189 阅读 · 0 评论 -
Local database deployment problems and fixtures
Local database deployment problems and fixtures原创 2014-11-07 20:03:08 · 2189 阅读 · 0 评论 -
SQL data reader reading data performance test
SQL data reader reading data performance test原创 2014-08-13 00:59:59 · 1260 阅读 · 0 评论 -
BulkCopy from source table to destination table with a column whose type is different
BulkCopy from source table to destination table with a column whose type is different原创 2014-03-26 01:47:12 · 1902 阅读 · 0 评论 -
How to save SQL Server data as Insert INTO SQL Script
How to save SQL Server data as Insert INTO SQL Script原创 2014-03-08 01:28:45 · 1625 阅读 · 0 评论 -
What is Index and how it works in SQL Server?
What is Index and how it works in SQL Server?原创 2013-06-27 21:05:32 · 1514 阅读 · 0 评论 -
SQL Server Management Studio Tips : How to activate saving table modifications
How to activate saving table modifications原创 2013-06-28 18:19:08 · 736 阅读 · 0 评论 -
Knowledge Conclusion - PART III: Entity framework & SQL Server
Knowledge Conclusion - PART III: Entity framework & SQL Server原创 2012-03-06 17:02:57 · 2667 阅读 · 0 评论 -
SQL 2008 Installation error: Impossible de charger le fichier ou l'assembly System, Version=4.0.0.0
/*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原创 2013-06-28 17:09:51 · 1564 阅读 · 0 评论 -
SQL Optimization
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原创 2013-06-19 02:02:21 · 725 阅读 · 0 评论 -
SQL Server - User Accounts
/*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原创 2013-04-26 18:35:07 · 1019 阅读 · 0 评论 -
SQL Server使用触发器删除重复的列(Delete duplicate rows using cursor in SQL Server)
/*By Jiangong SUN*/这里我使用的是cursor 加上top函数来删除重复的列的。先建立一个表格Create table employees(code nvarchar(20) Primary key, value nvarchar(200), description nvarchar(1000));插入数据Insert into e原创 2011-08-30 03:11:19 · 1209 阅读 · 0 评论 -
Create stored procedure and integrate it into linq to entities
/*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原创 2012-01-04 04:59:09 · 1258 阅读 · 0 评论 -
How to delete duplicate rows without children in sql server
/*************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原创 2012-02-22 22:51:32 · 9586 阅读 · 0 评论 -
How to backup and restore database in SQL Server
/*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....原创 2015-04-04 00:40:58 · 2581 阅读 · 0 评论