Alex questions

Alex answers

• In SQL Server, what are the data types that we could not include in Insert statement?
• SQL Server - While Loop vs "LOCAL STATIC READ_ONLY FORWARD_ONLY" Cursor
• SQL Server : drop all databases except the system ones
• OHCL (Open-high-low-close) T-SQL Query
• How to test performance of the stored procedure in SQL Server Management Studio
• Is there a way to manually set @@ROWCOUNT?
• Sybase inserts a single space in place of the empty string ''
• SSMS: Pipe Delimited output
• Alternative to sys.columns.max_length
• Recursively retrieve LAG() value of previous record