how you can move data or databases between servers and databases in sql server? : Sql server administration
1030why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
1137you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
1307You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
1056You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
1043
What is postgresql server?
Tell me what do you understand by a view? What does the with check option clause for a view do?
Define magic tables in sql server?
How to change the name of a database user?
Explain what is the use of custom fields in report?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Can sql servers linked to other servers?
Define full outer join?
What does it mean to invest in the index?
How can we solve concurrency problems?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is schemabinding a view?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?
Can we call future method from queueable?