Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?1217
Which institute is best for SQL Server 2005 Training?6 2895
How do we rollback the table data in SQL Server3 13600
where do you use Isolations?give me some exmpale?1 3110
In which year relase the 7.0& 2000 & 2005?1 1844
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply1 4101
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 4033
select empid empname from employee What is the result for the about query?4 3302
what is checksum in sql server.........???
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
System variable and temporary variables
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
wat wil hapn if we give the both read and deny read permission to user?
which backup strategy you are following at ur company
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
What is the difference between online clustering and Offline clustering?
Why do you want to join software field as you have done your BE in Electronics?
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?
role of sql sever 2005 in database rather than any other database
how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A
what is isolation level at dead lock?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?