随笔分类 -  MSSQL For Beginner

SQL Basic
Part 16 Important concepts related to functions in sql server
摘要：Important concepts related to functions in sql server 阅读全文
posted @ 2015-10-10 12:21 Gester.Lin 阅读(207) 评论(0) 推荐(1)
Part 14 Mathematical functions in sql server
摘要：Part 29 Mathematical functions in sql server 阅读全文
posted @ 2015-10-10 12:11 Gester.Lin 阅读(238) 评论(0) 推荐(1)
Part 13 Cast and Convert functions in SQL Server
摘要：Part 28 Cast and Convert functions in SQL Server 阅读全文
posted @ 2015-10-10 12:10 Gester.Lin 阅读(195) 评论(0) 推荐(0)
Part 2 Creating, altering and dropping a database
摘要：A SQL Server database can be created, altered and dropped1. Graphically using SQL Server Management Studio (SSMS) or2. Using a Query To create the dat 阅读全文
posted @ 2015-10-10 11:57 Gester.Lin 阅读(196) 评论(0) 推荐(0)
Part 1 What is SSMS?
摘要：note that,SSMS is a client tool and not the server by itself,it is a developer machines connects to SQL Server. 阅读全文
posted @ 2015-10-10 11:57 Gester.Lin 阅读(177) 评论(0) 推荐(0)
Part 3 talking about constraint in sql
摘要：What is Foreign key and how to create a Foreign key constraint? Note:Foreign Keys are used to enforce(强制) database integrity(完整) . In layman's terms(一 阅读全文
posted @ 2015-10-10 11:56 Gester.Lin 阅读(303) 评论(0) 推荐(0)
Part 4 Identity Column in SQL Server
摘要：Identity Column in SQL Server If a column is marked as an identity column, then the values for this column are automatically generated, when you inser 阅读全文
posted @ 2015-10-10 11:56 Gester.Lin 阅读(464) 评论(0) 推荐(0)
Part 6 Group by in sql server
摘要： 阅读全文
posted @ 2015-10-10 11:55 Gester.Lin 阅读(145) 评论(0) 推荐(0)
Part 5 Select statement in sql server
摘要：Select specific or all columnsselect * from 表名select * from Studentselect 列名，列名... from 表名select name,age,email from StudentDistinct rowsselect distin... 阅读全文
posted @ 2015-10-10 11:55 Gester.Lin 阅读(192) 评论(0) 推荐(0)
Part 7 Joins in sql server
摘要：Joins in sql serverAdvanced or intelligent joins in sql serverSelf join in sql serverDifferent ways to replace NULL in sql server 阅读全文
posted @ 2015-10-10 11:55 Gester.Lin 阅读(402) 评论(0) 推荐(0)
Part 9 Union and union all in sql server
摘要：Union and union all in sql server 阅读全文
posted @ 2015-10-10 11:54 Gester.Lin 阅读(167) 评论(0) 推荐(0)
Part 8 Coalesce function in sql server
摘要： 阅读全文
posted @ 2015-10-10 11:54 Gester.Lin 阅读(140) 评论(0) 推荐(0)
Part 18 Indexes in sql server
摘要：Indexes in sql serverClustered and nonclustered indexes in sql serverUnique and Non Unique Indexes in sql serverAdvantages and disadvantages of indexe... 阅读全文
posted @ 2015-09-15 22:19 Gester.Lin 阅读(162) 评论(0) 推荐(0)
Part 17 Temporary tables in SQL Server
摘要：Temporary tables in SQL Server 阅读全文
posted @ 2015-09-15 21:26 Gester.Lin 阅读(214) 评论(0) 推荐(0)
Part 15 Scalar user defined functions in sql server
摘要：Scalar user defined functions in sql serverInline table valued functions in sql serverMulti statement table valued functions in sql server 阅读全文
posted @ 2015-09-15 21:20 Gester.Lin 阅读(246) 评论(0) 推荐(0)
Part 12 DateTime functions in SQL Server
摘要：DateTime functions in SQL ServerIsDate, Day, Month, Year and DateName DateTime functions in SQL ServerDatePart, DateAdd and DateDiff functions in SQL ... 阅读全文
posted @ 2015-09-15 01:31 Gester.Lin 阅读(271) 评论(0) 推荐(0)
Part 11 string functions in sql server
摘要：Built in string functions in sql server 2008LEFT, RIGHT, CHARINDEX and SUBSTRING functions in sql serverReplicate, Space, Patindex, Replace and Stuff ... 阅读全文
posted @ 2015-09-14 01:09 Gester.Lin 阅读(293) 评论(0) 推荐(0)
Part 10 Stored procedures in sql server
摘要：Stored procedures in sql serverStored procedures with output parametersStored procedure output parameters or return valuesAdvantages of stored procedu... 阅读全文
posted @ 2015-09-14 00:38 Gester.Lin 阅读(224) 评论(0) 推荐(0)