Post New Resource

String Format in SQL

Posted By :Hitendra Posted Date :19/03/2010 Points :10 Category: SQL Query URL: http://www.codeanswer.blogspot.com

String Format in SQL

Using This sql Function We can Use String In sql Function

DROP FUNCTION dbo.fnFormatString
GO
CREATE FUNCTION dbo.fnFormatString(@format varchar(6000),
    @arg1 sql_variant,
    @arg2 sql_variant='',
    @arg3 sql_variant='')
RETURNS varchar(8000)
AS
BEGIN
RETURN REPLACE(
    REPLACE(
    REPLACE(@format, '{0}', CAST(@arg1 as varchar(400))),
    '{1}', CAST(@arg2 as varchar(400))),
    '{2}', CAST(@arg3 as varchar(400)))
END
GO
PRINT dbo.fnFormatString('This {0} of works like {1} in that langauge {2}'
    , 'sorta'
    , 'string.Format()'
    , 'C#')

Featured Articles

Best Practices No 5: - Detecting .NET application memory leaks
Memory leaks in .NET application have always being programmer's nightmare. Memory leaks are biggest problems when it comes to production servers. Productions servers normally need to run with least down time. Memory leaks grow slowly and after sometime they bring down the server by consuming huge chunks of memory. Maximum time people reboot the system, make it work temporarily and send a sorry note to the customer for the downtime. ... Read More

.NET Best Practice No: 1:- Detecting High Memory consuming functions in .NET code
One of the important factors for performance degradation in .NET code is memory consumption. Many developers just concentrate on execution time to determine performance bottle necks in a .NET application. Only measuring execution time does not clearly give idea of where the performance issue resides. Ok, said and done one of the biggest task is to understand which function, assembly or class has consumed how much memory. In this tutorial we will see how we can find which functions consume how much memory. This article discusses the best practices involved using CLR profiler for studying memory allocation.... Read More

How to improve your LINQ query performance by 5 X times ?
LINQ has been criticized by many early adopters for its performance issues. Well if you are just going to drag and drop using DBML code generator I am sure you will land up in to mess. Try doing this make a simple LINQ to SQL project using DBML and see your SQL profiler, I am sure you will never like to touch DBML code generator again. ... Read More

Responses

No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply

Read also another Resources from the same Author	Related Resource From The Same Category How to get DATE without DATE TIME using SQL SERVER? Find all Primary and Foreign Keys In A Database Get Values of a Column in a Single Variable Cross Tab Query Get the Random Records from a Table

Find More code samples in C#, ASP.Net, Vb.Net and more Here

String Format in SQL

Featured Articles

Read also another Resources from the same Author

Related Resource From The Same Category