How do you backup a Sybase database? —
Here is the actual command I am using for backing up my sybase db. dump database rsdb to “/scott_backups/uasBackupTest.dmp” Let me know if this helps you out and I will update as I figure out better procedures.
Archive for the ‘SQL Issues and statements’ Category
SQL: How do you query filtering by last month data —
A small project I have is to create a report based on last months data. For Example right now we are in December Month # 12 , So If I have the report run on 12/01/2010 @ 12:33AM I want all the data for the month of November to come out and November as we [...]
How do you round millisecond to a second using T-SQL —
Here is the question: How do you round milliseconds to seconds using SQL? Here is the CODE “ CONVERT(VARCHAR,DATEADD(ms, ROUND(duration$ms, -3), 0),108) AS Duration” As you can see we use CONVERT, VARCHAR, DATEADD, ROUND, to do this and you can change the duration$ms column to your open so it changes 1350 to 00:00:01. Please let me [...]
SQL Question? Why use UNION? —
Okay I used this SQL Script to join two tables but a certain amount of rows has to be joined with another table, here is how i did it with a join and union operation
Code to update one column with a subquery that grabs the info from another column table. —
UPDATE tbl_grocery_inventory set col_curry_qty = col_curry_qty – 1 WHERE col_ID in (select col_id from tbl_fruit where col_id=2)