Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?1680
Which institute is best for SQL Server 2005 Training?6 4144
How do we rollback the table data in SQL Server3 14710
where do you use Isolations?give me some exmpale?1 3849
In which year relase the 7.0& 2000 & 2005?1 2476
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply1 4711
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..4 5338
select empid empname from employee What is the result for the about query?4 4606
How are the exceptions handled in sql server programming?
How do I debug a stored procedure in sql server?
What is the difference between a local and a global temporary table?
What is sub-query in sql server? Explain its properties.
You want to implement the many-to-many relationship while designing tables. How would you do it?
Explain user defined functions?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
Where views are stored in sql server?
How many tables can be joined in SQL Server?
Can sql servers link to other servers like oracle?
How to create a scrollable cursor with the scroll option?
Explain aggregate functions?
What is NOT NULL Constraint in sql server 2012?
Is sql different from sql server?
What does truncate do?