You can't use wildcards in statements like you want. The easiest way for you to do what you want is to just grant the user the db_datareader role and make sure they're not part of a group with the ...
Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...
If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...
You can code a SQL SELECT statement in a number of ways to get the same results, but some versions of the same query may perform betterthan others. In this tip we ...
Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results