JodyT questions

JodyT answers

• INSERT a row only with default or null values
• Query to find Number of Parameters in a Stored Procedure or Function in Sql Server?
• How to use index in SQL query
• SELECT during a lengthy UPDATE - What happens to SELECT for different Transaction Isolation Levels and SELECT WITH (NOLOCK)?
• Writing a function to select data only on weekdays in PostgreSQL
• Insert into h2 table if not exists
• Create a new table and adding a primary key using SELECT INTO
• How to send a query result in CSV format?
• Generating SSIS packages with BIML that use Stored Procedures with temp tables
• List db_owner privileges on each database for a user