I build a store procedure to make a search in my customers table. But i would like to validate the sql query i build berfore running it. Is there a way to do that ?
I found something with SET PARSEONLY ON....
i want to replace some text using regular expression but it doesn't work :
here is my text (some TSQL)
CREATE PROCEDURE [dbo].[DELETE_FILE]
(@FILE varchar(255))
AS
--Comment
exec master..xp_deletefile @FILE
/*
maxi comment
*/
GO
I want to delete blank lines and comments
Dim re As Regex...
I have to built a database that i'll copy on three computers. Is there a way to identify each database ?
i know how to identify Access with 'Application.ProductCode' which gives me the Access GUID but what i need is a kind of Database GUID
i try to run a web task i create in SQL 2000
it works when i write this :
EXEC sp_runwebtask N'CREATE_MAIL'
but if i want to specify the outputfile like this :
EXEC sp_runwebtask N'CREATE_MAIL', N'D:\mail2.eml'
or
EXEC sp_runwebtask 'CREATE_MAIL', 'D:\mail2.eml'
or
EXEC sp_runwebtask...
i have an iframe and a button in my web page, my button call a function which reload the iframe. This work fine in ie but i don't know how to do in Netscape 6 ?
My script :
var ie = document.all ? 1 : 0;
var ns6 = document.getElementById && !document.all ? 1 : 0;
function fRefresh()
{
if (ie)...
i have a dynamic layer and an iframe in my web page.
when i display the layer ( document.getElementById("MYDIV").style.display = "block"; the layer appear on the page but, in Netscape 6.2, the layer don't recover the Iframe like in IE.
For the moment i mask my iframe when i...
In my 'TABLE' tag i often use the properties 'rules' and 'frame'. Is there an equivalent which works in NN ?
an example :
<table border=1 rules=none bordercolor=#DADADA cellspacing=0 cellpadding=0>
<tr>
<td>1</td>
<td>2</td>
</tr>
<tr>
<td>1</td>
<td>2</td>
</tr>
</table>
Thanx, and sorry...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.