I had once developed an application which tears data from html pages.

I created a VB.NET application which calls the target URL and gets the response.

When you get the application I...

Hi,

Besides setting allow_updates , Reconfigure with Override option can also be used for the solution as described at Ad hoc update to system catalogs is not supported

But it is...

Hello,

If your input parameter has a space between date and time parts, then your convert function will work quite well

DECLARE @dt varchar(50) = '21NOV1974 00:00:00'

SELECT @dt...

OK, I have added the following control within the CreateProcedure SP

IF @dbname 'master'

You can get the full sp code from create stored procedure on all databases using sp_MSForEachDB

Hello zehil,

Since we have previously created the sp in the master database, while the sp_msforeachdb is working for master db, we can get this error.

To eliminate the error within the...

Hello,

I have build a helper stored procedure for creating a stored procedure on all databases using sp_MsForEachDB procedure.

All that one should do is creating a sp in master database.

By calling...

Hi,

Did you check the MSDN article How to: Add a Data-Bound Image (Image Wizard)

That might be helpful

Eralper

T-SQL Programming

Hello,

If there can be only one relation at most you can create self referencing table like

CREATE TABLE Clients (

clientnumber int IDENTITY(1,1) NOT NULL,

title nvarchar(100),

[given name] nvarchar(100),

surname nvarchar(100),

brotherClient int

CONSTRAINT...

Hi,

The default DateFirst value is set in the sys.syslanguages system table.

But I do not know is it a good idea to alter this column in this system table.

I know that...

Hi Divya,

Is this a new article?

Hi Goldie,

Thanks for your concern that you have read my article.

I do not want to make the conversation too long about my article here since we should discuss the article...

Hi,

You know this discussion is originally started on an article which is describing this method. Because of that I had given an example on splitting by XML.

Eralper

http://www.kodyaz.com

Hi Greg,

BOL is the Books OnLine, the offline help documents of the SQL Server.

While installing the client tools, if you will not build any reporting services reports or ssis packages...

Hello Goldie,

Do you mean using the XML logic or placing it into a udf causes the performance decrease?

Using the XML inline is a little bit difficult for whom do not...

Hello all,

I have placed the XML string split logic into a user defined function and I think running the split within the function results better in performance than keeping the...