品忧小筑

- (MRecTemplate*)GetDataRecTemplate
{
MRecTemplate* data = [[[MRecTemplate alloc] init] autorelease];

sqlite3_stmt* stmt;
NSString* str = @”SELECT * FROM RecTemplates”;
int nResult = sqlite3_prepare_v2(m_db, [str UTF8String], -1, &stmt, NULL);
if (nResult == SQLITE_OK)
{
if (sqlite3_step(stmt) == SQLITE_ROW)
{
int i = 0;
. . . → Read More: SQLite读写二进制数据

–get the dbid which is in Transition mode, check the status is 0 or not.

select * from sys.databases where name =

–if status is not zero reset db status

exec sp_resetstatus

–look for blocking spid or IF WaitRsource column has that DBID

select * from sys.sysprocesses

–Look for waitresource column if that dbid is blocking

select * from sys.dm_exec_requests

–kill the sp . . . → Read More: Database is in transition. Try the statement later.

CREATE FUNCTION ToBase64 (@Input varchar(6000))
RETURNS varchar(8000)
AS
BEGIN
DECLARE
@Output varchar(8000),
@Bits varbinary(3),
@Pos int
SET @Pos = 1
SET @Output = ”
WHILE @Pos . . . → Read More: SQL Server Base64编码

CREATE FUNCTION dbo.HexStrToVarBin(@hexstr VARCHAR(max))
RETURNS varbinary(max)
AS

BEGIN
DECLARE @hex CHAR(2), @i INT, @count INT, @b varbinary(max), @odd BIT, @start bit
SET @count = LEN(@hexstr)
SET @start = 1
SET @b = CAST(” AS varbinary(1))
IF SUBSTRING(@hexstr, 1, 2) = ‘0x’
SET @i = 3
ELSE
SET @i = 1
SET @odd = CAST(LEN(SUBSTRING(@hexstr, @i . . . → Read More: SQL Server十六进制字符串转二进制

Sub Class1()
Dim db As Database
Dim tdf As TableDef
Dim fld As DAO.Field
Dim ndx As DAO.Index
Dim strSQL As String
Dim strFlds As String
Dim strCn As String

Dim fs, f

Set db = CurrentDb

Set fs = CreateObject(“Scripting.FileSystemObject”)
Set f = fs.CreateTextFile(“D:\Schema.txt”)

For Each tdf In db.TableDefs
If Left . . . → Read More: 用VBS将Access数据库表结构转SQL语句

–输入参数
–@tableName

SELECT column_name=syscolumns.name, datatype=systypes.name, length=syscolumns.length
FROM sysobjects
JOIN syscolumns ON sysobjects.id = syscolumns.id
JOIN systypes ON syscolumns.xtype=systypes.xtype
WHERE sysobjects.xtype=’U’
AND sysobjects.name=@tableName
ANDsystypes.name <> ’sysname’
ANDsyscolumns.name <> ‘isactive’ . . . → Read More: Sql Server枚举表结构

–存储过程输入参数
–@Path varchar(500)
–@FileName varchar(500)

set @sql = ‘DECLARE @idoc int ‘
set @sql += ‘DECLARE @xmlDocument varchar(MAX) ‘
set @sql += ‘DECLARE @Status int’

set @sql += ’set @xmlDocument = dbo.ufsReadfileAsString(‘ + char(39) + @Path + char(39) + ‘,’ + char(39) + @FileName + char(39) + ‘) ‘

set @sql += ‘EXEC @Status = sp_xml_preparedocument @idoc OUTPUT, . . . → Read More: Sql Server读取ADO样式的XML文件