alikrc

SELECT DISTINCT sc.id, 
                so.name 
FROM   syscomments sc 
       INNER JOIN sysobjects so 
         ON so.id = sc.id 
WHERE  sc.TEXT LIKE '%functionname%' 
ORDER  BY 2 

alikrc

SELECT FLOOR(25.9); --25

SELECT CEILING(25.1); --26

alikrc

select CONVERT(DATE,'2018-07-18 00:00:00') 

--RESULT: 2018-07-18

alikrc

	declare
	@id int--=123

	select @id

	select * from FOOTABLE t
	where	
		(@id is null or t.ID = @id) --if param is null it doesnt add the condition
   

alikrc

sp_helptext SpNameHere

alikrc

findstr "hello there" *.cs

ref:

https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/findstr

alikrc

operationtype	Description
1	  System Event
9	  Collect SQM data
10*	Workflow Operation
12	Update Match Code
25	Generate Full Text Catalog
27	Update Contract States

alikrc

Entity	Status (statecode)	Status Reason (statuscode)
Account (account)	0 Active	1 Active
	1 Inactive	2 Inactive
Activity (activitypointer)	0 Open	1 Open
	1 Completed	2 Completed
	2 Canceled	3 Canceled
	3 Scheduled	4 Scheduled
Appointment (appointment)	0 Open

alikrc

var url='http://example.com/movies.json';
fetch(url)
  .then(function(response) {
    console.log(response);
    return response.json();
  })
  .then(function(json) {
    console.log(JSON.stringify(json));
  });

alikrc

In Tools | Options | Keyboard...

1. Add CTRL+W as a Global shortcut for Window.CloseDocumentWindow
2. Remove the CTRL+W shortcut for Edit.SelectCurrentWord

The caveat to this is if you are used to using CTRL+W to select the current word. If you do, find another shortcut that works for that.