SQL SERVER Clean String function

SQL SERVER Clean String function



Create Function [dbo].[CleanString] (@input nvarchar(max))
Returns nvarchar(max)
As
Begin


declare @a nvarchar(max)
declare @b nvarchar(max)
Set @a=@input
Set @b = Replace(REPLACE(@a, SUBSTRING(@a, PATINDEX( '%[,~,@,#,/,\,(,),$,%,&,*,(,),+,.,]%', @a), 1 ),''),'-','')
Set @a=@b
Set @b = Replace(REPLACE(@a, SUBSTRING(@a, PATINDEX( '%[,~,@,#,/,\,(,),$,%,&,*,(,),+,.,]%', @a), 1 ),''),'-','')
Set @a=@b
Set @b = Replace(REPLACE(@a, SUBSTRING(@a, PATINDEX( '%[,~,@,#,/,\,(,),$,%,&,*,(,),+,.,]%', @a), 1 ),''),'-','')
Set @a=@b
Set @b = Replace(REPLACE(@a, SUBSTRING(@a, PATINDEX( '%[,~,@,#,/,\,(,),$,%,&,*,(,),+,.,]%', @a), 1 ),''),'-','')
return @b

End


Call Function on Select statement :

Select top 1 DataEntryDate ,   dbo.CleanString('A-SMN~dfs&d-fdsh/adsfdsf/sdfsdf\sdf')   from TableName


 

Post data and get jason C#

  string url = "www.YOURL_URL.com";
  string soapResult = "";
                WebClient cl = new WebClient(); // create web client
                var data = cl.DownloadString(url); //    Sending request to find web api REST service resource  using HttpClient 
                JObject currencies = JObject.Parse(data);
                var currency = currencies.SelectToken("TradeLicense.trade_name_en");
                soapResult = currency.ToString();

Describe table structure with MS SQL Server

This is the second in a series of three posts about using the sp_tables, sp_columns and sp_stored_procedures stored procedures with Microsoft SQL Server databases. This post is about sp_columns which is used to describe the table structure of a SQL Server table.

The simplest way to use sp_columns to show the columns and related information about a SQL Server table is to execute the stored proecedure passing it the table name like so:

exec sp_columns MyTable

You can read more information about what each column returned means in the MSDN documentation about this stored procedure. The sp_columns stored procedure can take additional arguments to the table name. You can also pass the table owner, table qualifier (i.e. the database name), column name and the ODBC version used. The table owner and column name parameters support wildcard pattern matching, so you can use % and _ For example, if you only wanted to query the "foo" column from the above example, you would do this:

exec sp_columns MyTable, @column_name = 'foo'

If you wanted to query all columns which started with the letter "a" you could do the following:

exec sp_columns MyTable, @column_name = 'a%'

That's a basic overview of the sp_columns stored procedure for describing a table structure in Microsoft SQL Server. The final post in this series (in a week's time) will look at sp_stored_procedures to get a list of stored procedures available.

Class for User Register - MVC

public class UserRegisterModel

    {

        [DisplayName("User Name")]

        [Required(ErrorMessage="Name can not be blank")]

        public string Name { get; set; }

        [Required(ErrorMessage = "Password can not be blank")]

        [StringLength(6,ErrorMessage="Password should be equal or less than 6 character")]

        public string Password { get; set; }

        [Required(ErrorMessage = "Email can not be blank")]

        [RegularExpression(@"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*",ErrorMessage="Email is not Valid")]

        public string Email { get; set; }

    } 

Windows 10 How to send a command line message to another PC on the network?

How to send a command line message to another PC on the network?
1. Start command prompt (cmd) – type cmd in the searchbox and run the app

2. Type the command as follows:

msg /SERVER:DestinationPC * /TIME:60 “This is the message to be sent to a PC named DestinationPC.”

