Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
3r3r
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' DECLARE @JSONData AS NVARCHAR(4000) SET @JSONData = N'{ "EmployeeInfo":{ "FirstName":"Jignesh", "LastName":"Trivedi", "Code":"CCEEDD", "Addresses":[ { "Address":"Test 0", "City":"Gandhinagar", "State":"Gujarat"}, { "Address":"Test 1", "City":"Gandhinagar", "State":"Gujarat"} ] } }' SELECT ISJSON(@JSONData)
run
|
edit
|
history
|
help
0
2021-03-23_LeetCodeSQL
join ans
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...
Numbers
arithmetic
Stuff code in sql
SQL Server - regex filtering using LIKE
DBMS ca2
calendar
tables