use DataLength function, for more information see SQL BOL.

try like this:

if datalength (@xmlWTSPrefrences) <> 0

begin

-- do something

end

else

begin

-- do something

end

🙂

table created successfully with some warning message. Try it.

which ver. of SQL Server using ?

SQL Server 2000: You can create DTS package through Enterprise Manager.

SQL Server 2005: Use Business Intelligent to create SSIS package.

try like:

selectisnull (add1, '') +isnull (add2, '') +isnull (add3, '') as 'Address' from

🙂

try like this:

selectisnull (add1, '') + isnull (add2, '') +isnull (add3, '') as 'Address' from

🙂

do you have any common field between the tables ?

While installing SQL Server 2005, you may select option for samples & databases, at that time sample databases installed.

🙂

Check the link: http://msdn2.microsoft.com/en-us/library/ms187445.aspx (Estimating the size of database). You may get good answer for your application.

🙂

Excellent.

🙂

Use my utility to generate DDL script for SQL Server Database.

Note: This utility requires, SQL Server 2005 and .NET 2.0 (Developed in C#.NET 2005 & SQL Server 2005)

🙂

Very good reply, thanks.

Very easy, see below attached document.

🙂

Check the following link for FYI:

http://www.sql-server-performance.com/articles/per/temp_tables_vs_variables_p1.aspx

🙂

After installed, do the following way:

Start -> Program -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration

and also see the attached document file.

🙂

It's working fine, but takes very long time to execute.