MSSQL and TSQL Programming and TSQL Examples
Hello everyone, In this article, I will try to give information about the Split function in SQL Server. In SQL Server, in some cases, you may want to show the comma strings you have in a tabular form by separating them with Id. You can easily do this using the...
Hello everyone, In this article, I will try to give information about listing all users in SQL Server. In SQL Server you may want to list all users in some cases. You can easily do this using the code below. SELECT name AS username, create_date, modify_date, type_desc AS type, authentication_type_desc...
Hello everyone, In this article, I will try to give information about getting the Schema list in SQL Server. In SQL Server you may want to get the Schema list in some cases. You can easily do this using the code below. SELECT s.name AS schema_name, s.schema_id, u.name AS schema_owner...
Hello everyone, In this article, I will try to give information about the keyboard shortcuts used in SQL Server. Using keyboard shortcuts can be useful in some situations in SQL Server. CTRL-SHIFT-F2 — Clear all bookmarks. CTRL+F2 — Insert or remove a bookmark (toggle). F2 — Move to next...
Hello everyone, In this article, I will talk about the use of For XML Path in SQL Server. In SQL Server, the For XML Path statement is an expression used to output XML. It is a structure similar to the use of For XML Explicit. It is easier to use....
Hello everyone, In this article, I will talk about the use of For XML Explicit in SQL Server. In SQL Server, For XML Explicit statement is used to output XML. The For XML Explicit statement is used with Tag and Parent statements. You might be a little confused when used...
Hello everyone, In this article, I will try to give information about how to calculate the year difference between two dates in SQL Server. In SQL Server, in some cases you may want to find the difference in years between two dates. You can easily do this using the code...
Hello everyone, In this article, I will try to give information about the creation and updating of Trigger in SQL Server. In SQL Server, in some cases, you may want to view the creation and update details of the Trigger. You can easily do this using the code below. SELECT...