JanBask Training

SQL Server Tagged Posts

How to Use Like Operator in SQL server?

by JanBaskTraining - May 17, 2019 - SQL server

SQL is the common query language to work with databases. When you design a report or using BI or any particular reporting tool, the software is running SQL query behind the scenes and always returns the selected data. When you want to select the desired data based on specific criteria, the WHERE clause is commonly used by the programmer to complete

continue reading..
2 readers |0 Comments|Reply

Coalesce Function SQL Server Example

by JanBaskTraining - May 15, 2019 - SQL Server

String manipulation is the process for transforming existing data into another form that can be used by businesses to generate reports.


continue reading..
3 readers |0 Comments|Reply

How to Create Table in SQL Server by SQL Query?

by JanBaskTraining - Aug 30, 2018 - SQL Server

Data or information in SQL server database is stored in tables. Each table has a unique name that is made up of rows and columns. The columns in a table are specified but it could have a plenty of rows. Each column has a specific name and data type for the column.

Further, Rows contain the records or data for the columns. Here, in this blog, we wi

continue reading..
0 readers |0 Comments|Reply