How to transfer data from a text file to SQL table, Which is the best method to do that?
Latest Answer: 1. Use BCP.exe to load data from text file into table 2. Use DTS Dataa Pump Task to load data into table from flat file ...
How To Define Unique Key in SQL Server
Latest Answer: Unique ...
Explain what is Distributed deadlock?
What is the different between Logging and Transaction?
How to join same fields of four tables at SQL Server?
What are the types of authentications supported SQL Server
Latest Answer: Sql Server supports two types authentications1)Windows Authentication2)SQL Server Authentication ...
How to define unique key in table? Is it possible to define one primary key and one unique key in a single table?
Latest Answer: You can make one (or more) columns unique in a table by defining a UNIQUE NONCLUSTERED index on the column. ...
What is tail log backup? Where can we use it?
Latest Answer: Tail Log Backup is the log backup taken after data coruption (Disaster). Though there is file corruption we can try to take log backup (Tail Log Backup). This will be used during point in time recovery.Consider a scenerio where in, we have full backup ...
How to deny insert, update, delete, update permissions for a specific user of a specific user database?
Latest Answer: So what context is the user in? A role a datareader? Datawriter?You want no permissions?USE Drop USER In a role?EXEC sp_droprolemember 'rolename' , 'Member'single objects?Revoke SELECT, ...
How to display list of tables from a particular database in MS-SQLHow to display description of that particular table?
Latest Answer: Submit a query on the SYS.TABLES table to get all of the data about the tables in a specific database. Be sure to specify the database that you are targeting.USE -- Specify your target database name (without the brackets)GO SELECT ...
View page [1] 2 3 4 5 6 Next >>
Go Top
