How get current date in SQL server 2000
Answers were Sorted based on User's Feedback
what are the main differences between ms access and sqlserver
Would it be a good idea to create an index on a table that always contains 10 records? Why or why not?
In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2
I am Having tables T1 and T2 both having same data how to check (or) compare the data in both table are same?
How to generate create procedure script on an existing stored procedure?
What do you mean by subquery?
Explain insert into select statement?
If we shrink the Databse and Files, how much size is decreased?
How do I find the sql server database version?
How can we solve concurrency problems?
explain different types of jions with examples briefly?
2 Answers Accenture, Excellence, Zensar,
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
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)