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
a
String agg
CTE Recursive sample
ss sqlpractice2014
Transaction Test
Pivot unpivot
Rno 37 boat
SaLLa
Usage of joins
#Temp Table fill