skip to main
|
skip to sidebar
Pages
Home
About Me
Technical Dreams...
Ads 468x60px
Social Icons
Friday, 28 September 2012
Repeate String N Times using REPLICATE function
In sql-server we have a function which repeats the string n number of times.
Function : REPLICATE(string,int)
Example : Select REPLICATE('rahul ',5)
Result : rahul rahul rahul rahul rahul
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Social Icons
Powered by
Blogger
.
Popular Posts
Count of Nodes in XML through Sql-Server
Hi, Here is the example by which we can count that how many times a particular node is coming. DECLARE @strXml XML = ( '<Pare...
Sql directives order
When we are optimizing the SQL statements to improve the performance I thought this tip would help the figure out where to tweak their cod...
Ranking Function
We have four types of ranking function in sql server 1.) row_number 2.) rank 3.) dense_rank Row_Number() Function The ROW_NUMBER(...
Chaning extension of a file
This is very usefull code for me. This code I was needed when my solution was migrated from VS2008 to VS2010. In VS2008 we are using the nam...
Connecting BIDS or Visual Studio 2008 with TFS 2010
In my project I am working on Visual Studio 2010 and I am using TFS 2010. For SSRS we have to use VS 2008 Or BIDS. But TFS 2010 does not al...
Save the Image in to database
Here is a code which we can use for storing the image into database for this we can convert the image into a byte array and then store that...
Detail members can only contain static inner members
Hi, 'The tablix 'Table1' has a detail member with inner members. Detail members can only contain static inner members. Thi...
Creating Connection String Dynamically
For creating the connection string dynamically first you create a notepad file and save it at desktop with the extension .udl For Example:...
Delete database forcefully
I am not sure how many times you might want to forcefully close all the active connections and drop a database. However, this is a very in...
Manipulate Header and Footer values at each page
Generally in SSRS Header and Footer value is same for a report. Sometime we require to show different value in the footer or header on the ...
Followers
Archive
►
2015
(5)
►
September
(1)
►
August
(1)
►
April
(1)
►
March
(2)
►
2014
(18)
►
December
(1)
►
November
(1)
►
September
(2)
►
July
(2)
►
May
(5)
►
March
(1)
►
February
(3)
►
January
(3)
►
2013
(15)
►
December
(1)
►
November
(1)
►
October
(1)
►
June
(1)
►
May
(1)
►
March
(1)
►
February
(2)
►
January
(7)
▼
2012
(40)
►
December
(6)
►
November
(2)
►
October
(8)
▼
September
(4)
Repeate String N Times using REPLICATE function
Length of LOB data () to be replicated exceeds con...
Find the statictics on an Object and Drop them
Get the active connection of SQL-Server
►
May
(6)
►
April
(5)
►
March
(5)
►
February
(3)
►
January
(1)
►
2011
(27)
►
December
(4)
►
November
(15)
►
October
(8)
Search
No comments:
Post a Comment