How to use "begin ... End" statement structures in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Find top Nth employee from each department in terms of salary?
What is 4nf in normalization form?
What do you understand by a view? What does the with check option clause for a view do?
What do you understand by user-defined function in the sql server?
How to enable/disable indexes?
Explain following error properties?
What is efficiency data?
Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
How to write a query with an inner join in ms sql server?
How we can refresh the view?
What happens if time-only values are provided as date and time literals?
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)