42 0
How to update table variable in stored procedure from another user defined function in 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

...
Type
Question
Sql table variable Sql
1569 0
SQL server date format and converting it (Various examples)
This article provides you in-depth knowledge of SQL server date format available and how to convert from one date format to other using examples
Type
Article
SQL Sql server date format date format conversion SQL
1988 0
How to back up SQL Server database ? (Various Ways explained)
This article explains various ways to backup SQL Server database using C#, using Powershell script, by generating scripts in SQL server or writing a script.
Type
Article
C# SQL sql server backup database backup sql server
238 0
Common Table Expressions (CTE) in Sql server
In this article, I have explained what is Common Table Expression (CTE), Advantages of using CTE and Recursive CTE in SQL using SQL server based example.
Type
Article
sql sql server cte in sql server cte sql
187 1
Error "Login failed. The login is from an untrusted domain and cannot be used with Windows authentication." in SQL server

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

...
Type
Question
SQL SQL-Server

242 1
Not able to start SQL server browser in windows

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

...

Type
Question
SQL SQL-server sql-server-browser
617 1
How to find missing date between two dates in sql table.

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

ID

Date

1

2018-1-10

2

2018-1-12

3

2018-1-13

4

2018-1-15

5

2018-1-17

6

2018-1-18

7

2018-1-20

8

2018-1-21

 

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

 

...
Type
Question
sql date sql-server
142 0
How to find missing date in sql table.

I have data like this,

ID

Date

1

2018-1-10

2

2018-1-12

3

2018-1-13

4

2018-1-15

5

2018-1-17

6

2018-1-18

7

2018-1-20

8

2018-1-21

 

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

 

...
Type
Question
sql date
636 1
Pseudo code in SQL

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.

 

...
Type
Question
SQL Pseudo
1851 0
Stored procedure in sql server (With Example)
In this article, I have explained basics and important points to understand stored procedure in sql server with examples.
Type
Article
SQL stored procedure in sql server stored procedure in sql sql create stored procedure sql server procedure

Page 1 of 5