Favorites: SqlServer

Source: Internet
Author: User
Tags switch case
CSDN: forum. csdn. netblistmssqldiy tribe SQL manual basic concepts: 1. View. Stored Procedure 3. Trigger 4. Custom function 5. cursor 6. Transaction

CSDN: http://forum.csdn.net/blist/mssql/ =================================================== =============== diy tribe SQL manual ================================== ============================ basic concepts: 1. view 2. stored Procedure 3. trigger 4. custom functions 5. cursor 6. transaction ================

Http://forum.csdn.net/blist/mssql/ (CSDN)
========================================================== ==============

Diy tribeSQL Manual
========================================================== ==============

Basic concepts:1. View2. Stored Procedure3. Trigger4. User-Defined Functions5. cursor 6. Transaction

========================================================== ==============
Some knowledge about SQL server databases:
Http://www.cnblogs.com/eflylab/category/80219.html
Http://www.cnblogs.com/goooto/favorite/123109.html
Http://www.dmblogs.com/nzblog/default.asp? Cateid = 3 & page = 1
Http://blog.csdn.net/fcuandy
========================================================== ==============

Classic SQL statements
(Note) how to judge whether the database field is not null or not ""
[Generate data dictionary] retrieve the description of fields in the database table
SQL ServerStored Procedure
SQLStored ProcedureLearning
With Input and Output ParametersStored ProcedureIntroduction
Calling SQL in C #Stored Procedure(Example with input and output parameters)
T-SQL Study Notes-Program Design Basics-Custom Functions
T-SQLCursorUse
Create in SQLTrigger 
How to Develop your own SQL Server 2000Trigger
SQLTransactionsAutomatic rollback (notes)
Does SQL server determine whether *** exists ???
========================================================== ==============
Paging storage process:
Personal paging Stored Procedure
SQL Server paging sorting Stored Procedure V1.0
ROW_NUMBER () usage _ (personal experience)
SQL Server 2005 ROW_NUMBER () function implementation Paging
Row_Number () function in SQL Server 2005
Code for Efficiency Test of large data volume paging stored procedures
ASP. NET high-efficiency paging stored procedure test passed
Custom pages of ASP. NET 2.0 on SQL Server 2005
========================================================== ==============
[Database] design skills for 14 databases
Database Design Skills
Database Design Skills: What do you know?
Database Design Skills
Database Design Experience
60 skills in Database Design/guidelines for Database Design
========================================================== ==============
Write efficient SQL queries (I)
Write efficient SQL queries (II)
Write efficient SQL queries (III)
Write efficient SQL queries (IV)
Write efficient SQL queries (V)
========================================================== ==============
Lock Overview
SQL Server deadlock Summary
SQL lock mechanism advanced
Database deadlock Problem and Solution
========================================================== ==============

Differences between temporary tables and table variables in SQL Server
Differences between system temporary tables and user temporary tables
========================================================== ==============
Dynamic SQL
Difference between SQL SERVER: EXEC and sp_executesql
========================================================== ==============
Common SQL date processing functions
SQL-datediff function (used in time difference calculation ,,,)
SQL statement date addition dateadd ()
Use the convert function in SQL to query dates
========================================================== ==============
@ Identity
Be careful when using @ identity
Scope_identity ()
Ident_current ('table name ')
========================================================== ==============
Select... from... where... group by... having... order...
SQL statements (common) Create, delete, and modify table Structures
Alter table image alter column id int IDENTITY (1, 1) not null help me see if the statement is correct !!
Remove duplicate values with multiple columns as condition in SQL query
(Record merging) Difference between union and union all
SQL batch import data instances
Table update table (batch) Operation example
SQL String Array Operations
Common SQL function statements
Is there a switch case statement similar to the C language in SQL ???
========================================================== ==============
Changing SQL columns and columns
Questions about the trigger (focusing on the Post-trigger)
Order generation in SQL
SQL Server reference: Selection of char and varchar (experience)
Problems found when using the float type in SqlServer
SQL Server 2005 Client installation and port settings
PowerDesigner tutorial-Conceptual Data Model
Set nocount on/OFF

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.