SQL server 跟Access的语句是不是一样的?
以前没有用过Access只用过SQL server,请问它们的语句是不是一样的?
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM Atable where uid=@uid" InsertCommand="INSERT INTO Atable(name,sex,address) VALUES (@name,@sex,@address)"
ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT uid, name, address, sex FROM Atable"
UpdateCommand="UPDATE Atable SET address =@address, name =@name,sex=@sex, where uid=@uid">
<UpdateParameters>
<asp:Parameter Name="name" Type="String"/>
<asp:Parameter Name="address" Type="String"/>
<asp:Parameter Name="sex" Type="String"/>
</UpdateParameters>
<InsertParameters>
<asp:ControlParameter ControlID="TextBox1" Name="address" PropertyName="Text" Type="String" />
<asp:ControlParameter ControlID="DropDownList1" Name="sex" PropertyName="SelectedValue"
Type="String" />
<asp:ControlParameter ControlID="TextBox2" Name="name" PropertyName="Text" Type="String" />
</InsertParameters>
<DeleteParameters>
<asp:Parameter Name="uid" Type="String" />
</DeleteParameters>
</asp:SqlDataSource>
这里面的四个SQL语句有没有出错?(运行时老是提示出错!!汗)