SELECT CONVERT(NVARCHAR(12),GETDATE(),131) AS 'Hijri Date'

OutPut: 28/08/1433

SELECT CONVERT(NVARCHAR(12),GETDATE(),130) AS 'Hijri Date'

OutPut : 28 شعبان 143

A Function Dependency tells you the relation ship of two columns in the a table.Functional Dependencies are fundamental to the process of Normalization that describes the relationship between attributes(columns) in a table.

For example, if A and B are ..............

Many times such requirement comes wherein you need to copy data from one database to another database. Below is the sample sql script demonstrating the same.

You can use a three part qualifier like DatabaseName.Schema.TableName to address a table in a different database.

Use Database1

INSERT INTO Databas2.dbo.TableName
SELECT * FROM Database1.dbo.TableName

You just need to make sure the selected data matches the datatypes in the destination table.

Here is simple sql update script with inner join in the statement
Update docs
set FileName = 'abcd’, FileNo = b.FileNo + 1
from DocAttributes a
inner join Docs b on a.DocID = b.DocId
where a.doctypeId = 2

There several ways you can check when was SQL server restarted last time. Below are some sql queries to quickly find out the server restart date time. You can run any one of below, all will give same result.

SQL Script to check number of CPU installed on the server.

Physical CPU (Core) = CPU Count / Hyper threaded Ratio

Here is the script which will rebuild all the indexes for all the tables in your database.