Define Unique Key?
No Answer is Posted For this Question
Be the First to Post Answer
Do you know concepts and capabilities of sql server?
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 is the use of CASCADE CONSTRAINTS?
How do you create type- insensitive operator?
how we can count records as a group of days like sum of records for(four mondays),(four tuesday)........ in a month. group the column for weekdays.
What is the difference between substr and charindex in the sql server?
How can you insert values in multiple rows using one Insert statement?
0 Answers Flextronics, Thomson Reuters, Virtusa,
How do you know if sql server is running on your local system?
Why truncate is ddl command?
What is data source view or dsv? : sql server analysis services, ssas
How do I create an extended event in sql server?
Is sql server 2016 free?
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)