Viewing 15 posts - 2,791 through 2,805 (of 3,221 total)
First this clause of your statement:
select s.sno from t,s where s.sid=t.sid and t.sno is null
will return more than a single value, this then yieds the error
Msg 512, Level 16,...
November 9, 2008 at 11:47 am
Have you searched the Microsoft download site for servers at
For the appropriate Books On Line for 6.5
November 7, 2008 at 11:52 am
Is this the error message you get?
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near '#'.
If not then please assist others to assist you by following the suggested posting...
November 7, 2008 at 11:40 am
Although it is included only for backwards compatibility ... look at the BOL explanation of the syscomments table which contains the text for all stored procedures. True you would...
November 7, 2008 at 11:30 am
Wally
Are you sure the data type for the column is TEXT, or is it VARCHAR, or CHAR? I presume that you are not checking for more or less than...
November 7, 2008 at 11:11 am
I am sure someone would be able to help you if you posted more information.... Please read the article whose link is in my signature block and follow those instructions...
November 5, 2008 at 8:16 pm
barathvaj.s
See above - clicked twice on the dang button
November 5, 2008 at 8:06 pm
barathvaj.s
READ the article whose link is in Lynn Pettis signature block and give us some more information so that we may help you. For example how is the data...
November 5, 2008 at 8:05 pm
Sabid.m
Use Books On Line (BOL) and read up on the "Openrowset" command. It can be utilized to read from a csv file, an Excel Spread Sheet as well as...
November 5, 2008 at 7:54 pm
Willkane.accounts
Could you expand the data a bit?
Read the article in my signature block to get an idea of what I mean asking this question.
October 19, 2008 at 5:05 pm
obarahmeh I created a table as:
CREATE TABLE [dbo].[DTable](
[Dvalue] [numeric](15, 4) NULL,
[Comment] [varchar](50) NULL
) ON [PRIMARY]
END
Entered various values and then used the following T-SQL statement to return the values
SELECT Dvalue AS...
October 19, 2008 at 4:55 pm
Assuming that the "number" is actually a CHAR or VARCHAR and NOT numeric use the SUBSTRING function for example:
DECLARE @Unk AS VARCHAR(10)
DECLARE @Ans AS VARCHAR(20)
SET @Unk = '14690573010'
SET @Ans =...
October 19, 2008 at 6:55 am
Ninja's RGR'us
Notify the 2nd app using the SHELL command for example:
Public Const WIN_NORMAL = 1 'Open Normal
Private Declare Function apiShellExecute Lib...
October 18, 2008 at 12:32 pm
dr_csharp.
I would use an alternate approach - when App 1 does the insert using either a dynamic sql statement or a parameterized stored procedure with a return value. Then...
October 18, 2008 at 10:25 am
If you must use a cursor Refer to books on line for 2 methods:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/dataacc9/html/ff404e02-630f-474d-b5d4-06442b756991.htm
Remember a cursor is an agonizing row by agonizing row operation it would be more efficient to...
October 18, 2008 at 7:00 am
Viewing 15 posts - 2,791 through 2,805 (of 3,221 total)