How to delete all rows with truncate table statement in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
Write a sql query to sort on different column name according to the parameters passed in the function?
How to join two tables in a single query in ms sql server?
your distribution database is full what will u do
What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?
Can we create a clustered index on composite primary key.
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?
Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?
Where the sql logs gets stored?
What is the difference between Userdefined function and stored procedure? Explain and give the example also
Restore database SQL2000, SQL2012 Backup of base is created in Microsoft SQL Server 2000 - 8.00.2066, I can't restore on Microsoft SQL Server 2012 - 11.0.2100.60
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....
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)