Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
No Answer is Posted For this Question
Be the First to Post Answer
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
syntax and example for bitmap index in sql???
How to use group functions in the select clause in ms sql server?
How many levels of sp nesting are possible?
What is difference between createstatement and preparedstatement?
How to transfer an existing table from one schema to another schema in ms sql server?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
What are the two authentication modes in sql server?
What is catalog views?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Which is the latest version of sql server and when it is released?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)