784 1
Relational Algebra and Relational Calculus

I am new to Database systems and I don't really have the best lecturer and we are learning about Relational algebra and relational calculus, not many videos or help online. 

Please can someone assist me with this topic as i would like to get further knowledge 

...
Type
Question
733 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
704 1
Get sum from three table and selected data using SQL

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

sql-table-fetch-data-from-three-tables-min.png


Table 2. Raw_item

table-2-min.png

Table 3 . inventory_data

table-3-min.png

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

...
Type
Question
694 0
Check database size in Sql server ( Various Ways explained)
In this article, I have explained, how you can check database size in SQL server using various possible ways, easily.
Type
Article
692 2
Can i have example of declare table and temp table in sql ? and how the update operation can be used on it ?

Can i have example of declare table and temp table in sql ? and how the update operation can be used on it with real life scenario ?

 

...
Type
Question

569 2
How to count the occurrence of specific word inside a string in sql server 2008?

Hi. Suppose, I have for example this string field in my sql database  "never say never"  and I want to count how many times "never" appear in the string in sql server 2008, so how I can check that.

Thanks.

...
Type
Question
488 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
442 1
I have deleted my database by accidentially in sql server 2017 is there is any way to recover it?

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

...
Type
Question
416 0
Query in Sql server to list all stored procedures in all databases
In this short article, I have provided simple query using which we can list all stored procedures in all database of SQL server or all stored procedures of specific database.
Type
Article
332 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

Page 5 of 6