can we create materialized view without using clustered index?
Can we create read only views in SQL server2000/2005?
What is the advantage of instead of trigger?
In what scenario we should use instead of triggers?
Can i have two different version of SQL Server in one machine .
Sql server 2000 , SQl server 2005
We know the default databases "master", "model", "msdb", "tempdb" are necessary for running SQL Server.
What specific data are storing inside these...
Suppose database is having two tables TABLE1, TABLE2 and both tables having one identity column.
suppose two users are working in the same...
I created one table having one column as identity column with identity seed=1 and identity increment as 1.
Now started one transaction and inserted...
Here my Question is what are the advantages of traditional view over dynamic SQL.
Here my guess is ,
If we use dynamic SQL instead of view, the...
I created one temporary table from the Query analyser. After that i went to enterprice Manager and opened the "tempdb" databse. But i cannot see the...
Separate names with a comma.