SQL | knowit

Find a string by searching all tables in MSSQL

DECLARE @search_string VARCHAR(100), @table_name SYSNAME, @table_id INT, @column_name SYSNAME, @sql_string ...

SELECT tbl.name ,ius.last_user_update ,ius.user_updates ,ius.last_user_seek ,ius.last_user_scan ,ius.last_user_lookup ...

UPDATE dbo.Users SET dbo.Users.user_desc=b.user_desc FROM dbo.Users a INNER JOIN dbo.Users_new b ON a.user_id = b.user_id;

Select * into NEW TABLE_15_02_2107 from SOURCE TABLE;

SELECT d.Company, d.[Year], SUM(CASE WHEN [Month] = 01 THEN Transactions ELSE 0 END) AS Jan, SUM(CASE WHEN [Month] = 02 THEN...

SELECT user_id FROM `table name` ORDER BY marks DESC, date_added ASC --LIMIT 1

SET rowcount 1 DELETE FROM [IVR_CONFIG_DB].[dbo].[TBL_IVR_CUSTOMERS] WHERE [TXT_CUST_TEL_NUM] = '123456789' SET rowcount 0

SELECT [UCID] ,[STARTDATETIME] ,[ANI] as 'PHONE Number calling' ,[PHONE_NUM] as 'Identification Phone' ,[EVENT_VALUE_1] = case...

SELECT date = CONVERT(DATE,[STARTDATETIME]), EVENT_VALUE_1, count (*) FROM [NAV360DataSummary].[dbo].[TBL_REPORT_MAIN] where...

SELECT groupid.[Group_Id] FROM [nav360_231].[dbo].[Users_Groups] as groupid JOIN [nav360_231].[dbo].[Users] AS userim ON groupid.User_Id...