var str="1,001,300.0";
str = str.replace(",",""); //will only replace the first comma
var x="1,2,25.8,1";
var y=x.replace(/,/g,''); //withGlobal Regular Expressionwill replace all comma
Monday, October 26, 2009
Wednesday, October 21, 2009
System Stored Procedure - sp_msforeachtable
-- enable all constraints
exec sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
sp_msforeachtable "ALTER TABLE ? DISABLE TRIGGER all"
sp_msforeachtable @command1="print '?'", @command2="ALTER TABLE ? ENABLE TRIGGER all"
Disable and Enable all constraints
-- disable all constraints
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
-- enable all constraints
exec sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
-- enable all constraints
exec sp_msforeachtable "ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all"
Monday, October 19, 2009
Make Iframes full screen
<body style= "height:100%;width:100%;margin: 0px;padding: 0;margin: 0px;" >
<iframe scrolling="no"width=100% height=100% name = "MainFrame" frameborder ="0" boreder="0"></iframe>
Note: looks like the style sheet code style= "height:100%;width:100%;margin: 0px;padding: 0;margin: 0px;" doesn't apply to iframe.
<iframe scrolling="no"
Note: looks like the style sheet code style= "height:100%;width:100%;margin: 0px;padding: 0;margin: 0px;" doesn't apply to iframe.
Subscribe to:
Posts (Atom)
