Can we write trigger for view?
No Answer is Posted For this Question
Be the First to Post Answer
what is mean by crystal repoart? ahere we will mainly use that?
How do you set a trace flag in sql server?
How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?
How do you create an execution plan?
What is molap and its advantage? : sql server analysis services, ssas
What are the types of subscriptions in SQL Server replication?
Mention a few common trace flags used with sql server?
What to perform pattern match with the like operator?
Explain about nested stored procedure?
Can we create clustered index on composite key?
Can we check locks in database? If so, how can we do this lock check?
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
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)