<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/'><id>tag:blogger.com,1999:blog-9075786158122089104.post841345642932231450..comments</id><updated>2010-01-29T11:44:37.607+05:30</updated><category term='scalar UDF'/><category term='generic pivot SP'/><category term='RETURN DATA FROM INSERT'/><category term='master.dbo.xp_fileexist'/><category term='DTS'/><category term='Cannot generate SSPI context'/><category term='ALTER TRIGGER'/><category term='find locked table'/><category term='data file size'/><category term='read xml'/><category term='array in SQL Server'/><category term='ritesh'/><category term='keep eye on hard disk space'/><category term='stuff'/><category term='servername'/><category term='all tables'/><category term='syscomments'/><category term='oslo'/><category term='copy files'/><category term='INFORMATION_SCHEMA.tables'/><category term='title case'/><category term='grouping sets in SQL Server 2008'/><category term='truncate'/><category term='fetch_prior'/><category term='keyset cursor'/><category term='Asymmetric'/><category term='set rowcount'/><category term='error 7411'/><category term='Msg 15118'/><category term='dm_db_partition_stats'/><category term='sp_executeSQL'/><category term='create txt file'/><category term='insert varbinary'/><category term='aggregate function'/><category term='create symmetric key'/><category term='update statestics'/><category term='email'/><category term='coalesce'/><category term='collation'/><category term='-SQL-Server 2005'/><category term='data management view'/><category term='WHERE Condition'/><category term='data access error'/><category term='restore DMK'/><category term='SSIS'/><category term='DIFFRENCE OF SET AND SELECT'/><category term='diffrence between rank() and rown_Number()'/><category term='.NET 3.5'/><category term='Right Join'/><category term='OBJECT_DEFINITION'/><category term='SELECT UNION ALL'/><category term='SNAPSHOT ISOLATION'/><category term='sys.procedures'/><category term='find disk space usage'/><category term='UDF'/><category term='cascading Update'/><category term='IE 8 RC1'/><category term='intersect'/><category term='Auto_Close'/><category term='correlated subquery'/><category term='generic list in SP'/><category term='find default value of column'/><category term='denali'/><category term='set based theory'/><category term='Sys.Columns'/><category term='DatabaseMailUserRole'/><category term='definition of cursor'/><category term='RETURN DATA FROM UPDATE'/><category term='SQl server quiz'/><category term='except'/><category term='filestream'/><category term='LN in Excel'/><category term='Policy managment'/><category term='ms sq'/><category term='msdb.dbo.sp_send_dbmail'/><category term='view'/><category term='Bug Fix'/><category term='load XML into SQL'/><category term='charindex'/><category term='cerate certificate'/><category term='delete with JOIN'/><category term='keep track of database file'/><category term='network-related or instance-specific error'/><category term='OUTER join'/><category term='Password validation failed'/><category term='restore master key'/><category term='example of Silverlight'/><category term='M language'/><category term='query job'/><category term='update puzzle'/><category term='.NET'/><category term='copy mdf'/><category term='fetch_last'/><category term='linked server'/><category term='change database mode'/><category term='ntile'/><category term='Microsoft'/><category term='sysobject'/><category term='error 28'/><category term='archive data in SQLServer'/><category term='backup encrypted database'/><category term='character map transformation task'/><category term='rollup'/><category term='create clustered index on view'/><category term='paging'/><category term='IE 8'/><category term='create master key'/><category term='xp_instance_regread'/><category term='Jason Olson'/><category term='FreeText'/><category term='use of cube and rollup'/><category term='copy ldf'/><category term='image store in sql server'/><category term='division operator'/><category term='find data file size'/><category term='service master key'/><category term='Log in sql server'/><category term='find first Friday'/><category term='delete duplicate records'/><category term='Sys.Database_files'/><category term='export from SQL to Flat file'/><category term='MS SQL Server 2005'/><category term='Flat File Destination'/><category term='EVENTDATA()'/><category term='catalog view'/><category term='Serializable Isolation Level'/><category term='update'/><category term='performance counter registry hive consistency'/><category term='DBCC INDEXDEFRAG'/><category term='configure php'/><category term='CLR function'/><category term='windows appilcation'/><category term='.NET Quiz 2011'/><category term='dateadd'/><category term='upgrade sql server'/><category term='delete many records'/><category term='sys.database_role_members'/><category term='find size of each table'/><category term='create nonclustered index on view'/><category term='open master key'/><category term='sp_refreshSQLModule'/><category term='YUKON'/><category term='xtype'/><category term='server trigger'/><category term='cube'/><category term='join'/><category term='SP_MSTABLESPACE'/><category term='read registry'/><category term='QUOTENAME'/><category term='find stored procedure'/><category term='teched'/><category term='script task'/><category term='sysjobhistory'/><category term='ado.net'/><category term='sql'/><category term='update image in sql server'/><category term='index'/><category term='invalid precision for decimal data type'/><category term='find user in all database'/><category term='keep eye on database file'/><category term='bulk copy'/><category term='copy files and folder from SQL Server'/><category term='split value'/><category term='day calculate with CTE'/><category term='row level versioning'/><category term='grouping sets'/><category term='Sys.Key_Constraint'/><category term='check file exists in SQL Server'/><category term='xlsx in sql server 2005'/><category term='padindex'/><category term='INSERT with Raw Constructor'/><category term='Silverlight'/><category term='multiple SQL Server in one server'/><category term='sp_depends'/><category term='10% discount'/><category term='teched event in Ahmedabad'/><category term='change collation'/><category term='Find fully qualified path'/><category term='body surface area'/><category term='master sql server'/><category term='comma separated value'/><category term='regex.split'/><category term='hand return value from C#'/><category term='database trigger'/><category term='order by'/><category term='sp_addrolemember'/><category term='datetime bug'/><category term='DML trigger'/><category term='Service Area Configuration'/><category term='create view'/><category term='INSERTED'/><category term='string or binary data would be truncated'/><category term='Full Text Search'/><category term='database backup'/><category term='SERVERPROPERTY'/><category term='sum'/><category term='CHECK'/><category term='Microsoft.ACE.OLEDB.12.0'/><category term='JOB List'/><category term='update null data'/><category term='jacob sebastian'/><category term='encryption'/><category term='Inner Join'/><category term='hint'/><category term='Michael Coles'/><category term='Partition by'/><category term='ASHX'/><category term='set default in all column'/><category term='john papa'/><category term='getdate()'/><category term='.DTS'/><category term='osql'/><category term='SAGE'/><category term='Windows Installer Cleanup Utility'/><category term='backup'/><category term='CROSS APPLY'/><category term='find currently running query'/><category term='untyped XML'/><category term='xml'/><category term='txt file'/><category term='guru sql server'/><category term='sp_rename'/><category term='create full text catalog'/><category term='startup stored procedure'/><category term='ForEach Loop'/><category term='FREETEXTTABLE'/><category term='read typed XML'/><category term='DROP SCHEMA'/><category term='Repeatable Read Isolation Level'/><category term='dynamic word document with image with C#'/><category term='– Context_Info'/><category term='query XML file'/><category term='Read Committed Isolation Level'/><category term='change data capture'/><category term='union in CTE'/><category term='Symmetric key'/><category term='create CSV file from SQL'/><category term='crystal report'/><category term='msdb..sysjobs'/><category term='DBCC SHOWCONTIG'/><category term='user'/><category term='dynamic cursor'/><category term='update with aggregate function'/><category term='find guest user'/><category term='MS SQL Server 2000'/><category term='synonym'/><category term='regional language in sql server'/><category term='inflectional'/><category term='Microsoft.Jet.OLEDB.4.0'/><category term='calculate clustered index size'/><category term='conditional split transformation'/><category term='check database size'/><category term='hardening sql server'/><category term='difference exec and sp_executeSQL'/><category term='xp_regRead'/><category term='audit trail'/><category term='select random'/><category term='find user permission'/><category term='configure php in IIS'/><category term='find lock'/><category term='Argument data type ntext is invalid'/><category term='HAVING Clause'/><category term='Msg 7403'/><category term='Session Variable'/><category term='update trigger'/><category term='log transaction'/><category term='set database offline'/><category term='identity_insert'/><category term='sp_spaceused'/><category term='paging in SP'/><category term='T SQL puzzle'/><category term='mbsa'/><category term='bulk insert'/><category term='TOP'/><category term='USER DEFINE FUNCTION'/><category term='retularexpression.regex'/><category term='dynamic query with Uniqueidentifier'/><category term='archive'/><category term='delete'/><category term='expert exchange'/><category term='decryption'/><category term='iFTS'/><category term='logical delete'/><category term='Sys.Foreign_Key_Columns'/><category term='encry\'/><category term='search modified object'/><category term='dynamic word document with C#'/><category term='count'/><category term='DROP PROC'/><category term='vinod kumar'/><category term='OPENROWSET'/><category term='experts-exchange.com'/><category term='ENABLE XP_CMDSHELL'/><category term='dynamic pivot'/><category term='memory leak'/><category term='frequently Asked question'/><category term='sp_fulltext_catalog'/><category term='micrso'/><category term='Left Join'/><category term='Contains'/><category term='Sys.Databases'/><category term='dmv'/><category term='Result Destination task'/><category term='sysobject.xtype'/><category term='return data'/><category term='internet explorer'/><category term='create synonym'/><category term='execute'/><category term='instance'/><category term='DDL TRIGGER'/><category term='beyondrelational.com'/><category term='null'/><category term='patindex'/><category term='deadLock'/><category term='data abstract layer'/><category term='subquery as table'/><category term='SPLIT'/><category term='insert into'/><category term='NDF'/><category term='fillfactor'/><category term='xp_sendmail'/><category term='encryption with asymmetric key'/><category term='fire fox'/><category term='OUTPUT Parameter'/><category term='features'/><category term='information_schema.routines'/><category term='Uniqueidentifier'/><category term='system.serviceprocess'/><category term='.DTSX'/><category term='update null for all column'/><category term='memory leak in SQL Server 2008'/><category term='find word in stored procedure'/><category term='T-sql'/><category term='ahmedabad user group'/><category term='update XML column'/><category term='OUTER APPLY'/><category term='environtment.currentdirectory'/><category term='subquery'/><category term='email from trigger'/><category term='RETURN DATA FROM DELETE'/><category term='fetch next'/><category term='total row in table'/><category term='SQL Injection'/><category term='comparison catalog view and information_schema'/><category term='image in sql-server 2005'/><category term='watch your hard disk space'/><category term='naming convention'/><category term='count and null'/><category term='grantlogin'/><category term='gandhinagar user group'/><category term='image store'/><category term='user account in SQL Server'/><category term='Aggregate'/><category term='ranking rows in groups'/><category term='PIVOT Task in SSIS'/><category term='read website in asp.net'/><category term='LEN'/><category term='http connection manager'/><category term='exclusive lock'/><category term='Visual Studio 2008'/><category term='union'/><category term='SELECT'/><category term='calculate non-clustered index size'/><category term='datetime format'/><category term='nested cte'/><category term='MSDB..sp_HELP_JOB'/><category term='noncolustered index'/><category term='multi statement UDF'/><category term='find user'/><category term='XP_CMDSHELL'/><category term='list of all datetime format'/><category term='Stored procedure naming conventino'/><category term='find table list'/><category term='mDF'/><category term='access 2007 in SQL Server'/><category term='.NET framework 4.0'/><category term='linked server with excel'/><category term='rename column name'/><category term='office 2010'/><category term='select duplicate records'/><category term='export data from SQL to CSV'/><category term='fn_PhysLocFormatter'/><category term='sql server instance'/><category term='CREATE RULE'/><category term='IMPROVED INSERT'/><category term='SQL Server profiler'/><category term='MSforEachDB'/><category term='fuzzy lookup'/><category term='LOG10 in sql server'/><category term='microsoft baseline security analyzer'/><category term='group by'/><category term='clustered index'/><category term='delete multiple records'/><category term='SQL Server &quot;Denali&quot;'/><category term='net stop'/><category term='CREATE TRIGGER'/><category term='COPY ONE TABLE FROM ANOTHER'/><category term='where'/><category term='sp_send_dbmail'/><category term='INSERT in SQL Server 2008'/><category term='DRI'/><category term='CREATE PROC'/><category term='Ritesh Shah'/><category term='copy backup from one location to another'/><category term='SELECT INTO'/><category term='CHAR'/><category term='find primary key'/><category term='instead of trigger'/><category term='row_number()'/><category term='sql server agent jobs'/><category term='xp_fileexist'/><category term='System.IO.DriveInfo.GetDrives()'/><category term='database tuning advisor'/><category term='asp.net'/><category term='DELETED'/><category term='HTTP Endpoint'/><category term='DataLength'/><category term='certificate in database'/><category term='View should be with schemabindings'/><category term='PSEUDO TABLE'/><category term='cte'/><category term='sp_fulltext_table'/><category term='store document in sql server'/><category term='select primary key'/><category term='xp_fixeddrives'/><category term='sys.database_principals'/><category term='insert manual value in identity column'/><category term='for xml path'/><category term='UTC datetime'/><category term='return value from SP'/><category term='concat_null_yields_null'/><category term='import excel file to sql server'/><category term='comparison of SP and UDF'/><category term='data size in table'/><category term='dynamic sql'/><category term='CODEPLEX Toolkit'/><category term='dynamic alter table script'/><category term='t-sq'/><category term='mvp'/><category term='COMPUTE'/><category term='shrink log file of all database'/><category term='microsoft best practices analyzer'/><category term='find foreign key'/><category term='error 8152'/><category term='difference between BCP and BULK INSERT'/><category term='single_user'/><category term='substring function'/><category term='System.IO.DriveInfo'/><category term='microsoft tech days'/><category term='find GMT +5.30 time'/><category term='fast_forward'/><category term='FTS'/><category term='MCPD'/><category term='sys.schemas'/><category term='bpa'/><category term='sp_fulltext_database'/><category term='SET'/><category term='FAQs in SQL Server'/><category term='SQL-Server 2005'/><category term='alter all column'/><category term='msg 8152'/><category term='getutcdate()'/><category term='microsoft sql server'/><category term='login'/><category term='BSA'/><category term='change column name'/><category term='Definition OF SCHEMA'/><category term='create database master key'/><category term='datediff'/><category term='sub cte'/><category term='search text of Stored procedure'/><category term='Unable to start debugging on web server. Debugging failed because integrated windows authentication is not enabled. Please see help for assistance'/><category term='multi_user'/><category term='proper case'/><category term='create login'/><category term='difference between Stored Procedure and User Define Function'/><category term='update XML data'/><category term='insert trigger'/><category term='find table size'/><category term='array pass to Stored procedure'/><category term='identity'/><category term='sch-m lock'/><category term='OVER'/><category term='DTA'/><category term='Microsoft sync service'/><category term='revoke access of user'/><category term='openquery'/><category term='update()'/><category term='DBCC Page'/><category term='Cross Tab Query'/><category term='Channel 9'/><category term='EXEC'/><category term='Merge Statement'/><category term='locate physical row address'/><category term='RANK()'/><category term='difference of cube and rollup'/><category term='shrink log file'/><category term='mark wills'/><category term='c-sharp'/><category term='server doesn&apos;t support requested protocol'/><category term='database master key'/><category term='pinal dave'/><category term='net start'/><category term='date'/><category term='delete in bunch'/><category term='dynamic select in SP'/><category term='forward_only'/><category term='information_schema.columns'/><category term='configure mySQL in windows'/><category term='100 article complete'/><category term='c#'/><category term='EXECUTE permission was denied on the object sp_send_dbmail'/><category term='DataFlow'/><category term='TCP Endpoint'/><category term='SERVERPROPERTY(&apos;ErrorLogFileName&apos;)'/><category term='bypass aspx in .NET'/><category term='T-SQL Challenges Beginners'/><category term='system databases'/><category term='export data from SQL to excel'/><category term='cursor'/><category term='sp_fulltext_column'/><category term='difference between delete and truncate'/><category term='user defined rules'/><category term='difference between len and datalength'/><category term='The OLE DB provider &quot;Microsoft.ACE.OLEDB.12.0&quot; has not been registered'/><category term='character count'/><category term='get drive infor of windows'/><category term='log file size'/><category term='guitar'/><category term='find log file size'/><category term='sql server 2005'/><category term='email when run out of space'/><category term='vb.net'/><category term='web.config'/><category term='scrollable cursor'/><category term='windows server 2003'/><category term='set database online'/><category term='typed XML'/><category term='MS SQL Server'/><category term='DMK'/><category term='schema change lock'/><category term='NEWID()'/><category term='cdc'/><category term='DAC'/><category term='static cursor'/><category term='restricted_user'/><category term='dmf'/><category term='windows 7.0'/><category term='ALTER PROC'/><category term='Msg 1939'/><category term='Msg 8116'/><category term='pivot with where condition'/><category term='full qualified path'/><category term='sp_MSforeachdb'/><category term='transaction log'/><category term='client/server application'/><category term='MCITP'/><category term='checkpoint'/><category term='convert local datetime to UTC'/><category term='LIKE'/><category term='error 7303'/><category term='CREATE SCHEMA'/><category term='xml relational data in sql table'/><category term='isnull'/><category term='table statistics'/><category term='sysindexes'/><category term='microsoft exams'/><category term='cannot open database'/><category term='OUTPUT'/><category term='formsof'/><category term='EXEC sp_BindRule'/><category term='Difference between sql server 2000 and sql server 2005'/><category term='PIVOT'/><category term='string manipulation'/><category term='addrolemember'/><category term='user and login issue'/><category term='SCHEMA'/><category term='LOG'/><category term='create user'/><category term='recursive query'/><category term='SQL DMO'/><category term='non-identity'/><category term='index reorganize'/><category term='error fix'/><category term='Merge Join Transformation Task'/><category term='calculate index size'/><category term='table naming convention'/><category term='order by total'/><category term='update fun'/><category term='free ebook'/><category term='teched on road'/><category term='sp_procoption'/><category term='Read UnCommitted Isolation Level'/><category term='split value in c#'/><category term='Visual Studio 2010'/><category term='Database Engine tuning adviser'/><category term='create full text index'/><category term='BCP'/><category term='multiple ways to insert records'/><category term='bulk operation'/><category term='sql server 2008'/><category term='delete all records'/><category term='inline table valued function'/><category term='Integrated Full Text Search'/><category term='SMK'/><category term='parameter in HTTP Endpoint'/><category term='find Last Friday'/><category term='LDF'/><category term='backup master key'/><category term='Sys.Objects'/><category term='union all'/><category term='fetch_first'/><category term='ASCII to CHARACTER'/><category term='ms sql server 2008'/><category term='Log in Excel'/><category term='ALTER SCHEMA'/><category term='db_name()'/><category term='total'/><category term='BLOB'/><category term='naming guideline of database object'/><category term='what is identity'/><category term='sp_MSforeachtable'/><category term='multyplication operator'/><category term='Cascading Delete'/><category term='bcp.exe'/><category term='sql server energy event'/><category term='primary key'/><category term='index rebuild'/><category term='find columns'/><category term='stored procedure'/><category term='wedding anniversary'/><category term='SQL SMO'/><category term='ContainsTable'/><category term='Difference between sql server 2005 and 2008'/><category term='trigger'/><category term='free second chance'/><category term='sqlhub.com'/><category term='grantdbaccess'/><category term='DBCC CheckDB'/><category term='machine.config'/><category term='image in database'/><category term='Indic_General_90_BIN'/><category term='ascii'/><category term='sp_configure'/><category term='insert image in sql server'/><category term='SendMail'/><category term='KEEPFIXED PLAN'/><category term='policy enforcing'/><category term='quarter'/><category term='ACCESS'/><category term='NEAR in CONTAINS'/><category term='restore encrypted database'/><category term='Update table'/><category term='find error log file'/><category term='Msg 1940'/><category term='Difference between WHERE and HAVING'/><category term='division operator return zero 0'/><category term='free SQL Server 2008 ebook'/><category term='Installation of Silverlight'/><category term='MCTS'/><category term='http handler'/><category term='set identity_insert'/><title type='text'>Comments on SQL-Server Blog of Ritesh Shah --Fight the fear of SQL with SQLHub.com: CHARINDEX and PATINDEX with STUFF function for str...</title><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://www.sqlhub.com/feeds/841345642932231450/comments/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/9075786158122089104/841345642932231450/comments/default'/><link rel='alternate' type='text/html' href='http://www.sqlhub.com/2010/01/charindex-and-patindex-with-stuff.html'/><author><name>Ritesh Shah</name><uri>http://www.blogger.com/profile/09562656548324468450</uri><email>noreply@blogger.com</email><gd:image xmlns:gd='http://schemas.google.com/g/2005' rel='http://schemas.google.com/g/2005#thumbnail' width='32' height='24' src='http://bp0.blogger.com/_wRRgPffD7II/SBjhxOW6mOI/AAAAAAAAABU/Rlxb-vueiSg/S220/ritesh.jpg'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>0</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage></feed>
