How to create a simple stored procedure in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
Call by value and call by reference in procedure and function, with NOCOPY.
How to connect ms access to sql servers through odbc?
What is an index?
What are the different types of columns types constraints in the sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
Can we insert data if clustered index is disabled?
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
What is a data source or ds? : sql server analysis services, ssas
Explain couple pf features of SQL server
Tell me what is the order in which the sql query is executed?
What is proper subset of candidate key?
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)