Month: July 2017

No Image

SQL: DB/ Table Queries

July 3, 2017 hung-nb 0

SQL Server Management Studio How to find a certain string inside a stored procedure/ function [sql]SELECT OBJECT_NAME(object_id) FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, ‘IsProcedure’) = 1 AND […]

No Image

SQL statements – SELECT

July 2, 2017 hung-nb 0

How to know number of rows being affected by SELECT/INSERT/UPDATE…? SQL Server[sql] UPDATE Employee SET JobTitle = N’Executive’ WHERE NationalIDNumber = 123456789 IF @@ROWCOUNT = […]