.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

How to write storeprocedure update special character in Sql server 2005

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :ASP.Net

Hi All,

I am using Sql Server 2005,My table structure is below.

Create Table ComentTable(id int,coments varchar(4000))

insert into ComentTable values(1,'sanjay I don%27t Know Tamil Language')

insert into ComentTable values(1,'sanjay I don%27t Know Kanar Language')

how to write storeprocedure update coments column replace %27 to '

View Complete Post

More Related Resource Links

SQL Server 2005 Express Edition Service Pack 3 (KB955706) update is successful but repeats installin

  Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) (update 1 of 1) This update seems to be stuck in a loop of installing, each time it successfull installs acccording to automatic updates. Then says it requires installing again straight away. This has been happening for 10 days now. I have tried a manual update from the website rather than automatic updates, no change. Any ideas why? Have posted in Windows update which is where I think the problem lies but they have suggested I post here also.

Update SQL Server 2005 SP3 KB970892

Hi guys, When I try to install the SP at the server with SQL 2005 Express Edition I get the following error message: EventID: 1023 Source: MsiInstaller Product: Microsoft SQL Server 2005 Express Edition - Update 'GDR 4053 for SQL Server Database Services 2005 ENU (KB970892)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files (x86)\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB970892_sqlrun_sql.msp.log. EventID: 10005 Source: MsiInstaller Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation. I tried this article but it does not help: http://support.microsoft.com/kb/925976/de I read an article to install some iis components but is this realy necessary? Thank a lot and best regards Christian LOG: === Verbose logging started: 9/9/2010  13:53:24  Build type: SHIP UNICODE 5.00.7600.00  Calling process: d:\51983bd1d61113e85006\hotfix.exe === MSI (c) (D8:18) [13:53:24:868]: Resetting cached policy values MSI (c) (D8:18) [13:53:24:868]: Machine policy value 'Debug' is 0 MSI (c) (D8:18) [13:53:24:868]: ******* RunEngine:            ******* Product: {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}   

SQL Server 2005 Service Pack 2 available on Microsoft Update (MU)


Service Pack 2 for SQL Server 2005, SQL Server 2005 Express, Server 2005 Server 2005 Express Advanced, and Server 2005 Express Toolkit has been published to Microsoft Update at http://update.microsoft.com/microsoftupdate/v6/default.aspx.

If a SQL Server 2005 component is not on SP2 then the SP2 update will be offered for each language and platform that we support. This update is only available as an optional update on the Microsoft Update web site. To see the update you need to choose "Custom" scan.

The Express updates; Express, Express Advanced, and Express Toolkit will be automatically download and installed, if you have accepted to receive updates through Microsoft Update and you have enable automatic updates on you Windows machines. You can also see the update directly on the Microsoft Update web site.

 All of these updates will be available through WSUS so an IT admin can control deployment of these updates through their enterprise.

 Customers can optionally obtain SQL Server SP1 through Microsoft Update if they hide the SP2 update.

See the following link for more information on SQL Server SP

Security Update for SQL Server 2005 Service Pack 3 (KB970892) could not be installed


Auto updates picked up this update to install but it wouldn't install. I tried doing it manually with no success. Anyone run across this?I have the service pack 2 with updates already. What would cause this?

Cannot install Cumulative Update 11 for SQL Server 2005


Please note: running as a Domain Admin, FTData folders all exist, SIDs are correct for the relavnt user groups, Full Control permission given to Administartors group for WMI yet stull:

Cannot install Cumulative Update 11 for SQL Server 2005

Sumary.txt extract;

Product Installation Status
Product                   : SQL Server Database Services 2005 (MSSQLSERVER)
Product Version (Previous): 4211
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2258854_sqlrun_sql.msp.log
Error Number              : 11032
Error Description         : Unable to install Windows Installer MSP file

Hotfix.log extract:

09/22/2010 21:20:28.175 Installing product: SQL9
09/22/2010 21:20:28.635 Registry: Opened registry key "Software\Micr

How to write a trigger when given a condition in SQL SERVER 2005?


Hi Guys,
I am using SQL SERVER 2005.

I know how to write a trigger for a basic insert or update or delete. But here in my case I have to use the below condition and create a trigger.

I havent used any trigger till now in my job. So I am facing a slight problem in understanding and writing the code.....
I got the following requirement to create a new trigger for the following scenario :

The user (john) should be notified when the following happens :

Any transaction entered to account 100 which is not a ABN,CCH,or TTW
Any transaction entered to account 189 which is not a KHD

Description of fields :
100 and 189 are values for AccountCode Column in Account Table
ABN,CCH,TTW and KHD are values for CompanyTypeCode Column in Company Table.
I need to create new trigger on DLT_Data table

SQL server 2005 +asp.net 4.0 +html special characters problems saving special characters


Hello all

Could I please ask - how do I go about inserting into a database special characters such as the uppercase O, umlaut 


Please understand that I have been able to insert the special character from inside MMS by putting an N in front of the value

but when I run the  SQL file from inside an ASP.net 4.0 page it comes up as a diamond with a question mark in it

Does anyone have any idea how I would be able to acheive this?

SQL Server Maintenance Plan - Update Statistics fails if schema contains special chars


