How to get a list of all tables with "sys.tables" view in ms sql server?
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,
What is perspective, have you ever created perspective? : sql server analysis services, ssas
what is the difference between count(*) and count(1) ?
What is difference between drop truncate and delete?
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?
What are the advantages of using stored procedures? Please don't simply say compilation time will be saved as they are already complied. Please specify some other advantages.
what is differece between union and union all
Can we call stored procedure in view in sql server?
Explain difference between control flow and data flow?
What is dml command?
What is user-defined function?
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
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)