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
Campeonato2DLuizFelipe
Combined Where and having
Window Functions - ROW_NUMBER()
Task_6_Final
While Loop in SQL Server for Multiple Entries
BC160401693
reee
bc160401693
ASSESSMENT2
Sequence object -- New Feature of 2012 sql server