You searched for the word(s): userid:756568

More Search Options

RSS Available

• Re: how to implement full text search and show the results in a gridview

  Sorry, I did not proof-read my reply and posted incorrect sample code. The T-SQL Statement that actually executes on SQL Server should end up like Contains([Description],' "black shoe" ') The Select Command in the ASPX page is fine. ADO.Net will add the single quotes but the double quotes need to included by you, when the parameter value is set. This is VB.Net syntax. e.Command.Parameters( "@Description") .Value = String.Concat(chr(34),txtSearch.Text,chr(34))

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/19/2008

• Re: how to implement full text search and show the results in a gridview

  I think multiple words, ie a phrase, need to be delimited with double quotes. Contains (@ Description , ' "black shoe " ' )

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/19/2008

• Re: like '%date%'

  [quote user="muybn"] I'm curious to know why this statement won't return all rows beginning with "2008-12-09" [/quote] The default format when converting a datetime to a string is mon dd yyyy hh:miAM (or PM). If you want to rely on the default, you would need to write Where CallDate Like '%Dec 9 2008%' Note that you need two spaces after the month name for days < 10 Also this statement CONVERT ( CHAR (10),callDATE,121) like '%2008-12-09%' There is no

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/10/2008

• Re: Stored procedure with multiple values

  Load the Ids into a local Table variable and then after the loop link the Hotel table to the local table. DECLARE @pos int , @nextpos int , @valuelen int Declare @List Table (ListId int) SELECT @pos = 0, @nextpos = 1 WHILE @nextpos > 0 BEGIN SELECT @nextpos = charindex( ',' , @list, @pos + 1) SELECT @valuelen = CASE WHEN @nextpos > 0 THEN @nextpos ELSE len (@list) + 1 END - @pos - 1 Insert Into @Table Values( convert ( int , substring (@list, @pos + 1, @valuelen))) SELECT @pos = @nextpos

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/7/2008

• Re: CROSS JOIN execution plan

  The fact that a Cross Join behaves like an Inner Join is irrelevant. The query still returns duplicate records because of the > and between criterias (not like the exact join in the sample site) and is why you need to use Distinct. I don't know how many records in each table you have but as data gets added the memory/io costs to run this query will keep increasing. In my test data I have 830 Orders of which 67 belong to UserId 6, I created a table with 100 announcements. The query returns

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/4/2008

• Re: won't return the results I want (Inner Join help)

  This is the reason why Outer Joins were invented. LEFT OUTER JOIN SiteNames ON CounselingSession.SiteKey = SiteNames.SiteKey With a Left Join (the Outer keyword is optional), if a CounselingSession.SiteKey does not exist in the SiteNames table all columns in the Selection List from the SiteNames table will be set to Null.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/3/2008

• Re: I want specific code to write it for reading data from table customer according to my code pleeeeeeeease help me

  Is there a question in there somewhere? If you want people to help you, take the time to format your post so that it is more readable.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/3/2008

• Re: Processing 'console' output from sql server -- impossible?

  Use the SQLConnection.InfoMessage event. http://msdn.microsoft.com/en-ca/library/a0hee08w(VS.80).aspx

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/3/2008

• Re: CROSS JOIN execution plan

  Since the final resultset does not include anything from tblOrder I don't think you need the Join at all (unless there are more requirements which you have not mentioned). And since are using Distinct in your sample, I think this query is all you need. Select * From tblAnnouncement Where OrderPlacedBeforeDate > (Select Min(OrderDate) From tblOrders Where UserId=?)

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 12/3/2008

• Re: T-SQL dynamically excluding fields from update statement

  You could use IsNull ,MoreInfo = IsNull(@MoreInfo, MoreInfo) However, the above still updates the MoreInfo field. The only way to exclude a field from being updated is to not include it in the Update statement. Use If statements or build and execute a dynamic sql string.

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by brucevde on 11/27/2008