What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
No Answer is Posted For this Question
Be the First to Post Answer
How to include text values in sql statements?
between cast and convert which function would you prefer and why?
Explain unique key in sql server?
What is schemabinding a view?
hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting
Explain the usage of floor function in sql server.
Why use stored procedures in sql server?
Is it possible to update the views? If yes, how, if not, why?
what is an extended stored procedure? : Sql server database administration
how many type of indexing in database?
Explain about nested stored procedure?
hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq
Oracle (3253)
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)