Learn With Sundar

Get Started

  • Difference Between Drop Table, Truncate Table & Delete Table in MS SQL Server – Zero to Hero Query Master – Part 6

    Introduction In this article, we will discuss the difference between Drop Table, Truncate Table, Delete Table. To perform dropping, deleting and truncating a table, I am creating three tables. With these three tables let’s look into more:  Students.StudentDetails Students.StudentMarks  Students.StudentClass Drop Table The syntax for dropping a table in MS SQL is,  Syntax Example When…

  • Tables in Database- MS SQL Server – Zero to Hero Query Master – Part 5

    Introduction All the data in a database is stored in a Table, which is a data object. Data is organized in Rows and Columns in a table and each row represents a unique record while each column represents a field in the record Types of Tables SQL Server provides the following types of tables that…

  • How is Data Stored in SQL Database

    Introduction Being Software Developer / DBA / Database Developer, its important to know or understand the concept How the Data is Stored in SQL Database. This knowledge is very important when we want to troubleshoot and fix SQL queries that are not performing well from the Tuning point. In this article, we will discuss how…

  • Get Started with SQL Server Machine Learning Services – Part 1

    Introduction We know Humans learn from their past experiences. Mean while Machines follow Instructions given by Humans. But what if Human can train Machines to learn from the past data?. In simple, this is what Machine learning is !!!!. SQL Server has capabilities of Machine Learning. In this article, we will discuss about the capabilities…

  • SQL Server Date Functions

    Introduction Date and Time plays major role in many projects. SQL Server has several date and time functions. In this article, we will discuss all the Date and Time functions in SQL Server with an Example. CURRENT_TIMESTAMP() Returns the date and time of the machine the SQL Server is running on. Example DATEADD() Adds a…

  • SQL Server String Functions

    Introduction In this article, we will discuss about the SQL Server String Functions (built in functions) in SQL Server. String Functions in SQL Server ASCII() Return the ASCII code value of a character CHAR() Convert an ASCII value to a character CHARINDEX() Search for a substring inside a string starting from a specified location and…

Subscribe

Enter your email below to receive updates.