New concepts of sql server 2005 use in your project.
No Answer is Posted For this Question
Be the First to Post Answer
What is the use of keyword with encryption. Create a store procedure with encryption?
Explain “row_number()” in sql server with an example?
when u import an excel file into sql if suppose one column has got a date field with system time attached to it what data type u will use in sql to import it in a table? Note: a condition is the excel file has no primary key defined to a column...also u r importing bulk data into sql
List all the types of user-defined functions?
What is an index?
Describe triggers features and limitations?
What are cursors stored procedures and triggers?
How to override dml statements with triggers?
What are the differences between user defined functions and stored procedures?
What is the contrast amongst drop and truncate?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
What is transaction server implicit?
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)