Give main differences between "Truncate" and "Delete".
No Answer is Posted For this Question
Be the First to Post Answer
Explain the use of containers in ssis and also their types?
what is difference between view and Dip.
What action plan is preferred if sql server is not responding?
Can you roll back the ddl statement in a trigger?
What is ddl command?
Can group functions be mixed with non-group selection fields in ms sql server?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Hi all, I need query help for below senorio, could you please help me. TableName = City CITYID ContinuationID CITYNAME 1 1 SAN 1 2 DIEGO 2 1 SAN 2 2 FRANCISCO 3 1 CHICAGO 4 1 NEW 4 2 YORK 4 3 CITY Could you please help me to write a generalized SQL that returns results as given below in the Query result CITYID NAME1 NAME2 NAME3 NAME4 NAME5 1 SAN DIEGO 2 SAN FRANCISCO 3 CHICAGO 4 NEW YORK CITY
i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?
What is extended stored procedures?
Can you explain what are commit and rollback in sql?
Explain a differential backup?
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)