N a g a s a i
Software Engineer, Blogger, Gadgets, Sports, Circket, Movies and Gamer.
Showing posts with label
SQL Azure
.
Show all posts
Showing posts with label
SQL Azure
.
Show all posts
Wednesday, January 23, 2019
Get Current TimeZone Name in SQL Server
›
Here is how we can get current time zone from sql server DECLARE @TimeZone VARCHAR(50) EXEC MASTER.dbo.xp_regread 'HKEY_LOCAL_MACHINE...
Friday, June 08, 2018
Determining which version and edition of SQL Server Database Engine is running
›
Open SQL Server Management Studio (SSMS) and connect to SQL Server. Run below query to find version and edition of SQL server. SELECT ...
Sunday, November 27, 2016
EXCEPT and INTERSECT in T-SQL
›
The UNION, EXCEPT and INTERSECT operators of SQL enable you to combine more than one SELECT statement to form a single result set. The UNION...
Wednesday, January 20, 2016
How can I list all foreign keys referencing a given table in SQL Server?
›
Here is how you can get list of all foreign key references using below query for all tables in your database SELECT obj.name AS FK_NAME,...
Thursday, January 06, 2011
SQL Server AZURE code-named "Denali" is ready for Download
›
Microsoft SQL Server code-named “Denali” empowers organizations to be more agile in today’s competitive market. Customers can efficiently de...
›
Home
View web version