Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?1 4483
How do I compare two values when one value(data type) is char and the other is an integer?3 6092
What are the pros and cons of creating extended stored procedures?1 3969
I need a query that retrieves info from an Oracle table and a query that retrieves info from a SQL Server table. The info has to be joined together according to Record ID numbers. I have very limited access to the Oracle database but full control of the SQL Server database.How do I join two different queries from two different databases?1 4969
How to Check Whether a Global Temporary Exists in a SQL Database or not?2 5783
how to know Who Is Blocking Your SQL Server?4 8961
How to Get the last identity value used4 5445
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?1 3720
How to Run a Query on a Remote SQL Server?2 6249
How to Generate a Series of Random Integers With T-SQL?1 3067
What is normalization?9 6912
What is a Stored Procedure?8 6695
Can you give an example of Stored Procedure?4 7063
What is the difference between online clustering and Offline clustering?
where the connection string store in the database
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
how to take backup bcp out for a column in table in sql server?
hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
How can we call UDF(User Define Function) using C# code in ASP.net ?
How to trouble shoot if unable to connect SQL Server
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
how to do partition in sqlserver
How to restore performance issues and how to check?
What is Lock table in SQL?
Scalability, Availability, Integration with internet, etc.)?