DATABASE (SQL) DAY 4) CHANGE DATA TYPE, MULTIPLE STRING,BETWEEN, SQL FUNCTION

                                                 *DATA TYPE*

* HOW TO CHANGE DATA TYPE

*ALTER COMMAND 

 QUERY:-

-: ALTER TABLE stu2 ALTER COLUMN name NVARCHAR(50);

-: SELECT * FROM stu2;

-: SP_HELP stu2;

                                             *STRING QUERY*

* FIND A MULTIPLE STRING IN A QUERY USE IN A QUERY USE IN OPERATOR.

QUERY :-

 SELECT * FROM student WHERE city IN ('NAGPUR','PUNE','NASHIK');

SELECT * FROM student WHERE city NOT IN ('NAGPUR');

SELECT * FROM student WHERE city <>'NAGPUR';


                                                  *BETWEEN*

QUERY:-

SELECT * FROM emp WHERE salary BETWEEN 1000 AND 1800;

INSERT INTO emp VALUES (102,'SOHAM',1200);

INSERT INTO emp VALUES (103,'AJAY',1500);

INSERT INTO emp VALUES (101,'RAMESH',2000);

SELECT * FROM emp;


                                                    *SQL FUNCTION*

*SQL FUNCTION DIRECTRY WORKING ON DATABASE COLOUMN

*THERE ARE SQL FUNCTION.

1)SUM( ), 2)MIN ( ), 3) MAX( ), 4) COUNT( ), 5)AVG( )

   

       

CHANGE DATA TYPE, MULTIPLE STRING,BETWEEN, SQL FUNCTION








Comments

Post a Comment

Popular posts from this blog

DATA CONTROL ( Gridview , Repeater , Formview , DataList , Detailsview , Listview )

  GRIDVIEW SOURCE CODE :      <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"              Height="279px" Width="610px">             <Columns>                 <asp:TemplateField HeaderText="roll">                 <ItemTemplate>                     <asp:TextBox ID="txtroll" runat="server" Text='<%# Eval("roll") %>'></asp:TextBox>                 </ItemTemplate>                 </asp:TemplateField>                 <asp:TemplateField HeaderText="name">                 <ItemTemplate>               ...
Read more

Z 5 ) MVC (Model view Controller)

Image
  MVC (Model view Controller)    Model View Controller   The first version of  MVC is called MVED(Model View Editor) MVC is to multi layer architecture  Model         (class and variables) View          (.cshtml) Controller   (Logic building) MVC is directly operate html page in this reason it is called light weight environment. MVC Block Diagrame   .NET Framework  ASP.NET MVC ASP.Net Webform Benefits of MVC application It is manage complex application Direct control use in html It provide test driven development testing to (url http/data)
Read more

Z 8 ) MVC HTMLHELPER METHOD AND ACTIONLINK (how to use css ,atrributes,style in css)

Image
  HTML HELPER METHODS IN ASP.NET MVC 5 In ASP.NET MVC Framework, helper methods: Ø  Are extension methods to the Html Helper class, can be called only from views. Ø  An HTML helper is a method that is used to render html content in a view. Ø  Simplifies the process of creating a view. Ø  Allows generating HTML markup that you can reuse across the Web application. Some of the commonly used helper methods while developing an MVC application are as follows: Ø  Html.ActionLink() Ø  Html.BeginForm() and Html.EndForm() Ø  Html.Label() Ø  Html.TextBox() Ø  Html.TextArea() Ø  Html.Password() Ø  Html.CheckBox()
Read more