What are the aggregate and scalar functions?
No Answer is Posted For this Question
Be the First to Post Answer
How can you insert null values in a column while inserting the data?
CREATE TABLE [dbo].[HPMS_CompetencyTypes](CompetencyType varchar(50) ) go create trigger hpms_create_Insert on HPMS_CompetencyTypes for insert as if Exists ( select * from [HPMS_CompetencyTypes] where CompetencyType=(select * from [HPMS_CompetencyTypes])) begin Rollback tran Raiserror ('duplicate value',12,6) go insert HPMS_CompetencyTypes (CompetencyType) values ('new') I'm new to trigger can any one tell me where is the issue. Please.
what is difference between view and Dip.
What are the advantages of using a stored procedure?
What are dml (data manipulation language) statements in ms sql server?
what are the types of indexes? : Sql server database administration
What are different types of collation sensitivity?
What happens on checkpoint?
If i am handling 150 servers then how to check the active jobs of all the servers?
How is table type constraint applied to a table?
What is DAC? what is the use of it?
can you instantiate a com object by using t-sql? : Sql server database administration
Oracle (3253)
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)