hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000
3 6706How to write query to Delete the records in child table and corresponding records in parent table
11 35368Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?
2 7040Assume,there are three tables in a database, Can i have both primary key and foreign key for each table in the same database?
4 8954
What is the difference between functions and stored procedures?
How to perform key word search in tables?
Which sql server is best?
What is sql server 2000 work load governor?
What are the types of dml?
How can you know if the row fetched from cursor is still valid in underlying table?
What is meant by indexing files?
Explain few examples of stored procedure over triggers?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is temporal table?
What is update locks?
What is subquery in sql?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
What is used to replicate sessions between instances in coldfusion clusters?
How to use "begin ... End" statement structures in ms sql server?