Found the answer: SQL Server has an “OPENROWSET” command that accepts a filepath. eg Update myTable set Image = ( SELECT * FROM OPENROWSET(BULK N’C:\image.png’, SINGLE_BLOB) test) where ImageID = 1 Source: http://shortfastcode.blogspot.com/2009/12/insert-binary-data-like-images-into-sql.html
Do it like this: SET DATEFIRST 1 — Define beginning of week as Monday SELECT […] AND WorkDate >= dateadd(day, 1-datepart(dw, getdate()), CONVERT(date,getdate())) AND WorkDate < dateadd(day, 8-datepart(dw, getdate()), CONVERT(date,getdate())) Explanation: datepart(dw, getdate()) will return the number of the day in the current week, from 1 to 7, starting with whatever you specified using SET … Read more
I’ve been struggling with this one for while and when I recently installed Toad for MySQL I got the same issue. I installed sysInternals process monitor tool to try and work out which file was causing the issue. The answer is temp files. Both SQL server management studio and toad use a similar naming convention … Read more
If you mean that you want to be able to attach the database on another server, then this is what you can do: detach the database (right click the database and click Detach) copy the mdf and ldf files to your backup location attach the database (right click Databases and click Attach) This is the … Read more
Just this should work: COLUMNNAME NOT LIKE ‘%[_]xyz%’ You don’t need the ESCAPE here. What you wrote should also work. If you do want to use ESCAPE you could do this: columnname NOT LIKE ‘%\_xyz%’ ESCAPE ‘\’; Documentation on escape characters is here.
CTRL+H Find what: ‘, ‘ (No Quotes) Replace With: ‘, \n’ (No Quotes) Expand the Find options and tick the Use Regular Expressions checkbox.
I’ve been doing some testing, and it appears you do not need a record with a root hierarchyid. For example, normally you would one root node (level 1) and multiple childen, but you can skip the root node, having no root records, just records that start at level 2: //table schema CREATE TABLE [Entity]( [ID] … Read more
It depends on the recursion level for triggers currently set on the DB. If you do this: SP_CONFIGURE ‘nested_triggers’,0 GO RECONFIGURE GO Or this: ALTER DATABASE db_name SET RECURSIVE_TRIGGERS OFF That trigger above won’t be called again, and you would be safe (unless you get into some kind of deadlock; that could be possible but … Read more
You can use a Common Table expression to do that: WITH Top10Records AS ( select top 10 * from #MytempTable ) SELECT * FROM Top10Records GO
INSERT dbo.DataValue(DateStamp, ItemId, Value) SELECT DateStamp, ItemId, Value FROM dbo.tmp_holding_DataValue AS t WHERE NOT EXISTS (SELECT 1 FROM dbo.DataValue AS d WHERE DateStamp = t.DateStamp AND ItemId = t.ItemId);