– Replace DestinationPC with your destination PC name (see your computer network for the list of computers in that network if you don’t know the name pf the PC you are trying to send the message to.



– Replace the value of TIME with desired seconds before the message closes

– Replace the text between quotation marks with the message text you want to be displayed.

3. Hit enter and voila, the message is sent.

This is the relapse commend on XP Windows net send 

How to add HTML codes in Blogger Posts

If you wants to show HTML code without any customization in your blog then just use this site: SimpleCode. This method is too easy to use and it shows code in a very simple way.


Use the below
http://vault.simplebits.com/cgi-bin/simplecode.pl?mode=process

Jquery Start count and Brack timer clearTimeout()

The below JQuery Jquery Start count and Brack timer  clearTimeout()




<!DOCTYPE html>
<html>
<body>

<button onclick="startCount()">Start count!</button>
<input type="text" id="txt">
<button onclick="stopCount()">Stop count!</button>

<p>
Click on the "Start count!" button above to start the timer. The input field will count forever, starting at 0. Click on the "Stop count!" button to stop the counting. Click on the "Start count!" button to start the timer again.
</p>

<script>
var c = 0;
var t;
var timer_is_on = 0;
var myCounter = 0;

function timedCount() {
  document.getElementById("txt").value = c;
  c = c + 1;  
  
  t = setTimeout(timedCount, 1000);
  myCounter = myCounter + 1
   if(myCounter == 4)
    {
     c = 0;
     t;
     timer_is_on = 0;
     myCounter = 0;
    clearTimeout(t);
  timer_is_on = 0;
    }
   
}

function startCount() {
  if (!timer_is_on) {
    timer_is_on = 1;
    timedCount();
  
   
  }
}

function stopCount() {
 c = 0;
 t;
 timer_is_on = 0;
 myCounter = 0;
  clearTimeout(t);
  timer_is_on = 0;
}
</script>

</body>
</html>

SQL server find search for Database , Find all stored procedures related tables

Find SP 

sp_helptext 'spname'

Find all stored procedures related tables 

SELECT *  FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%table_name%'

Find all stored procedures newly created

SELECT *  FROM sys.procedures order by create_date desc

Find all stored procedures newly modify

SELECT *  FROM sys.procedures order by modify_date desc

Find all tables 

SELECT * FROM sys.tables

Find table with like

Select * from sys.tables  where name like '%tablename%'

SELECT

    o.name AS ReferencingObject, 

    sd.referenced_entity_name AS ReferencedObject

FROM sys.sql_expression_dependencies  AS sd

INNER JOIN sys.objects AS o

    ON o.object_id = sd.referencing_id

WHERE sd.referenced_entity_name = 'Tabel_Name';

 SELECT name, type   FROM dbo.sysobjects

 WHERE (type = 'P')

"The Devoted Friend" by P. Craig Russsell.

"The Devoted Friend" by P. Craig Russsell.

"The Devoted Friend" is a darkly comic short story for children by the Irish author Oscar Wilde. It was first published in 1888 in the anthology The Happy Prince and Other Tales, which in addition to its title story also includes "The Nightingale and the Rose", "The Selfish Giant" and "The Remarkable Rocket".

The two main characters in "The Devoted Friend" are a poor man known as little Hans and a rich Miller. The Miller claims to be a devoted friend of little Hans. In truth, he selfishly takes advantage of little Hans at every opportunity. Little Hans always does everything that the Miller asks him to do because he does not want to lose the Miller's friendship or offend him. Little Hans' desire to remain the Miller's friend ultimately proves fatal for him.

Plot

"The Devoted Friend" takes the form of a "story-within-a-story". The main narrative is told to a Water-rat by a Linnet. The Water-rat chastises a Duck for allowing her children to misbehave. When the Duck responds that she is a good parent, the Water-rat says that he knows nothing about family life because he is single. He goes on to say that he is not interested in love but thinks that, "there is nothing in the world either nobler or rarer than a devoted friendship". When the Linnet asks the Water-rat what he would expect of a devoted friend, he replies, "I would expect my devoted friend to be devoted to me". In an attempt to show the Water-rat the foolishness of what he has said, the Linnet tells him the story of little Hans and the Miller.

During the spring, summer and autumn, little Hans makes a living by selling the flowers and fruit from his beautiful garden. During the winter, he struggles to survive. Hugh the wealthy Miller, who owns several cows and sheep in addition to his profitable mill, claims to be a good friend of little Hans. He often goes to see him from spring to autumn, always helping himself to a lot of little Hans' flowers or fruit when he visits him. The Miller never goes to see little Hans during the winter, claiming that he is certain that little Hans would not like to be bothered during that difficult time of year.

 the Miller visits little Hans. He finds out that, in order to have any money for food during the winter, little Hans was forced to sell several of his possessions, including his wheelbarrow. The Miller tells Hans that he will give him his old wheelbarrow, which is in very bad condition with one side completely missing. Hans replies that he can repair the wheelbarrow because he has a plank of wood in his house. The Miller says that the plank is exactly what he needs to fix the hole in the roof of his barn. The Miller goes on to ask Hans to fill a large basket with flowers. The Miller tells Hans that it would be unfriendly to refuse him the flowers or the plank since he has promised him his wheelbarrow.

The following day, the Miller tells little Hans to take a sack of flour to market for him. The next day, he tells Hans to fix his barn roof. The day after that, he tells Hans to drive his sheep to the mountain. Each day, the Miller has another task for little Hans which takes Hans all day to perform. The Miller always tells Hans that it would be unfriendly of him to refuse and reminds him that he has promised to give him his wheelbarrow. Little Hans has no time to tend to the garden which he depends on to make a living.

On a stormy night, the Miller comes to little Hans' house. He says that his son is injured and tells little Hans to fetch the doctor. He refuses to lend Hans his lantern because it is a new one. Again, he reminds little hans that he has promised to give him his wheelbarrow and that it would be unfriendly to refuse to help him. Little Hans follows the doctor back to the Miller's house. However, since Hans does not have a lantern and it is raining so heavily that it is difficult to see, Hans gets lost. He wanders onto the moor and drowns in a pool.

The Miller concludes that little Hans died because he promised to give him his wheelbarrow for free. He says, "I will certainly take care not to give anything away again. One always suffers for being generous".

After having heard the story, the Water-rat says that he feels sorry for the sensitive Miller. The Linnet points out that there is a moral to the story which the Water-rat has failed to understand. The Water-rat is horrified when he finds out that the story was supposed to have a moral and leaves in disgust.

Visual Studio 2015 Keyboard shortcuts Ctrl+Shift+R Find relapse

T to access the Find/Replace in Files dialog box, choose Find and Replace on the Edit menu (or CTRL+SHIFT+F). When you choose Find All, a Find Results window opens and lists the matches for your search.

Keyboard shortcuts Ctrl+Shift+R and Ctrl+Shift+P are assigned to the Record Macro and Run Macro commands if they are not used in your Visual Studio keyboard scheme. If they are used, but you want to reassign them to Visual Commander, you can manually assign them in Visual Studio keyboard options for the VCmd.RecordMacro and VCmd.RunMacro commands.
There is only one macro - recording the new macro overwrites the previous one. If you want to save the macro for future regular use, you can manually copy its code to a new command or use the explicit Save Macro as Command menu item.
You can record Find Next and Find Previous commands from the Find and Replace dialog: