Always use parameterized query anyway correct your current attempt as below “INSERT INTO tbl_user (UserID, UserName, UserName , UserType) VALUES(‘” + myUser.ID + “‘,'” + myUser.Name + “‘, ‘” + myUser.Password + “‘, ‘” + myUser.Type + “‘)”; RECOMMENDED Way is to Go with parameterized query always to prevent SQL Injection Attacks SqlCommand cmd = … Read more
A simple aggregate query something like this will work SELECT COUNT(*) inserts, DATEPART(HOUR,orderreceivedTime) hour FROM order GROUP BY DATEPART(HOUR,orderreceivedTime) solved SQL find Peak Hour and Peak off Hour from the table
Add <select name=”foo” onchange=”javascript:this.form.submit();”> solved Help needed in refining PHP search [closed]
Create your table taro: SELECT * INTO taro FROM ( SELECT 1111 AS [C no.], ‘ken’ AS [Name], ‘shiro’ AS Item, ‘3/3/2000 12:22’ AS [Date], ‘$25’ AS Amount UNION ALL SELECT 1111 AS [C no.], ‘ken’ AS Name, ‘aeshte’ AS Item, ‘3/3/2000 12:22’ AS [Date], ‘$25’ AS Amount UNION ALL SELECT 1111 AS [C no.], … Read more
You could try using UNION ALL for build a unique column result and select the max from this select max(col) from ( select col1 col from trans_punch union all select col2 from trans_punch) t solved I want to retrieve max value from two column – SQL table
Try this, you are missing “+”s and “‘”s: DECLARE @SQL NVARCHAR(MAX) = N’ SELECT CASE WHEN ISNULL(10, ””) = ”” AND ISNULL(””, ””) = ”” THEN ”” ELSE CONVERT(NVARCHAR(5), 10) + ‘ + ”’ To ”’ + ‘ + CONVERT(NVARCHAR(5), 20) END;’; SELECT @SQL; EXEC(@SQL); 1 solved syntax error while executing sql [closed]
Picture paints a thousand words No! Don’t post pictures of data or code! Your question is not at all clear, even with the picture. And – looking at my attempt to answer – you see, that I had to type in a test scenario. This was your job actually… For the next question please provide … Read more
So I solved this myself by using a Sub-query. The nature of the the requirement meant that it was difficult for me to produce a list which eliminated the duplicates, because i was looking in a joined table for results which may or may not appear. So i used a sub-query in the where clause … Read more
Seems like you want to turn a base36 number into a base10 number. Then you could create a function for base conversion. The function create function dbo.fnBase36ToBase10(@input varchar(8)) returns int as begin declare @base36string varchar(8) = upper(@input); declare @result int = 0; declare @basechars varchar(36) = ‘0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ’; declare @N int = 36; declare @digit char(1); … Read more
Your question and your error arent related. For your client, you need to install Sql Express. LocalDB deployment on client PC For the flash error, you need to check where you are using flash and make sure is also installed. 2 solved How to create software .exe file attached it with database which can able … Read more
try this: create table City ( Id int, Name varchar(50) ); insert into City (Id, Name) VALUES (1, ‘Toronto’), (2, ‘Chicago’) create table Libraries( Id int, Name varchar(50), CityId int ); insert into Libraries (Id, Name, CityId) VALUES (1, ‘Toronto Library 1’, 1), (2, ‘Toronto Library 2’, 1), (3, ‘Chicago Library 1’, 2), (4, ‘Chicago … Read more
SELECT MYTABLE1.*, MYTABLE2.* FROM MYTABLE1 LEFT OUTER JOIN MYTABLE2 ON same WHERE XXX The ON does not have to relate the two tables This is more like a filtered cross join 1 solved Convert multiple sub-queries to on join [closed]
You’ll want to use the sys.databases table for that probably; SELECT name FROM sys.databases 5 solved How to display a list of the database? [closed]
WITH recentPhone as ( SELECT Cname, MAX(MobileSI) as recentSI from RECORDS GROUP BY Cname ) SELECT CASE WHEN earlier.Mname is null THEN RECORDS.Cname + ‘ has just got their first mobile, a ‘ + RECORDS.Mname ELSE RECORDS.Cname + ‘ has upgraded from a ‘ + RECORDS.Mname + ‘ to a ‘ + earlier.Mname END as … Read more
Jain, it looks like you are trying to adapt the code in the answer here to your own situation. What Andomar did there was to select the information from a subquery which contained only a single value, since he didn’t have access to the original poster’s source and tables. Doing it that way allows everyone … Read more