Enclose the keywords in double quotes if you want to search exactly for control of SET @Keywords=””control of”” If you want to search for control and of, use the following: SET @Keywords=”control AND of” But server may consider of as a garbage or stop word, so in this case use the following: SET @Keywords=”control AND … Read more
Did you try first: ALTER TABLE <tablename> DROP CONSTRAINT defEmptyString; ?
Chances are that you are hitting on a problem with parameter sniffing. I suggest reading Slow in the Application, Fast in SSMS? by Erland Sommarskog to get a full understanding of the issue (long article but very good).
I’m not an SQL tuning expert, but joining hundreds of millions of rows on a VARCHAR field doesn’t sound like a good idea in any database system I know. You could try adding an integer column to each table and computing a hash on the NAME field that should get the possible matches to a … Read more
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
MySQL SELECT GROUP_CONCAT(t.prodid SEPARATOR ‘,’) FROM PRODUCTS t WHERE t.prodtype=”XYZ” Oracle: There is an excellent summary of the available string aggregation techniques on Tim Hall’s site. SQL Server 2005+ SELECT STUFF((SELECT ‘,’+ t.prodid FROM PRODUCTS t WHERE t.prodtype=”XYZ” FOR XML PATH(”)), 1, 1, ”)
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
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);
Have you tried to refresh the intellisense cache Edit -> Intellisense -> Refresh Local Cache (CTRL+Shift+R)
UPDATE table SET col_2 = col_1