When autocomplete results are available use up and down arrows to review and enter to select. Touch device users, explore by touch or with swipe gestures.
In a database I was able to create a stored procedure. However, when I went to execute the stored procedure, SQL Server told me I didn't have permission to do so. Is this a bug or did I do something wrong? In this tip we look at this issue.
Master SQL IN 16 pages: Whether An Amazing SQL Guide That You'll Love! This guide is a one-stop resource for SQL, covering everything from simple SQL commands to complex things like window functions, and it does all this in only 16 easy-to-understand pages! It also includes real-world examples that make learning easier. Here's a quick look at what's inside: 📍Basic SQL commands: Start learning SQL with these. ⚫ SQL Joins: Learn how to bring data together from different places. 📍SQL Unions...
More about this Pin
In a database I was able to create a stored procedure. However, when I went to execute the stored procedure, SQL Server told me I didn't have permission to do so. Is this a bug or did I do something wrong? In this tip we look at this issue.
Many companies now have a requirement to keep data for long periods of time. While this data does have to be available if requested, it usually does not need to be accessible by the application for any current transactions. Data that falls into this categ
I'm planning on patching my SQL Servers to the latest service pack, but I’m not sure how to complete this for a environment that is using database mirroring. In this tip we cover the steps.
As we continue our series of tips on getting started with developing with .NET and SQL Server we look at how to use the data grid view with SQL Server data.
I'm planning on patching my SQL Servers to the latest service pack, but I’m not sure how to complete this for a environment that is using database mirroring. In this tip we cover the steps.
SQL Exercise, Practice and Solution: From the following table, write a SQL query to find the details of those salespeople who live in cities other than Paris and Rome. Return salesman_id, name, city, commission.
I was recently asked if we are going to see performance differences if we explicitly drop temporary tables. I couldn’t remember the specifics, but I said it actually didn’t matter. However, that answer has bugged me, so I set up a quick test. Explicitly Drop Temporary Tables We could make this a crazy set of […]