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 5007
How do I compare two values when one value(data type) is char and the other is an integer?3 6652
What are the pros and cons of creating extended stored procedures?1 4350
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 5352
How to Check Whether a Global Temporary Exists in a SQL Database or not?2 6301
how to know Who Is Blocking Your SQL Server?4 9932
How to Get the last identity value used4 6227
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?1 4100
How to Run a Query on a Remote SQL Server?2 6757
How to Generate a Series of Random Integers With T-SQL?1 3515
What is normalization?9 8138
What is a Stored Procedure?8 7978
What are relationships and mention different types of relationships in the dbms
How to set the current database in ms sql server?
What does null mean?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
List some advantages and disadvantages of stored procedure?
What is the concept of optimization?
What is Federation and Federation Member?
What is isnull() operator?
What is user-defined multi-statement table-valued function?
Differentiate between mongodb vs. Sql server?
explain extended properties
What is delete query?
What are the advantages of having an index on the sql server?
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?