Click here to Skip to main content
Page 1 of 1
Page Size: 10 · 25 · 50


Author filtered by: Sukanta Ghosh [x]
Question 26 Apr 2013   license: CPOL
My Company supplies the MS SQL Server 2005 Express database .mdf files with their solution. Which we attach at client's computers SQL server (Doesn't have the Management studio) on first run of the application software. Now my boss wants me to lock the database so that no one can even see the...
Answer 26 Apr 2013   license: CPOL
With CTE as ( Select emp_id,emp_Name,reports_to,1 as Level From emp Where reports_to=1 Union all Select E.emp_id,E.emp_name,E.reports_to,Level+1 From emp as E Inner join CTE on E.reports_to=CTE.emp_id ) Select * from CTE;Quote: Any way thanks though, for helping about exactly what...
Question 25 Apr 2013   license: CPOL
I have a Employee table likeemp_id bigint,reports_to bigint,emp_name varchar(20),Constraint [PK_Emp] Primary key (emp_id),Constraint [FK_Emp] Foreign key (reports_to) references [MSS].[dbo].[Emp]([emp_id])emp_id reports_to emp_name------ ------ ...

Page 1 of 1


Advertise | Privacy | Mobile
Web01 | 2.6.130513.1 | Last Updated 14 May 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid