Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Why the ANSI-92 outer join sql statement fails but legacy sql succeed?
I have a table, customer. The following is the sql statement and its output: select C.ID, C.FNAME, C.LNAME, C.DATE FROM CUSTOMER C WHERE C.ID = 1007 3 John Smith 2005-10-05 00:00:00.000 4 Mary Brown NULL 5 Bill White NULL And another table, account_detail, with about 30 records in there...- 9295
- Thread
- Replies: 7
- Forum: Microsoft SQL Server: Programming
-
Why a transaction failed? How can we ensure a transaction work?
I have a stored procedure like the following (in between the two ----- lines): ------------------------------------ CREATE PROCEDURE abc @V1 int, @V2 money, @V3 int output AS ……... ……... Begin tran Insert or Update data Statement-1 IF (@@ERROR...- 9295
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
SQL Debugger does not work from within the Query Analyzer
I was trying to use the Transact-SQL Debugger. I went to Object Browser, found my stored procedure, right clicked and chosed "Debug". The "Debug Procedure" window came up. I entered values for all variables and clicked on the Execute button. I didn't see anything happen. I could not add...- 9295
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Need help on writing a join script
/* ===================================================================================== -- -- In the following sample database, there are three tables: VENDOR, PRODUCT and -- PRODUCT_PICTURE...- 9295
- Thread
- Replies: 17
- Forum: Microsoft SQL Server: Programming
