Can you explain what is indexed view? How to create it?
No Answer is Posted For this Question
Be the First to Post Answer
System requirements for sql server 2005 express edition?
What is a Lock and let me know Different types of locks?
Explain trigger and its types?
What is the recovery model?
Is the log file is a part of file group?
What is sql injection and why is it a problem? : sql server security
I have a table Events Events containing cardno,time,id,name- -each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible
How much is a sql server license?
Can you name a few encryption mechanisms in sql server?
What happens when converting big values to numeric data types?
Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.
what is the sql equivaent of the dataset relation object ?