关于sql列默认值 在sql数据库里有一个表,其中列“序号”列是标识列,每增加一条记录就自动加一,还有一列是“生产日期”,我想“编号”默认为生产日期+序号。例如,序号为1,生产日期为2009-1-1,编号就默认为20090101。序号为1000,生产日期为2010-01-01,编号就默认为201001011000,请问在“编号”列的默认值里怎样填写代码,谢谢指教,感激涕零。本人保证给分 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 lz是指vb里?还是sql server里? sql server里,请哪位老师指点一下 vb 里这样做Private Function s_fun_GetID() As String Dim strID As String Dim strF As String Dim resF As New ADODB.Recordset strID = qianzhui & Trim(Format(Date, "yymmdd")) strF = "" strF = strF & " SELECT MAX(MID(MY_ID, 8, 2)) MAX_ID" & vbNewLine strF = strF & " FROM MY_TABLE " & vbNewLine strF = strF & " WHERE MID(MY_ID, 1, 7) = '" & strID & "' " & vbNewLine resF.Open strF, P_Connect If Val(resF.Fields("MAX_ID") & "") = 0 Then strID = strID & "01" Else strID = strID & Right("00" & (Val(resF.Fields("MAX_ID") & "") + 1), 2) End If resF.Close Set resF = Nothing s_fun_GetID = strID End Function sql server应该怎么写,写在哪里 Private Function s_fun_GetID() As String Dim strID As String Dim strF As String Dim resF As New ADODB.Recordset strID = qianzhui & Trim(Format(Date, "yymmdd")) strF = "" strF = strF & " SELECT MAX(MID(MY_ID, 8, 2)) MAX_ID" & vbNewLine strF = strF & " FROM MY_TABLE " & vbNewLine strF = strF & " WHERE MID(MY_ID, 1, 7) = '" & strID & "' " & vbNewLine resF.Open strF, P_Connect If Val(resF.Fields("MAX_ID") & "") = 0 Then strID = strID & "01" Else strID = strID & Right("00" & (Val(resF.Fields("MAX_ID") & "") + 1), 2) End If resF.Close Set resF = Nothing s_fun_GetID = strID End Function VB2010: 如何动态加载 / 卸载MenuStrip? VB6不能加载ocx 如何对toolbar控件加载背景颜色 Adodc1控件与DataGrid1绑定后,如何同时删除多个记录 各位大侠,下面这段XML如何通VB引用的XML4.0读出来? 请教InputBox函数输入问题,如何控制用户输入的是数字?在线等,急 *** 窗口焦点问题 *** vb和accsee做项目,对多用户的可以实现吗? .net 含有数字的字符串排序问题,急,大家帮帮忙! odbc问题? 求助:vb ole控件出错 对象变量或with块变量未设置
Private Function s_fun_GetID() As String
Dim strID As String
Dim strF As String
Dim resF As New ADODB.Recordset
strID = qianzhui & Trim(Format(Date, "yymmdd"))
strF = ""
strF = strF & " SELECT MAX(MID(MY_ID, 8, 2)) MAX_ID" & vbNewLine
strF = strF & " FROM MY_TABLE " & vbNewLine
strF = strF & " WHERE MID(MY_ID, 1, 7) = '" & strID & "' " & vbNewLine
resF.Open strF, P_Connect
If Val(resF.Fields("MAX_ID") & "") = 0 Then
strID = strID & "01"
Else
strID = strID & Right("00" & (Val(resF.Fields("MAX_ID") & "") + 1), 2)
End If
resF.Close
Set resF = Nothing
s_fun_GetID = strID
End Function
Dim strID As String
Dim strF As String
Dim resF As New ADODB.Recordset
strID = qianzhui & Trim(Format(Date, "yymmdd"))
strF = ""
strF = strF & " SELECT MAX(MID(MY_ID, 8, 2)) MAX_ID" & vbNewLine
strF = strF & " FROM MY_TABLE " & vbNewLine
strF = strF & " WHERE MID(MY_ID, 1, 7) = '" & strID & "' " & vbNewLine
resF.Open strF, P_Connect
If Val(resF.Fields("MAX_ID") & "") = 0 Then
strID = strID & "01"
Else
strID = strID & Right("00" & (Val(resF.Fields("MAX_ID") & "") + 1), 2)
End If
resF.Close
Set resF = Nothing
s_fun_GetID = strID
End Function