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
Subscribe to:
Post Comments (Atom)
Popular Posts
-
If we want to split the value in SSRS then we can use the in built split function as follows For example : if we want to split "...
-
Que: How to return a value from the SQL Stored procedure. Ans: With the out parameter we can return the value from the SQL Server. B...
-
Hi, Below code will sort the comma separated values. for using this code we need to use fnSplit method. DECLARE @list VARCH...
-
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...
-
Hi, Below are the three ways by which we can get the definition and information of sql object like view, procedure or function S...
-
Hi, Below query will give the time according to time zone DECLARE @TIMZONE VARCHAR ( 6 ) DECLARE @USERTIMZONE VARCHAR ( 50 ) ...
-
I have noticed that code formatting is a difficult task for many of us. I found one small plugin notepad++ in order to do the code formatt...
-
This is my first video article in this I am showing how to replace select * from will all the columns Thx, RS
-
Hi, In sql-server we have modify,exist and delete functions to change the xml data. Below is the example of replacing the xml value wh...
-
/* Count Number Of Tables In A Database */ SELECT COUNT(*) AS TABLE_COUNT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE&#...
No comments:
Post a Comment