Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.1 4511
System variable and temporary variables980
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?817
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
What is data modeling and Reterminal integrity?
what is difference between view and Dip.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
how to use DTS package in 2000,2005,2008 in sql server
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
ow to bring suspect mode datbase online from scratch
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
where the connection string store in the database
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
whats the maximum size of view state??
What is best institute to Learn DotNET And SQL in chennai?
what is the Ticketing tool used in Wipro technologies at Bangalore...???