<div>
what is the database? not all database systems allow the * in the DELETE statement.
</div>


what is the database? not all database systems allow the * in the DELETE statement.

<div>
for the reference:<br />
<a href="http://msdn.microsoft.com/en-us/library/ms189835.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms189835.aspx</a><br />
sql server does not allow the *<br />
<br />
while ms access does:<br />
<a href="http://msdn.microsoft.com/en-us/library/bb177896.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/bb177896.aspx</a>
</div>


for the reference:
http://msdn.microsoft.com/en-us/library/ms189835.aspx [http://msdn.microsoft.com/en-us/library/ms189835.aspx]
sql server does not allow the *

while ms access does:
http://msdn.microsoft.com/en-us/library/bb177896.aspx [http://msdn.microsoft.com/en-us/library/bb177896.aspx]

<div>
Is that rule only for the SQLDataReader?. &nbsp;I use the &quot;*&quot; in my queries all the time, including directly through the Query Analyzer.
</div>


Is that rule only for the SQLDataReader?.  I use the "*" in my queries all the time, including directly through the Query Analyzer.

<div>
oops. &nbsp;duhhh.. &nbsp;Since I usually use the DELETE in conjunction with WHERE, I overlooked it. &nbsp;I was thinking &quot;TRUNCATE TABLE&quot;.. &nbsp;My Bad...<br />
<br />

</div>


oops.  duhhh..  Since I usually use the DELETE in conjunction with WHERE, I overlooked it.  I was thinking "TRUNCATE TABLE"..  My Bad...



<div>
<div class="content wysiwyg-content">
I'm new to C#, but this SQL statement is giving me errors; &quot;SQLException Unhandled, Incorrect syntax near &quot;*&quot;&quot;<br />
<br />
Here is the code:<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlCommand command = conn.CreateCommand();<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.CommandText = &quot;DELETE * FROM MASTER&quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; command.CommandType = CommandType.Text;<br />
<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SqlDataReader reader = command.ExecuteReader();<br />
<br />
Since when can't I use an &quot;*&quot; in a SQL statement? &nbsp;If I change the statement to a simple &quot;DELETE FROM MASTER&quot; it works fine. &nbsp;- confused..
</div>
</div>


I'm new to C#, but this SQL statement is giving me errors; "SQLException Unhandled, Incorrect syntax near "*""

Here is the code:

            SqlCommand command = conn.CreateCommand();
            command.CommandText = "DELETE * FROM MASTER";
            command.CommandType = CommandType.Text;

            SqlDataReader reader = command.ExecuteReader();

Since when can't I use an "*" in a SQL statement?  If I change the statement to a simple "DELETE FROM MASTER" it works fine.  - confused..

What is wrong with this SQL statement?, C# is giving me errors..

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.