between cast and convert which function would you prefer and why?
No Answer is Posted For this Question
Be the First to Post Answer
How to transfer an existing table from one schema to another schema in ms sql server?
What is named query? : sql server analysis services, ssas
Do you know what is bit data type and whats the information that can be stored inside a bit column?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
When is update_statistics command used?
What is the difference between getdate and sysdatetime?
Explain filtered indexes?
What are the diifferences between the ms sql server vs mysql?
Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
what is the difference between group and having give an example with query and sample output
What is sql server replication? : sql server replication
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)