mssql server where condition

June 18, 2017

 SQL server where condition First example showing you numeric in mssql server  where condtion. and 2nd showing you string example. third one showing boolain.   select * from table where columname = 12 select * from table where columname = ‘abc’ select * from table where columname = 0    —zero or 1 true and […]

Mssql server

How to delete record mssql

June 16, 2017

 How to delete record via mssql   “delete from table”         —-Delete all records in table “delete from table where column = value”  —-Delete record with condition. Please do comments if you have any question.share with your friends.

Mssql server

MSsql update query

June 16, 2017

 MSsql update query update query syntax first write update Then your Table Name then write set then column name and colum = equal to your value ‘abc’  then where condition if you condition on fix record. Update testtable set Name = ‘abc’ where id = 5  — what ever your record id or if you […]

Home Mssql server

Mssql DISTINCT Query Example

June 16, 2017

 Mssql DISTINCT query example First i am going to showing you my table data. below 1st image.   Now i am going to distinct this table its mean that if germany or what ever your data more then one time it will be show it one time like below last image example. Please do comments […]

Mssql server

Simple MSSql server select query

June 16, 2017

 Simple Sql server query Simple Sql query. select * from tableName   when you run this query you will get result like that.

Mssql server

Disable Back button in browser

June 15, 2017

 Disable Back button in browser Html,,mvc,php Add below script in head tag <script type = “text/javascript” > function GOBack() { window.history.forward(); } setTimeout(“GOBack()”, 0);   </script>

Home Javascript

Basic angular js

June 14, 2017

  Basic angular js First Add this in head <script src=””></script> Then  Add it to body <div ng-app=””> <p>input box</p> <p>Xyz your text : <input type=”text” ng-model=”xyz” placeholder=”xyz enter here”></p> <h1>here is your text {{xyz}}</h1> </div> Please Follow us for more

Angular js Php

Bootstrap basic

June 13, 2017

 First of all Add link in head. <meta name=”viewport” content=”width=device-width, initial-scale=1″> <link rel=”stylesheet” href=””> <script src=””></script> <script src=””></script> Then first create container in div then row in div  and then column show you example below. i will define how column md sm lg next post.   In body <div class=”container”>   <div class=”row”>     […] Bootstrap Mvc Php