SQL

Scenario : User defined function return one table. If that table contains at least one row,one column in the table variable from another sp should get updated.

Should I use cross join on UDF to update table variable?

sql

I was trying to run my amazon RDS account using MS SQL server management studio, and was able to login succesfully but when using that values in web.config and loading page in browser, I am getting error as below

"Login failed. The login is from an untrusted domain and cannot be used with Windows authentication."

How Can I resolve this issue, here is my Connection string

Today, I was trying to Start my SQL server browser using SQL server configuration manager in windows 10, but I cannot see any option to start it as it is blurred and not clickable, so cannot start SQL server browser, here is the screenshot of my pc

...

I would like to know a sql query to find all missing dates between two dates , suppose my sql table is as below

I need to run sql query which will return missing dates from date column like  ‘2018-1-11’ , ‘2018-1-14’.

I have to write a pseudocode program to read the two sample files, calculate and print the final mark for each subject, as well as the average final mark per student.

Document the code well using comments.

The final mark is calculated as 25% of the year mark, 25% of the prac mark and 50% of the exam mark.

Assume the records of the two files are arranged in Student number (S-no) sequence. Note that some students have more subjects than others….

I was tasked with the above program and im not sure how to express this in pseudo code.

Hello, I am trying to get Sum of three columns from three different table and get results table using SQL.

Suppose here are my tables

Table 1: raw_item_fcst

Table 2. Raw_item

Table 3 . inventory_data

I try to write query to fetch data from these tables using subquery , Here is my sub query

Hi, I have deleted my database by accidentially in sql server 2017 is there is any way to recover it? Thanks.

I want sum of two column values from two different tables, how can I do it using SQL?

Suppose, these are my two tables, Table 1

I am using SQL server Express 2012 in my new windows 10 laptop, now I need to open SQL server configuration manager in windows 10? Where can I find it in Windows 10, in Windows 7, it was easier to navigate and check it in All Programs -> SQL server 2012 -> SQL server configuration manager, but in Windows 10 I cannot find it.

Where can I find it in windows 10? I tried to check in All programs but wasn't able to find it.

Thanks