MSSQL and TSQL Programming and TSQL Examples
Hello to everyone, In this article, I will try to give information about creating Entity Class from database table in SQL Server. In SQL Server, in some cases you may want to create Entity Class from database table. You can easily do this using the code below. DECLARE @TableName sysname...
Hello to everyone, In this article, I will try to give information about listing the IDENTITY columns of all tables in SQL Server. In SQL Server, in some cases you may want to list the IDENTITY columns of all tables. You can easily do this using the code below. SELECT...
Hello to everyone, In this article, I will try to give information about the function that removes duplicates from a comma-separated string in SQL Server. In SQL Server you may want to remove duplicates from comma separated string in some cases You can easily do this using the function below....
Hello to everyone, In this article, I will try to give information about listing active connections in SQL Server. In SQL Server you may want to list active connections in some cases. You can easily do this using the code below. select db_name(dbid) as DatabaseName, count(dbid) as NumberOfConnections, loginame as...
Hello to everyone, In this article, I will try to give information about getting a list of all logins and all logins under all windows group in SQL Server. In SQL Server, in some cases you may want to get a list of all logins under all logins and all...
Hello to everyone, In this article, I will try to give information about finding words with all capital letters in SQL Server. In SQL Server you may want to find words with all caps in some cases. You can do this easily using the code below. SELECT * FROM dbo.Categories...
Hello to everyone, In this article, I will try to give information about getting the first and last day of the year in SQL Server. In SQL Server you may want to get the first and last day dates of the year in some cases. You can easily do this...
Hello to everyone, In this article, I will try to give information about not showing the time expression in the date information in SQL Server. In SQL Server, in some cases, you may want to not show the time expression in the date information. You can easily do this using...