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
Calendar In Sql Server Reporting Services.
In SSRS there is no any option by which we can create the calender in the reports but this thing can be done using SQL-Server here I am giv...
Simple tricks in SQL-Server
Here I am going to explain some cool tricks in SQL-Server. Trick 1: Code Wrap Some times will see our code is going to beyond the...
How to create SSRS report in newspaper format
This post is about how to create the SSRS reports in the newspaper format i.e. if you want to move your data from first column, then seco...
Blank page in SSRS
In SSRS some times we are facing the problem of blank pages and so many times it will became night mare to fix this issue. Reason: Whene...
SQL Server Basics
This post is for Basics of SQL Server. I will cover below topics in this post Create Table Data Types Variable Declaration CURD Oper...
How to find nth highest salary
In this post I will explain how to get the nth highest salary for an employee in different ways. I have below record present in my emplo...
SQL Server - Enabling Service Broker
In this post I will cover to enable the service broker id and solution of some error related to this. With the help of below query we ca...
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...
Strikethrough selected text JavaScript
Here is code which shows how to strike though the selected text in textbox using JavaScript. < script type ="text/java...
SQL Server 2012 Data Type
Below is the list of SQL -Server 2012 Data Type Thx, RS
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