Tag Archives: sql

Find out anagram using SQL

Any word or phrase that exactly reproduces the letters in another order is an anagram. For example: “Hamlet” is an anagram of the word “Amleth”. We will show u a query today which can determine if two given words are … Continue reading

Posted in SQL, Database | Tagged , | Leave a comment

Avoid Concurrency problem while running SQL Server Jobs

Hello everyone, This time my problem was to delay the start of a SQL server job if another job is already running. Obviously, the reason for this is that the jobs use the same database resources. The sysjobhistory table in … Continue reading

Posted in SQL, Database, SSIS (SQL Server Integration Service) | Tagged , , , , , | Leave a comment

Get current user name for any query in SQL server

Just use ‘SYSTEM_USER’. Example: Select SYSTEM_USER

Posted in SQL, Database | Tagged , , | Leave a comment