Mithilesh_SQL

Sql with Json

https://msdn.microsoft.com/en-in/library/dn921882.aspx

Format Query Results as JSON with FOR JSON (SQL Server)

Sql server 2016 support JSON

https://blogs.technet.microsoft.com/dataplatforminsider/2016/01/05/json-in-sql-server-2016-part-1-of-4/

JSON in SQL Server 2016: Part 1 of 4 Official News from Microsoft’s Information Platform

To Find the nth Highest Salary via common table,DENSE_RANK,Co-related queries...

Co-related queries...
select * from empmast e1
where 3=(select count(*) from empMast e2 where e2.salary>=e1.salary)

Part 1 How to find nth highest salary in sql Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version o...

https://www.youtube.com/watch?v=K2mFsfhLckw&index=4&list=PL083E4EEC22030EAD

SQL Server video :- Explain aggregate functions,group by clause and having keyword ? Preparing for C # / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q visit for 500 videos @ http://www.questpond.com In this video we wil...

Difference between sub queries and co-related queries.....

SQL Server interview questions :- What are Sub Query and Co-related Queries ? Preparing for C # / .NET interviews start here http://www.youtube.com/watch?v=gaDn-sVLj8Q http://www.questpond.com In this video we will try to understand wha...

SQL Server Interview questions :- Find the second highest ? Visit us for more videos at http://www.questpond.com Many times during SQL server interviews , many of them ask this tricky question "Find the second highest...

Can SQL Server views be updated (SQL Server interview questions and Answers) ? Visit us ://www.questpond.com for more SQL Server interview questions and answers videos, In this video we will try to answer a very tricky SQL Server i...

Drop Existing Constraint in sql
ALTER TABLE [TABLE_NAME] DROP CONSTRAINT [CostraintName]
ex-
ALTER TABLE itemmast DROP CONSTRAINT fkactvd

Renaming existing column in sql

sp_rename '[tablename.oldcolumnname]','[newColumnName]','COLUMN'

Example :-
sp_rename 'employee.empid','emplooyeeID','COLUMN'

Creating Primary key constraint on existing column...

ALTER TABLE Employee ADD CONSTRAINT pkEmpID PRIMARY KEY (EmpId)

Primary Key Constraint.............
CREATE TABLE Employee(EmpId INT NOT NULL CONSTRAINT pkEmpId Primary key)