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

More Search Options

RSS Available

• Full-text search with '#' and '+' in keyword

  Searches by keyword containing pound '#' and plus '+' signs using a Sql Server 2005's Full-Text index, and functions 'freetext' and 'containstable' does not yield correct results matching the term, such as 'C#' and 'C++'. The returned results seems equivalent of ones returned by terms without the pound and plus signs. Could anyone shed some light on this?

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Yubo on 4/10/2009
  Filed under: containstable, Full text search, fulltext, freetext

• Database options using t-sql - PageVerify

  I encounter a requirement to get PageVerify database option value (CHECKSUM, NONE, or TornPageDetection) from sql server using t-sql? Could anybody shed some light? thanks, YB

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Yubo on 3/29/2007
  Filed under: TornPageDetection, checksum, database options

• Re: Stored procedures with multiple result sets

  No, unfortunately this is a pure t-sql task. No client side processing at all. thanks.

  Posted to Data Access and ObjectDataSource Control (Forum) by Yubo on 3/21/2007

• Re: Stored procedures with multiple result sets

  No. This is a pure t-sql task that is done totally on the server. No client applications here, or any ADO.NET.

  Posted to Data Access and ObjectDataSource Control (Forum) by Yubo on 3/19/2007

• Stored procedures with multiple result sets

  Hi, I have a requirement to access, through t-sql, records from multiple result sets returned from a stored procedure. Does anybody know the syntax on how to retrieve from the 1st or 2nd returned record set? thanks, YB

  Posted to Data Access and ObjectDataSource Control (Forum) by Yubo on 3/19/2007
  Filed under: multiple result sets, stored procedure

• Access Linked Server system function

  Could anyone shed some light on the syntax of accessing system function on a linked server? I'm trying to get the recovery models of databases on a linked. However using databasepropertyex locally generates wrong results. e.g. select databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases I tried select [server/databasename].databasepropertyex(name, 'recovery') RecoveryModel from [server/databasename].master.dbo.SysDatabases which does not work. Thanks

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Yubo on 3/16/2007

• Re: If conditional problem in T-Sql

  Hi, Thanks for your alternative way of querying system table for column existence. However the problem still persists: even though the EXISTS clause is evaluated to be false, the query engine is still trying to insert statement, resulting in an error: Server: Msg 207, Level 16, State 3, Line 6 Invalid column name 'ReportTitle'. This is a very strange phenomena. - Yubo

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Yubo on 1/31/2007

• If conditional problem in T-Sql

  I encounter a T-Sql problem related to if conditional processing: The following script execute an insert statement depending on whether column 'ReportTitle' exists in table ReportPreferences. However it gets executed even when ReportTitle column is not present. Could anyone offer some advice? IF(Coalesce(Col_length('ReportPreferences','ReportTitle'),0) > 0) Begin INSERT INTO dbo.Defaults SELECT FinancialPlannerID,ReportTitle FROM dbo.ReportPreferences end GO

  Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Yubo on 1/31/2007

• Smtpmail on hosting server

  I'm sending email messages using Smtpmail class on my 2.0 web application - code snippet as follows. However the hosting server would fail to deliver the emails, returning no error messages. ... Smtpmail.SmtpServer("smtp.[hostingserver].com"); SmtpMail.Send(mailMessage); ... Any one can shed some light on this issue? thanks, YB

  Posted to Web Forms (Forum) by Yubo on 10/6/2006

• Compiler Error Message: ASPNET: Make sure that the class defined in this code file matches the 'inherits' attribute

  I've been trying to resolve the error from my hosting server. The page compiles well a while ago, and the error emerges out of no where. Could anyone shed some light? aspx page directive: <%@ Page Language="C#" MasterPageFile="Default.master" Title="Home" CodeFile="Default.aspx.cs" Inherits="Default_aspx" %> Compiler Error Message: ASPNET: Make sure that the class defined in this code file matches the 'inherits' attribute, and that it extends the correct base class (e.g. Page or UserControl

  Posted to Web Forms (Forum) by Yubo on 8/15/2006