Sharepoint - Asp.net - MVC - C# - Sql server - Jquery - Javascript

Keyboard Shorcuts (Microsoft Windows) 1. CTRL+C (Copy) 2. CTRL+X (Cut) 3. CTRL+V (Paste) 4. CTRL+Z (Undo) 5. DELETE (Delete) 6. SHIFT+DELETE (Delete the selected item permanently without placing the item in the Recycle Bin) 7. CTRL while dragging an item (Copy the selected item) 8. CTRL+SHIFT while dragging an item (Create a shortcut to the selected item) 9. F2 key (Rename the selected item) 10. CTRL+RIGHT ARROW (Move the insertion point to the beginning of the next word) 11. CTRL+LEFT ARROW (Move the insertion point to the beginning of the previous word) 12. CTRL+DOWN ARROW (Move the insertion point to the beginning of the next paragraph) 13. CTRL+UP ARROW (Move the insertion point to the beginning of the previous paragraph) 14. CTRL+SHIFT with any of the arrow keys (Highlight a block of text) SHIFT with any of the arrow keys (Select more than one item in a window or on the desktop, or select text in a document) 15. CTRL+A (Select all) 16. F3 key (Search for a file

Query to Find Column From All Tables of Database SELECT t.name AS table_name , SCHEMA_NAME ( schema_id ) AS schema_name , c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t. OBJECT_ID = c. OBJECT_ID WHERE c.name LIKE '%EmployeeID%' ORDER BY schema_name , table_name ;   Find Column Used in Stored Procedure – Search Stored Procedure for Column Name SELECT obj.Name SPName , sc. TEXT SPText FROM sys.syscomments sc INNER JOIN sys.objects obj ON sc.Id = obj. OBJECT_ID WHERE sc. TEXT LIKE '%' + 'Name Your Column Here' + '%' AND TYPE = 'P' How to search every table and field in a SQL Server Database CREATE   PROC  SearchAllTables (      @SearchStr   nvarchar ( 100 ) ) AS BEGIN      -- Copyright © 2002 Narayana Vyas Kondreddi. All rights reserved.      -- Purpose: To search all columns of all tables for a given search string      -- Written by: Narayana Vyas Kondreddi      -- Site: http://vyaskn.t