Can a trigger be created on a view?
No Answer is Posted For this Question
Be the First to Post Answer
Can sql servers linked to other servers like oracle?
What are the advantages of partitioning?
What is data modification?
What is index, cluster index and nonclustered index?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
what is web server?
What does nvl stand for?
What is the difference between DataRow.Delete() and DataRow.Remove()?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
What are the restrictions applicable while creating views? : SQL Server Architecture
Please get the 4 th maximum salary from a table without using any sql keyword (TOP,MAX are mot allowed)
Explain system scalar functions?