Search results for query: *

Thanks David...this article looks like it is going to be really helpful!

My company has two SQL Server databases which have data we would like to be searched via Sharepoint. It was my understanding that Sharepoint needs physical documents in a directory to index and then a search can be performed which returns the location of these documents. I have written some...

Thanks guys! Yes I needed to use commandtext to get it to work correctly.

How is this done in VB.Net? I have the following code but it is not working: rsGetNotes.Open("GetNotes"), CN, ADODB.CursorTypeEnum.adOpenStatic) I would have thought that the results of this recordset would now be located in rsGetNotes.Fields(0).value, but the recordset never even opens...

Tab is char(9) and spaces is char(32). You removed line feeds and carrige returns. The table here may help: http://www.asciitable.com/ You can also use the ASCII string function to find the others. ex: PRINT ASCII('a') -- The ASCII value of the letter "a" is 97

How is this done in VB.Net? I have the following code but it is not working: rsGetNotes.Open("GetNotes"), CN, ADODB.CursorTypeEnum.adOpenStatic) I would have thought that the results of this recordset would now be located in rsGetNotes.Fields(0).value, but the recordset never even opens...

I am attempting to use SQL Server # temp tables in my VB app. I create a #table in the app which creates the temp table that is a available for that particular session. The next step in my program is to run a cn.execute to insert into this table, however, this creates a new login processes in...

Thanks dbomrrsm ...with a few modifications this seemed work! set @insertstatement = 'insert into KbText_' + cast(@appid as varchar(25))+' select ''Yes'',' + @vtext1+ @vtext2+ @vtext3+ @vtext4+ @vtext5+ @vtext6 + ' TextData,' + cast(@appid as varchar(25)) exec(@insertstatement)

Within a stored procedure, I am trying to execute an insert statement which contains variables. The code for the insert is below: select @insertstatement = * 'insert into KbText_' + @appid select ''Yes'', ' + @vtext1 + @vtext2 + @vtext3 + @vtext4 + @vtext5 + @vtext6 + ' TextData ', + @appid...