code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what is the order of execution of where,having,group by in select stement6 19528
PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.
please can anyone answer this query Table 1 has 2 columns: EmployeeId,Age Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region who has the oldest person10 8403
can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=315 11700
i want table name basis on column name.5 6204
i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.3 6401
In clustered and non clustered indexes which one is faster while executing a query ?1 6725
How to create logins using windows Authentication mode?2 3348
write the query for taking database restore in sql?2 4275
What is identity?
How many levels of sp nesting is possible?
Can I save my report as html, excel or word? : sql server management studio
Where can you find the error log information? : sql server database administration
What is tcl in sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What is the Disadvantage of indexed sequential file.
What is an execution plan? When would you use it?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What are the advantages of using stored procedures?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
List down some advantages of sql stored procedure?
How to define the name and server for a new dsn?
What is normalization and its types?