How do I edit a procedure in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Explain primary key and foreign key constraints?
What is the difference between locking and multi-versioning?
Explain the properties of a relational table?
What is serializable?
A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?
if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..
17 Answers 3i Infotech, Rolta, TCS,
What are views used for?
What is the difference between executequery () and executeupdate ()?
What is the simplest way to create a new database in ms sql server?
What is clustered vs nonclustered index?
Explain transaction server auto commit?
What is a dbms wizard?
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)