Latest Answer : Just replace "[your-schema-name-here]" in the following query with your schema name. Hope it comes handy to some of you out there. Select OBJECT_TYPE,OBJECT_NAME FROM(Select 'TABLE' as OBJECT_TYPE, TABLE_NAME as OBJECT_NAME, TABLE_SCHEMA ...
Latest Answer : CO-RELATED Query: It used to find the exits or doesnot exits value. It has two select statement, the outer select statement will execute first and then the inner select statement execute.There is no need of relation between the two select statement. ...
Latest Answer : Clustered Index ...
Latest Answer : CREATE TABLE dbo.SalesByQuarter ( Y INT, Q INT, sales INT, PRIMARY KEY (Y,Q) ) GO INSERT dbo.SalesByQuarter(Y,Q,Sales) SELECT 2003, 2, 479000 ...
Latest Answer : no.because,stored procedures are explicity invoked and trigger is nothing but a stored procedure but fires an event or data modifications occur.trigger is a implicity invoked. ...
Error While creating BACKUP:I am Creating FullBackup for one database Named Postings.I executed below Query and i am getting The Below error message.USE mastergoEXEC SP_ADDUMPDEVICE 'disk','PostingsBac','E:BACKUPPostingsBac.BAK'BACKUP
Latest Answer : This is basically a problem with the physical path of the Backup device, I suppose. Be sure the physical path that you are giving has full access from your Windows user Account or not. ...
How we can pulish the connectivity of SQL query to the HTML file or web page? Please Explain.
Latest Answer : Normally connection of SQL file to a web page can be done in two ways1. Through the code2. In web config fileIf we give through the code, we need to alter the relevant pages, where as if we give through web config , this will be a common file and will ...
How to deny insert, update, delete, update permissions for a specific user of a specific user database?
Latest Answer : So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ...
What is the buffer size of SQL query output row?
How can we rename a Database with query?
Latest Answer : Syntax of renaming the database:sp_renamedb old_database name new_database nameEg:Â name of the database is tree. Now if you need to change the database as three. So the query for changing the database as follows:sp_renamedb tree three ...
