Many a times we may need to get the Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server. In this article we will see how we can get these parts of the DateTime in Sql Server. You may like to read the other popular articles on Date and Time: How to get… Continue reading How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server
I have a table of students: id | age ——– 0 | 25 1 | 25 2 | 23 I want to query for all students, and an additional column that counts how many students are of the same age: id | age | count —————- 0 | 25 | 2 1 | 25 |… Continue reading Count occurrences of a column value efficiently in SQL
1) This is the best Solution. First of all run following T-SQL Query in Query Analyzer. This will return all the existing users in database in result pan. USE YourDB GO EXEC sp_change_users_login ‘Report’ GO Run following T-SQL Query in Query Analyzer to associate login with the username. ‘Auto_Fix’ attribute will create the user in… Continue reading SQL Server 2012 Error 15023 : User already exists in current database.
If the transaction log file (.ldf) in Microsoft SQL is too big, it can cause performance issues, eat up valuable disk space and consume resources when you back up. Therefore it’s imperative to periodically maintain the database to keep the .ldf file under control. To reduce the .ldf file, you must do threethings: Backup the… Continue reading How to Shrink LDF File Size using SQL Management Studio
This kind of error I get trying to edit rdl file by Report Bulider 3.0. After while I figured out that I need do this two steps : 1. Open a command prompt. Enter the following: rundll32 dfshim CleanOnlineAppCache Press Enter. 2. Go to the C:\Users\[User Name]\AppData\Local\Apps\2.0 Delete the all temporay files. *You may want… Continue reading Unable to install this application because an application with the same identity is already installed.
Problem Sometimes you may have issues connecting to SQL Server and you may get messages such as the following: ERROR: (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error:) An error has occurred while establishing a connection to the server. (provider: Named Pipes Provider, error:… Continue reading Resolving could not open a connection to SQL Server errors
In this article I will show you real example of the usage of Column Visibility property in SSRS. Column visibility property is used to show or hide the column in the report. Now in this article, we can use this property to allow the users to select columns what they want to see in a… Continue reading Conditionally Setting Column Visibility in SSRS