wat wil hapn if we give the both read and deny read
permission to user?
What is a trigger? Why we need it?
Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?
From where can you change the default port?
How can windows applications connect to sql servers via odbc?
What is after dml trigger?
What structure can you implement for the database to speed up table reads?
What do you mean by collation recursive stored procedure?
Explain the use of containers in ssis and also their types?
what number files will a information contain in SQL Server? How many forms of information files exist in SQL Server? How many of those files can exist for a single database?
WHAT IS THE DIFFERENCE BETWEEN CANDIDATE KEY ,COMPOSITE KEY AND PRIMARY KEY. THAN U.
What area unit the various kinds of info compression introduced in sql server 2008?
Can anyone explain difference between Database, Data warehouse and Data mart with some example?````