Thanks for the information.
Thanks for the reply.
By default the views are not read only
Suppose i created one view which refers only one table and it is a simple view (means...
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
Check the connection string is valid one
SELECT * FROM
(SELECT id AS id1, name AS name1, phone AS phone1 FROM Employee WHERE Id = 1) a CROSS JOIN
(SELECT id AS id2, name...
Thanks for the above information
We know the default databases "master", "model", "msdb", "tempdb" are necessary for running SQL Server.
What specific data are storing inside these...
The above information is really helpful. Thanks for that.
Suppose database is having two tables TABLE1, TABLE2 and both tables having one identity column.
suppose two users are working in the same...
Thanks for the information
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...
comparision of the performance between
"selecting from the view"
"selecting from the base table"
(the above queries giving same result)
suppose i have one table TABLE1;
I have one view VIEW1 ( as Select * from TABLE1 where status=true)
Actually i want to know the differece or...
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.