Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
2057Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply
1 5387i 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 6365
How many types of functions are there in sql server?
Is BCNF better than 2NF & 3NF? Why?
What do you mean by sql server 2005 express management tools?
What is bcp? When does it use?
What does select 1 mean?
What is the difference between for xml raw and for xml auto?
What is sql server schema compare? How we can compare two database schemas?
What are the aggregate and scalar functions?
Can we write trigger for view?
When I run the sql server 2000 setup, it just hangs. What do I do?
What is the contrast between sql and pl/sql?
How will you monitor replication latency in transactional replication? : sql server replication
Define constraints and give an example of their use?
What are the restrictions applicable while creating views? : SQL Server Architecture
What is a system database and what is a user database?