Mention the differences between substr and charindex in sql server.
No Answer is Posted For this Question
Be the First to Post Answer
What are the differences between char and varchar in ms sql server?
what is the diffrence between Snap Shot and Transaction Replication
What is log shipping?
When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO
What are the advantages dts has over bcp?
In what three ways is the return statement used in a stored procedure?
what are the joins,primary key,foriegn key, candidate key, super key and expain them?
What is the impact on other user sessions when creating indexes?
What are the advantages to use stored procedures?
Define candidate key, alternate key, and composite key.
How connect excel to sql server?
Explain table valued parameters in sql server? Why tvp used?
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)