Mithilesh_SQL

30/11/2016

Sql with Json

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

30/11/2016

Sql server 2016 support JSON

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

Official News from Microsoft’s Information Platform

12/12/2014

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)

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...

11/12/2014

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

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...

10/12/2014

Difference between sub queries 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...

10/12/2014

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...

10/12/2014

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...

25/07/2014

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

24/07/2014

Renaming existing column in sql

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

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

24/07/2014

Creating Primary key constraint on existing column...

ALTER TABLE Employee ADD CONSTRAINT pkEmpID PRIMARY KEY (EmpId)

24/07/2014

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