Variable table name ms sql server

no allowed use dynamic sql instead.

build dynamic sql and then use exec or sp_executesql to run query

EXEC | EXECUTE

Example

DECLARE @table VARCHAR(50) = 'HR.Employees';
EXEC ( 'SELECT * FROM '+@table );

Example 2 [Stored Procedure]

DECLARE @ID INT = 34;
EXEC ( '[dbo].[p__Clean] '''+@ID+'''' );

How to determine the number of days in a month in SQL Server?

CREATE FUNCTION dbo.f__GetDaysInMonth(
                @Date DATE )
RETURNS TINYINT
AS
BEGIN
     DECLARE @Days TINYINT;
     SELECT @Days = DAY(DATEADD(month, DATEDIFF(MONTH, 0, @Date) + 1, -1));
 RETURN @Days
END;
GO
--Usage
SELECT dbo.f__GetDaysInMonth('11-Apr-2015')

There are uncommitted transactions. Do you wish to commit these before closing the window?

This happens when ANSI_DEFAULTS is set ON

which enables

SET ANSI_NULLS
SET CURSOR_CLOSE_ON_COMMIT
SET ANSI_NULL_DFLT_ON
SET IMPLICIT_TRANSACTIONS 
SET ANSI_PADDING
SET QUOTED_IDENTIFIER
SET ANSI_WARNINGS

and because of IMPLICIT_TRANSACTIONS transactions that are automatically opened as the result of this setting being ON must be explicitly committed or rolled back by the user at the end of the transaction

so you have to select commit and execute

List of known project type Guids visual studio

C#	{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}
VB.NET	{F184B08F-C81C-45F6-A57F-5ABD9991F28F}
C++	{8BC9CEB8-8B4A-11D0-8D11-00A0C91BC942}
F#	{F2A71F9B-5D33-465A-A702-920D77279786}
J#	{E6FDF86B-F3D1-11D4-8576-0002A516ECE8}
JScript	{262852C6-CD72-467D-83FE-5EEB1973A190}
Web Application	{349C5851-65DF-11DA-9384-00065B846F21}
Web Site	{E24C65DC-7377-472B-9ABA-BC803B73C61A}
Distributed System	{F135691A-BF7E-435D-8960-F99683D2D49C}
Windows Communication Foundation (WCF)	{3D9AD99F-2412-4246-B90B-4EAA41C64699}
Windows Presentation Foundation (WPF)	{60DC8134-EBA5-43B8-BCC9-BB4BC16C2548}
Visual Database Tools	{C252FEB5-A946-4202-B1D4-9916A0590387}
Database	{A9ACE9BB-CECE-4E62-9AA4-C7E7C5BD2124}
Database (other project types)	{4F174C21-8C12-11D0-8340-0000F80270F8}
Test	{3AC096D0-A1C2-E12C-1390-A8335801FDAB}
Legacy (2003) Smart Device (C#)	{20D4826A-C6FA-45DB-90F4-C717570B9F32}
Legacy (2003) Smart Device (VB.NET)	{CB4CE8C6-1BDB-4DC7-A4D3-65A1999772F8}
Smart Device (C#)	{4D628B5B-2FBC-4AA6-8C16-197242AEB884}
Smart Device (VB.NET)	{68B1623D-7FB9-47D8-8664-7ECEA3297D4F}
Workflow (C#)	{14822709-B5A1-4724-98CA-57A101D1B079}
Workflow (VB.NET)	{D59BE175-2ED0-4C54-BE3D-CDAA9F3214C8}
Deployment Merge Module	{06A35CCD-C46D-44D5-987B-CF40FF872267}
Deployment Cab	{3EA9E505-35AC-4774-B492-AD1749C4943A}
Deployment Setup	{978C614F-708E-4E1A-B201-565925725DBA}
Deployment Smart Device Cab	{AB322303-2255-48EF-A496-5904EB18DA55}
Visual Studio Tools for Applications (VSTA)	{A860303F-1F3F-4691-B57E-529FC101A107}
Visual Studio Tools for Office (VSTO)	{BAA0C2D2-18E2-41B9-852F-F413020CAA33}
SharePoint Workflow	{F8810EC1-6754-47FC-A15F-DFABD2E3FA90}
XNA (Windows)	{6D335F3A-9D43-41b4-9D22-F6F17C4BE596}
XNA (XBox)	{2DF5C3F4-5A5F-47a9-8E94-23B4456F55E2}
XNA (Zune)	{D399B71A-8929-442a-A9AC-8BEC78BB2433}
SharePoint (VB.NET)	{EC05E597-79D4-47f3-ADA0-324C4F7C7484}
SharePoint (C#)	{593B0543-81F6-4436-BA1E-4747859CAAE2}
Silverlight	{A1591282-1198-4647-A2B1-27E5FF5F6F3B}
ASP.NET MVC 1.0	{603C0E0B-DB56-11DC-BE95-000D561079B0}
ASP.NET MVC 2.0	{F85E285D-A4E0-4152-9332-AB1D724D3325}
ASP.NET MVC 3.0	{E53F8FEA-EAE0-44A6-8774-FFD645390401}
ASP.NET MVC 4.0	{E3E379DF-F4C6-4180-9B81-6769533ABE47}
Extensibility	{82B43B9B-A64C-4715-B499-D71E9CA2BD60}
Store App Windows Phone 8.1	{76F1466A-8B6D-4E39-A767-685A06062A39}
Store App Windows Phone 8.1 Silverlight (C#)	{C089C8C0-30E0-4E22-80C0-CE093F111A43}
Store App Windows Phone 8.1 Silverlight (VB.NET)	{DB03555F-0C8B-43BE-9FF9-57896B3C5E56}
Store App Windows 8.1	{BC8A1FFA-BEE3-4634-8014-F334798102B3}
Store App Universal	{D954291E-2A0B-460D-934E-DC6B0785DB48}
Store App Portable Universal	{786C830F-07A1-408B-BD7F-6EE04809D6DB}
LightSwitch	{8BB0C5E8-0616-4F60-8E55-A43933E57E9C}
LightSwitch Project	{581633EB-B896-402F-8E60-36F3DA191C85}
Office/SharePoint App	{C1CDDADD-2546-481F-9697-4EA41081F2FC}

Controlling order of serialization in asp net c#

use Order with XmlElement

public class ItemGroup
{
    [XmlElement(Order = 0)]
    public Reference Reference { get; set; }
    [XmlElement(Order = 1)]
    public Reference None { get; set; }
    [XmlElement(Order = 2)]
    public Reference Content { get; set; }
    [XmlElement(Order = 3)]
    public Reference Compile { get; set; }
}