Finally i'm back after a month of crazyness due to my webhost not performing up to its promise of 99.9% uptime. Enough with the rant and on with the article, today i'm going to talk about how to list databases in a SQL Server by just using T-SQL and then showing you how to truncate the logs on...
we have a number of batch scripts at work which executes sql-related tasks for each of our project releases. last time, i incorporated errorlevel checks so we know if there was a problem with the execution and in order to abort the rest of the operations if something else has gone wrong. i was surprised...
I came across this error ORA-00904 : "GetTotalItem": invalid identifier when I tried to call a local function inside a dynamic query. I am currently working with Oracle database (we’re using Oracle 9i). My task is to add additional field (TotalItem) in the existing query in the StoredProc1...
My current task in our project is majorly in MSSQL. I wanted to debug a chain of stored procedures and I have just found out that MS has removed debugging tools out of SQL Server 2005 client tools and relied more on visual studio's. I have experienced debugging both from SQL Server 2005 Query Analyzer...
Not being an SQL guy, i'm really not used to implicit commands from T-SQL. By implicit, I mean those simplified commands which does the same thing as those documented in every SQL books. I first encountered a query below from a teammate: FROM Table1 T1 JOIN Table2 ON ... Every book includes all those...