How to get all stored procedures in sql server?
No Answer is Posted For this Question
Be the First to Post Answer
What are the steps you can take to avoid “deadlocks”?
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?
What is inner join? Explain with an example?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
What are the differences between char and nchar in ms sql server?
How can we delete Duplicate row in table?
What is an indice?
What are the underflow and overflow behaviors on float literals?
What is difference between oltp and olap?
What is entity data services?
how to define testing of network layers? : Sql server database administration
Can you explain different types of locks in sql server?
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)