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 4265
How do I compare two values when one value(data type) is char and the other is an integer?3 5890
What are the pros and cons of creating extended stored procedures?1 3800
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 4790
How to Check Whether a Global Temporary Exists in a SQL Database or not?2 5586
how to know Who Is Blocking Your SQL Server?4 8606
How to Get the last identity value used4 5206
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?1 3516
How to Run a Query on a Remote SQL Server?2 6020
How to Generate a Series of Random Integers With T-SQL?1 2888
What is normalization?9 6573
What is a Stored Procedure?8 6273
Can you give an example of Stored Procedure?4 6811
what are the critical issues you have resloved in your company
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
What is RMS migrations?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
last function used in MS Access to convert sql what function will use in sql
You are doing log shipping due to some reasons it is failing. How you will proceed from there
after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?
your distribution database is full what will u do
How we create SQL Server 2005 Reporting Services ? Give me Sample
SQL Server Architecture ?
How can we call UDF(User Define Function) using C# code in ASP.net ?
how can u get last observation in an unknown dataset ?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
What is the difference between NOROW and LOCKROW?