Using SQL Server Joins: Inner, Outer, Cross, Self Join Statements

Using SQL Server Joins: Inner, Outer, Cross, Self Join Statements http://technet.microsoft.com/en-us/library/ms191472%28v=sql.105%29.aspx

Subquery Fundamentals http://technet.microsoft.com/en-us/library/ms189575%28v=sql.105%29.aspx

SQL Server Join Example http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/

How to use Cursor in Sql Server?

DECLARE CURSOR (Transact-SQL) http://technet.microsoft.com/en-us/library/ms180169.aspx

How to use Cursor in Sql http://www.codeproject.com/Tips/277847/How-to-use-Cursor-in-Sql

SQL Server Cursor Example http://www.mssqltips.com/sqlservertip/1599/sql-server-cursor-example/

Pivot tables

Pivot tables in SQL Server. A simple sample. http://blogs.msdn.com/b/spike/archive/2009/03/03/pivot-tables-in-sql-server-a-simple-sample.aspx

Using PIVOT and UNPIVOT http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

Simple Way To Use Pivot In SQL Query http://www.codeproject.com/Tips/500811/Simple-Way-To-Use-Pivot-In-SQL-Query

Working with Data-tier Application projects in Visual Studio 2010

From Channel 9: “Working with Data-tier Application projects in Visual Studio 2010”

“This demonstration shows the database-developer related enhancements in Visual Studio 2010 and introduces the concept of a data-tier application project. It shows how to issue T-SQL commands directly from within Visual Studio and how to work with graphical execution plans.” reference: http://channel9.msdn.com/Learn/Courses/SQL2008R2TrainingKit/SQL10R2UPD04/SQL10R2UPD04_DEMO_03

Database […]

Entity Framework / Core

From Start to Finish: ASP.NET Core, Entity Framework Core and Visual Studio Code https://www.youtube.com/watch?v=TZF46oPBHPc Code-First Development with Entity Framework 4 (huge tutorial about Entity Framework 4) http://weblogs.asp.net/scottgu/archive/2010/07/16/code-first-development-with-entity-framework-4.aspx Entity Framework 4.0 – How To POCO http://devtalk.dk/2009/05/22/Entity+Framework+40+How+To+POCO.aspx Getting Started Entity Framework – MS Quickstart Tutorial http://msdn.microsoft.com/en-us/library/bb386876.aspx ms tutorial – Model-First in the Entity Framework 4 http://msdn.microsoft.com/en-us/library/ff830362 Microsoft […]

sql server 2008 management studio says “Saving changes is not permitted…”

Sql Server 2008 Management Studio “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.” Tools > Options dialog box […]

Ms Sql Compact Edition Tools

SQL Server Compact Toolbox http://sqlcetoolbox.codeplex.com/ SQL Compact data and schema script utility http://exportsqlce.codeplex.com/ for more, check:

http://www.codeplex.com/site/search?query=SQL%20Server%20Mobile%20or%20Compact&ac=8

More tools available as commercial products Data Port Console Data Port Wizard http://www.primeworks-mobile.com/ […]

Sql Server Editions and Comparison

Sql Server 2005 Editions Comparison

http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx

 

Sql Server 2008 Editions Comparison

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

 

Compare Editions–Compact and Express for 2008

http://www.microsoft.com/sqlserver/2008/en/us/compare-specialized.aspx

 

Entity Framework can be used with Sql Server CE !

http://blogs.msdn.com/sqlservercompact/archive/2008/03/07/my-first-entity-application-against-sqlce.aspx

 

 

SQL Express v LocalDB v SQL Compact Edition https://blogs.msdn.microsoft.com/jerrynixon/2012/02/26/sql-express-v-localdb-v-sql-compact-edition/

 

 

 

[…]

xml bulk import to sql server

How to import XML into SQL Server with the XML Bulk Load component, using SQLXMLBulkLoad.SQLXMLBulkLoad Using SQLXML Bulk Load in the .NET Environment XML Bulk Load Examples (SQLXML 4.0)

Playing with Vertial and Horizontal Tables

Pivot Transformation SQL Server 2005 Integration Services – Part 38 – Pivot Transformation Horizontal vs. Vertical Database Design Using PIVOT and UNPIVOT

[…]