What is transactional replication?
No Answer is Posted For this Question
Be the First to Post Answer
What are user-defined functions (udfs) in sql server?
How to concatenate two character strings together?
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ?
Which sql server table is used to hold the stored procedure script?
How to generate create function script on an existing function?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Explain the concept of recursive stored procedure.
What is the difference between count () and rowcount ()?
What is store procedure?
What happens if time-only values are provided as date and time literals?
Is it possible to create tables in stored procedures using a variable for the table name?
If we use where clause in the left outer join then how the query would behave/act?