Transact-SQL SQL Server

SQL Server > Transact-SQL

Transact-SQL is Microsoft's proprietary extension to SQL (Structured Query Language).
All applications that communicate with SQL Server use Transact-SQL to send statements to the server, regardless of the user interface of the application.

SET Statements

• NOCOUNT
• XACT_ABORT

Mnagements Commands

• Kill

Code Collaborator Add Changes To Review Number

Code Collaborator > Add changes to review

addhgdiffs - Uploads diffs generated by hg diff command

Example

Upload from Mercurial

3883 is the review number

-r difference from revision 0 to 1

ccollab addhgdiffs 3883 -r 0 -r 1

-c specific revision id

ccollab addhgdiffs codereviewid -c revisionid

PARSE SQL Server Example

SQL Server > Built-in Functions > PARSE

Translates an expression to the requested data type.

Example

SELECT PARSE('3-11-2014' AS datetime USING 'en-US') AS Result_En

Result_En

2014-03-11 00:00:00.000

SELECT PARSE('3-11-2014' AS datetime USING 'de-DE') AS Result_De

Result_De

2014-11-03 00:00:00.000

Telerik Reporting Binding C# Example

Telerik > Reporting > ObjectDataSource

ObjectDataSource component represents the middle-tier object and provides data retrieval capabilities. 
Example

var ods = new Telerik.Reporting.ObjectDataSource();

ods.DataSource = GetData();

ods.DataMember = "Products"; //table to bind to        

Telerik.Reporting.Report report = new Telerik.Reporting.Report();

report.DataSource = ods;

Telerik.Reporting.InstanceReportSource reportSource = new Telerik.Reporting.InstanceReportSource();

reportSource.ReportDocument = report;

reportViewer1.ReportSource = reportSource;

reportViewer1.RefreshReport();

Get Computer Name C#

C#  > System > Environment Class > MachineName

Returns the computer's name. This is established at system start up when the name is read from the registry. 

Example

   string _name = Environment.MachineName;

ADO.NET LINQ to SQL

ADO.NET >  LINQ to SQL

Is a component for managing relational data as objects. 

• the data model of a relational database is mapped to an object model  
• translates into SQL the language-integrated queries in the object model and sends them to the database for execution
• translates database result  back to objects 

Methods

• DeleteOnSubmit

VB.NET LINQ TO SQL Delete Rows From Database

ADO.NET > LINQ TO SQL > Delete rows from database

DeleteOnSubmit removes entity, but does not disappear from the query results until after SubmitChanges is called. 

Example


C#

var deleteData =
    from details in db.GetDetails
    where details.ID == 1
    select details;

foreach (var detail in deleteData )
{
    db.Details.DeleteOnSubmit(detail);
}

try
{
    db.SubmitChanges();
}
catch (Exception e)
{
}

VB.Net

Dim deleteData = _

    From details In db.GetDetails() _

    Where details.ID = 1 _

    Select details

For Each detail As Detail In deleteData

    db.Details.DeleteOnSubmit(detail)

Next 

Try

    db.SubmitChanges()

Catch ex As Exception

End Try