Reputation
Next tag badge:
629/400 score
66/80 answers
Badges
10 136 230
Impact
~902k people reached

May
2
comment show invalid object name
It depends. You could try String sql = "select * from dbo.login where loginname=? and password=?"; but there's really not enough information in the question to do more than guess. Perhaps ask on Stack Overflow but make sure the question is clear and answerable. See their Help Center for advice.
May
2
revised Field types for columns in a MySQL query
added 19 characters in body
May
2
revised Percona 5.7 tokudb poor query performance - wrong (non-clustered) index chosen
Not my answer; I just edited it.
May
2
answered SARGable WHERE clause for two date columns
May
2
revised SARGable WHERE clause for two date columns
Removed self-answer; edited tags; incorporated information in comments
May
2
revised Selecting one row from each group based on a Varchar field
Incorporated improvements suggested by Andriy M
May
2
revised Recreate a table that was deleted during an ALTER statement (errno: -1)?
Incorporated comments; edited tags
May
2
revised Selecting one row from each group based on a Varchar field
Typo
May
2
revised Selecting one row from each group based on a Varchar field
Incorporated comment by Serg
May
2
revised Field types for columns in a MySQL query
Incorporated comments
May
2
comment show invalid object name
I'm closing this question because it is off-topic.
May
2
comment show invalid object name
Does the login table exist in the database you are connecting to? Which schema is it in? You should use the schema prefix with SQL Server, for example dbo.login. The question is lacking detail, and is more of a programming question than a database question. See What topics can I ask about here? in our help center.
May
2
revised Get data from previous years dynamically
Removed horizontal scroll bar from code
May
2
reviewed Edit Get data from previous years dynamically
May
2
revised Get data from previous years dynamically
Improved suggested edit
May
2
reviewed No Action Needed Importing a large column (8000 chars) from Excel using SSIS
May
2
revised SQL Logins in db_owner role on database cannot create stored procedures
Incorporated comments
May
2
revised Sybase 12 to behave like Oracle and SQL Server 2014 - non blocking transaction read
edited tags
May
2
revised Percona 5.7 tokudb poor query performance - wrong (non-clustered) index chosen
added 42 characters in body
May
2
answered Capitalize only the first letter of a name