We have a database schema with a period in it's name.  This is valid as per http://msdn.microsoft.com/en-us/library/aa224033(SQL.80).aspx. When we create a maintenance plan to update statistics it will succeed if the object property is set to 'Tables and Views'. If this is set to 'Table' it will fail.

Steps to Reproduce

  • Create a new schema in a user database with a period in it's name, ie
    CREATE SCHEMA [Windows.EventLog] AUTHORIZATION [dbo]
  • Create a table with owner using schema created in #1, ie
    CREATE TABLE [Windows.EventLog].[Computer](
    	[ComputerId] [smallint] IDENTITY(1,1) NOT NULL,
    	[ComputerName] [varchar](255) NOT NULL,
    ) ON [PRIMARY]
  • Create a new maintenance plan, drag 'Update Statistics Task' to designer surface, edit properites, choose the user database, View T-SQL and test execution: it will work
  • Edit maintenance plan and modify 'Update Statistics Task', change Object to Table, change selection to all, execute task and it will fail. Also, if you now try to click 'View T-SQL' or change it back to 'Tables and Views', a error dialog with title 'Microsoft.SqlServer.MaintenancePlanTasksUI' shows will message 'Object

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) windows update install error 0xD

I have tried several times to use Windows Update to install the SQL Server 2005 Express Edition Service Pack 3 (KB955706) but it keeps failing.  When I check the install history all I get is error code 0xD59

I have Windows XP SP2 on a Core 2 Duo Dell Vostro 1500

List of special characters in SQL Server 2005


Does Microsoft provide a list of T-SQL special characters in SQL Server 2005 that can be escaped?

Security Update for SQL Server 2005 Service Pack 2 (KB960089)

Each time I attempt to install the above update it fails.   I am on Windows 7.   Can anyone help please. 

not able to update sql server 2005 service pack 3

security update for sql 2005 service pack 3 (kb970892) - not able to install this update on server 2003 standard edition. Please help.

Security Update for SQL Server 2005 Service Pack 2 (KB970895) - Error Code: 0x733F -


Thie above update fails to install at every attempt. I've looked around and found others with the same problem, but many of the "solutions" are way too technical for me. I've been asked to post the "summary.txt" file from the hotfix folder in this forum, and it appears below. Please help.

Time: 11/27/2009 14:51:37.449
KB Number: KB970895
Machine: ASUS
OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3080
Command-line parameters specified:
Cluster Installation: No

Prerequisites Check & Status
SQLSupport: Passed

Products Detected                         Language  Level  Patch Level       Platform  Edition
SQL Server Database Services 2005 (SQLEXPRESS)  ENU       SP2    2005.090.3077.00  x86       EXPRESS
SQL Server Tools and Workstation Components 2005  ENU       SP3           9.3.4035  x86       EXPRESS

Products Disqualified & Reason

Cannot update Excel 2007 spreadsheet as linked server within SQL 2005 or SQL 2008 via ADO


I am having difficulty updating an Excel worksheet via the ACE.OLEDB.12.0

I have a worksheet defined as a linked server in SQL Server via this
provider, and all attempts to update the lone worksheet in this file as a
linked server results in the following:

OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "linked_excel"
returned message "Bookmark is invalid.".
Msg 7346, Level 16, State 2, Line 1
Cannot get the data of the row from the OLE DB provider
"Microsoft.ACE.OLEDB.12.0" for linked server "linked_excel".

The query:
update linked_excel...sheet1$ set error_col='hithere' where

However, when I try to perform precisely the same update against the same
source via openrowset, it works, to-wit:

update openrowset('Microsoft.ACE.OLEDB.12.0','Excel
12.0;HDR=yes;Database=f:\path_to_file\filename.xlsx','select * from
set error_col='hithere'

SELECT's performed against either version work properly.

The linked server behavior is consistent across SQL 2005 and 2008

I am concerned that this problem is an artifact of an OLEDB provider update that purposely disabled update b

How to write a SQL query to present values horizontally sql server 2005

Suppose I have one table called Jobs:

    [JOBID] [int] IDENTITY(1,1) NOT NULL,
    [PARTDESC] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [OrderPlacedBy] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
    [SpecialistName] [nvarchar](64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [Priority] [int] NOT NULL,
    [Symptoms] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [CustomerNotes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [ShopNotes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JobType] [nvarchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [JobState] [nvarchar](32) COLLATE Latin1_General_CI_AS NULL,
    [JobAddedDate] [datetime] NOT NULL,
    [JobStartedDate] [datetime] NULL,
    [JobFinishedDate] [datetime] NULL,
    [JobShippedDate] [datetime] NULL,
    [RecievedDate] [datetime] NULL

I want to see the specialist name and his jobs IDs horizontally.

ANA 201,502,605,701,774
BEN 102,103,051
JEN 705,401,402,509,409,408

A s

SQL Server 2005 Try and Catch Exception Handling

I'm pretty excited to see that there is some real error handling for T-SQL code in SQL Server 2005. It's pretty painful to have your wonderfully architected .NET solution tainted by less-than-VBScript error handling for stored procedures in the database. The big difference being the addition of TRY..CATCH blocks. Let's take a look:

sql server 2000 vs 2005


i would like to ask what the difference between sql server 2000 and 2005 

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend