How to create function without parameter in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What is partition index in sql server?
Explain how many normalization forms?
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
how to find out the repeated value from table using groupby function?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.
What authentication modes does sql server support?
What is the recovery model?
If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.
Explain comment on transactions?
What is named calculation? : sql server analysis services, ssas