List/Grid SQL Server Subscribe RSS feed of category SQL Server
How To Select Current Date In SQL Server
While working in SQL Server, often you need to select current date. There are many ways to get the current date using queries in SQL Server, but the result SQL Server gives you always have the full date and time value. There are number of ways to extract only the Date Part from a DateTime field that SQL Server gives us. When I had Database Concepts as a course in…
How To Restore Database Backup In SQL Server
You have a backup of your Database and you want to apply that, because your Database got corrupted. I will be using SQL Server 2008 for the example purpose in this article. Instructions: In the SQL Server, open Object Explorer. If you don’t able to find it, Go to View menu and select Object Explorer. In the Object Explorer, Expand Server instance and select the Database you want to take…
How To Backup A SQL Server Database
It is a recommended step, if you are working on a project that regularly communicate with your Database and you have a number of subscribers. Because at any time, by any means, if your database gone corrupt, you will be in a great problem if you haven’t taken backup of your Database. Instructions: In the SQL Server, open Object Explorer. If you don’t able to find it, Go to View…
How To Create A New SQL Server Login
You need a SQL Server Login to connect to SQL Server. If you are sharing database with other your, then you will be creating a new login for the other user, instead of sharing a same login because of security purposes. In SQL Server, there are two kinds of Login available : Windows Authentication, SQL Server Authentication. I will be showing you how to create both types of Logins. Instructions:…
How To Create A New Database User In SQL Server
In this article, I will show you how you can create a new user in SQL Server. I will be using SQL Server 2008 for this article. Instructions: Open SQL Server Management Studio and Open “Object Explorer”. Expand “Database” folder and select the database for which you want to create a new user. Expand that database, right clink on Security folder for that database and choose New->User. In the Create…