MarioBinder

cast([timeStamp] as date) = '2018-02-16' and
cast([timeStamp] as time) >= '06:00:00.000' and cast([timeStamp] as time) <= '07:00:00.000'

MarioBinder

select*
  FROM TABLE
  WHERE username like '%\_del' ESCAPE '\'

MarioBinder

var request = new XMLHttpRequest();

request.open('GET', 'https://api_deepli.nk', true);
request.onload = function () {

  // Begin accessing JSON data here
  var data = JSON.parse(this.response);

  if (request.status >= 200 && request.status < 400) {
    data.forEach(movie => {

MarioBinder

UPDATE s 
  SET s.IsFreezed = 1
  FROM [DBNAME].[dbo].[COLUMN] AS s
  INNER JOIN [DBNAME].[dbo].[COLUMN] AS m 
  ON s.Id = m.StatusId 
WHERE m.Subject = 'xxxxx' 
AND s.HasSent = 0;

MarioBinder

-- replaced the first old characters with new signs
update [DATABASE].[dbo].[TABLE] set COLUMN = stuff(COLUMN, 1, 12, 'E:\Daten\LIVE\')

MarioBinder

--offline
USE master
GO
ALTER DATABASE dbname
SET OFFLINE WITH ROLLBACK IMMEDIATE
GO

--online
USE master
GO

MarioBinder

Use dbname;
ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

Use master;
DROP DATABASE dbname;

MarioBinder

ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

ALTER DATABASE [dbname] MODIFY NAME = [dbname_new]
GO

ALTER DATABASE [dbname_new] SET MULTI_USER;    
GO

MarioBinder

public ActionResult Export(ViewModel model)
{
    var fileData = _repo.GetFile(model...);
    var serializer = new JavaScriptSerializer { MaxJsonLength = Int32.MaxValue, RecursionLimit = 100 };
    var dataJson = new DownloadAjaxResult(true)
    {
        File = fileData,
        Filename = model.Filename
    };
    return new ContentResult()

MarioBinder

//https://stackoverflow.com/a/17488875/119109
$.fn.serializeObject = function()
{
   var o = {};
   var a = this.serializeArray();
   $.each(a, function() {
       if (o[this.name]) {
           if (!o[this.name].push) {
               o[this.name] = [o[this.name]];
           }