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
Allow only numeric character in JavaScript
Hi, Here is the example code of Javascript which allows you to type only numeric value in a textbox. Here is the features of this code...
Retrieve the Image From the Database
If we want to retrive the image from the database then first we pick the image from the database and then convert it into the image : Here...
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(...
Find Duplicate Entry
In this way we can find duplicate entry in the database -- create table for test data create table test_data ( id int, product char(1...
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...
Getting Hard Disk Serial No. in C#
Every hard disk has a unique serial number which we can get by our code here is a example which gives you the you computer's c drive se...
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...
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...
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...
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...
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