Explain some stored procedure creating best practices or guidelines?
No Answer is Posted For this Question
Be the First to Post Answer
What is the difference between varchar and varchar(max) datatypes?
How to divide query output into multiple groups with the group by clause in ms sql server?
Write a sql query to sort on different column name according to the parameters passed in the function?
Tell me when is the update_statistics command used?
Which are the olap features?
I have a table in which phno is one of the columns.i do have some values in tht phno column.i need to update phno column values with 0(zero) as prefix.give me a correct solution plz...
Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
Why I can not enter 0.001 second in date and time literals in ms sql server?
How do I edit a procedure in sql server?
What is @@Identity in sql?
Do you know what are the properties of the relational tables?
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)