|
||||||
|
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/ 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 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 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 […] 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 “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 […] 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 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/
[…] 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) Pivot Transformation SQL Server 2005 Integration Services – Part 38 – Pivot Transformation Horizontal vs. Vertical Database Design Using PIVOT and UNPIVOT […] |
||||||
|
Copyright © 2018 Alen Malhasoglu's Blog - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
