Right click on the database you want to import/export to, click Tasks, then Import Data/Export Data, then follow the wizard that pops up, it’s pretty straight forward from there. solved Exporting excel spreedsheet to SQL Server Management Studio
WHat Can I do ? During Installing MSSQl server 2014 brings message . An error was encountered. The system cannot read from the specified device solved WHat Can I do ? During Installing MSSQl server 2014 brings message . An error was encountered. The system cannot read from the specified device
Use it as Declare @num int Set @num =1 SELECT * FROM USERLOGIN WHERE USERNAME=@username AND PWD=@PWD AND level = @num if you are using SQL server below 2008 or like Declare @num int=1 SELECT * FROM USERLOGIN WHERE USERNAME=@username AND PWD=@PWD AND level = @num for SQL Server 2008 and above 0 solved Getting … Read more
Your problem is that you are attempting to insert 3 values: values(‘{0}’,'{1}’,N'{2}’) Into 4 columns: (nokar,modeledokht,tozihat,username) I believe you meant to do this: values(‘{0}’,'{1}’,N'{2}’,'{3}’) Side note: Always use Command.Parameters instead of parsing your command as string! When parsing the command as a string, you are subjected to SQL injections and errors like the one you … Read more
Your problem is coming from including columns in SELECT statement from table_2 that do not have values for rows that exists in table_1. You need to change SELECT Table_2.ScriptNumber to SELECT Table_1.ScriptNumber As future reference make sure you always select all relevant columns from LEFT tables and only columns you need from RIGHT table. Otherwise … Read more
With a precision of two decimal places, determine the average number of guns for all battleships (including the ones in the Outcomes table) solved With a precision of two decimal places, determine the average number of guns for all battleships (including the ones in the Outcomes table)
You can use an aggregate function with a CASE expression similar to this: select itemname, sum(case when month(date) = month(getdate()) -1 then amt else 0 end) LastMonthAmt, sum(case when month(date) = month(getdate()) then amt else 0 end) CurrentMonthAmt from yourtable group by itemname; See SQL Fiddle with Demo 0 solved Current month and last month … Read more
Your method is open to SQL Injection. You should try this: protected void Button1_Click(object sender, EventArgs e) { string email = Request.QueryString[“Email”]; cmd.Connection = cn; cmd.CommandType = CommandType.Text; cmd.CommandText = “INSERT INTO Job (Industry, JobPosition, ExactAddress, Region, Salary, JobDesc, EmployerID) VALUES (@industry, @jobPosition, @exactAddress, @region, @salary, @jobDesc, (Select employerid from employer where email = @email))”; … Read more
Is this what you are looking for? SELECT EIID FROM UserTable AS t WHERE strings=”PDSCLm” AND NOT EXISTS ( SELECT 1 FROM UserTable AS t2 WHERE t.EIID = t2.EEID AND t2.strings IN (‘JPNaOn’, ‘PDSCLs’) ); 0 solved How to find particular string value for the particular group ID in a table? [closed]
Collect your error messages, if you get none return the result of your query, else return or raise the collected errormessages. Declare @a Table (a int,b int,c int) insert into @a Values(1,2,3),(4,4,4) Declare @va int=2 Declare @vb int=2 Declare @vc int=2 Declare @error Varchar(100)=” if not exists(select * from @a where a=@va) Select @Error=@Error + … Read more
As I wrote in the comment the answer of your first question is: If I understand your PRC well, in case of @IP = ” it should returns a wieder set of members. I think it is possible that the Username, Email or Country is longer in the member table then the @Temp table’s definition. … Read more
Here is how you use a parameter in your first insert statement. I think you still have some very serious logic issues here though. This is going to insert 1 row into StockDetail and the values don’t make any sense at all. You would be inserting the count of rows from the Branch table as … Read more
create the UFN_STRING_SPLIT function suggested by @Dave here link create FUNCTION [dbo].[UFN_STRING_SPLIT] ( @List NVARCHAR(MAX), @Delimiter NVARCHAR(255) ) RETURNS TABLE WITH SCHEMABINDING AS RETURN ( SELECT Item = y.i.value(‘(./text())[1]’, ‘nvarchar(max)’) FROM ( SELECT x = CONVERT(XML, ‘<i>’ + REPLACE(@List, @Delimiter, ‘</i><i>’) + ‘</i>’).query(‘.’) ) AS a CROSS APPLY x.nodes(‘i’) AS y(i) ); test your code: … Read more
Final update After yet another goal post shifting, I’ve updated my CTE again. This is the final update since even if you are going to change your demands again I’ve had enough. Please take my advice for future questions: Defind the problem as well as you can. Provide the most accurate table structure and sample … Read more
You can make use of Pivot function in SQL server: Demo SELECT * FROM TABLE1 PIVOT(MIN(QTY) FOR [YEAR] IN ([2017], [2018], [2019], [2020])) PIVOT_TABLE; solved Pivot Data on A SQL WITH Query