Useful tips for everyday
How do you determine the first day of the week? Each day of the week is given a number. For instance, Sunday is the first…
What should you use to export from DB2 and import the data to SQL Server? SQL Server Migration Assistant (SSMA) for DB2 is a comprehensive…
How update last inserted row in SQL? 1 Answer INSERT dbo. table(column) SELECT 1; SELECT SCOPE_IDENTITY(); INSERT dbo. table(column) OUTPUT inserted. * SELECT 1; ALTER…
How to create a trigger to update a date field when record? This is the place for advice and discussions 0 0 A record’s field…
How long does TRUNCATE take? 1 Answer. If there are zero transactions locking the table schema, the TRUNCATE TABLE command will finish near-instantaneously. The most…
How do I publish a report in Report Builder? To publish a report part On the Report Builder menu, click Publish Report Parts. To save…
How do I grant permission to remote user in MySQL? Grant access Log in to your MySQL server locally as the root user by using…
How do I remotely connect to mysql on a Mac? 1 Answer To install MySQL client run this command in your terminal: $ brew install…
How can I improve my query time? 25 tips to Improve SQL Query Performance Use EXISTS instead of IN to check existence of data. Avoid…
What is keyspace in database? A keyspace (or key space) in a NoSQL data store is an object that holds together all column families of…