Unnikrishnan R questions

Unnikrishnan R answers

• Ordering based on number value in a string from SQL
• How can I add Hour and minute in a single query
• Both left and right aliases encountered in Hive JOIN; without any inequality clause
• Checking Truncate/Alter Permission for a login
• SQL Server execute (sp_executesql ) command in SQL function
• How to use a variable in Openrowset command
• Can we write case statement without having else statement
• Is is safe to use @@IDENTITY in a transaction?
• Query to select and combine uppermost and lowermost value from tables