How to provide column names in insert statements in ms sql server?
No Answer is Posted For this Question
Be the First to Post Answer
How to provide login information for a new odbc dsn?
What is shared lock?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
employee table has employee id ----------- empid ---------------- 1 2 3 3 3 4 5 5 5 6 6 6 7 here the values r repeated two times.how to select the repeated values only.i.e 3,5,6 should alone come.
Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance
Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?
What is history table in sql server?
Explain “not null constraint” in sql server?
How to use copy and concatenate commands in SQL?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is your recommendation for a query running very slow? : sql server database administration
How to override dml statements with triggers?
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)