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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SELECT syntax
Can anyone explain the usage of this syntax in SQL Server 2000. SELECT TOP 1 1 FROM .....- mc81773
- Thread
- Replies: 1
- Forum: Visual Basic (Classic)
-
How to print from Query Analyzer
I have tried simple print statements and it works. Eg: DECLARE @CheckCnt int SELECT @CheckCnt=COUNT(*) FROM Table1 print @CheckCnt This prints the count. Now if I try this it doesn't print at all. Eg: DECLARE @Record_Identifier char(1) DECLARE Cursor1 CURSOR FOR SELECT Record_Identifier FROM...- mc81773
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
Beginner Question for @@ERROR
My question was very vague. I need to know why the error trapping didn't work. Thanks- mc81773
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Beginner Question for @@ERROR
I created a stored procedure that will return the error code if it fails. When executing the proc, I get the message like this and what is returned is Output Messages: Server: Msg 242, Level 16, State 3, Procedure p_load_data, Line 280 The conversion of a char data type to a datetime data type...- mc81773
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
-
Execute different commands using ADO
I am using DTS in SQL Server 2000. Inside DTS,using VB scripting modules I am trying to do the following: 1. Insert into ERRORLOG table. ERRORNUM varchar(5) ERRORdet varchar(50) 2. Execute a stored procedure. SQL Server : Server1.aaa.com UserID : mysuser Password : mypass Database : PYMT1... -
Convert string type to integer
I want to convert the string type to integer and then add 1 to that number. Then convert it back to string. This is my code now and doesn't work. 'Read the control file record ControlRecord = Controlfile.ReadLine 'Get the control number, This is string type LastControlNum = Mid(ControlRecord...
