You didn’t tell what is wrong exactly but I see a few things wrong in your code. You should always use parameterized queries. This kind of string concatenations are open for SQL Injection attacks. I assume your Scor and ID columns are numeric, not character. That’s why you should not use single quotes with it. … Read more
Join the tables, concatenate the strings and use LIKE to look for the “certain text”. SELECT p.path + ‘\’ + d.filename FROM documents d INNER JOIN documentsinprojects dp ON dp.documentid = d.documentid INNER JOIN projects p ON p.projectid = dp.projectid WHERE p.path LIKE ‘%certain text%’ AND d.filename LIKE ‘%certain text%’; 4 solved Microsoft SQL Server: … Read more
The problem is not at the procedure it is at the calling. When you call the stored procedure, you need to declare and pass in the required parameter declare @NAME VARCHAR(50), @CITY VARCHAR(200), @MOBILE NUMERIC(20) execute GETDETAIL @AGE = 21, @NAME = @NAME OUTPUT, @CITY = @CITY OUTPUT, @MOBILE = @MOBILE OUTPUT SELECT @NAME, @CITY, … Read more
Use the answer to this question to sort both sides of the comparison alphabetically, and then compare the two sides with an equals operator. solved Convert SQL query to SQL Server [closed]
You are appending mainmenu.tbxSelected whereas I suspect that your intention was to append mainmenu.tbxSelected.Text The former would probably result in a fully qualified typename in your WHERE clause, which would contain commas. As an aside, you should be aware that constructing SQL in this way leaves you potentially open to SQL Injection attacks. If that’s … Read more
It seems for what you are trying to do, that what you need is an UPDATE statement and not an INSERT as you are writing. This seems a much more appropiate query: UPDATE GradeTable SET Grade = @grade, UserID = @UserID, RegDate = @RegDate WHERE StudentID = @StudentID AND CourseID = @CourseID Note that I … Read more
UPDATE whatever_your_table_is_called SET seconddescription = longdescription ,longdescription = seconddescription solved SQL Server, replace value of column A with value of column B, and value of column B with value of column A
This should look more like this: DateTime now = DateTime.Now; DateTime after1month = DateTime.Now.AddMonths(1); SqlCommand cmd = new SqlCommand(“SELECT * FROM TABLE WHERE THEDATE BETWEEN @now AND @after1month”, connection); cmd.Parameters.Add(new SqlParameter(“@now”, System.Data.SqlDbType.DateTime).Value = now); cmd.Parameters.Add(new SqlParameter(“@after1month”, System.Data.SqlDbType.DateTime).Value = after1month); Sometimes you can do it directly on SQL Server side using query: SELECT * FROM TABLE … Read more
Try this code: select id, max(case when seqcnt = -1 then frequency end) [oldfrequency], max(case when seqcnt = 1 then frequency end) [newfrequency] from ( –this subquery will create new column named seqCnt, which will be equal to: — -1 when this is the first seqno — 1 if this is the last seqno — … Read more
If you’re fetching the value into C#, you can use the DateTime.ToString(“dd/mm/yyyy”) on the front end. solved how to display only date in web page [closed]